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/
Month: August 2017
ORA-1246 TNS:permission denied
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
Check it out…
case insensitive database
New Oracle Security On-Line Training Dates Added — Pete Finnigan’s Oracle security weblog
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
Master of disaster
Welcome