Oracle inmemory + collation (CI/AI)

Hi all,

I recently  ran into an interesting scenario. I collect table facts from various databases and want to perform analysis on it. Given I often copy/paste table name from various places, I set table_name with collate "binary_ci" so that I don't have to wrap the table name with upper function every time, i.e., my table definition looks like:

  CREATE TABLE MYTABLE

   (    "DBNAME" CHAR(8 BYTE) COLLATE "USING_NLS_COMP",

    "OWNER" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,

    "TABLE_NAME" VARCHAR2(128 BYTE) COLLATE "BINARY_CI" NOT NULL ENABLE,

    "NUM_ROWS" NUMBER,

    "AVG_ROW_LEN" NUMBER,