Recovering Tables with RMAN (12c)

Hello, everyone.
Today I will talk about of one the interesting features on oracle 12c, which is recovery a table with RMAN.
There are could be many reasons to restore a table, for example a data load failure, a huge insert data in wrong way, these types of restore could be dangerous.
On the other way you can create a second database 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