OraFAQ Forum: Client Tools » UTL

Home » SQL & PL/SQL » Client Tools » UTL_FILE

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

UTL_FILE [message #648934]

Mon, 07 March 2016 20:26

mskphani
Messages: 5
Registered: March 2016

Junior Member

Hi

I have around 1 million records that need to be written to a csv file. I have used utl_file. It's taking more time. Is there any way to speed up the writing process. Thanks for your help.

Report message to a moderator

Re: UTL_FILE [message #648935 is a reply to message #648934]

Mon, 07 March 2016 20:52

BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

sqlplus scott/tiger
set colsep ,
set pages 0
spool emp.csv
SELECT * FROM EMP;
SPOOL OFF
EXIT

Report message to a moderator

Re: UTL_FILE [message #648956 is a reply to message #648935]

Tue, 08 March 2016 12:39

Bill B
Messages: 1969
Registered: December 2004

Senior Member

You have to run the commands from a script (file.sql) file for all the commands to work correctly.

sqlplus scott/tiger
set colsep ,
set pages 0
SET FEEDBACK OFF
SET ECHO OFF
SET LINESIZE 20000
SET TRIMSPOOL OFF
SET VERIFY OFF
SET HEADING OFF
SET TERMOUT OFF
spool emp.csv
SELECT * FROM EMP;
SPOOL OFF
EXIT

Report message to a moderator

Previous Topic:	Purpose of attached special Icon
Next Topic:	Someone please explain this behavior with multi-byte characters

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 18 05:10:06 CST 2021