Difference between revisions of "Datapump"
From dbawiki
(→Use the flashback parameter to export and import a consitent dump) |
|||
| Line 4: | Line 4: | ||
where db_params.par would look like this: | where db_params.par would look like this: | ||
| − | flashback_time=sysdate | + | flashback_time=”to_timestamp (to_char (sysdate, ‘YYYY-MM-DD HH24:MI:SS’), ‘YYYY-MM-DD HH24:MI:SS’)” |
directory=DATAPUMP_DIR | directory=DATAPUMP_DIR | ||
dumpfile=db_schema.dmp | dumpfile=db_schema.dmp | ||
Revision as of 19:36, 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=”to_timestamp (to_char (sysdate, ‘YYYY-MM-DD HH24:MI:SS’), ‘YYYY-MM-DD HH24:MI:SS’)” 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
