STX tables that are being used by active collections should not be dropped. Therefore, the safest way to remove these tables is to shutdown acm to ensure no collections are running. Steps to follow are shown below.

1. Shutdown acm

$ acm stop

2. Login to SQL as the AVUSER.
3. Execute the following SQL to find all the tables to be dropped:

SELECT table_name FROM user_catalog WHERE table_name LIKE 'STX%'

4. Drop all the STX tables:

BEGIN
     FOR tablename IN (SELECT table_name FROM user_catalog WHERE table_name LIKE 'STX%') LOOP
      EXECUTE IMMEDIATE
     'DROP TABLE ' || tablename.table_name || ' purge'; 
     END LOOP; 
 END;

5. Restart acm:

$ acm start