Re: Case sensitive Tablenames

"Hobo" <hobo_at_bulla.de> wrote in message news:<3f5edd64$0$272$88693e94_at_news.cneweb.de>...
> Hello,
>
> at a customer db the setting for tablenames is set to only Capital letters.
> How can we manage this at our DB. We've found a parameter
> SQL_ATTR_MATADATA_ID???? Is it a hidden parameter for init,ora?
>
> Can anyone help?
>
> Thanks inadvance
>
> Horst

This might be a duplicate post. Google issued an error on my first attempt, but sometimes the messages appear so apologies if two nearly identical posts show up.

Horst, by default Oracle stores all object names in the rdbms dictionary in upper case though it is possible to override this behavior. If you need to work with mixed or lower case object names see the article:
Help, I can't drop a table which I created in my Oracle database using MS-Access ? at the cooperatve FAQ http://www.jlcomp.demon.co.uk/faq/

I did a search of the version 9 documentation for SQL_ATTR_MATADATA_ID and METADATA but came up empty. Where did you find this parameter?

• Mark D Powell --