| strange problem in droping a single table [message #231999] |
Thu, 19 April 2007 01:14  |
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  |
 |
Michel Cadot
Messages: 68686
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
