-
how can I delete all views in my database in ONE step.
thanks,
-
spool script.sql
select 'drop view ' || owner || '.' || view_name
from dba_views;
spool off
spool script.log
@ script.sql
spool off
-
thanks very much,
I am using this settings to get red off the headings and
feedback and the rest of the junk, but it is not working !!
set heading off;
set feedback off;
set echo off;
set termout off;
set scan off;
I keep getting this
SQL> select 'drop table ' || table_name||';'
2 from user_tables
drop table test;
drop table test1;
SQL>spool off;
any idea???
thanks again
-
well, as far as I know, you cannot prevent the query and the spool off from being in the spooled file ...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|