OraFAQ Forum: Server Utilities » Check the INSERT statements

Home » RDBMS Server » Server Utilities » Check the INSERT statements (Oracle 11g R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Check the INSERT statements [message #529470]

Tue, 01 November 2011 06:12

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

Report message to a moderator

Re: Check the INSERT statements [message #529472 is a reply to message #529470]

Tue, 01 November 2011 06:19

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

Report message to a moderator

Re: Check the INSERT statements [message #529542 is a reply to message #529472]

Tue, 01 November 2011 13:25

Littlefoot
Messages: 21826
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.

Report message to a moderator

Previous Topic:	using NULLIF statement for two conditions.
Next Topic:	Load multiple tables from SQL* Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 20 14:04:30 CST 2026