ORA-38305: object not in RECYCLE BIN
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
PLS-00610: ROW can be used only once in SET clause of UPDATE statement
ORA-29504: invalid or missing schema name
RMAN-06570: datafile number switched to datafile copy "string"
SQL*Loader-00469: SID directive expects 1 argument, number found.
ORA-16563: unable to add value, syntax error at "string"
ORA-13032: Invalid NULL SDO_GEOMETRY object
ORA-28584: heterogeneous apply internal error
ORA-36208: (XSAGOP05N) In AGGMAP workspace object, you can only specify NAOPERATOR string with the PROPORTIONAL or EVEN operators, not string.
TNS-00506: Operation would block
LSX-00009: data missing for type "~S"
NNL-00241: Processing of modification requests is currently enabled
ORA-29917: cannot lock a table which gets its rows from a collection operand