spooling problem

From: Markus Innerebner <markusin_at_yahoo.de>
Date: Tue, 05 Oct 2004 11:08:49 +0200
Message-ID: <2sf6m6F1iaiumU1@uni-berlin.de>

hello i want to execute a spooling script with following problem: I do:
1) spool dropTables.sql
2) SELECT 'DROP '||object_type||' '||object_name||';' FROM user_objects

WHERE object_type NOT like 'TABLE';
3) spool off

when I no edit the file dropTables.sql i see following:

more dropTables.LST

'DROPTABLE'||TABLE_NAME||'CASCADECONSTRAINTS;'

DROP TABLE VPROC__CHANNELS CASCADE CONSTRAINTS;
DROP TABLE VPROC__CHANNELS1 CASCADE CONSTRAINTS;
DROP TABLE VPROC__CHANNELS2 CASCADE CONSTRAINTS;
DROP TABLE VPROC__LIST CASCADE CONSTRAINTS;
DROP TABLE VPROC__LIST1 CASCADE CONSTRAINTS;
DROP TABLE VPROC__LIST2 CASCADE CONSTRAINTS;

DROP TABLE WEIGHTPERUNITTYPEPEER CASCADE CONSTRAINTS; DROP TABLE WEIGHTTYPEPEER CASCADE CONSTRAINTS;

DROP TABLE WEIGH__CHANNELISMANUALSET CASCADE CONSTRAINTS;
DROP TABLE WEIGH__CHANNELISMANUALSET1 CASCADE CONSTRAINTS;
DROP TABLE WEIGH__CHANNELS CASCADE CONSTRAINTS;

'DROPTABLE'||TABLE_NAME||'CASCADECONSTRAINTS;'

DROP TABLE WEIGH__CHANNELS1 CASCADE CONSTRAINTS; DROP TABLE WORKFLOWMANAGERIMPL_CONTAINERL CASCADE CONSTRAINTS; DROP TABLE WORKFLOWMANAGERIMPL_LOGICALCON CASCADE CONSTRAINTS; DROP TABLE WORKFLOWMANAGERPEER CASCADE CONSTRAINTS; DROP TABLE WORKFLOWMANAGERPEER_TYPELIST CASCADE CONSTRAINTS; DROP TABLE WORKFLOWSYSTEMPEER CASCADE CONSTRAINTS; DROP TABLE WORKFLOWSYSTEMPEER_AGGABSTRACT CASCADE CONSTRAINTS; DROP TABLE WORKFLOWSYSTEMPEER_AGGPROCESSC CASCADE CONSTRAINTS;

DROP TABLE WORKF__CHANNELISMANUALSET CASCADE CONSTRAINTS;
DROP TABLE WORKF__CHANNELS CASCADE CONSTRAINTS;
DROP TABLE WORKF__LIST CASCADE CONSTRAINTS;

'DROPTABLE'||TABLE_NAME||'CASCADECONSTRAINTS;'

DROP TABLE WORKF__LIST1 CASCADE CONSTRAINTS;
DROP TABLE WORKF__MAP CASCADE CONSTRAINTS;
DROP TABLE WORKF__MAP1 CASCADE CONSTRAINTS;
DROP TABLE WORKF__MAP2 CASCADE CONSTRAINTS;

DROP TABLE WORKSTATIONPEER CASCADE CONSTRAINTS; DROP TABLE WORKSTATIONPEER_ASSPERSONINCHA CASCADE CONSTRAINTS;

DROP TABLE WORKS__CHANNELISMANUALSET CASCADE CONSTRAINTS;
DROP TABLE WORKS__CHANNELS CASCADE CONSTRAINTS;
DROP TABLE WORKS__LIST CASCADE CONSTRAINTS;

DROP TABLE WUERTHCOMPANYPEER CASCADE CONSTRAINTS; DROP TABLE WUERTHCOMPANYPEER_AGGABSTRACTC CASCADE CONSTRAINTS;
'DROPTABLE'||TABLE_NAME||'CASCADECONSTRAINTS;'

DROP TABLE WUERT__CHANNELISMANUALSET CASCADE CONSTRAINTS;
DROP TABLE WUERT__CHANNELS CASCADE CONSTRAINTS;
DROP TABLE WUERT__LIST CASCADE CONSTRAINTS;

is it possible that the lines

'DROPTABLE'||TABLE_NAME||'CASCADECONSTRAINTS;'

are not written in the file?

thanks
best regards

Markus Innerebner Received on Tue Oct 05 2004 - 04:08:49 CDT