Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    delhi (india)

    Question Unanswered: shifting to oracle DB


    i wanted to shift my work from the
    NT server to linux server & the work has been done sucessfully.
    the problem is i want to shift the database as well.

    I want to shift the MS-SQL data base to
    ORACLE database.
    i have tables in MS SQL with names like
    "10/10000 MBPS ETHERNET CARD" etc
    with spaces, spl characters etc so the migration tool
    is not allowing to do that.
    can u help me out.


  2. #2
    Join Date
    Mar 2002
    Reading, UK
    If you have table names with spaces you need to create the table in Oracle with the table name in " " though this might not work with all characters.

    i.e. create table "10/10000 MBPS ETHERNET CARD" (x char(1));

    NOTE in all your queries you will also have to refer to the table in " ".

    The other alternative is to change the name of your tables so that they dont use any unusual characters and then run your migration tool.


Posting Permissions

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