Database Utilities (MOSC)

MOSC Banner

expdp with flashback_scn returned same dump file size as without flashback_scn

edited Sep 30, 2015 3:56AM in Database Utilities (MOSC) 4 commentsAnswered ✓

Dear All,

I am exporting some tables of the database using expdp with flashback_scn. The dump file size is same as if I execute the expdp command without flashback_scn. Can anyone please help me that why the size of dump file is same? I did following steps:

1. select DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER from dual;

2. Waited till all the transactions disappeared from gv$transaction where STARTSCN_B is less as the flashback_scn returned above.

3. select DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER from dual;

4. expdp <user>/<pass> tables=<table_names> director=<directory_name> estimate_only=y flashback_scn=<flashback_scn returned from step-3>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center