Mr Michal,
can u explore your answer , I mean how to enable this feature with proper command in sqlplus

Best regards,
Malik

[Updated on: Mon, 09 June 2008 23:17]

[Updated on: Tue, 10 June 2008 00:07]

Hi again!
Mr Michal,

Plzz I need exact command only from which i can enable
this feature,
I serch all documents but not found solution for my prob.
If u have any hyper link abt it,plz post that out over here,or provide me web address of that metalink.

Thax alot,
best regards,
Malik

[Updated on: Thu, 12 June 2008 22:46]

[Updated on: Fri, 13 June 2008 06:00]

[Updated on: Sat, 14 June 2008 00:44]

[Updated on: Sat, 14 June 2008 01:31]

[Updated on: Sat, 14 June 2008 01:50]

Thax alot!

Mr Micheal for your proper step by step guidance.
and timely response.
Anyway my real Sql*plus description is as follows

SQL> conn system
Enter password:
Connected.
SQL> show parameter recyclebin;

NAME TYPE VALUE
------------------------------------ ----------- ------------
_recyclebin boolean FALSE

SQL> show parameter recycle;

NAME TYPE VALUE
------------------------------------ ----------- ------------
_recyclebin boolean FALSE
buffer_pool_recycle string
db_recycle_cache_size big integer 0
SQL>
SQL> CONN SYSTEM
Enter password:
Connected.
SQL> ALTER SYSTEM SET "_RECYCLEBIN"=TRUE SCOPE=BOTH;

System altered.

SQL> SHOW PARAMETER RECYCLEBIN;
NAME TYPE VALUE
------------------------------------ ----------- ---------------
_recyclebin boolean TRUE

SQL> SHOW PARAMETER RECYCLE;
NAME TYPE VALUE
------------------------------------ ----------- ---------------
_recyclebin boolean TRUE
buffer_pool_recycle string
db_recycle_cache_size big integer 0


SQL> SHOW PARAMETER RECYC;


NAME TYPE VALUE
------------------------------------ ----------- ---------------
_recyclebin boolean TRUE
buffer_pool_recycle string
db_recycle_cache_size big integer 0

SQL> CREATE TABLE T1
2 (ID NUMBER(33));

Table created.

SQL> SELECT * FROM T1;

no rows selected

SQL> DESC T1
Name Null? Type
----------------------------------------- -------- ------------

ID NUMBER(33)

SQL> INSERT INTO T1 VALUES (786);

1 row created.

SQL> SELECT * FROM T1;


ID
----------
786




SQL> DROP TABLE T1;

Table dropped.

SQL> SELECT FLASHBACK_ON FROM V$DATABASE;


FLA
---
YES

SQL> SELECT * FROM RECYCLEBIN;

no rows selected


SQL> FLASHBACK TABLE T1 TO BEFORE DROP RENAME TO T2;
FLASHBACK TABLE T1 TO BEFORE DROP RENAME TO T2
*
ERROR at line 1:
ORA-38305: object not in RECYCLE BIN.

SQL> SHOW USER
USER is "SYSTEM"
SQL> SHOW PARAMETER PFILE;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string D:\ORAHOME_1\DATABASE\SPFILEA.
ORA
SQL>
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod
PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production

SQL> select * from v$instance;

INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_
----------------- --------- ------------ --- ---------- ------- -----------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST
---------- --- ----------------- ------------------ ---------
1 a
MALIK
10.1.0.2.0 14-JUN-08 OPEN NO 1 STARTED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL


SQL> select * from dba_recyclebin;

no rows selected

SQL> select * from recyclebin;

no rows selected


SQL> select * from user_recyclebin;

no rows selected

SQL>

I hope above sql*plus description which is made by copy paste,will help
you to detect my issue.

Best regards,

Malik

[Updated on: Sun, 15 June 2008 01:02]

[Updated on: Wed, 09 July 2008 03:19]