Home » SQL & PL/SQL » SQL & PL/SQL » Drop Function gives error (oracle 12c Windows 2012)
Drop Function gives error [message #666615] Fri, 17 November 2017 03:53 Go to next message
muthukrish104
Messages: 11
Registered: November 2017
Junior Member
Hi,

One of our developer is getting this error while trying to drop or replace it with the same name on a Function.

Quote:

ora-01041: internal error.hostdef extension doesn't exist.

It gives the same error, even if we just do begin and end;

But able to create it in another name.

Regards
M.Krish
Re: Drop Function gives error [message #666621 is a reply to message #666615] Fri, 17 November 2017 06:25 Go to previous messageGo to next message
EdStevens
Messages: 863
Registered: September 2013
Senior Member
What did you discover when you googled 'ora-01041'?

Everything I find on it deals with issues when you connect, not in executing DDL once you have a connection.

What do you find in the alert log at the time of the error?
Re: Drop Function gives error [message #666702 is a reply to message #666621] Tue, 21 November 2017 00:24 Go to previous messageGo to next message
muthukrish104
Messages: 11
Registered: November 2017
Junior Member
Hi,

Thanks for the reply,

There is no issue in the connection, because the same can be created with another name.

The alert log shows the same error code line only.

Regards
M.Krish
Re: Drop Function gives error [message #666704 is a reply to message #666702] Tue, 21 November 2017 01:08 Go to previous messageGo to next message
Littlefoot
Messages: 21266
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Can you afford shutting down the database server? If so, what happens once it is up again?
Re: Drop Function gives error [message #666732 is a reply to message #666704] Tue, 21 November 2017 09:03 Go to previous messageGo to next message
Alien
Messages: 275
Registered: June 1999
Senior Member
Hi,

what is the name of the function? Any difference if you include the schema in the drop command?

Regards,

Arian
Re: Drop Function gives error [message #666738 is a reply to message #666732] Wed, 22 November 2017 05:52 Go to previous messageGo to next message
muthukrish104
Messages: 11
Registered: November 2017
Junior Member
Hi Alien,

Thanks for the reply, we have checked the length of the name and adding schema name infront of the function.
But no use.

Is it possible to import them from the Production server through EXPDP and while import can we use replace keyword like EXIST_ACTION=REPLACE for tables?

Regards
M.Krish
Re: Drop Function gives error [message #666743 is a reply to message #666738] Wed, 22 November 2017 07:05 Go to previous message
BlackSwan
Messages: 25748
Registered: January 2009
Location: SoCal
Senior Member

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read
Previous Topic: how can get Three consecutive days
Next Topic: Unable to grant Admin privileges on SQL Developer 12c
Goto Forum:
  


Current Time: Fri Dec 15 06:41:53 CST 2017

Total time taken to generate the page: 0.01406 seconds