Drop the Storage and Revoke Database User Permissions
If you drop all database components in a schema, you can drop the storage and revoke the database user permissions.
This command drops the two tablespaces (default names) for Oracle:
dbConfigurator.bat -a drop -d oracle -c storage -v latest
-l jdbc:wm:oracle://DBserver:1521;serviceName=myservicename -au adminuser
-ap adminpass -u webmuser -p w3bmpass -t tablespace_dir
This command drops the two tablespaces (custom names) for Oracle:
dbConfigurator.bat -a drop -d oracle -c storage -v latest
-l jdbc:wm:oracle://DBserver:1521;serviceName=myservicename -au adminuser
-ap adminpass -u webmuser -p w3bmpass -t tablespace_dir -tsdata MYDATA
-tsindex MYINDEX
This command drops the database for SQL Server:
dbConfigurator.bat -a drop -d sqlserver -c storage -v latest
-l jdbc:wm:sqlserver://DBserver:1433;databaseName=master -u webmuser
-p w3bmpass -au sa -ap sa_password -n webmdb
This command drops the buffer pool and tablespaces (default names), and revokes permissions for DB2:
dbConfigurator.bat -a drop -d db2luw -c storage -v latest
-l jdbc:wm:db2://vmxpdb01:50000;databaseName=amol -u webmuser -au adminuser
-ap admin_password -t tablespace_dir
This command drops the buffer pool and tablespaces (custom names), and revokes permissions for DB2:
dbConfigurator.bat -a drop -d db2luw -c storage -v latest
-l jdbc:wm:db2://vmxpdb01:50000;databaseName=amol -u webmuser -au adminuser
-ap admin_password -t tablespace_dir -tsdata MYDATA -tsindex MYINDEX
-tsblob MYBLOB -b MYBUFF
Contact Support
|
Community
|
Feedback