| How to load the flat files data to database? [message #360669] |
Sat, 22 November 2008 00:41  |
aviva4500
Messages: 122
Registered: July 2008
Location: bangalore
|
Senior Member |
|
|
Hi all,
I would like to know how to load the flat files by using sql*loader? I have gone through many articles but still no luck .I have tried the below steps so far.But i get the following error.
1. created new folder in my c drive as:
C:\TEST\xtrn_data
2. created a file employee.csv using above data (from this artical) to this directory
C:\TEST\xtrn_data\LOAD.csv
3. connected as sys and created xtern_data_dir directory object:
SQL> conn sys as sysdba;
Enter password: ***
Connected.
SQL> create or replace Directory xtern_data_dir as 'C:\TEST\xtrn_data';
Directory created.
4. Issued grant read and write privileges to directory object to Scott.
SQL> grant read, write on directory xtern_data_dir to Scott;
Grant succeeded.
5. connected as Scott and created external table:
SQL> create table xtern_empl_rpt
2 ( empl_id varchar2(3),
3 last_name varchar2(50),
4 first_name varchar2(50),
5 ssn varchar2(9),
6 email_addr varchar2(100),
7 years_of_service number(2,0)
8 )
9 organization external
10 ( default directory xtern_data_dir
11 access parameters
12 ( records delimited by newline
13 fields terminated by ','
14 )
15 location ('LOAD.csv')
16 );
Table created.
I have error when i issue select command.
select * from xtern_empl_rpt;
Error at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
kup-04063:unable to open log file xtern_empl_rpt_32230.log
os error No such file or directory
ora-06512:at "sys.oracle_loader",line 19
Thanks & Regards
Hammer.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: How to load the flat files data to database? [message #362425 is a reply to message #360681] |
Tue, 02 December 2008 04:20  |
aviva4500
Messages: 122
Registered: July 2008
Location: bangalore
|
Senior Member |
|
|
Hi,
You are correct absolutely i didn't created the file in the database server.But now i have created it in the same server .But i get the below error.
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-30653: reject limit reached
ORA-06512: at "SYS.ORACLE_LOADER", line 52
ORA-06512: at line
Thanks & Regards
Hammer
|
|
|
|
|
|
|
|
|
|
|
|
| Re: How to load the flat files data to database? [message #362546 is a reply to message #362544] |
Tue, 02 December 2008 23:55 |
aviva4500
Messages: 122
Registered: July 2008
Location: bangalore
|
Senior Member |
|
|
Hi,
I have one more clarification if in a folder I have 10 files how can i append to the same table.For example in the previous post i have one file called "load.csv" if i have more data files how can i automize all the files in that particular folder.
Thanks & Regards,
Hammer.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
