ORA-38305: object not in RECYCLE BIN

Question Posted / guest

3 Answers
18380 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

ORA-38305: object not in RECYCLE BIN..

Answer / b.v.ramana

This error is due to setting of flash back parameters
u can enable flash back as

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 184549376 bytes
Fixed Size 1300928 bytes
Variable Size 157820480 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.

SQL> alter system set DB_FLASHBACK_RETENTION_TARGET=4320;
--4320 min(time)
System altered.

SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=536870912;
System altered.

SQL> alter system set DB_RECOVERY_FILE_DEST='/u02/fra';
System altered. --a recovery file size of 512MB and defined
the location for the file recovery area (FRA) as /u02/fra.

SQL> alter database flashback on;
Database altered.

SQL> alter database open;
Database altered.

oracle@nexus6 ~$ sqlplus ben/passwd
SQL*Plus: Release 10.1.0.2.0 - Production on Thu Nov 4
00:41:36 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 -
Production
With the Partitioning, OLAP and Data Mining options

and u can test now as
1) create a table
2) insert some records
3) and drop the table
then

4)flashback table <table_name> to before drop;

exec it u will get back the table with data

cheers................

BHENDE VENKATARAMANA

Is This Answer Correct ?

9 Yes

4 No

ORA-38305: object not in RECYCLE BIN..

Answer / guest

Cause: Trying to Flashback Drop an object which is not in
RecycleBin.

Action: Only the objects in RecycleBin can be Flashback Dropped.

Please add more information about this Error

Is This Answer Correct ?

3 Yes

1 No

ORA-38305: object not in RECYCLE BIN..

Answer / b.v.ramana

U CAN GET THIS ERROR BCOZ OF FLUSHED OUT THE OBJECT FROM
RECYCLEBIN
OR
LACK OF PREVILAGES
OR
DISABLED THE DB RECOVERY FILE
(BEFORE THIS I HAD GIVEN THE SCRIPT TO ENABLE THE DB
RECOVERY FILE ON UNIX ENVIRONMENT)

HOPE THIS WILL SLOVE U R PROBLEM

CHEERS..........
BHENDE VENKATARAMANA

Is This Answer Correct ?

1 Yes

5 No

Post New Answer