Index: openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.adp,v diff -u -r1.4.2.5 -r1.4.2.6 --- openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.adp 13 Jul 2023 12:43:20 -0000 1.4.2.5 +++ openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.adp 2 Sep 2024 09:40:22 -0000 1.4.2.6 @@ -2,10 +2,14 @@ {/doc/acs-core-docs/ {ACS Core Documentation}} {Deleting a tablespace} Deleting a tablespace +

@@ -16,20 +20,16 @@ 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;
+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 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#';
+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!

If you feel the need to delete everything related to the service, you -can also issue the following:

-SVRMGR> drop tablespace $OPENACS_SERVICE_NAME including contents cascade constraints;
+can also issue the following:

SVRMGR> drop tablespace $OPENACS_SERVICE_NAME including contents cascade constraints;
 

@@ -44,8 +44,7 @@ .

Then, to drop the db, just do:

 [$OPENACS_SERVICE_NAME ~]$ dropdb $OPENACS_SERVICE_NAME
 
-DROP DATABASE
-
+DROP DATABASE