DTS Mystery SQLSERVER TO ORACLE. (Not resolved yet)

[abhijit]

Hi All,
I used a simple DTS transfer to transfer one table "PRODUCTS" into my Oracle Database 8i.
The Import / Export wizard gave me a message 'Sucessful'.

When I connect to oracle and issue the following query.

select table_name, tablespace_name from user_tables;
I am able to see the name "Products" in my table_name column.

However when I issue a "desc Products" or "Select * from Products", I get the following message.

ERROR:
ORA-04043: object Products does not exist

Could someone explain this mystery?

Regards,
Abhijit

[nihar]

Though I am not at all comfortable with Oracle 8i, my guess is that your table has been transferred to a d/base other than the one which you are currently seeing.

Like in Sql when u import the default destination database is master and not the one which you are importing to.

So maybe it has also transferred to the default database. Just thinking aloud.

[abhijit]

Originally posted by nihar

Though I am not at all comfortable with Oracle 8i, my guess is that your table has been transferred to a d/base other than the one which you are currently seeing.

Like in Sql when u import the default destination database is master and not the one which you are importing to.

So maybe it has also transferred to the default database. Just thinking aloud.

Sorry none of the above. In oracle the default database [tablespace] for every user is determined at the time of user-creation. Unlike MSSQL. So it has gone to the correct tablespace.
This can only be answered if you have access to both SQL Server as well as Oracle and try it out for yourself.

Abhijit

[nihar]

ok.
unfortunately i dont have access to Oracle; only sql server2000.

Do post the answer if it is resolved.