| import data from csv. file [message #138185] |
Tue, 20 September 2005 11:38  |
hubstack
Messages: 12
Registered: August 2005
|
Junior Member |
|
|
I've created the following control file in order to load data from a comma-delimited file into a SQL table. However, when I select and attempt to run the control file I receive the error
"ORA 0900: invalid SQL Statement".
OPTIONS (ERRORS = 30000 )
LOAD DATA
APPEND
INTO TABLE hs_import_su
Fields terminated by ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
SEQ NUMBER,
PANEL_SITE_ID NUMBER,
SEQNEXT NUMBER,
MEMBER_ID NUMBER,
MEMBERV NUMBER,
START_TIME DATE,
END_TIME DATE,
SEC_PROX NUMBER,
SEQNO NUMBER,
SEQNEW NUMBER,
ASSIGNED_MEMBER_ID NUMBER,
SEC_DUR NUMBER,
NEXT_AMI NUMBER,
NEXT_SDU NUMBER,
NEXT_HH NUMBER,
ACTV_MEM NUMBER,
S_PRIN NUMBER,
SUPER NUMBER,
NO_OF_ADULT NUMBER,
COMPUTES NUMBER,
CONNECTION_SPEED_ID NUMBER,
SAMEHHFL NUMBER,
DIRECT_F NUMBER,
DURATN_F NUMBER,
SHRTPR_F NUMBER,
MEDMPR_F NUMBER,
LONGPR_F NUMBER,
CREATEV NUMBER,
SUPER_SESS_ID NUMBER
);
|
|
|
|
|
|
|
|
|
|
|
|
| Re: import data from csv. file [message #140573 is a reply to message #138390] |
Tue, 04 October 2005 16:35  |
29april
Messages: 1
Registered: October 2005
Location: New Jersey
|
Junior Member |
|
|
did you figure out how to do it?? Pls let me know too. Im having exactly the same problem. Is it bcos of any virus or something?
I recently uninstalled oracle server and loaded client. Im having this problem from now only. Pls email me at krizzynat@yahoo.com. Thanks
Krishna
|
|
|
|
| Re: import data from csv. file [message #140591 is a reply to message #138185] |
Tue, 04 October 2005 18:49 |
cumin
Messages: 82
Registered: August 2005
|
Member |
|
|
|
I had a similar problem, and learned that sqlldr is not necessarily installed on all clients. If you do not have it, you will need the dba to install it (I believe). I tried putting a copy of the .exe file in the right place, and it didn't work; I had to get the dba to manually install the software.
|
|
|
|
| Re: import data from csv. file [message #140615 is a reply to message #140591] |
Wed, 05 October 2005 00:02 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Try executing it from the following location:
Go to $ORACLE_HOME/bin , like on my machine it is
D:\oracle\ora92\bin>sqlldr
SQL*Loader: Release 9.2.0.1.0 - Production on Wed Oct 5 10:29:49 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Are you getting this on your machine.
regards,
tarun
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
