Monthly Archives: March 2017

I ran an export which included the table EMP. Later I imported this into a test instance using TABLE_EXISTS_ACTION=SKIP, and received error ORA-39325: TABLE_EXISTS_ACTION cannot be applied to “MYSCHEMA”.”EMP”. Upon further investigation, there was already a view named MYSCHEMA.EMP in … Continue reading →

Here’s an example of counting logons (established connections) at the listener: By minute: fgrep “23-FEB-2017 10:” listener.log | fgrep “establish” | awk ‘{ print $1 ” ” $2 }’ | awk -F: ‘{ print $1 “:” $2 }’ | sort … Continue reading →