ORACLE @ Work

When /usr/bin/find: Argument list too long error USE THIS: find /u01/app/oracle/diag/rdbms/TEST/TEST/trace/ -name '*.trm'  -mtime +3...

In Oracle 11g, we can change the table to READ ONLY mode which doesn't allow any DML over it. Below is a tested scenario. SQL> ...

drop trigger log_errors_trig; drop table log_errors_tab; create table log_errors_tab ( error varchar2(30), timestamp date, usernam...

OEM was nice the other day and offered some Segment Adviser Recommendations to shrink a few tables that had become fragmented. However, w...

If you want to change all occurrences of developer to administrator in the oracle.txt file in the grep example, enter this: Content o...

In 11g , there is a new SQL command that can be used to shrink temporary tablespaces. This command can be used to shrink only locally manage...

Cd to $ORACLE_HOME/dbs orapwd file=orapw password=<>same as SYS> entries=10

Remove the following directories from your filesystem: / /oc4j/j2ee/OC4J_DBConsole_ _ If the dbcontrol is upgraded from lower version...

Rename diskgroup option is a new feature of 11gR2  but can be done for 10g & 11gR1 as well. It requires installing 11gR2 SIHA Grid I...

While trying to drop a user with QUEUE table objects; it won't let you drop with below warnings. ORA-00604: error occurred at recursi...

Today I was facing issues accessing metalink (https://support.oracle.com/). Seems the site is down. Then I found the below alternate link o...

When attempting to perform a point-in-time recovery from a hot backup you receive an ORA-01547 followed by ORA-01195 and ORA-01110:  SQL...

 To rename or relocate datafiles in the SYSTEM tablespace one must use option II, 'Renaming or Moving a Datafile with the Database Sh...