Re: Importing files from LOTUS

rsnyder_at_ems.cdc.com (Richard Snyder) writes:

> 1) Are there any Oracle utilities to do the import written by 
>    Oracle, LOTUS or others?
> 2) If not what is the best approach to import the LOTUS data?

There is a utility SQLLOAD, which is called SQL*Loader. It is a standard tool for loading data from external files into ORACLE databese tables.

I believe, it is not difficult to save LOTUS table in a format like this:

"Jason", "23", "guy"
"Josefine", "21", "girl"
"Tom", "25", "guy"

Then, create the control file for SQL*Loader:

LOAD DATA
INFILE *
INTO TABLE FRIENDS
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' (NAME, AGE INTEGER EXTERNAL, SEX)
BEGINDATA
"Jason", "23", "guy"
"Josefine", "21", "girl"
"Tom", "25", "guy"

And that's it, run SQLLOAD <user/passw> <control file>

The language used in control files gives you high flexibility in describing how your data are formatted. You may specify the field's datatypes, the position of data fields, choose which records to load and which to discard, generate sequential numbers, and so on.

Best regards,
Igor Mameshin.

E-mail: igor%monolit.kiev.ua_at_hq.demos.su Received on Fri Jan 15 1993 - 15:45:46 CET