|
-
Oct 31st, 2002, 11:03 PM
#1
 DTS Mystery SQLSERVER TO ORACLE. (Not resolved yet)
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 
Last edited by abhijit; Nov 3rd, 2002 at 06:43 AM.
Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
save a blobFileStreamDataTable To Text Filemy blog
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote