Friday afternoon - updating Oracle XE Oracle Headquarters Redwood Shores1 e1698667100526

Friday afternoon – updating Oracle XE

I had nothing really to do this afternoon, so i updated Oracle XE ( Beta) with the Oracle (standard database) patch, that is…only the data dictionary part.

Just to check if this could be done and if some limitations were data dictionary based… 😉


SQL> sho user

SQL> select * from v$version;

Oracle Database 10g Express Edition Release - Beta
PL/SQL Release - Beta
CORE      Beta
TNS for 32-bit Windows: Version - Beta
NLSRTL Version - 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  ;

14 objects were invalid afterwards and a lot of synonyms, probably APEX / HTMLDB related.

Sorry Sergio, i think i recked it…


One Response

  1. Sergio April 7, 2006