Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm quite confused and I need some clarification!

I do full export of database with Export Pump (for replication/duplication).

What I usually do is:

SQL>SHUTDOWN IMMEDIATE
SQL>STARTUP RESTRICT

Then export, so I can have a consistent export (DMP-file).

Now can I export only with the parameter CONSISTENT=Y and/or FLASHBACK_SCN=SOME_NUMBER? What is the differences (if any), and when to use them?

I hope some one explain it to me in simple language!

What are the best practices in this regard?

share|improve this question
3  
There is no need to start Oracle in restricted mode in order to get a consistent dump. –  a_horse_with_no_name Mar 14 '13 at 8:45

1 Answer 1

up vote 1 down vote accepted

Data Pump command-line arguments are partially backward-compatible with Export and Import utilities, and CONSISTENT maps to FLASHBACK_TIME.

FLASHBACK_SCN is used to specify system change number until all changes from the source database are exported. FLASHBACK_TIME allows you to specify change time. When you specify CONSISTENT, Data Pump Export determines the current time and uses that value for FLASHBACK_TIME implicitly.

For more info read Oracle Database Utilities.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.