Home » RDBMS Server » Backup & Recovery » flashback table to before drop; (oracle 10.2.0.1.0,Redhat Linux 4)
flashback table to before drop; [message #447571] Tue, 16 March 2010 03:20 Go to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Dear All;

i have droped a table, i try to flash back it as before but

SQL> FLASHBACK TABLE TEST1 TO BEFORE DROP;


ERROR at line 1:
ORA-38305: object not in RECYCLE BIN



SQL> SELECT TNAME FROM TAB;

TNAME
------------------------------
TEST
BIN$gecjE6DhSGLgQAB/AQAtzw==$0


but my setting related to flashback table

Connected to:
Oracle Database 10g Release 10.2.0.1.0 - Production

SQL> show parameter db_flashback_retention_target

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_flashback_retention_target        integer     1440
SQL> show parameter db_recovery_file_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u03/flash_recovery_area
db_recovery_file_dest_size           big integer 2G
SQL> show parameter recyclebin;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
recyclebin                           string      on


what could be the resion.

regards
Re: flashback table to before drop; [message #447578 is a reply to message #447571] Tue, 16 March 2010 03:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select * from user_recyclebin;

Regards
Michel
Re: flashback table to before drop; [message #447579 is a reply to message #447578] Tue, 16 March 2010 03:55 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
SQL> select * from user_recyclebin;

OBJECT_NAME                    ORIGINAL_NAME                    OPERATION TYPE
------------------------------ -------------------------------- --------- --------------------
TS_NAME                        CREATETIME          DROPTIME              DROPSCN
------------------------------ ------------------- ------------------- ---------
PARTITION_NAME                   CAN CAN   RELATED BASE_OBJECT PURGE_OBJECT     SPACE
-------------------------------- --- --- --------- ----------- ------------ ---------
BIN$gecjE6DhSGLgQAB/AQAtzw==$0 TEST1                            DROP      TABLE
USERS                          2010-03-16:09:58:19 2010-03-16:10:42:17 924195161
                                 YES YES    263981      263981       263981        16

Re: flashback table to before drop; [message #447580 is a reply to message #447579] Tue, 16 March 2010 04:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Show us the session from top to bottom.

Regards
Michel
Re: flashback table to before drop; [message #447693 is a reply to message #447571] Wed, 17 March 2010 07:14 Go to previous messageGo to next message
tnaresh1982
Messages: 2
Registered: March 2010
Location: hyderabad
Junior Member
May be you are trying to flashback the table from different schema..plz check it once

and please check the object name..

[Updated on: Wed, 17 March 2010 07:17]

Report message to a moderator

Re: flashback table to before drop; [message #447703 is a reply to message #447693] Wed, 17 March 2010 07:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As there has been no feedback since more than 1 day (when this user is used to answer quickly and does it in his current other topics) I think he found his error but does not bother to feedback.

Regards
Michel
Re: flashback table to before drop; [message #448123 is a reply to message #447703] Fri, 19 March 2010 11:34 Go to previous messageGo to next message
tnaresh1982
Messages: 2
Registered: March 2010
Location: hyderabad
Junior Member
Flashback table works only when the tablespace is in Local management(LMTS), I think he droped the table from the tablespace which is in DMTS...
Re: flashback table to before drop; [message #448128 is a reply to message #448123] Fri, 19 March 2010 12:12 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
tnaresh1982 wrote on Fri, 19 March 2010 11:34
Flashback table works only when the tablespace is in Local management(LMTS), I think he droped the table from the tablespace which is in DMTS...

Where did you see this restriction? I see no reason for this.
Please post reference.

Regards
Michel

Previous Topic: Media Library Status Checking In RMAN
Next Topic: Flashback database question
Goto Forum:
  


Current Time: Fri Dec 09 13:49:01 CST 2016

Total time taken to generate the page: 0.19529 seconds