| flashback .. to before drop [message #247062] |
Sat, 23 June 2007 07:06  |
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 #247157 is a reply to message #247062] |
Sun, 24 June 2007 14:24  |
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 |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
