Home » SQL & PL/SQL » SQL & PL/SQL » I have a little problem in Oracle 10g Database For Windows
I have a little problem in Oracle 10g Database For Windows [message #14702] Sun, 05 September 2004 00:08 Go to next message
Bebe
Messages: 5
Registered: March 2004
Junior Member
Hi there.I install Oracle 10g standard for windows 32 .I delete all my tables from database and when i do this command "Select table_name from user_tables;"
i receive this.
BIN$u1xVB/eUSQ6ibRpt2AvMmw==$0
BIN$3mnfDB+yQLuitVwMfb77cg==$0
BIN$ZJgOAimNS16WAWPXuDyQxQ==$0
BIN$9o6in/GsT1GNv9uPrMzdXg==$0
BIN$VfdLTgeNTxukMbyP4G/SIw==$0
BIN$3yaWm9J5Sb+vef+zVUBqXw==$0
BIN$YkchII8cQrelO6XVuNB/PQ==$0
BIN$fTWG16AgTnCtvkZBheP8Ew==$0
BIN$d7Y5XnZLQSas3sQoxCzF+Q==$0
BIN$A6u4LbHlT666w0FLt1PKSg==$0
BIN$nP+kT4O3RYSdvvqfGLyRyw==$0
How can i delete this?,and start again without this.Please send me a reply with the solution.Thanks A Lot
Re: I have a little problem in Oracle 10g Database For Windows [message #14703 is a reply to message #14702] Sun, 05 September 2004 00:19 Go to previous messageGo to next message
Bebe
Messages: 5
Registered: March 2004
Junior Member
Hi there.I install Oracle 10g standard for windows 32 .I delete all my
tables from database and when i do this command "Select table_name from
user_tables;"
i receive this.
BIN$u1xVB/eUSQ6ibRpt2AvMmw==$0
BIN$3mnfDB+yQLuitVwMfb77cg==$0
BIN$ZJgOAimNS16WAWPXuDyQxQ==$0
BIN$9o6in/GsT1GNv9uPrMzdXg==$0
BIN$VfdLTgeNTxukMbyP4G/SIw==$0
BIN$3yaWm9J5Sb+vef+zVUBqXw==$0
BIN$YkchII8cQrelO6XVuNB/PQ==$0
BIN$fTWG16AgTnCtvkZBheP8Ew==$0
BIN$d7Y5XnZLQSas3sQoxCzF+Q==$0
BIN$A6u4LbHlT666w0FLt1PKSg==$0
BIN$nP+kT4O3RYSdvvqfGLyRyw==$0
How can i delete this?,and start again without this.Please send me a
reply with the solution.Thanks A Lot
Re: I have a little problem in Oracle 10g Database For Windows [message #194367 is a reply to message #14703] Thu, 21 September 2006 13:27 Go to previous messageGo to next message
canicula
Messages: 1
Registered: June 2006
Junior Member
Yep, I got the very same problem.
how can I get rid of these?
co-ask.
Re: I have a little problem in Oracle 10g Database For Windows [message #194368 is a reply to message #194367] Thu, 21 September 2006 13:30 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Those are dropped tables that are kept in the RECYCLEBIN for flashback purposes. To remove them, you need to issue:
PURGE RECYCLEBIN;


Re: I have a little problem in Oracle 10g Database For Windows [message #194394 is a reply to message #14702] Thu, 21 September 2006 23:42 Go to previous messageGo to next message
vijaykumarsudi
Messages: 9
Registered: September 2006
Location: hyderabad
Junior Member

Hello sir,
The tables you have deleted are in recycle bin.Inorder to delete them from recyclebin type command purge recyclebin; at SQL prompt.
Re: I have a little problem in Oracle 10g Database For Windows [message #194515 is a reply to message #194394] Fri, 22 September 2006 08:17 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
What additional information did this offer that ebrian didn't say?
Re: I have a little problem in Oracle 10g Database For Windows [message #194902 is a reply to message #194515] Tue, 26 September 2006 01:54 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Well, it did add that you need to issue that command at the SQL Prompt, which might help the extremely hard of thinking.
Other than that, not much.
Previous Topic: sql prompt
Next Topic: returning current weeks first date along with sysdate
Goto Forum:
  


Current Time: Sun Dec 04 20:44:12 CST 2016

Total time taken to generate the page: 0.10433 seconds