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.4 -r1.4.2.5 --- openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.adp 27 Apr 2022 16:52:20 -0000 1.4.2.4 +++ openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.adp 13 Jul 2023 12:43:20 -0000 1.4.2.5 @@ -1,11 +1,11 @@ -{/doc/acs-core-docs {ACS Core Documentation}} {Deleting a tablespace} +{/doc/acs-core-docs/ {ACS Core Documentation}} {Deleting a tablespace} Deleting a tablespace

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

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

Then, to drop the db, just do:

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