Sunday, February 26, 2012

Dts

Hi everybody

I have created tables in oracle 9i under a user using DTS in SQL Server. (i have exported from sql server to oracle 9i using DTS) . When i query select * from tab , it list al the tables created . But when i desc the structure of table or select * from table_name ,it shows object or view does not exist. what will be the problem ?
pls reply
ThanksWell this is more of an Oracle question...but I think the answer lies in the fact of the "user" (which in sql server is like the owner) who created the table.

Plus I wouldn't do it that way...

I would create all of my objects using DDL, bcp the data out to a pipe delimited file, copy the data to the Oracle box, and then use sqlLoader to populate the table.

No comments:

Post a Comment