Thursday, November 19, 2015

How to handle RMAN DUPLICATE: Errors in krbm_getDupCopy during duplicate

›
I recently cloned a 11.2.0.4 database using tape backups as source. The clone failed right before "open resetlogs". In other wor...
1 comment:
Wednesday, November 18, 2015

How to drop a redo logfile group and redo logfile group members - syntax

›
alter database drop logfile group 4; The drop statement will be confirmed by an entry in the database's alert log. Don't forget t...

Query to find basic redo log information

›
COL MEMBER FORMAT A50 SET LINES 200 SELECT A.GROUP#,A.MEMBER, B.BYTES/1024/1024 "MB", B.ARCHIVED,B.STATUS,B.SEQUENCE# FROM V$LOGFI...
Wednesday, November 11, 2015

How to add a comment on a column

›
Use this syntax: COMMENT ON COLUMN SCOTT.EMP.DOB IS 'Date of Birth';
Tuesday, November 10, 2015

How to find the default tablespace type (smallfile vs bigfile)

›
SQL> select property_value from database_properties where property_name = 'DEFAULT_TBS_TYPE'; PROPERTY_VALUE --------------- S...
Monday, November 9, 2015

How to append text at beginning and at end of each line in vi (unix)

›
Go to top of line with :0 Append text to the end of each line, globally: :%s/$/text/g Add text to the beginning of each line, globally: ...

How to install and deinstall Oracle Spatial and Oracle Multimedia

›
The following advice is an excerpt from a Service Request with Oracle support services, on how to administer Spatial and Multimedia: To re...
1 comment: