Proabably i am very new to the world of oracle and got stuck in my first attempt .
We have the application which is currently working on SQL Server 2000 and we are migrating to Oracle 10g.
Starting, I created one database on the oracle server, and then using import export utility of the SQL Server i migrated on SQL Table to the Oracle under the user Scott.
Now using TOAD when i login to my database with the user scott, and do the select on the table which i migrated it gives me table or view does not exists, where as when i do Select * fRom Tab; i can view that table in the list.
Can anyone let me know what is the reason for that?? may be becuase of rights or somthing else?