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, 1532🔥, 0💬
Popular Posts:
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...