Rem
Rem $Header: spdusr.sql 07-apr-00.17:23:51 cdialeri Exp $
Rem
Rem spdusr.sql
Rem
Rem  Copyright (c) Oracle Corporation 1999, 2000. All Rights Reserved.
Rem
Rem    NAME
Rem      spdusr.sql
Rem
Rem    DESCRIPTION
Rem      SQL*Plus command file to DROP user which contains the
Rem      STATSPACK database objects.
Rem
Rem    NOTES
Rem      Must be run when connected to SYS (or internal)
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    cdialeri    04/07/00 - 1261813
Rem    cdialeri    02/16/00 - 1191805
Rem    cdialeri    11/04/99 - 1059172
Rem    cdialeri    08/13/99 - Created
Rem

set echo off;

spool spdusr.lis

Rem 
Rem  Drop X$views

drop view           X_$KCBFWAIT;
drop public synonym  X$KCBFWAIT;
drop view           X_$KSPPSV;
drop public synonym  X$KSPPSV;
drop view           X_$KSPPI;
drop public synonym  X$KSPPI;
drop view           X_$KSQST;
drop public synonym  X$KSQST;
drop view           V_$FILESTATXS;
drop public synonym  V$FILESTATXS;
drop view           V_$SQLXS;
drop public synonym  V$SQLXS;
drop view           V_$TEMPSTATXS;
drop public synonym  V$TEMPSTATXS;

Rem
Rem  Drop PERFSTAT user cascade
Rem

drop user perfstat cascade;

prompt
prompt NOTE:
prompt   SPDUSR complete. Please check spdusr.lis for any errors.
prompt

spool off;
set echo on;

