Analytic Workspaces and the Oracle Database 10g RECYCLEBIN

5 views

Skip to first unread message

ola...@gmail.com

unread,

Feb 27, 2006, 12:34:27 PM2/27/06

to olapdba

-----------------------------
EXAMPLE 1 : Purge Objects from Recyclebin
-----------------------------

SQL> conn scott/tiger
SQL> show recyclebin
SQL> set serverout on size unlimited pages 500 lines 110
SQL> exec dbms_aw.execute('aw create test');
SQL> exec dbms_aw.execute('aw detach test');
SQL> exec dbms_aw.execute('aw delete test');

SQL> show recyclebin
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------
-------------------
AW$TEST BIN$Dcrzb/GTGX7gRAgAIMgMCA==$0 TABLE
2006-02-27:12:22:11

SQL> purge recyclebin;
OR
SQL> purge table AW$TEST;
OR
SQL> purge table "BIN$Dcrzb/GTGX7gRAgAIMgMCA==$0";
SQL> show recyclebin

-----------------------------
EXAMPLE 2 : Do not store deleted AW in RECYCLEBIN
-----------------------------

If you drop Analytic Workspaces via AWM you can create a logon trigger
to do the same thing.

SQL> alter session set recyclebin=off;
SQL> conn scott/tiger
SQL> show recyclebin
SQL> set serverout on size unlimited pages 500 lines 110
SQL> exec dbms_aw.execute('aw create test');
SQL> exec dbms_aw.execute('aw detach test');
SQL> exec dbms_aw.execute('aw delete test');
SQL> show recyclebin

Reply all

Reply to author

Forward

0 new messages