| Oracle SQL Loader [message #1343] |
Tue, 23 April 2002 05:24  |
Jochen
Messages: 6
Registered: December 2000
|
Junior Member |
|
|
hi folks,
i´m trying to import a text file into an oracle db. is it possible to import files, where the values are separated by TABSPACE instead of commas or something like this, if so, how do i tell this the ctl-file?
thanks in advance
|
|
|
|
| Re: Oracle SQL Loader [message #1344 is a reply to message #1343] |
Tue, 23 April 2002 06:00  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
if this is a typo, you cannot import a text file into oracle.you need to load it using a sql*loader.
try this inthe control file
INTO TABLE TEST
FIELDS TERMINATED BY "<tab>"
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
