Home » SQL & PL/SQL » SQL & PL/SQL » how can i remove the garbage table name from tab (oracle,10g,win xp)
how can i remove the garbage table name from tab [message #284941] Sun, 02 December 2007 23:37 Go to next message
sd_md_rizwan@yahoo.com
Messages: 37
Registered: September 2007
Location: Saudi Arabia
Member

hi this is rizwan
how can i remove the garbage table name from tab
sometimes when table is deleted it leaves the garbage name, please anybody tell me how to remove them from tab
thank u
Re: how can i remove the garbage table name from tab [message #284948 is a reply to message #284941] Mon, 03 December 2007 00:05 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Dear what backend and frontend are you using?
Re: how can i remove the garbage table name from tab [message #284957 is a reply to message #284941] Mon, 03 December 2007 00:21 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Purge the recycle bin:
SQL> select * From tab;

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
PLAN_TABLE                     TABLE
KC_POSTE                       TABLE
TOAD_PLAN_TABLE                TABLE
TEST                           TABLE
BIN$OQ6MFxTHQwWhQ34OW+c+Cw==$0 TABLE
BIN$ct/65gGKR6OZmeG8YB7IGA==$0 TABLE
BIN$z/oAoqLDRVmrJ98QY+5Ivw==$0 TABLE
BIN$6HVy4Hc/RuyWpF9O3x0LFQ==$0 TABLE
BIN$DhwjsKgnT7amGQc8cgdGmA==$0 TABLE
BIN$4gghvmQIQjCqDdt0OFm3Ow==$0 TABLE
BIN$S31ZPlV6RvCNFRPyGFnnwQ==$0 TABLE
DEPT                           TABLE
EMP                            TABLE
BONUS                          TABLE
BIN$8mc+oThrSOW+5yFCkCxXCw==$0 TABLE
BIN$N7TMFPeATDGe/UXB4OLm+g==$0 TABLE
BIN$PXCMb2MbSv2NuxDAyBxDxA==$0 TABLE
BIN$CruurlR9RXu2BBBFA6GRMA==$0 TABLE
BIN$MvWwT8dSRVuZXanE4cUJmQ==$0 TABLE
BIN$d/S6YO59QROG7YJWD9Rvaw==$0 TABLE
BIN$vvOMJveyRwW4VNgHp9iggA==$0 TABLE
BIN$CXhhnbmNQSKWw6ozmv9Dpg==$0 TABLE
BIN$7skCGOrDQqOStPpyDeVNEQ==$0 TABLE
EXT_TABLE                      TABLE

24 rows selected.

SQL> purge recyclebin;

Recyclebin purged.

SQL> select * From tab;

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
PLAN_TABLE                     TABLE
KC_POSTE                       TABLE
TOAD_PLAN_TABLE                TABLE
TEST                           TABLE
DEPT                           TABLE
EMP                            TABLE
BONUS                          TABLE
EXT_TABLE                      TABLE

8 rows selected.

SQL>
Re: how can i remove the garbage table name from tab [message #284959 is a reply to message #284957] Mon, 03 December 2007 00:26 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Dear how did this happen. I dont see these kinds of name in my database. I think tab table is data dictionary table right?
Re: how can i remove the garbage table name from tab [message #284963 is a reply to message #284948] Mon, 03 December 2007 00:30 Go to previous messageGo to next message
sd_md_rizwan@yahoo.com
Messages: 37
Registered: September 2007
Location: Saudi Arabia
Member

hi thanks for reply

iam using oracle 10g for both frontend and backend
Re: how can i remove the garbage table name from tab [message #284965 is a reply to message #284957] Mon, 03 December 2007 00:34 Go to previous messageGo to next message
sd_md_rizwan@yahoo.com
Messages: 37
Registered: September 2007
Location: Saudi Arabia
Member

hi this is rizwan
i got cleared the garbage table names from the tab with ur solution thank you verymuch for the help.
Re: how can i remove the garbage table name from tab [message #284966 is a reply to message #284963] Mon, 03 December 2007 00:34 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Dear it is not wise to Delete data from Data Dictionary tables. I you want to view the table names only then you can execute following query:

SELECT * FROM tab
WHERE tname NOT LIKE ('BIN$'%);

Regards,
Azam Khan
Re: how can i remove the garbage table name from tab [message #284969 is a reply to message #284959] Mon, 03 December 2007 00:39 Go to previous messageGo to next message
sd_md_rizwan@yahoo.com
Messages: 37
Registered: September 2007
Location: Saudi Arabia
Member

hi azamkhan thanks for the reply
i got cleared the garbage table names by help of littlefoot anyhow thanks for the help

the situation was

SQL> select * From tab;

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
PLAN_TABLE TABLE
KC_POSTE TABLE
TOAD_PLAN_TABLE TABLE
TEST TABLE
BIN$OQ6MFxTHQwWhQ34OW+c+Cw==$0 TABLE
BIN$ct/65gGKR6OZmeG8YB7IGA==$0 TABLE
BIN$z/oAoqLDRVmrJ98QY+5Ivw==$0 TABLE
BIN$6HVy4Hc/RuyWpF9O3x0LFQ==$0 TABLE
BIN$DhwjsKgnT7amGQc8cgdGmA==$0 TABLE
BIN$4gghvmQIQjCqDdt0OFm3Ow==$0 TABLE
BIN$S31ZPlV6RvCNFRPyGFnnwQ==$0 TABLE
DEPT TABLE
EMP TABLE
BONUS TABLE
BIN$8mc+oThrSOW+5yFCkCxXCw==$0 TABLE
BIN$N7TMFPeATDGe/UXB4OLm+g==$0 TABLE
BIN$PXCMb2MbSv2NuxDAyBxDxA==$0 TABLE
BIN$CruurlR9RXu2BBBFA6GRMA==$0 TABLE
BIN$MvWwT8dSRVuZXanE4cUJmQ==$0 TABLE
BIN$d/S6YO59QROG7YJWD9Rvaw==$0 TABLE
BIN$vvOMJveyRwW4VNgHp9iggA==$0 TABLE
BIN$CXhhnbmNQSKWw6ozmv9Dpg==$0 TABLE
BIN$7skCGOrDQqOStPpyDeVNEQ==$0 TABLE
EXT_TABLE TABLE

24 rows selected.

SQL> purge recyclebin;

Recyclebin purged.

SQL> select * From tab;

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
PLAN_TABLE TABLE
KC_POSTE TABLE
TOAD_PLAN_TABLE TABLE
TEST TABLE
DEPT TABLE
EMP TABLE
BONUS TABLE
EXT_TABLE TABLE

8 rows selected.

SQL>
Re: how can i remove the garbage table name from tab [message #284971 is a reply to message #284969] Mon, 03 December 2007 00:46 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Just five moment read the below lilnk.

http://www.orafaq.com/forum/h/80704/

Babu
Re: how can i remove the garbage table name from tab [message #284983 is a reply to message #284971] Mon, 03 December 2007 01:22 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
To avoid that a dropped table ends up in the recycle bin you can use:
DROP TABLE <yourtable> PURGE;
.

Moved to Newbies, there's no Forms involved as far as I can see.

And as for TAB:
OracleŽ Database Reference 10g Release 2 (10.2)

TAB

TAB is included for compatibility. Oracle recommends that you do not use this view.
User_tables is a viable alternative.

MHE
Re: how can i remove the garbage table name from tab [message #284992 is a reply to message #284969] Mon, 03 December 2007 01:36 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you never want to use the recycle bin then set "recyclebin" parameter to "off".

Regards
Michel
Previous Topic: Write the XML into CLOB using PL/SQL Procedure (merged 2 threads)
Next Topic: Is there any way to refresh the package initialization section ?
Goto Forum:
  


Current Time: Sat Dec 10 20:28:12 CST 2016

Total time taken to generate the page: 0.05441 seconds