Skip to Main Content

Database Software

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!

Converting table and column names from case SENSITIVE to insensitive.

770860May 4 2010 — edited May 24 2010
Hello,

I recently imported an Access 97 database into Oracle. The problem that occured is that ALL the table and column names are now case sensitive... which also makes me think the data is case sensetive.

Is there a way to convert the entire database (or one step @ a time) to all uppercase (or case insensitive) ?

Any help / suggestions are welcome.

Oliver.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 21 2010
Added on May 4 2010
2 comments
4,499 views