Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE
UTL_FILE [message #39896] Wed, 21 August 2002 22:39 Go to next message
hshah
Messages: 6
Registered: August 2002
Junior Member
I am trying to read text file with 35 records.and output into text file in notepad. It can output only 30kb even though it can read more. I have to output over 500MB records (with delimiters)and then can use SQL Server DTS package to put in database tables . I wonder if it can be put straight into database tables to solve 30kb problem can you suggest any better solution Thanks

Report message to a moderator

Re: UTL_FILE [message #39899 is a reply to message #39896] Thu, 22 August 2002 03:28 Go to previous messageGo to next message
Rajarshi
Messages: 11
Registered: November 2001
Junior Member
What you have written is not clear... pls clarify your problems more.... or send your code!

Report message to a moderator

Re: UTL_FILE [message #39901 is a reply to message #39896] Thu, 22 August 2002 04:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
if you have a valid txt file with data,
(tab delimited or csv or anything)
you can directly load that into database using SQL*LOADER.
something like your BCP??

Report message to a moderator

Re: UTL_FILE [message #39931 is a reply to message #39896] Sun, 25 August 2002 08:28 Go to previous message
hshah
Messages: 6
Registered: August 2002
Junior Member
By using UTl_file.put_line, I am able to output records in notepad over 32k (for a sample file of 132k output of 43k)I presume all the spaces and blanklines is the difference of input minus output)Hope it works for 500mb records which I will try . But it is causing one unintended side effect problem. Put_line function is suppose to add new line (which in my case I donot need)If I donot use put_line function is creating memory output problem. I donot have SQl loader . Besises my Pl/SQL code helps me put delimiters in textileand other manipulation.BCP(orDTS package works fineon delimiter text file) Thanks

Report message to a moderator

Previous Topic: Use of Index for group by caluse
Next Topic: Oracle Data Dictionary Views
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 13:02:20 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.