Re: Migrating Oracle Databases

SQLLoader is an importing tool not an extraction tool. You will need to use sql plus and the spool command to extract your tables to ASCII.

On Fri, 05 Sep 1997 14:31:51 GMT, "Andy Spamer" <as_at_simdell.co.uk> wrote:

>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
Received on Fri Sep 05 1997 - 00:00:00 CDT