This content has been marked as final. Show 8 replies
expdp and impdp.
See this Oracle-base article for examples.
The OWNER parameter of exp has been replaced by the SCHEMAS parameter which is used to specify the schemas to be exported. The following is an example of the schema export and import syntax.
expdp scott/tiger@db10g schemas=SCOTT directory=TEST_DIR dumpfile=SCOTT.dmp logfile=expdpSCOTT.log
impdp scott/tiger@db10g schemas=SCOTT directory=TEST_DIR dumpfile=SCOTT.dmp logfile=impdpSCOTT.logFor example output files see expdpSCOTT.log and impdpSCOTT.log.
rp0428 wrote:Wow thanks Rp :) . But why inventory management has to be unified hehehe? Just kidding!
I have no idea what is UIM
Unified Inventory Management. And now you know as much as I do about it!
AmosAw wrote:Datapump is definitely there in 11.2 as well. What do you mean by backup of database domain ? Database domain won't be something like test.us.oracle.com ? So how would you take the backup of it?
Thanks for the heads up. But that's for 10g right? Still applicable for mine i.e. 11g (22.214.171.124.0)? And lastly, what about backing up for database domain? Once backed up it does the same for both schema and domain?
Same for 11g. Backing up the domain is a weblogic issue. You will need to refer to those docs or post in the weblogic forum
For general questions
WebLogic Server - General
WebLogic Server - Management / Console / WLST / Configuration
I am confused myself. Here's the extract from the guide:
+"As a precaution against a failed patch installation, Oracle recommends that you backup your database schema for UIM, database domain for UIM, WebLogic Server domain for UIM, the UIM_Home directory (UIM install directory), and the OUI inventory directory."+
I figured the backup for WLS domain can come later so sorting the issue of backing up for database schema and database domain. Did I misconstrue the database domain for UIM part?
Appreciate all the help thus far. Thanks guys
Edited by: AmosAw on Aug 5, 2012 9:19 PM