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
How did you export the table from SQL Server to Oracle ?
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!!!!
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.
Click Here to Expand Forum to Full Width