importing Sql2000 tables in to oracle 8i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: importing Sql2000 tables in to oracle 8i

  1. #1
    Join Date
    Oct 2003
    Posts
    1

    importing Sql2000 tables in to oracle 8i

    HI

    I have exported a database from sqlserver2000 to oracle8i,it was successful, i could also see the table names in oracle, but when i want to view the contents of the table it says table or view does not exists. What could be the problem?

    Murali

  2. #2
    Join Date
    Apr 2003
    Location
    South Carolina
    Posts
    148
    SQL> Select table_name from user_tables ;

    Logged on as the owner of the tables ...

    You may find that the SQLServer tables were defined as
    "Tablename" - Using both upper and lower. If this is true
    and they were created in Oracle with " marks, then the tables
    are now case sensitive ...

    HTH
    Gregg

  3. #3
    Join Date
    Dec 2007
    Posts
    1

    Import sql2000 tables

    I have exported a database from sqlserver2000 to oracle8i,it was successful, i could also see the table names in oracle, but when i want to view the contents of the table it says table or view does not exists. What could be the problem?

    Mahesh C

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    are you serious? you copy and paste the original question which was answered 4 years ago, dont add anything and dont even try the answer supplied?

    what a disgrace

  5. #5
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    To Mahesh..
    Such a lazy dumbass..
    http://www.perf-engg.com
    A performance engineering forum

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