OraFAQ Forum: Server Utilities

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

Show: Today's Messages :: 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

[Message index]

		Data Pump By: gxeon on Tue, 13 September 2011 01:44
		Re: Data Pump By: Michel Cadot on Tue, 13 September 2011 02:11
		Re: Data Pump By: gxeon on Tue, 13 September 2011 02:46
		Re: Data Pump By: gxeon on Tue, 13 September 2011 02:47
		Re: Data Pump By: Michel Cadot on Tue, 13 September 2011 02:55

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 16:23:15 CDT 2024