OraFAQ Forum: Backup & Recovery » flashback table to before drop;

Home » RDBMS Server » Backup & Recovery » flashback table to before drop; (oracle 10.2.0.1.0,Redhat Linux 4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

flashback table to before drop; [message #447571]

Tue, 16 March 2010 03:20

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

Report message to a moderator

Re: flashback table to before drop; [message #447578 is a reply to message #447571]

Tue, 16 March 2010 03:42

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

select * from user_recyclebin;

Regards
Michel

Report message to a moderator

Re: flashback table to before drop; [message #447579 is a reply to message #447578]

Tue, 16 March 2010 03:55

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

Report message to a moderator

Re: flashback table to before drop; [message #447580 is a reply to message #447579]

Tue, 16 March 2010 04:05

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Show us the session from top to bottom.

Regards
Michel

Report message to a moderator

Re: flashback table to before drop; [message #447693 is a reply to message #447571]

Wed, 17 March 2010 07:14

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: flashback table to before drop; [message #448123 is a reply to message #447703]

Fri, 19 March 2010 11:34

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...

Report message to a moderator

Re: flashback table to before drop; [message #448128 is a reply to message #448123]

Fri, 19 March 2010 12:12

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 20:48:21 CST 2024