Loading an Oracle 8.05 database with a flat file

Loading an Oracle 8.05 database with a flat file

Post by Chri » Thu, 25 Jan 2001 04:19:09



I am trying to figure out the best method to take a flat file and
create an automated way to load an Oracle 8.05 database.  Im not sure
if SQL Loader is the best tool.  I will be taking fields from the flat
file and loading different fields into different tables.

Thanks for any assistance
Chris

Sent via Deja.com
http://www.deja.com/

 
 
 

Loading an Oracle 8.05 database with a flat file

Post by Sybrand Bakke » Thu, 25 Jan 2001 05:21:51


Sqlloader can do this.
Please refer to the server utilities manual for further details.
If all is well there should be a couple of utlcase*.ctl in your installation
demonstrating this behavior.

Hth,

Sybrand Bakker, Oracle DBA


Quote:> I am trying to figure out the best method to take a flat file and
> create an automated way to load an Oracle 8.05 database.  Im not sure
> if SQL Loader is the best tool.  I will be taking fields from the flat
> file and loading different fields into different tables.

> Thanks for any assistance
> Chris

> Sent via Deja.com
> http://www.deja.com/


 
 
 

1. How to load a flat file load into a MS OLAP Cube

Hi All

I have a requirement to load data into OLAP cubes coming from Flat
files. I have now built a solution to load the flat files into SQL
Server as a staging table and from where I am loading the cubes.
Sometimes this is cumbersome I attempted loading files from a flat
file but appears not to work can any of you please throw some light
how I can load from a flat file what type of data source to setup for
Analysis services to access a flat file data source. I also attempted
setting up a flatfile linked server and loading from it the
performance appears not to be good with this. Appreciate your help on
this I desperately need a solution for this problem.

Thanks in advance
Samanthaco

2. Traning Course

3. moving data-files redhat6.1 oracle 8.05

4. Schema Checking..?

5. Decreasing Data file size in Oracle 8.05

6. Replication and full-text indexing

7. how to load Oracle db from flat files?

8. Monitor User logins??

9. Load Flat File into Oracle DB

10. Flat file database and Oracle database

11. Accessing Flat files through DTS Flat File OLE DB Provider

12. Help needed loading flat file

13. connect to MVS, download a flat file and load a SQL table