Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2001 04:27 AM
тАО10-16-2001 04:27 AM
UTL_fILE
I have a text file which contains rows upto 1M.
Instead of using SQLLOADER I want to use UTL_FILE concept to insert those records into the
different oracle tables.
Can any one have an idea ,If have please provide an example..
Thanks for the Advance in Help..
Regards
Rajkumar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2001 07:16 AM
тАО10-16-2001 07:16 AM
Re: UTL_fILE
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2001 10:53 PM
тАО10-16-2001 10:53 PM
Re: UTL_fILE
I have never done any file reading using UTL_FILE, although I have used to write out to files. As Oracle features go, it is pretty poor: it has poor error handling, and is pretty slow - especially compared to SQL-LOADER.
Good Luck
Steve
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2001 10:56 PM
тАО10-16-2001 10:56 PM
Re: UTL_fILE
check the enclosed note from Oracle Metalink. Here you'll find how to set up a function to read and write from/to files:
To read from files, check the following section of the note:
-- Open the same file to read from
file_handle :=
UTL_FILE.FOPEN('/tmp','myfile.txt','R');
-- Read a line from the file.
UTL_FILE.GET_LINE (file_handle, retrieved_buffer);
-- Print fetched line out to the SQL*PLUS prompt.
DBMS_OUTPUT.PUT_LINE(retrieved_buffer);
-- CLose the file.
UTL_FILE.FCLOSE(file_handle);
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-17-2001 12:15 AM
тАО10-17-2001 12:15 AM
Re: UTL_fILE
If this is what you need to do, then you will use the UTL_FILE package.
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-17-2001 12:26 AM
тАО10-17-2001 12:26 AM
Re: UTL_fILE
Go for the sqlloader.
Faster, easier to handle.
If you read the manual, check for ctl files
( param files for sqlloader ).
There you can set conditions for the load.
Rgds
Alexander M. Ermes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-17-2001 02:14 AM
тАО10-17-2001 02:14 AM
Re: UTL_fILE
Thank you for your reples..
I will try using these options which i have recieved from you all and i will let you know the result..
Thanks & Regards
Rajkumar