 drop table problems [message #111712] |
Fri, 18 March 2005 14:08  |
ebort
Messages: 2
Registered: March 2005
|
Junior Member |
|
|
SQL> drop table student;
Table dropped.
SQL> select table_name
2 from user_tables;
TABLE_NAME
------------------------------
BIN$RforjzrfTfGj/dJb59hVmg==$0
BIN$q7ZvRlRLQTy2V4Ybz7Mq9g==$0
BIN$IVda9q6zRt6GsPIbxLwXWQ==$0
BIN$R4fvQuJIS4eqAFIwogDEdg==$0
BIN$u7yCFbB4SUuwfyIrHMapiw==$0
BIN$iXOOX33nRW+Fu3Q/3jz4Hw==$0
6 rows selected.
No matter how I drop a table, this is the result. The table name is replaced with a line like this...
BIN$RforjzrfTfGj/dJb59hVmg==$0
Why?? This is on my local machine adn an oracle 10g
Someone please help!!
|
|
|
|
| Re: drop table problems [message #111713 is a reply to message #111712] |
Fri, 18 March 2005 14:19  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
That's because it's now in the recycle bin (do a select from user_recyclebin to verify). If you want to get rid of it, do the following:
DROP TABLE ... PURGE;
or
PURGE recyclebin;
Best regards.
Frank
|
|
|
|
| Re: drop table problems [message #111759 is a reply to message #111713] |
Sat, 19 March 2005 07:49 |
ebort
Messages: 2
Registered: March 2005
|
Junior Member |
|
|
Thank you Frank! Super! I'm guessing you know how to restore things from recyclebin as well...?
And..is it possible to turn of the visibility of the recyclebin? Meaning that if I write select table_name from user_tables; the content of the recyclebin does not show.
Regards Eirik
[Updated on: Sat, 19 March 2005 07:53] Report message to a moderator |
|
|
|
| Re: drop table problems [message #111765 is a reply to message #111759] |
Sat, 19 March 2005 09:11 |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
1. Yes, lookup the "FLASHBACK TABLE <original_table_name> TO BEFORE DROP {RENAME TO <new_table_name>};" command in the SQL Reference guide.
2. No. If you are desperate, you can change the dictionary views, however, I suggest you learn to live with it.
Best regards.
Frank
|
|
|
|
| Re: drop table problems [message #111917 is a reply to message #111712] |
Mon, 21 March 2005 17:01 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
You have 2 other options to the drop .. purge command:
1. Used the new dropped column that has been added to many of the standard views like user_tables and user_indexes to only get those that have not been dropped.
2. When I upgraded (on windows) from 10.1.0.2 to 10.1.0.3, the behavior changed, and a regular select table_name from user_tables only returned the ones that were not dropped.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
