export from sql server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: export from sql server

  1. #1
    Join Date
    Sep 2001
    Location
    chennai
    Posts
    69
    dear friends

    i exported a table from sql server to oracle. the export was successful and the table was created in oracle. when i logged into oracle and quried the table by using "select * from tab" the table is listed. but if try to describe the table using "desc tablename" it throws an error message saying that the object or view does not exists. the same thing happens if i try to select values from the table.

    what could be the problem in this case. can anyone provide me a solution.

    thanks in advance

    regards

    swamianthan


  2. #2
    Join Date
    Oct 2001
    Posts
    83
    Hello,

    How did you export the table from SQL Server to Oracle ?

    Thinks


  3. #3
    Join Date
    May 2002
    Posts
    12
    Try reading the SQL server script which creates the table for Oracle.The script BY DEFAULT will always contain the table in
    quotes eg create table "TEST".That is why when you do a select * from "TEST" ,you can see the table and not when
    select * from TEST.Your best bet would be to get the script from SQL server modify it yourself and create the tables yourself (with proper sizing and tablespaces etc) and then import the data.Hope this helps!!!!

  4. #4
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    rswamin

    Just for my information and knowldge.

    Can u please tell me in brief what were the steps u took for export backup from sql server to oracle.

    Bcoz ur info be useful any time in future.

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