Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Turn On or Off Recycle Bin for the Instance
How To Turn On or Off Recycle Bin for the Instance? - Oracle DBA FAQ - Managing Oracle Database Tables
✍: FYIcenter.com
You can turn on or off the recycle bin feature for an instance in the instance parameter file with "recyclebin=on/off". You can also turn on or off the recycle bin feature on the running instance with a SQL*Plus command, if you log in as SYSTEM. See the following example:
SQL> connect SYSTEM/fyicenter Connected. SQL> SHOW PARAMETERS RECYCLEBIN NAME TYPE VALUE ------------------------------------ ----------- ------- recyclebin string on SQL> ALTER SYSTEM SET RECYCLEBIN = OFF; System altered. SQL> SHOW PARAMETERS RECYCLEBIN NAME TYPE VALUE ------------------------------------ ----------- ------- recyclebin string OFF
Warning: Turning off the recycle bin feature will give your users hard times on recovering dropped tables.
2007-05-04, 5217👍, 0💬
Popular Posts:
How To Avoid the Undefined Index Error? - PHP Script Tips - Processing Web Forms If you don't want y...
Why is there extra white space before or after tables? This is often caused by invalid HTML syntax. ...
I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, ...
Can you explain in GSC and VAF in function points? In GSC (General System Characteristic) there are ...
How Do You Uninstall JUnit Uninstalling JUnit is easy. Just remember these: Delete the directory tha...