Home » RDBMS Server » Server Utilities » IMP-00041: Warning: object created with compilation warnings
IMP-00041: Warning: object created with compilation warnings [message #135190] Tue, 30 August 2005 06:48 Go to next message
orcl dba
Messages: 68
Registered: August 2005
Member
Hi,

I have performed a user-mode import into my database and I have quite some warnings in my log file. The export server uses UTF8 NCHAR character set and the import was done in AL16UTF16 NCHAR character set(The database character set of the source and target database are the same). All the tables were created and the data was imported successfully. I have the "IMP-00041: Warning: object created with compilation warnings" number of times while the views were being created. My question is what action do I need to take regarding this warning? Finally, the import ended with the "import terminated successfully with warnings" message. Please advise.

Thanks,
Sankalpa
Re: IMP-00041: Warning: object created with compilation warnings [message #135199 is a reply to message #135190] Tue, 30 August 2005 07:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It is quite a normal / frequent behaviour
after import ,compile those objects manually.
Re: IMP-00041: Warning: object created with compilation warnings [message #441715 is a reply to message #135199] Tue, 02 February 2010 20:46 Go to previous messageGo to next message
becks999
Messages: 2
Registered: November 2009
Junior Member
Hi,

While surfing the forum, chance upon this thread.

I also have this compliation warning when i do a import. So how do i compile the objects manually..

Sorry new to oracle database.

Thanks
Re: IMP-00041: Warning: object created with compilation warnings [message #441717 is a reply to message #441715] Tue, 02 February 2010 21:00 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>So how do i compile the objects manually..
What OBJECT_NAME & OBJECT_TYPE has problem?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: IMP-00041: Warning: object created with compilation warnings [message #441720 is a reply to message #441715] Tue, 02 February 2010 21:18 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
As you didn`t Provided the required information...

I can give you this link...

http://www.orafaq.com/node/2008.
IF it is not sufficient post what Blackswan asked.
And you versions.And how you performed the import?And the total information.

Goodluck
sriram Smile
Re: IMP-00041: Warning: object created with compilation warnings [message #441731 is a reply to message #441715] Tue, 02 February 2010 22:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
So how do i compile the objects manually..

alter <object type> <object name> compile;
and
show error
to get the errors.

Regards
Michel
Re: IMP-00041: Warning: object created with compilation warnings [message #441739 is a reply to message #135190] Wed, 03 February 2010 00:08 Go to previous messageGo to next message
becks999
Messages: 2
Registered: November 2009
Junior Member
Sorry about the insufficent information..
The import export is from Oracle 10g2.

One of the warnings is as below:

IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "SYSTEM"."SMHOST_V" ("ID", "HOSTN"
"AME", "RPCADDRESS", "FTPADDRESS", "OS", "OS_VERSION") AS "
"SELECT"
" nameobject_id_sequenceid_ id,"
" host_hostname_hostname,"
" host_rpcaddress_rpcaddress,"
" Host_FTPAddress_FTPAddress,"
" Host_OS_os,"
" Host_OSVersion_os_version"
"from SMhost_s"

Do not really understand which one is the object name and type.
Re: IMP-00041: Warning: object created with compilation warnings [message #441746 is a reply to message #441739] Wed, 03 February 2010 00:26 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Do not really understand which one is the object name and type.

CREATE FORCE VIEW "SYSTEM"."SMHOST_V"
              ^      ^        ^
              |      |        |
     Object Type   Owner     Name

Regards
Michel
Previous Topic: SQL Loader
Next Topic: SOLRJ Loadjava Classes into Database
Goto Forum:
  


Current Time: Sat Dec 03 12:29:33 CST 2016

Total time taken to generate the page: 0.12876 seconds