请教SPOOL用法,我会在A.TXT中出现
'ALTERTABLE'||''||SEGMENT_NAME
--------------------------------------------------------------------------------
这样的东西,该怎么去掉呢?
SQL> spool d:\share\ww04\a.txt
Started spooling to d:\share\ww04\a.txt
SQL>
SQL> select 'alter table'||' '|| segment_name || ' move tablespace INTAS_OUTBOUND_DATA02' || ';'
2 from dba_segments
3 where tablespace_name='INTAS_OUTBOUND_DATA01';
'ALTERTABLE'||''||SEGMENT_NAME
--------------------------------------------------------------------------------
alter table TB_CFG_SP_INFO move tablespace INTAS_OUTBOUND_DATA02;
alter table TB_CFG_SP_BIZ_INFO move tablespace INTAS_OUTBOUND_DATA02;
alter table TB_CFG_GCUS_DATA_DICT move tablespace INTAS_OUTBOUND_DATA02;
alter table TB_CFG_DATA_DICT move tablespace INTAS_OUTBOUND_DATA02;
alter table OUTBOUND_INTERFACE_LDR_LOG move tablespace INTAS_OUTBOUND_DATA02;
alter table OUTBOUND_INTERFACE_INFO move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_GROUP_CONTRACT_DAILY move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_USER_BINDING_INFO_DAILY move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_USER_CONSUME_INFO_DAILY move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_USER_DATA_INFO_DAILY move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_USER_MONTERLNET_CUS_DAILY move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_USER_BOUNS_INFO_DAILY move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_USER_OWING_DAILY move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_VIP_SER_LOG_DAILY move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_ABNORMAL_ACTION_DAILY move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_ABNORMAL_ACT_DETAIL_DAILY move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_VIP_USER_INFO_DAILY move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_VIP_CARD_DAILY move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_GROUP_INFO_DAILY move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_GROUP_OPPONENT_INFO_DAILY move tablespace INTAS_OUTBOUND_DATA02;
'ALTERTABLE'||''||SEGMENT_NAME
--------------------------------------------------------------------------------
alter table BZ_GROUP_ORDER_PRODUCT_DAILY move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_GROUP_DEAL_REQUEST_DAILY move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_GROUP_SERVICE_LOG_DAILY move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_GROUP_WRITEOFF_REL_DAILY move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_GCUS_PAYMENT_WRITEOFF_DAILY move tablespace INTAS_OUTBOUND_DATA0
alter table BZ_GROUP_IT_SYSTEM_DAILY move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_USER_VCALL_INFO_MONTH move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_GROUP_MEMB_VCALL_MONTH move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_USER_INFO_DAILY move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_USER_PKG_ACCEPT_DAILY move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_GCUS_ALERT_INFO_MONTH move tablespace INTAS_OUTBOUND_DATA02;
alter table DIM_BRAND move tablespace INTAS_OUTBOUND_DATA02;
alter table DIM_USER_STATUS move tablespace INTAS_OUTBOUND_DATA02;
alter table BZ_LEAVE_USER_INFO_MONTH move tablespace INTAS_OUTBOUND_DATA02;
34 rows selected
SQL> spool off;
Stopped spooling to d:\share\ww04\a.txt
SQL>