Stack Overflow
Stack Overflow

Questions tagged [spool]

SPOOL is an acronym for simultaneous peripheral operations on-line. It is a type of buffering. The most common spooling application is print spooling, which places a task (or 'print job') into a queue for extended or later processing.

310 questions
3
votes
3 answers

Stop spool printing the sql query used (Oracle)

I have this running in SQLplus set feedback off set pagesize 0 spool TypeDrop.sql select distinct 'drop type '||object_name|| ';' from user_objects where object_type='TYPE'; spool off It prints out to TypeDrop.sql: SQL> select distinct 'drop type…
joec
  • 3,533
  • 10
  • 60
  • 89
3
votes
1 answer

S3 spool bucket / anonymous PUT

I'd like to use S3 CORS and key expiration to create a 'spool bucket'. This spool bucket should support the following: Frontend code (say, jQuery) should be able to HTTP PUT arbitrarily named keys to the bucket Backend code (say, Python/boto)…
Yaniv Aknin
  • 4,103
  • 3
  • 23
  • 29
3
votes
1 answer

Spool mail and send directly mail

I need 2 kind of mails: Spool mail (for bulk mails) Direct mail (like a register mail) Now I have 2 services:
Mitchel Verschoof
  • 1,543
  • 4
  • 20
  • 38
3
votes
3 answers

What is the equivalent of the spool command in MySQL?

I know you use the spool command when you are trying to write a report to a file in Oracle SQLplus. What is the equivalent command in MySQL? This is my code: set termout off spool ${DB_ADMIN_HOME}/data/Datareport.log @…
rambokayambo
  • 341
  • 4
  • 10
  • 27
3
votes
1 answer

File format of spool files with .tmp extensions?

In many Windows setups, when you print directly to a printer, two files are typically created in the windows spool directory "C:\Windows\System32\spool\PRINTERS". A spool file "80021.SPL" and a shadow file "80021.SHD" are examples of these files. …
Ultratrunks
  • 2,464
  • 5
  • 28
  • 48
2
votes
2 answers

How to send 12 000 emails via Swiftmailer in Symfony2?

Sometimes we need to send many emails. We are selecting users by 100, for each user create mail, send it (add to spool), make $em->clear(). But even in production env we cann't send much than 4000 emails: got "Unable allocate memory". What proper…
Koc
  • 2,375
  • 2
  • 22
  • 26
2
votes
0 answers

Oracle SQL predefined variable _CONNECT_IDENTIFIER not working with Spool in Toad

I am using Toad and have a file 'run_script.sql' that is used to run .sql scripts and spools to an output file. This has always worked for me, creating the spooled file in the same directory as the 'run_script.sql' file. However, I recently had…
MagicMatt
  • 33
  • 1
  • 3
2
votes
1 answer

rows and columns truncating when spooling in sqlplus

*I am spooling some data from oracle database to CSV file using sqlplus, My resulting table has 44 columns and more than 7000 rows but when it spooling to csv it is displaying only 26 columns in excel(Index A to Z) also some rows are truncating. I…
Abdul Ashif
  • 33
  • 7
2
votes
1 answer

How to do dynamic spool's using sqlplus by batch-file

I'm trying save multiples txt archives with querye result using a single .sql archive called by a batch-file for automate-work. My Batch-file: set d=%location%result.txt set f=%location%result2.txt echo exit | sqlplus…
Enrique Georg
  • 23
  • 3
2
votes
1 answer

What is the equivalent of set termout off in MySQL?

In Oracle SQLPlus, I can write: set termout off spool data.out @query.sql spool off to make sure the query output is sent to the file data.out and not to the terminal. Is there a way I can do the same in MySQL?
codeforester
  • 39,467
  • 16
  • 112
  • 140
2
votes
2 answers

How to select spool's filename from table in sqlplus

how could I select the name of my spool filename from a table in sqlplus? I have something like: SPOOL ON SPOOL XXXXXXXXX.bkp SELECT * FROM my_table WHERE field1='value'; SPOOL OFF And want the XXXXXXXXX.bkp to have the value of a field from this…
Fernando Rybka
  • 238
  • 1
  • 4
  • 14
2
votes
1 answer

SQLcl unable to set spool to file

In SQLcl setting spool to file gives error "SP2-0556: Invalid File Name". There are no whitespaces in file name, and the path is correct (folder C:\Temp does exist). Have tried; spool load_data.sql spool C:\Temp\load_data.sql spool…
Davor
  • 25
  • 1
  • 6
2
votes
0 answers

Would like to generate or spool a HTML file based on a condition

Would like to generate or spool a HTML file based on a condition for instance in the below case where only if the result count is greater that 0 spool the html file or else don't DECLARE VAL1 INT; BEGIN select count(*) into VAL1 from …
Pradeep Naik
  • 21
  • 1
2
votes
1 answer

SqlDeveloper SPOOL: Blank first line

I want to export multiple tables to a semicolon separated file each using SqlDeveloper (version is 4.1.5.21). Currently I use SET SQLFORMAT delimited spool ..\dir\table1.csv select * from table1; spool off; for each table in a script, which is…
Jdv
  • 962
  • 10
  • 34
2
votes
2 answers

SQLPlus dynamic spool filename

i have an Oracle db and i want to export data to a file.However filename, extension and separator will take value from table. The problem is that i can't use the values from table. Could you suggest me a way to do it? Or if i can do this with…
Seth De
  • 37
  • 1
  • 1
  • 8
1 2
3
…
20 21