Home » RDBMS Server » Server Administration » strange problem in droping a single table
strange problem in droping a single table [message #231999] Thu, 19 April 2007 01:14 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
SQL> conn scott/tiger
Connected.

SQL> drop table admins;
drop table admins
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-20000: Drop is not currently supported,
Please Contact WIZMEN Systems
ORA-06512: at line 2


I had assigned a DBA role to Scott
i also run the scripts catalog.sql and catproc.sql by logon as sys as sysdba
Can anybody help me in resolving the strange problem?
Re: strange problem in droping a single table [message #232002 is a reply to message #231999] Thu, 19 April 2007 01:17 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You have a DDL that forbids the "drop table".
Quote:
ORA-20000: Drop is not currently supported,
Please Contact WIZMEN Systems

is a custom message that comes from this trigger.
Ask your favorite DBA or "Contact WIZMEN Systems".

Regards
Michel


Previous Topic: Scripts to check object's last modified date
Next Topic: Oracle 9i database
Goto Forum:
  


Current Time: Sun Dec 04 14:26:57 CST 2016

Total time taken to generate the page: 0.07320 seconds