OraFAQ Forum: Server Utilities » IMP-00041: Warning: object created with compilation warnings

Home » RDBMS Server » Server Utilities » IMP-00041: Warning: object created with compilation warnings

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

IMP-00041: Warning: object created with compilation warnings [message #135190]

Tue, 30 August 2005 06:48

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

Report message to a moderator

Re: IMP-00041: Warning: object created with compilation warnings [message #135199 is a reply to message #135190]

Tue, 30 August 2005 07:22

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

It is quite a normal / frequent behaviour
after import ,compile those objects manually.

Report message to a moderator

Re: IMP-00041: Warning: object created with compilation warnings [message #441715 is a reply to message #135199]

Tue, 02 February 2010 20:46

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

Report message to a moderator

Re: IMP-00041: Warning: object created with compilation warnings [message #441717 is a reply to message #441715]

Tue, 02 February 2010 21:00

BlackSwan
Messages: 26766
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/

Report message to a moderator

Re: IMP-00041: Warning: object created with compilation warnings [message #441720 is a reply to message #441715]

Tue, 02 February 2010 21:18

ramoradba
Messages: 2457
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

Report message to a moderator

Re: IMP-00041: Warning: object created with compilation warnings [message #441731 is a reply to message #441715]

Tue, 02 February 2010 22:47

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: IMP-00041: Warning: object created with compilation warnings [message #441739 is a reply to message #135190]

Wed, 03 February 2010 00:08

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.

Report message to a moderator

Re: IMP-00041: Warning: object created with compilation warnings [message #441746 is a reply to message #441739]

Wed, 03 February 2010 00:26

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	SQL Loader
Next Topic:	SOLRJ Loadjava Classes into Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 14 07:25:46 CST 2025