OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Data Pump (Oracle 10g, Windows 2003)

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

Data Pump [message #522656]

Tue, 13 September 2011 01:44

gxeon
Messages: 53
Registered: January 2011
Location: Mumbai

Member

Hello

I need to use Data Pump for the first time on my production Database.Currently on Testing Database, when i am taking schema level export there are no errors or warnings in the log file but when i importing it gives fallowing ORA in the import log file. i searched on google,the only way i found is to recompile the invalid objects. Please tell me how to avoid this warnings in log file.

"ORA-39082: Object type ALTER_PROCEDURE:"QUANTISV4"."P_CTM_ABN_INVST_EQUITY" created with compilation warnings"

Please help i am new to Oracle DBA.

GG

Report message to a moderator

Re: Data Pump [message #522671 is a reply to message #522656]

Tue, 13 September 2011 02:11

Michel Cadot
Messages: 54239
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Please tell me how to avoid this warnings in log file.

Instead of trying to remove the warnings in the log file you should fix the code so that it does not generate these warnings.

Check plsql_warnings parameters in both databases, I bet the settings are different.
Always enable the warnings on development/test environment.

Regards
Michel

Report message to a moderator

Re: Data Pump [message #522685 is a reply to message #522671]

Tue, 13 September 2011 02:46

gxeon
Messages: 53
Registered: January 2011
Location: Mumbai

Member

Sir

as you said i changed the parameter with

Alter System set PLSQL_WARNINGS='DISABLE:ALL' scope=spfile;

but still its giving "ORA-39082: Object type ALTER_PROCEDURE:"QUANTISV4"."P_CTM_ABN_INVST_INTERSCHEME" created with compilation warnings" , total 566 errors in the import logfile.

Report message to a moderator