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, 1541🔥, 0💬
Popular Posts:
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...