SQL*PLUS- Spooling problem
From: David Vanmarcke <david.vanmarcke_at_argenta.be>
Date: Mon, 8 Mar 1999 16:59:59 +0100
Message-ID: <36e3f426.0_at_news-feed.bru.tfi.be>
Hi,
[Quoted] spool inssel1.log
SELECT TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS') FROM dual
/
INSERT INTO owner1.table1 SELECT * FROM owner1.table1_at_db_name
/
COMMIT
/
SELECT 'info:','owner1','table1', COUNT(*) FROM owner1.table1
/
INSERT INTO owner1.table2 SELECT * FROM owner1.table2_at_db_name
/
COMMIT
/
SELECT 'info:','owner1','table2', COUNT(*) FROM owner1.table2
/
...
SELECT TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS') FROM dual
/
spool off
Date: Mon, 8 Mar 1999 16:59:59 +0100
Message-ID: <36e3f426.0_at_news-feed.bru.tfi.be>
Hi,
[Quoted] I have the following syntax-like script (original is with 1500 insert-commit-select blocks)
[Quoted] spool inssel1.log
SELECT TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS') FROM dual
/
INSERT INTO owner1.table1 SELECT * FROM owner1.table1_at_db_name
/
COMMIT
/
SELECT 'info:','owner1','table1', COUNT(*) FROM owner1.table1
/
INSERT INTO owner1.table2 SELECT * FROM owner1.table2_at_db_name
/
COMMIT
/
SELECT 'info:','owner1','table2', COUNT(*) FROM owner1.table2
/
...
SELECT TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS') FROM dual
/
spool off
[Quoted] When the script is finished, the last xx lines of my logfiles are repeated
twice
although they have not been executed twice.
[Quoted] Is there anybody who can give me a reason why this duplication of logged
lines appears ???
I assume it has something to do with SQL*PLUS versus database links ..., but
I hope to have a confirmation from the pro's out there ! ;o)
Thanx in advance !!!
David.
[Quoted] 8.0.4.3 (Digital unix) Received on Mon Mar 08 1999 - 16:59:59 CET