Migration
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Migration

  1. #1
    Join Date
    Jan 2002
    Posts
    152
    I have to migrate a database from SQLServer 7.0 to Oracle 8i.
    I make it from the SQLServer console,and no problem.But there are some tables with several "Long" type fields,and there's an error telling me that Oracle only supports one "Long" field per table...
    What can I do?
    I don't have Oracle Migration Worbench...I tried to get the demo form otn.oracle.com,but it doesn't work,because that's for Oracle 9i,and I have 8i.
    Thanks in advance

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Create 2 tables with LONG columns and join them in the view.
    Best wishes!
    Dmitri

  3. #3
    Join Date
    Jan 2002
    Posts
    152
    Thanks very much Dmtri!!!
    That's a very good idea...it should have been mine...hahaha
    Too many hours working,my brain is empty.
    Bye

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width