This content has been marked as final. Show 6 replies
could you provide some more details on what you actually want to migrate?
If it's just the database content, exp/imp or even better expdp/impdp would be the two tools you are searching for. Export all schemas you need from 11.2 SE and import the dumps to 11.2 XE and you are done.
There are some tables in my database which have no rows and all the tables in database are created with *"SEGMENT CREATION DEFERRED"* so these tables are not getting exported.
Is there any other way by which i can get all objects migrated properly from Oracle 11.2 SE to 11g XE Beta
use datapump (expdp/impdp).
11g XE Beta has only 4GB of user data so i don't think you can put your 6GB in it.
Original exp is deprecated in 11gR2 - it does not export tables with deferred segment creation. You will need to use expdp.
The limit was raised to 11 GB with 11g. ;)