ORA-38305: object not in RECYCLE BIN

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

More Oracle Errors Interview Questions

PLS-00610: ROW can be used only once in SET clause of UPDATE statement

1 Answers  


ORA-29504: invalid or missing schema name

1 Answers  


RMAN-06570: datafile number switched to datafile copy "string"

1 Answers  


SQL*Loader-00469: SID directive expects 1 argument, number found.

1 Answers  


ORA-16563: unable to add value, syntax error at "string"

1 Answers  






ORA-13032: Invalid NULL SDO_GEOMETRY object

1 Answers  


ORA-28584: heterogeneous apply internal error

1 Answers  


ORA-36208: (XSAGOP05N) In AGGMAP workspace object, you can only specify NAOPERATOR string with the PROPORTIONAL or EVEN operators, not string.

1 Answers  


TNS-00506: Operation would block

1 Answers  


LSX-00009: data missing for type "~S"

1 Answers  


NNL-00241: Processing of modification requests is currently enabled

1 Answers  


ORA-29917: cannot lock a table which gets its rows from a collection operand

1 Answers  


Categories