Home » RDBMS Server » Server Utilities » Check the INSERT statements (Oracle 11g R2)
Check the INSERT statements [message #529470] Tue, 01 November 2011 06:12 Go to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Hi All,

I have an export dumpfile and when I am importing it in the new database I want to see all the SQL statements including "CREATE", "ALTER", and "INSERT". I am able to see CREATE and ALTER by using the option SHOW=Y in my import statement (IMP) but not able to see the INSERT commands.

Is there any way I can see INSERT statements as well.

Thanks
Deepak
Re: Check the INSERT statements [message #529472 is a reply to message #529470] Tue, 01 November 2011 06:19 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

I am able to see the DDL statements but I want to the DML (INSERT) statements from the dump file export taken by using EXP utility.

Thanks n Regards
Deepak
Re: Check the INSERT statements [message #529542 is a reply to message #529472] Tue, 01 November 2011 13:25 Go to previous message
Littlefoot
Messages: 21530
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I know, you can't do that. However, someone might know better.
Previous Topic: using NULLIF statement for two conditions.
Next Topic: Load multiple tables from SQL* Loader
Goto Forum:
  


Current Time: Wed Feb 19 13:25:54 CST 2020