Home » SQL & PL/SQL » SQL & PL/SQL » un-known table in schema (10.2.0.1.0)
un-known table in schema [message #432294] Mon, 23 November 2009 08:23 Go to next message
nasir_mughal
Messages: 121
Registered: April 2007
Location: Karachi
Senior Member
Hi

I found a table in un-recognize format created by oracle in one of our schema.
1) I wonder what is reason it was created by oracle.?
2) How to drop it.?


SQL> SELECT * FROM CAT
  2  WHERE TABLE_TYPE='TABLE'
  3  /


TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
REO6                           TABLE
SALESMAN                       TABLE
SEM_K                          TABLE
SERIAL_NUMBERS                 TABLE
K4                             TABLE
KF10                           TABLE
BIN$ddUuYstdQ+G4F813aOAoRg==$0 TABLE
M4                             TABLE
BRDATA                         TABLE



Kindly help me.

Thanks in advance


Re: un-known table in schema [message #432295 is a reply to message #432294] Mon, 23 November 2009 08:30 Go to previous messageGo to next message
BlackSwan
Messages: 24904
Registered: January 2009
Senior Member
caused by DROP TABLE & it resides in RECYCLE BIN

[Updated on: Mon, 23 November 2009 08:31]

Report message to a moderator

Re: un-known table in schema [message #432303 is a reply to message #432294] Mon, 23 November 2009 08:57 Go to previous messageGo to next message
Michel Cadot
Messages: 63801
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use PURGE statement.

Regards
Michel
Re: un-known table in schema [message #432304 is a reply to message #432295] Mon, 23 November 2009 08:58 Go to previous messageGo to next message
nasir_mughal
Messages: 121
Registered: April 2007
Location: Karachi
Senior Member
Thanks sir, but how to completely remove it from schema.? And I dont see anything in RECYCLE BIN.

Kindly help.
Re: un-known table in schema [message #432306 is a reply to message #432304] Mon, 23 November 2009 09:01 Go to previous messageGo to next message
nasir_mughal
Messages: 121
Registered: April 2007
Location: Karachi
Senior Member
Problem solved.

Thanks sir.
Re: un-known table in schema [message #432441 is a reply to message #432304] Tue, 24 November 2009 04:28 Go to previous message
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
Senior Member
Smile

Here it is..

Using Oracle's recycle bin

Previous Topic: oracle 9i
Next Topic: Any function of oracle to return the quarter of sysdate
Goto Forum:
  


Current Time: Sun Sep 25 07:50:37 CDT 2016

Total time taken to generate the page: 0.11634 seconds