oracle 38305,ORA-38305: object not in RECYCLE BIN

1. edit your $ORACLE_HOME/sqlplus/admin/glogin.sql ... to include this statement

set sqlprompt "_date _user'@'_connect_identifier >"

2. select flashback_on from v$database;

3. below is my test case, notice err

11:33:44 11-NOV-08 [email protected] >get fb_stat

1 select to_char(begin_time,'DD-MON-YY HH24:MI:SS'), flashback_data,

2 db_data, redo_data, ESTIMATED_FLASHBACK_SIZE

3* from v$flashback_database_stat

11:33:48 11-NOV-08 [email protected] >/

TO_CHAR(BEGIN_TIME,'DD-MON- FLASHBACK_DATA DB_DATA REDO_DATA ESTIMATED_FLASHBACK_SIZE

--------------------------- -------------- ---------- ---------- ------------------------

11-NOV-08 10:44:37 3047424 5087232 1256960 0

11-NOV-08 09:14:41 3858432 6897664 1549312 43081728

11-NOV-08 08:14:40 3334144 5382144 1783808 42835968

10-NOV-08 16:55:48 6209536 6381568 3772416 42541056

10-NOV-08 15:55:45 3309568 5914624 1416704 47382528

10-NOV-08 14:55:38 5898240 7249920 2394112 47063040

10-NOV-08 13:55:32 3358720 5611520 1194496 46129152

10-NOV-08 12:55:28 3276800 5177344 1240064 45785088

10-NOV-08 11:25:28 3768320 6856704 1400832 45465600

10-NOV-08 09:55:27 46956544 43941888 44796928 45244416

10-NOV-08 08:25:26 5398528 8527872 3053568 34308096

07-NOV-08 19:53:28 9101312 9035776 5017088 33472512

07-NOV-08 18:50:03 3342336 4964352 1211904 85450752

07-NOV-08 17:20:03 3907584 7168000 1602560 85770240

07-NOV-08 16:20:02 3686400 6168576 1545216 86851584

07-NOV-08 15:20:01 3825664 5775360 1565184 86802432

07-NOV-08 13:50:01 6397952 9535488 2270208 86630400

07-NOV-08 12:50:00 3039232 4784128 1132544 85794816

07-NOV-08 11:49:59 3194880 5267456 1140736 86261760

07-NOV-08 10:19:59 4022272 7020544 1491456 86630400

07-NOV-08 08:49:58 46178304 43008000 47238144 87957504

06-NOV-08 18:42:08 8560640 10600448 4692480 46841856

06-NOV-08 17:42:02 3678208 5603328 1355264 94322688

06-NOV-08 16:41:56 3334144 5152768 1133056 95059968

06-NOV-08 15:41:49 2981888 4997120 1123328 97050624

25 rows selected.

11:33:51 11-NOV-08 [email protected] >host

11:34:00 11-NOV-08 [email protected] >@fbtab

flashback table ealert to timestamp(sysdate-5/24)

*

ERROR at line 1:

ORA-08189: cannot flashback the table because row movement is not enabled

11:34:04 11-NOV-08 [email protected] >l

1* flashback table ealert to timestamp(sysdate-5/24)

11:34:14 11-NOV-08 [email protected] >spool

currently spooling to fb.LST

11:34:20 11-NOV-08 [email protected] >spool off