| unable to drop table [message #61369] |
Sat, 17 April 2004 16:16  |
vadlamani
Messages: 39
Registered: November 2003
|
Member |
|
|
select * from tab;
TNAME TABTYPE CLUSTERID
------------------------- ----- ------- ----------
AUTHOR TABLE
CUSTOMER TABLE
PUBLISHER TABLE
BOOK_CATEGORIES TABLE
ORDERS TABLE
WRITTENBY TABLE
BOOK TABLE
BIN$Hp93RFJZQLeWZdSi32nKNg==$0 TABLE
BIN$gVjZDdI4RJ+YF72FBQx2fg==$0 TABLE
BIN$rMwdpm5oTrm5nYBv1g4Fow==$0 TABLE
INVENTORY TABLE
BIN$HUb4AmTZSA2HdiP/Ufakqw==$0 TABLE
12 rows selected.
when i try to drop the junk tables
SQL> drop table BIN$HUb4AmTZSA2HdiP/Ufakqw==$0;
drop table BIN$HUb4AmTZSA2HdiP/Ufakqw==$0
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
SQL> drop table BIN$Hp93RFJZQLeWZdSi32nKNg==$0
2 ;
drop table BIN$Hp93RFJZQLeWZdSi32nKNg==$0
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
SQL> select * from BIN$Hp93RFJZQLeWZdSi32nKNg==$0;
select * from BIN$Hp93RFJZQLeWZdSi32nKNg==$0
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
SQL> desc BIN$Hp93RFJZQLeWZdSi32nKNg==$0
SP2-0565: Illegal identifier.
I am getting error
Can any one tell me hoe to drop those tables & even i dont know how i created that tables.i couldnt even SELECT from those tables
|
|
|
|
| Re: unable to drop table [message #61378 is a reply to message #61369] |
Sun, 18 April 2004 22:50  |
KING
Messages: 9
Registered: February 2002
|
Junior Member |
|
|
These tables might have been created by some application for repository purpose.
you can drop these tables by having the table names within quotes!!!
|
|
|
|
| Re: unable to drop table [message #61450 is a reply to message #61369] |
Sat, 24 April 2004 23:49 |
Kourosh Vakhshouri
Messages: 5
Registered: March 2002
|
Junior Member |
|
|
Dear Sir/Madam
You can drop them from recyclebin.
sql>show recyclebin;
you can find droped tables
and you can use
sql>purge recyclebin;
all droped tables will remove and you can see result by
sql>select * from tab;
Tip:
sql>drop table table_name purge;
For bypassing recyclebin
Sincerely
Kourosh Vakhshouri
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
