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 -r1.4.2.1 --- openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.adp 25 Apr 2018 08:38:27 -0000 1.4 +++ openacs-4/packages/acs-core-docs/www/install-openacs-delete-tablespace.adp 2 Mar 2019 19:30:05 -0000 1.4.2.1 @@ -1,5 +1,5 @@ -{/doc/acs-core-docs {ACS Core Documentation}} {Deleting a tablespace} +{/doc/acs-core-docs/ {ACS Core Documentation}} {Deleting a tablespace} Deleting a 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;
 

@@ -36,9 +36,9 @@ 'down' flag (-d). If you're using inittab, you have to comment out your server in /etc/inittab, reread the inittab with /sbin/init q, and then -restart-aolserver $OPENACS_SERVICE_NAME +restart-aolserver $OPENACS_SERVICE_NAME .

Then, to drop the db, just do:

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