Database Administration (MOSC)

MOSC Banner

How to join tables with conflicting collations?

edited Aug 14, 2019 5:06AM in Database Administration (MOSC) 1 commentAnswered

I don't know how to compare objects from tables with different collations.  See below.

select tablename from itd_csdw.tablemaint where tablename in (select table_Name from dba_tables);

                                                                     *

ERROR at line 1:

ORA-43915: unable to determine collation: arguments have conflicting collations

Here's the DDL for the table.

select dbms_metadata.get_ddl('TABLE','TABLEMAINT','ITD_CSDW') from dual

/

DBMS_METADATA.GET_DDL('TABLE','TABLEMAINT','ITD_CSDW')

--------------------------------------------------------------------------------

CREATE TABLE "ITD_CSDW"."TABLEMAINT"

   (   "TABLENAME" VARCHAR2(50) COLLATE BINARY_CI NOT NULL ENABLE,

   ) ...

DEFAULT COLLATION BINARY_CI...

COLUMN STORE COMPRESS FOR QUERY HIGH..

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center