For those interested, I managed to get around this by creating a Microsoft
ODBC for Oracle DSN and using the SQL Server Import/Export Wizard to export
the tables to Oracle. It took several goes - the first being very
unsuccessful, especially in transferring data, but the next was much better.
Tables that then still would not create I reviewed the data types for both
tablesets and fiddled a bit and eventually it all got through.
Quote:
>Does anyone know what the best way to migrate a database from SQL Server to
>Oracle is?
>SQL Server 7 on windows NT to Oracle 8 on the same server.
>Josy