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

Thread: Migration

  1. 02-28-2002, 07:53 AM #1
    jamoji
    jamoji is offline Member
    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
    Reply With Quote Reply With Quote
  2. 02-28-2002, 08:40 AM #2
    kgb
    kgb is offline Advisor
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    Create 2 tables with LONG columns and join them in the view.
    Best wishes!
    Dmitri
    Reply With Quote Reply With Quote
  3. 02-28-2002, 08:55 AM #3
    jamoji
    jamoji is offline Member
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width