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.