expdp system directory=DATA_PUMP dumpfile=FullDB1_Jan25_08.dmp job_name=test3 logfile=FullDB1_Jan25_08_EXPDP.log...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
If I use the above syntax, I am not seeing all the schema names in log file during expdp as we see in exp option.
The following system schemas are not exported as part of a Full export because the metadata they contain is exported as part of other objects in the dump file set: SYS, ORDSYS, EXFSYS, MDSYS, DMSYS, CTXSYS, ORDPLUGINS, LBACSYS, XDB, SI_INFORMTN_SCHEMA, DIP, DBSNMP, and WMSYS.
So you will not see every schema. But you should see the schemas in your database not in the above list.
Dig Deeper on Oracle database administration
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.continue reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.continue reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.