Friday afternoon – updating Oracle XE

Marco Gralike 1

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?

0 0
Read Time:1 Minute, 1 Second

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

About Post Author

Marco Gralike

Marco Gralike, working for AMIS Services BV as a Principal Oracle Database Consultant in the Netherlands, has experience as a DBA since 1994 (Oracle 6). Marco is also eager and skillful in other fields, like Operating System Administration and Application Servers, mainly to find working, performing solutions. Marco has been specializing in Oracle XMLDB, since 2003, focusing on his old love, database administration and performance.He is an Oracle XMLDB enthusiast ever since. He is also a dedicated contributor of the Oracle User Group community, helping people with their steep XMLDB learning curve. To this purpose, Marco also devoted his personal blog site to XMLDB and other Oracle issues. Marco is a member of the OakTable network and an Oracle ACE Director (specialization Oracle XMLDB).
Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

One thought on “Friday afternoon – updating Oracle XE

Comments are closed.

Next Post

Getting started with Cobertura - A Java Code Coverage Tool

Cobertura a coverage tool. A coverage tool shows how many lines of code are touched. In most cases you’ll use Cobertura to see how good your regressions test are. You can also use it to see how many lines of code are reached or to improve code that is accessed […]
%d bloggers like this: