Home » SQL & PL/SQL » Client Tools » flashback .. to before drop
flashback .. to before drop [message #247062] Sat, 23 June 2007 07:06 Go to next message
seyiisq
Messages: 125
Registered: September 2005
Senior Member
I dropped a significant table in my database and has been trying to use a 'flashback ... to before drop' but keep getting the error as shown below

This table was created and drop while i was logged on as user system.

SQL> drop table plants;

Table dropped.

SQL> flashback table plants to before drop;
flashback table plants to before drop
*
ERROR at line 1:
ORA-38305: object not in RECYCLE BIN


SQL> flashback table PLANTS to before drop;
flashback table PLANTS to before drop
*
ERROR at line 1:
ORA-38305: object not in RECYCLE BIN

[Updated on: Sat, 23 June 2007 08:07]

Report message to a moderator

Re: flashback .. to before drop [message #247072 is a reply to message #247062] Sat, 23 June 2007 10:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please always post your Oracle version (4 decimals).

Post "select original_name, type, createtime, droptime from user_recyclebin;"

Please read and follow How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS
Break your lines to max 80-100 characters when you format.

Regards
Michel
Re: flashback .. to before drop [message #247157 is a reply to message #247062] Sun, 24 June 2007 14:24 Go to previous messageGo to next message
seyiisq
Messages: 125
Registered: September 2005
Senior Member
thanks for the advice. i use oracle 10.1.0.2 on window xp
I got to know later that i can't use
'flashback table ....to before drop' while logged on as user 'SYSTEM' because any table dropped does not go to the recycle bin, but was just wondering if there is a round it.

I tried the same in another user schema and it worked should i assume that any table dropped in the system schema cannot be retrieved.
Re: flashback .. to before drop [message #247158 is a reply to message #247157] Sun, 24 June 2007 14:31 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.

It is not the object created by SYSTEM but object created in SYSTEM tablespace that are not protected by recycle bin.

Regards
Michel
Previous Topic: Matrix out put
Next Topic: Number of db_files too high
Goto Forum:
  


Current Time: Sat Dec 10 14:34:31 CST 2016

Total time taken to generate the page: 0.09098 seconds