schema B with default collation = BINARY_CI schema B with default collation = USING_NLS_COMP   join tables from both schemas produces error ORA-43915: unable to determine collation: arguments have conflicting collations Solution recreate table in B schema with  BINARY_CI R/          

  set permission on Oracle binary: cd $ORACLE_HOME/bin chmod 6755 oracle permissions on /oracle/xxxxxxxxxxx/dbms122/bin/oracle   not correct /xxxi/hbai>ls -altr $ORACLE_HOME/bin/oracle -rwsrws--- 1 hsxxx dba 408095920 9. Aug 13:41 /oracle/xxxxxxxxxxx/dbms122/bin/oracle   These are correct -rwsr-s--x 1 hsxxx dba 408095920 9. Aug 13:41 /oracle/xxxxxxxxxxx/dbms122/bin/oracle  

https://oracle-base.com/articles/12c/real-time-materialized-views-12cr2

https://oracle-base.com/blog/2017/04/21/collation-and-case-insensitive-database-in-oracle-12-2/

We have finally added new on-line training dates for some of our classes; the very popular two days "How to perform a security audit of an Oracle Database" is first followed by the one day class "Hardening and Securing Oracle....[Read More] Posted by Pete On 07/08/17 At 06:30 PM via New Oracle Security On-Line Training Dates … Continue reading New Oracle Security On-Line Training Dates Added — Pete Finnigan’s Oracle security weblog

Welcome