read contents in export dump
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