lower case table_name in all_objects table
417545Apr 17 2004 — edited Apr 19 2004Hi.
Because I don't have SQL Loader and I have to import some data from text files I am using SQL Server 2000 to import data from text files and then export the data to my oracle table.
Something interesting is happening.
When I filled the destination table name I had it in lower case, let's say table_name.
The export was successful. When I'm logging to my schema and have select * from table_name I'm getting an error that the table doesn't exists. When I'm looking in the all_objects I can find my table name, the problem is that it is in lower case as opposed to all the others which are upper case.
I have done the same process but choosing the table name as TABLE_NAME(upper) and everything worked, I can see the table.
My question now is why this happened (For export I used Microsoft OLE DB Oracle Provider) and how can I get rid of the lower case table_name table.
Thank you.
Claudia.