Re: Drop Database

Hello,

there is a small error in the statement

> SQL> set pagesize 999
> SQL> spool c:\temp\drop-constraints.sql
> SQL> select 'alter table ' || table_name || ' drop constraint ' ||
> constraint_name || ';' from user_constraints;
> SQL> spool off
> SQL> spool c:\temp\drop-objects.sql
> SQL> select 'drop ' || object_type || ' ' || object_name || ';' from
> user_objects where object_type in ('TABLE', 'VIEW', 'INDEX', 'SEQUENCE',
> 'PACKAGE', 'PROCEDURE', 'FUNCTION', 'TYPE') order by object_type;
> SQL> spool off
>
> SQL> @c:\temp\drop-constraints.sql
> SQL> @c:\temp\drop-objects.sql

The '-character in the spool statement was wrong.

Greetings

    Clemens Hoffmann Received on Tue Mar 12 2002 - 06:17:05 CST