Difference between revisions of "Datapump"
From dbawiki
(Created page with "==Use the flashback parameter to export and import a consitent dump== expdp <user>/<pwd> parfile=db_params.par where db_params.par would look like this: flashback_time=sysdat...") |
(→Use the flashback parameter to export and import a consitent dump) |
||
| Line 1: | Line 1: | ||
| − | ==Use the flashback parameter to export and import a | + | ==Use the flashback parameter to export and import a consistent dump== |
expdp <user>/<pwd> parfile=db_params.par | expdp <user>/<pwd> parfile=db_params.par | ||
Revision as of 19:29, 28 November 2011
Use the flashback parameter to export and import a consistent dump
expdp <user>/<pwd> parfile=db_params.par
where db_params.par would look like this:
flashback_time=sysdate directory=DATAPUMP_DIR dumpfile=db_schema.dmp schemas=(apps,test)
This performs a consistent dump of 2 schemas
Keeping the parameters in a file like this allows the possibility to reuse it for the import:
impdp <user>/<pwd> parfile=db_params.par
