July 1, 2003 at 7:44 am
Hi Guys,
I have just carried out a large migration of data from SQL server 2000 to Oracle 9i.
90 % of the tables were recreated in oracle successfully however some failed saying that that Oracle did not allow multiple LONG fields.
Each of the 300 or so tables that did not migrate contain several long fields and i need to get them into Oracle, any suggestions?
All advice gratefully received,
🙂
July 1, 2003 at 8:52 am
Have you messed around with using DTS to manually import these tables. You may have to transform the data using VB Script for the data types it is not handling. BOL has information on using VB Script to transform data.
Darren
Darren
July 3, 2003 at 6:23 am
I don't know exactly how DTS works but I know that on Oracle LONG datatype are restricted to one per table.
Instead of using LONG datatype Oracle strongly suggest to use CLOB.
Reagrds,
Carl
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply