I created a table from Excel using SQL Server DTS on my Oracle 8.1.6 database. When I do a
SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER = ' aaaa',
I am able to see that particular table, but when I try to access it in my query, I get a
'object does not exist' error.
Does anyone know what is going wrong.
the table must have been registered in lower case while creating and that is the problem you are facing while you select.
from sql server if you create a table with a lower case, u will face this kind of problem. For testing,Try a table in uppercase, then issue a select.