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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,318 views