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: Move datafile online (New feature)

Hello readers!!
Today I will talk about one interesting feature on Oracle 12c: Move a datafile online.
You could have many reasons to move a datafile online, for example: to another file system, or to another ASM disk group.
On previous versions if you want to move a datafile or rename, you must to put datafile offline and you need to recover the datafile and bring back online. During this operation it is not possible access the data inside the datafile. Continue reading

Oracle Entreprise Manager Cloud 12c: Configuring e-mail alerts

Hello everyone!
Today I will show how to configure e-mail alerts in OEM 12c.
I did one implementation in one client last week, all databases are monitored with OEM 12c, this is a very good tool.
The scopes of OEM 12c are not limited only at database level.
We will create commun alert for full tablespaces.
Let’s start: Continue reading