sqlnewbie08
asked on
Oracle 10g Export
using data pump, when doing a 'full' export using login system, what schemas are being exported? I know it will export all application specific schemas, but does it also export the 'system' schema. Based on the documentation, I'm aware that it does not do sys, dbsnmp, ... The database will obviously be created and will have sys, system schemas already present. I really only want to export the app schema, but was told to do a 'full' export with the system id vs. the application id... not sure why and was hoping to get a better understaing.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I did a 'full' export and then an import using the schema as the login.... see below
However, when i did that it did not import the users, profiles, ..... just the schema's objects.
I was told that if you do the exort and import using the 'system' login you will get everything... ie, it will create all the users, profiles, roles, any schemas...... What I need to understand is since the 'system' schema is already there from the database creation scripts, what will the import do if you use the 'system' as the login for the import to the 'system' schema??? Will is try to recreate the system objects???
expdp directory=expdmpdir dumpfile=expapp.dmp logfile=expapp.log full=y content=metadata_only encryption_password=pswd
impdp app directory=expdmpdir dumpfile=expapp.dmp logfile=imp_app.log full=y content=metadata_only encryption_password=pswd
However, when i did that it did not import the users, profiles, ..... just the schema's objects.
I was told that if you do the exort and import using the 'system' login you will get everything... ie, it will create all the users, profiles, roles, any schemas...... What I need to understand is since the 'system' schema is already there from the database creation scripts, what will the import do if you use the 'system' as the login for the import to the 'system' schema??? Will is try to recreate the system objects???
expdp directory=expdmpdir dumpfile=expapp.dmp logfile=expapp.log full=y content=metadata_only encryption_password=pswd
impdp app directory=expdmpdir dumpfile=expapp.dmp logfile=imp_app.log full=y content=metadata_only encryption_password=pswd
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
In our case we only what the objects for the application, not the data.
Ok.. why would I want to import the SYSTEM schema when it already there from the database creation steps and running catalog and catproc...?
Ok.. why would I want to import the SYSTEM schema when it already there from the database creation steps and running catalog and catproc...?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yes, but SYSTEM is part of the database creation. after i ran the scripts to set up the database, sys and system were already there... SYSTEM is the views for the SYS objects.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER