Monthly Archives: settembre 2015

Guaranteed restore point
  • 24
    Set

Guaranteed restore point

In front of any activity on the database ( example UPGRADE / application changes ) over the RMAN backup , in addition to exports and other types of rescue, a fast method (especially then in case of rollback ) to have a consistency point is to create a GUARANTEED RESTORE POINT for a possible rollback database. Requirements :...

Read More
Oracle PL/SQL:  implicit vs explicit cursors
  • 14
    Set

Oracle PL/SQL: implicit vs explicit cursors

PL/SQL issues an implicit cursor whenever you execute a SQL statement directly in your code, as long as that code does not employ an explicit cursor. It is called an "implicit" cursor because you do not explicitly declare a cursor for the SQL statement. If you use an implicit cursor, Oracle performs the open, fetches, and close for...

Read More
Oracle 12c: Move datafile feature
  • 1
    Set

Oracle 12c: Move datafile feature

Until the release 11g move a datafile was an operation very problematic; We had to put the tablespace offline, copy the datafile to the new destination and rename it : SQL> alter database rename datafile “A” to “B”; From Oracle release Oracle 12c, you can move a datafile from a mount point to another without having to put...

Read More