Re: Migrating Oracle Databases

From: Chinna <jchinna_at_enron.com>
Date: 1997/09/16
Message-ID: <01bcc2d4$71861840$06f7fb9b@eoghou1325.eog.enron.com>#1/1

yes.. SQL*LOADER utility is used to load data from ASCII/EBCDIC files to Oracle
database.

Sql*loader direct path :

LOAD DATA
INFILE "ADV.DAT"
INSERT INTO TABLE emp
(empno position(01:04) integer external, ename position(06:15) char)

Let me know if this helped,
Chinna

Andy Spamer <as_at_simdell.co.uk> wrote in article <01bcb9e9$325ff800$ee000801_at_AS-PC.Simdell.co.uk>...
> I have a query regarding Oracle databases and the ability to migrate the
> data held in the database.
>
> I have a customer who currently has an Oracle database (circa 4GB). This
> contains approximately 25 tables and various indexes. They require that
> this database be migrated to MS SQLServer. This database was set up by an
> external organisation, and neither my customer or i, have any knowledge
of
> Oracle.
>
> In SQLServer i can load in a table that is held as CSV format ASCII, what
i
> need to know is who do i create such a file in Oracle?
>
> I understand their is a command called ?SQLLoader? in Oracle. Is this
> standard? if so what is it any use to me, and if it is what is the
syntax?
>
> Version of Oracle is 7.0.16.14 btw.
>
> Thanks in advance
>
> --
> Andrew Spamer
> Senior Software Analyst
> Simdell Limited
> Email: as_at_simdell.co.uk
>
Received on Tue Sep 16 1997 - 00:00:00 CDT