Home » RDBMS Server » Server Utilities » Data Pump (Oracle 10g, Windows 2003)
Data Pump [message #522656] Tue, 13 September 2011 01:44 Go to next message
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
Re: Data Pump [message #522671 is a reply to message #522656] Tue, 13 September 2011 02:11 Go to previous messageGo to next message
Michel Cadot
Messages: 60055
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
Re: Data Pump [message #522685 is a reply to message #522671] Tue, 13 September 2011 02:46 Go to previous messageGo to next message
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.
Re: Data Pump [message #522687 is a reply to message #522685] Tue, 13 September 2011 02:47 Go to previous messageGo to next message
gxeon
Messages: 53
Registered: January 2011
Location: Mumbai
Member
i changed it on both the databases.
Re: Data Pump [message #522690 is a reply to message #522687] Tue, 13 September 2011 02:55 Go to previous message
Michel Cadot
Messages: 60055
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have the log and code, I have not.
You can know what is the root of the warnings, I can't.

Regards
Michel
Previous Topic: Removed the current archive logs
Next Topic: expdp -Error:Job "DBA_UTIL"."SYS_EXPORT_SCHEMA_08" stopped due to fatal error
Goto Forum:
  


Current Time: Thu Dec 25 11:54:23 CST 2014

Total time taken to generate the page: 0.09888 seconds