You are viewing a plain text version of this content. The canonical link for it is here.

Posted to ddlutils-dev@db.apache.org by "Dave Lindsey (JIRA)" <ji...@apache.org> on 2009/02/04 03:47:59 UTC

[jira] Created: (DDLUTILS-240) Oracle "schema name" must be UPPERCASE.

Oracle "schema name" must be UPPERCASE.  
-----------------------------------------

                 Key: DDLUTILS-240
                 URL: https://issues.apache.org/jira/browse/DDLUTILS-240
             Project: DdlUtils
          Issue Type: Improvement
         Environment: Oracle 9i
            Reporter: Dave Lindsey
            Assignee: Thomas Dudziak
            Priority: Minor


In Oracle, a schema equates to a user name.

Oracle converts the user name to UPPER CASE and in its tables.

If your user name is user1 and you enter "user1" as you schema, you get no tables back.

You must enter USER1 as the schema name in order to get tables back.

The Oracle Readers could/should ?? convert user name to uppercase to match what is stored in the database. 

 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.