Collections:
Turn On and Off Recycle Bin for the Instance in Oracle
How To Turn On or Off Recycle Bin for the Instance in Oracle?
✍: 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.
⇒ Show Dropped Tables in Recycle Bin in Oracle
⇐ Recycle Bin - Storage to Hold Dropped Tables in Oracle
2019-05-14, 1955🔥, 0💬
Popular Posts:
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...