|
|
|
|
|
|
| Re: How to enable/On recyclebin in 10g db [message #325863 is a reply to message #325838] |
Mon, 09 June 2008 05:03   |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
SQL> alter system set recyclebin=ON scope=both
SQL> /
Session altered.
SQL> show parameter recyclebin
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
recyclebin string ON
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: How to enable/On recyclebin in 10g db [message #326024 is a reply to message #325838] |
Mon, 09 June 2008 23:32 |
malikjee
Messages: 80
Registered: May 2007
Location: lahore
|
Member |
 
|
|
alter system set "user_recyclebin"=on scope=both;
then
alter system set "_recyclebin"=on scope=both;
then
alter system set "dba_recyclebin"=on scope=both;
alter system set recyclebin=on scope=both;
With apologise, please tell me sound,exact command to enable ,if I m on mistake,
best regards,
Malik
[Updated on: Tue, 10 June 2008 00:07] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: How to enable/On recyclebin in 10g db [message #327125 is a reply to message #325838] |
Sat, 14 June 2008 01:26 |
malikjee
Messages: 80
Registered: May 2007
Location: lahore
|
Member |
|
|
Hi there!
Sorry to disturb.
here is my connection information ,I have connected externaly in sqlplus not in sqlpus worksheet,because it is a faulty.
SQL>CONN /AS SYSDBA;
Connected
SQL>alter system set "_recyclebin"=true scope=both;
System altered.
SQL>show parameter recyclebin;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
recyclebin string true
------------------------------------------------------------
SQL>CREATE TABLE t1 (ID NUMBER(24));
Table created.
SQL>DROP TABLE t1;
Table dropped.
SQL>FLASHBACK TABLE t1 TO BEFORE DROP RENAME TO t2;
EEROR ORA38305.
Object not in recyclebin.
SQL>alter session set "_recyclebin"=true scope=both;
session altered.
SQL>CREATE TABLE t1 (ID NUMBER(24));
Table created.
SQL>DROP TABLE t1;
Table dropped.
SQL>FLASHBACK TABLE t1 TO BEFORE DROP RENAME TO t2;
EEROR ORA38305.
Object not in recyclebin.
I dont know from where I am on mistake,
Best regards,
Malik
[Updated on: Sat, 14 June 2008 01:31] Report message to a moderator |
|
|
|
| Re: How to enable/On recyclebin in 10g db [message #327127 is a reply to message #327125] |
Sat, 14 June 2008 01:48 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Now
1/ Use genuine SQL*Plus not worksheet and use copy and paste
2/ Use code tags
3/ Do the same thing with another user:
- Never ever use SYS but for maintenance purpose (startup, shutdown, backup, recover)
- SYS is special
- SYS is Oracle proprietary (try to open a SR/TAR starting with "i did that with SYS" and you'll see the immediate answer)
- SYS does not act like any other user
- When you use SYS Oracle deactivates some code path and activates others
- Whatever you do with SYS will neither validate nor invalidate the same thing with any other user.
NEVER EVER use SYS for anything that can be done by another user.
Use SYS ONLY for something that can't be done by someone else.
Regards
Michel
[Updated on: Sat, 14 June 2008 01:50] Report message to a moderator |
|
|
|
| Re: How to enable/On recyclebin in 10g db [message #327209 is a reply to message #325838] |
Sun, 15 June 2008 00:41 |
malikjee
Messages: 80
Registered: May 2007
Location: lahore
|
Member |
|
|
|
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] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
