Index: openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.html,v diff -u -r1.5 -r1.6 --- openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.html 16 Feb 2005 00:21:02 -0000 1.5 +++ openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.html 4 Jun 2006 00:45:24 -0000 1.6 @@ -1,12 +1,13 @@ -Deleting a tablespace
Alex logo
Prev Chapter�7.�Database Management Next

Deleting a tablespace

Skip down for instructions on Deleting a PostgreSQL tablespace. + +Deleting a tablespace

Alex logo
Prev Chapter�7.�Database Management Next

Deleting a tablespace

Skip down for instructions on Deleting a PostgreSQL tablespace.

Deleting an Oracle tablespace

Should it become necessary to rebuild a tablespace from scratch, you can use the drop user command in SVRMGRL with the cascade option. This command will drop the user and every database object the user owns.

SVRMGR> drop user $OPENACS_SERVICE_NAME cascade;

- If this does not work because svrmgrl "cannot drop a user that - is currently connected", make sure to kill the AOLserver using + If this does not work because svrmgrl "cannot drop a user that + is currently connected", make sure to kill the AOLserver using this user. If it still does not work, do:

SVRMGR> select username, sid, serial# from v$session where lower(username)='$OPENACS_SERVICE_NAME';

and then

SVRMGR> alter system kill session 'sid, serial#';

where sid and serial# are replaced with the corresponding values for the open session.

Use with caution!