Oracle Table - How To Turn On or Off Recycle Bin for the Session
Interview Question Database For Software Developers
|
|
| 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 | | By: FYIcenter.com | 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> SELECT COUNT(*) FROM recyclebin;
COUNT(*)
----------
0
SQL> ALTER SESSION SET recyclebin = off;
Session altered.
SQL> CREATE TABLE emp_dept_90
2 AS SELECT * FROM employees WHERE department_id=90;
Table created.
SQL> DROP TABLE emp_dept_90;
Table dropped.
SQL> SELECT COUNT(*) FROM recyclebin;
COUNT(*)
----------
0
Warning: Turning off the recycle bin feature in your session will give yourself hard times
on recovering dropped tables.
| | ID: 667 | Rank: 1079 | Votes: 0 | Views: 43 | Submitted: 20070504 |
1059
:-) | | What Is an Oracle Tablespace | | What Is an Oracle Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files... | | Submitted: 20070504 |
|
Copyright © 2009 FYIcenter.com
All rights in the contents of this Website are reserved by the individual author.
No part of the contents may be reproduced in any form without author's permission.
|
|
|
Atom feed
List view