THE ARCHIVE / 2 ENTRIES

2014/04.

BROWSE THE FIELD NOTES

2014/04

All notes 12c Exadata GO internals konferencje RAC RMAN RUST security tips&tricks tuning

2 field notes / page 1 of 1

001Oracle26 Apr 2014

Oracle 12c – FETCH FIRST n ROWS ONLY

Oracle 12c offers a lot of fascinating new features – among them (at last) "FETCH FIRST n ROWS ONLY" syntax. http://www.oracle-base.com/articles/12c/row-limiting-clause-for-top-n-queries-12cr1.php Out of curios

1 MIN READRead the field notes ↗

002RMAN26 Apr 2014

Oracle myth: You need DBID to restore the controlfile

My experience shows that you don’t have to know the DBID now for restoring contorlfile from backup. If I know the name of backup piece, that contains controlfile I can do the following scenario:

2 MIN READRead the field notes ↗