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, 1612🔥, 0💬
Popular Posts:
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...