Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

lower case table_name in all_objects table

417545Apr 17 2004 — edited Apr 19 2004
Hi.

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2004
Added on Apr 17 2004
3 comments
582 views