Dropping Oracle Database Users and Objects

Use SQL*Plus as the sys user to drop the Oracle cache administration user cacheadmin and all objects such as tables and triggers owned by the cache administration user.

Then drop the TT_CACHE_ADMIN_ROLE role, and the default tablespace cachetblsp used by the Oracle cache administration user including the contents of the tablespace and its data file.

% sqlplus sys as sysdba
Enter password: password
SQL> DROP USER cacheadmin CASCADE;
SQL> DROP ROLE TT_CACHE_ADMIN_ROLE;
SQL> DROP TABLESPACE cachetblsp INCLUDING CONTENTS AND DATAFILES;
SQL> exit

Also, you can run TimesTen SQL*Plus scripts to drop the Oracle Database objects used to implement autorefresh operations. See Managing a Cache Environment with Oracle Database Objects.