Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

ORA-38708: not enough space for first flashback database log file

2 Answers  


NZE-29231: the cryptographic engine failed to initialize

1 Answers  


NZE-28875: SSL: use server-gated cryptographic suites

1 Answers  


ORA-00088: command cannot be executed by shared server

1 Answers  


ORA-25225: invalid value string, DEQUEUE_MODE should be REMOVE or BROWSE or LOCKED

1 Answers  






ORA-09831: snyStartThread: failed to build the server port set.

1 Answers  


ORA-06927: CMX: T_DATAIN received before all data written

1 Answers  


PROT-00807: Please ensure you have file creation privileges in the executing directory before running this tool.

1 Answers  


NPL-00411: incoming ASN.1 NULL encoding has nonzero length of string

1 Answers  


TNS-12646: Invalid value specified for boolean parameter

1 Answers  


TNS-00025: INTCTL: The ORACLE environment is not set up correctly

1 Answers  


CLSS-00200: local node string not listed in configuration

1 Answers  






Categories