Re: dropping all objects for an user

Create dynamic SQL and execute.

e.g

SQL>spool x
SQL>select 'drop table ' || tname || ';' from tab;
SQL>spool off

SQL>@x

same way, can write for view etc.

sometimes, it won't drop because of integrity constraint..Pl. remove all contraint first.

Thanks,

Vrajesh.

dfp1 wrote:

> Hi,
>
> Is there a SQL statement that will let me drop all the objects in an users
> schema, but preserve the user (with privileges etc. intact)?
>
> Thanks,
> Dinesh
Received on Thu Apr 22 1999 - 10:59:46 CDT