Demodrop.sql
Download the script to drop the demo tables here.
Always test these 'demodrop' commands on a test server before implementing them on a production server.
If you can't find the sql script to drop the demo tables in your $ORACLE_HOME/sqlplus/demo folder
(or %ORACLE_HOME%\sqlplus\demo on windows)
you can cut it from this page and paste it in a text editor of your choice.
Save it to a file on your server or PC and run it to complete dropping the Oracle demo tables.
Demo_drop.sql
====== start of section to cut ======
-- -- Copyright (c) Oracle Corporation 1988, 2000. All Rights Reserved. -- -- -- DESCRIPTION -- This script drops the SQL*Plus demonstration tables created by -- demobld.sql. It should be STARTed by each owner of the tables. -- -- USAGE -- From within SQL*Plus, enter: -- START demodrop.sql SET TERMOUT ON PROMPT Dropping demonstration tables. Please wait. SET TERMOUT OFF DROP TABLE EMP; DROP TABLE DEPT; DROP TABLE BONUS; DROP TABLE SALGRADE; DROP TABLE DUMMY; SET TERMOUT ON PROMPT Demonstration table drop is complete. EXIT====== end of section to cut ======
Drop scott user
If you want to drop the scott user, do the following (login as DBA ):
SQL> drop user scott cascade;
User dropped.
User dropped.
