Oracle Lower case conundrum

[Surrendermonkey]

Hi - possibly a programming question, but not really.
I have exported two tables from SQL 7 into Oracle 8i via OLE DB. Everything went wonderfully excepting that I left my table names in mixed case in SQL, and now they appear in Oracle with mixed case names.
Now, I can re-import the data any day of the week, but I am left with a couple of tables in Oracle that I cannot do a thing with - I can't drop or remove or rename them or anything because, though they are there, Oracle refuses to 'see' them since their names are the wrong case.

What can I do?

Any suggestions gratefully received,

surrendermonkey.


Colon-Hyphen-Close-Bracket

[Clearcode]

I don't know what the system tables are called in Oracle but if you find the equivalents to the SQL server tables called SysObjects and update them?
They should be in the Model database or something...

HTH,
Duncan

-------------------------------------------------
Ex. Datis: Duncan Jones
Merrion Computing Ltd
http://www.merrioncomputing.com

[apanchu]

type
drop table "xYz"
it will drop this table xYz