Re: Deleting a schema in Oracle 9i

From: Frank <frankfz_at_gmail.com>
Date: 8 Oct 2004 00:49:59 -0700
Message-ID: <1fd2a057.0410072349.12be512c@posting.google.com>

see following example. schema name is test.

SQL> connect test/test
Connected.
SQL> create table tab1 (col1 number);

Table created.

SQL> connect / as sysdba;
Connected.
SQL> desc test.tab1;

 Name                                      Null?    Type
 ----------------------------------------- -------- -------

 COL1                                               NUMBER

SQL> drop user test cascade;

User dropped.

SQL> desc test.tab1
ERROR:
ORA-04043: object test.tab1 does not exist

"John" <johnyetter_at_earthlink.net> wrote in message news:<Q8n9d.9027$M05.7205_at_newsread3.news.pas.earthlink.net>...
> Hi All,
>
> Can anyone tell me how to delete a schema (and all of its related tables and
> views) in a step or two?
>
> Thanks
Received on Fri Oct 08 2004 - 02:49:59 CDT