Duplicate Tables
As per my problem concern in my database i have 85 tables in my database out of 85 tables 42 tables which are created by me through sql command in oracle, and remaining 42 tables are same name but in capital letters with the same owner name and tablespace. Like suppose itemmaster which is created by me and other table is ITEMMASTER.
This problem is arrises when i export the all tables through sqlserver 7.0 to oracle it export all the table to oracle successfully but when in oracle i go for the desc it does't allow me with this message view for this particular table is not exist.
Then i created my own tables with the same name in existing particular database and oracle allows me to create all the tables with same name. Now in my database there are 85 tables.
When i use drop command for any table which is in capital letter it drop my own created table.
How can i eliminate this problem pl. give me proper solution.
Prashant