SQL Server 2000 Migrate to Oracle

From: C Stabri <kyrkarsa_at_yahoo.com>
Date: 30 Aug 2004 01:35:24 -0700
Message-ID: <b9f051f9.0408300035.5af3234@posting.google.com>

I am trying to get some tables out of SQL Server 2000 and into Oracle 9i. However I am encountering problems.

Many of the tables and column names in SQL server are > than 30 Characters which meansa any auto inport I do fails. Is there a way to get around this.

2.The Create table statements for the SQL database are not compatabible with ORacle Create table statements.

Bascially I need advices on getting 400 odd tables our of SQL server into Oracle, any ideas where I have table and column anems > than 30 chars.

Thanks Received on Mon Aug 30 2004 - 03:35:24 CDT