Database Administration (MOSC)

MOSC Banner

read contents in export dump

edited Sep 7, 2017 7:37AM in Database Administration (MOSC) 7 commentsAnswered ✓

Hello,

I have export dumps taken in target database using expdp

and this db was refreshed with another db so the data was overwritten.

Now the user is asking can we get a DDL for one of the statement in table using old backup without actually importing to database.

I wanted to know old value before refresh.. Is there any way ?

I tried below but its failing with error. Dumps are on server and dba directory is also in valid.

impdp \'/ as sysdba\' directory=EXP SHOW=y FILE=EXP_schemalevel_OLD_01.dmp > EXP_schemalevel_OLD_01.dmp.sql

ORA-39002: invalid operation

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