OraFAQ Forum: SQL & PL/SQL » Drop Function gives error

Home » SQL & PL/SQL » SQL & PL/SQL » Drop Function gives error (oracle 12c Windows 2012)

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

Drop Function gives error [message #666615]

Fri, 17 November 2017 03:53

muthukrish104
Messages: 82
Registered: November 2017

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

Report message to a moderator

Re: Drop Function gives error [message #666621 is a reply to message #666615]

Fri, 17 November 2017 06:25

EdStevens
Messages: 1377
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?

Report message to a moderator

Re: Drop Function gives error [message #666702 is a reply to message #666621]

Tue, 21 November 2017 00:24

muthukrish104
Messages: 82
Registered: November 2017

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

Report message to a moderator

Re: Drop Function gives error [message #666704 is a reply to message #666702]

Tue, 21 November 2017 01:08

Littlefoot
Messages: 21826
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?

Report message to a moderator

Re: Drop Function gives error [message #666732 is a reply to message #666704]

Tue, 21 November 2017 09:03

Alien
Messages: 292
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

Report message to a moderator

Re: Drop Function gives error [message #666738 is a reply to message #666732]

Wed, 22 November 2017 05:52

muthukrish104
Messages: 82
Registered: November 2017

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

Report message to a moderator

Re: Drop Function gives error [message #666743 is a reply to message #666738]

Wed, 22 November 2017 07:05

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

Report message to a moderator

Previous Topic:	how can get Three consecutive days
Next Topic:	Unable to grant Admin privileges on SQL Developer 12c

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 06 06:11:10 CDT 2026