Moving data between Oracle Database 10g XE and Oracle Database 11g XE

Follow the guidelines presented in this section if you want to do either of the following:

• Move data between Oracle Database 10g XE and Oracle Database 11g XE

• Upgrade your Oracle Database 10g XE to Oracle Database 11g XE

The steps are as follows:

1. 1. Create a database directory object by connecting to Oracle Database 10g XE as SYS user:

   SQL> CREATE OR REPLACE DIRECTORY dump_dir AS 'c:\xetest';
   SQL> GRANT READ,WRITE ON DIRECTORY dump_dir TO system;
   
   

2. 2. Export the data from Oracle Database 10g XE:

   expdp system/******** full=Y EXCLUDE=SCHEMA:\'LIKE \'APEX_%\'\',SCHEMA:\'LIKE \'FLOWS_%\'\' directory=DUMP_DIR dumpfile=DB10G.dmp logfile=DB10G_expdp.log
   expdp system/******** TABLES=FLOWS_FILES.WWV_FLOW_FILE_OBJECTS$ directory=DUMP_DIR dumpfile=DB10G2.dmp logfile=DB10G_expdp.log
   

3. 3. Uninstall Oracle Database 10g XE.

4. 4. Install Oracle Database 11g XE.

5. 5. Create a database directory object by connecting as SYS user:

   SQL> CREATE...