Pluggable Database save state (automatic start)

On this post I will show one interesting feature on 12c at version 12.1.0.2, save state of a pluggable database.
After restart a container database all pluggables databases stays on mount state, imagine if you are a DBA with more than 100 PDBs.
You may need to write a trigger event or a script to put the PDBs on write mode, this operations could be complexs.
Considering that not all PDBs don’t have to stay on write mode.

Let’s start: Continue reading

Migrating the database from File System to ASM (12c)

Hello everyone!

On this post I will show how migrate your oracle database reside on a file system to an ASM.
I will not entered on the detail how to configure and install your grid infrastructure software and how to allocate/create disks to ASM. Continue reading

Oracle Database 12c: Invisible columns

Hi everyone,

Today I will talk a little about a new feature on Oracle Database 12c, there are invisible columns. For use this feature there are some restrictions in some types of tables like:
Invisible columns are not supported in external tables, cluster tables, or temporary tables.
Also there are some kinds of operation that will not see a column set to invisible:
A statement with wildcard character, such as select * from mytables.
The SQL*Plus DESC command (Below I will tell how to see invisible columns with DESC command)
A PL/SQL %rowtype declaration
An insert into select * statement

Invisible columns can be made invisible when using the Continue reading

Oracle Database 12c: Data pump views_as_tables parameter (New feature)

Hello everyone!!
How many times, you would like to converted a view into a table during an export or import process.
Well, now on Oracle 12c this is can be possible with the views_as_tables parameter, with this parameter allows you to convert a view into a table during either an export to a dump file or a import from a dump file.
During the process of export dump file, the views listed into the parameter views_as_tables are converted during the process. Continue reading

Oracle Database 12c (12.1.0.2) installation on Solaris 11 (11.2 x86)

Hello everyone!!
Today I will show, how to prepare the Solaris 11.2 for install Oracle Database 12c (12.1.0.2).
I am still familiarizing with Solaris systems, to me it has been a good experience.
I am discovering very good features about Solaris systems. This is a simple post, with few steps you can be prepare.

To complete the steps you will need the following prerequisites Continue reading