Biju

www.bijoos.com

OracleDB12c New Feature: Password File in ASM

by

Prior to Oracle Database 12c, the password file always was located under $ORACLE_HOME/dbs directory, even for RAC instances and for RAC ASM cluster. DBA had to manage and keep in sync the password file in each node. In 12c, now the password file can be stored on ASM instance and hence shared by all instances … Read more

OracleDB12c New Feature: Exporting View Data

by

Oracle Database 12c datapump export expdp has an option to export the views as tables. Expdp exports the view definition as a table and its data. This is an extremely useful feature to export subset of data. At import time, datapump creates the table with column name and data type similar to the view and … Read more