| not spooling currently error [message #12110] |
Thu, 29 April 2004 09:46  |
Raquel
Messages: 46
Registered: July 2003
|
Member |
|
|
spool 'c:tempdergStats.txt'
spool 'c:tempdergStats.txt'
create table derg1_nomatch as
select distinct derg1.sw_ident
from derg1
MINUS
select distinct switchtable_curr.SWITCH
FROM switchtable_curr;
create table derg2_nomatch as
select distinct derg1.sw_ident
from derg1
MINUS
select distinct switchtable_curr.SWITCH
FROM switchtable_curr;
create table derg3_nomatch as
select distinct derg1.sw_ident
from derg1
MINUS
select distinct switchtable_curr.SWITCH
FROM switchtable_curr;
create table derg4_nomatch as
select distinct derg1.sw_ident
from derg1
MINUS
select distinct switchtable_curr.SWITCH
FROM switchtable_curr;
select count(*) from derg1_nomatch ;
select count(*) from derg2_nomatch ;
select count(*) from derg3_nomatch ;
select count(*) from derg4_nomatch ;
spool off;
When I run this script I get an error 'not spooling currently'. Why won't it create the file with the results of my queries?
|
|
|
|
|
|
|
|
|
|
| Re: not spooling currently error [message #463037 is a reply to message #12110] |
Tue, 29 June 2010 08:35  |
Boclive
Messages: 1
Registered: June 2010
|
Junior Member |
|
|
|
I got this error when I ran my script as a user other than "oracle". When I ran it as "oracle", spooler started and file was output. Check environment variables for the sql account you are using.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
