How To Turn On or Off Recycle Bin for the Instance

Q

How To Turn On or Off Recycle Bin for the Instance? - Oracle DBA FAQ - Managing Oracle Database Tables

✍: FYIcenter.com

A

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, 5287👍, 0💬

How To View All Columns in an Existing Table
How To View All Columns in an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables If you have an existing table and want to know how many columns are in the table and how they are defined, you can use the system view USER_TAB_COLUMNS as shown in the following tutorial exercise: SQL> C... 2007-05-03, 7978👍, 0💬

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 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 w... 2007-05-04, 5288👍, 0💬

How To Turn On or Off Recycle Bin for the Session
How To Turn On or Off Recycle Bin for the Session? - Oracle DBA FAQ - Managing Oracle Database Tables If you want to control the recycle bin feature in your own session, you can use the ALTER SESSION statement to turn on or off. Here is an example SQL script: SQL> connect HR/fyicenter Connected. SQL... 2007-05-04, 5172👍, 0💬

How To View the Dropped Tables in Your Recycle Bin
How To View the Dropped Tables in Your Recycle Bin? - Oracle DBA FAQ - Managing Oracle Database Tables You can look what's in your recycle bin through the predefined view called RECYCLEBIN. You can use the SELECT statement to list the dropped tables as shown in the following script: SQL> connect HR/... 2007-05-04, 4965👍, 0💬

How To Rename a Column in an Existing Table
How To Rename a Column in an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables Let's say you have an existing with an existing column, but you don't like the name of that column, can you rename that column name? The answer is yes. You can use the ALTER TABLE ... RENAME COLUMN statem... 2007-05-03, 4922👍, 0💬

How To Delete a Column in an Existing Table
How To Delete a Column in an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables If you have an existing column in a table and you need that column any more, you can delete it with ALTER TABLE ... DROP COLUMN statement. Here is an example SQL script: SQL> CREATE TABLE emp_dept_90 2 AS... 2007-05-03, 4905👍, 0💬

How To List All Tables in Your Schema
How To List All Tables in Your Schema? - Oracle DBA FAQ - Managing Oracle Database Tables If you log in with your Oracle account, and you want to get a list of all tables in your schema, you can get it through the USER_TABLES view with a SELECT statement, as shown in the following SQL script: SQL> c... 2007-05-04, 4878👍, 0💬

What Is a Recycle Bin
What Is a Recycle Bin? - Oracle DBA FAQ - Managing Oracle Database Tables Recycle bin is a logical storage to hold the tables that have been dropped from the database, in case it was dropped in error. Tables in recycle bin can be recovered back into database by the Flashback Drop action. Oracle data... 2007-05-04, 4812👍, 0💬

How To Recover a Dropped Table
How To Recover a Dropped Table? - Oracle DBA FAQ - Managing Oracle Database Tables If you accidentally dropped a table, can you recover it back? The answer is yes, if you have the recycle bin feature turned on. You can use the FLASHBACK TABLE ... TO BEFORE DROP statement to recover a dropped table f... 2007-05-03, 4772👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.