In article <01bcb9e9$325ff800$ee000801_at_AS-PC.Simdell.co.uk>, Andy Spamer
<as_at_simdell.co.uk> writes
>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
>
You'll have to write/procure (whatever) a script/program to get the data
out as a CSV file. Oracle does not provide you with a tool that will
dump a table's contents into a CSV type. Having said that, there are a
few scripts/programs floating around that do what you require. Post a
message requesting for one or search te WEB.
--
Bola Ogunlana
Received on Thu Sep 11 1997 - 00:00:00 CDT
