SET line 132
SET recsep OFF
SET pages 0

SPOOL _tmp.sql
SELECT 
	'CREATE SNAPSHOT LOG ON '||owner||'.'||table_name||CHR(10)||
	'TABLESPACE CWSP_IDX'||CHR(10)||
	'WITH ROWID'||CHR(10)||'INCLUDING NEW VALUES;'||CHR(10)
FROM
	all_tables
WHERE
	owner IN ('SITEBUILDER')
/

SPOOL OFF
