Tuesday, May 29, 2018

Shell script snipplet for resetting a password

›
This little code snipplet to use a Linux/Unix escape character to send a line shift into a string of mulitple commands: #!/bin/bash . /ho...
Tuesday, May 22, 2018

Workaround for ORA-46372: audit file not found

›
In my environment, I had the following errors popping up in Cloud Control: ORA-46372: audit file '/u01/oracle/audit/proddb01/ora_audi...
Tuesday, April 24, 2018

Partitioned index properties

›
The following query will reveal information about the indexes on a partitioned table. Very useful when you want to investigate if a part...
Thursday, April 19, 2018

How do I find which objects that were analyzed during an autostats job?

›
Step 1 Find the start and stop times of the maintenance window: select window_name, cast(last_start_date as date) "Start Time"...
1 comment:
Wednesday, April 18, 2018

Potential solution for ORA-12008: error in materialized view or zonemap refresh path

›
During the synch-phase of an online redefintion, I received the error: begin ORA-42009: error occurred while synchronizing the redefiniti...
1 comment:
Tuesday, April 17, 2018

Syntax for index hint

›
Use /*+ INDEX(table_name index_name) */ For example: set autot trace exp stat select /*+ INDEX(MYTABLE MY_IDX1) */ min(entry_num) from s...
Friday, April 13, 2018

A solution for ORA-28040

›
When connecting to Oracle 12c databases you may get ERROR: ORA-28040: No matching authentication protocol upon login. The error is de...