I had nothing really to do this afternoon, so i updated Oracle XE (10.2.0.1 Beta) with the Oracle (standard database) patch 10.2.0.2, that is…only the data dictionary part.
Just to check if this could be done and if some limitations were data dictionary based… 😉
Alas?
SQL> sho user USER is "SYS" SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta PL/SQL Release 10.2.0.1.0 - Beta CORE 10.2.0.1.0 Beta TNS for 32-bit Windows: Version 10.2.0.1.0 - Beta NLSRTL Version 10.2.0.1.0 - Beta
SQL> create tablespace oversized 2 datafile 'c:\oraclexe\oradata\xe\oversized.dbf' size 5G 3 ; create tablespace oversized * ERROR at line 1: ORA-12952: The request exceeds the maximum allowed database size of 4 GB SQL> create database link test01 connect to system identified by manager using 'LAB.AMIS.NL'; Database link created. SQL> select * from global_name@test01 2 ; GLOBAL_NAME -------------------------------------------------------------------------------- LAB.AMIS.NL
14 objects were invalid afterwards and a lot of synonyms, probably APEX / HTMLDB related.
Sorry Sergio, i think i recked it…
Marco
Uh oh, bummer. Good thing it’s so easy to re-install afresh. 😉
Sergio