Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
This is a discussion on Load UNIX Text file to Oracle table within the Oracle forums, part of the Databases category; I have a file contains some numbers in UNIX, i need to create a table in Oracle and those numbers that are in UNIX text file insert into Oracle table. ...
|
|||||||
| Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks. |
![]() |
| LinkBack | Thread Tools | Display Modes |
|
|||
|
Load UNIX Text file to Oracle table
I have a file contains some numbers in UNIX, i need to create a table in Oracle and those numbers that are in UNIX text file insert into Oracle table.
Please Give a solution for this.... |
| Sponsored Links |
|
|||
|
Re: Load UNIX Text file to Oracle table
Use oracle_loader load txt,csv,dat file into oracle table but
u need to define a oracle directory here mydir is oracle directory , and also ur file will be under oracle directory path Example create table emp_ext (empno number(8), ename varchar2(30),sal number, hiredate date) organization external ( type oracle_loader default directory mydir access parameters ( records delimited by newline fields terminated by ',' ) location ('emplist.csv') ) parallel 5 reject limit 200;
__________________
Sireesha |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Load Genrator On Unix platform | Akshay_Mihir | LoadRunner | 1 | 08-19-2008 06:17 AM |
| Convert dbf file to ASCII (text) file | mohit1211 | Oracle | 2 | 02-17-2008 11:54 PM |
| Upload text file | Geek_Guest | ASP.NET | 0 | 11-07-2007 07:12 PM |
| transcribing .rec file to text file | Mamal | Scripting | 1 | 08-17-2007 10:57 AM |
| Operating with Text File in UNIX | nancyphilips | Unix/Linux | 1 | 09-24-2006 04:58 AM |