Posts

Posted on

OracleDB12c New Feature: Exporting View Data

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 performs the data load.

Grants and other dependent objects on the views are also exported.

When VIEWS_AS_TABLES option is specified in the expdp, Oracle implicit creates a table using the CREATE TABLE AS and populates with data.

Read more about this feature in the Oracle Documentation.

Posted on

OracleDB12c New Feature: Misc Security Changes

Security in Oracle12c Database is enhanced, in this blog will try to identify few difference you would see compared with 11gR2.

SELECT ANY DICTIONARY privilege in 12c excludes access to the following tables with authentication information:

  • DEFAULT_PWD$
  • ENC$
  • LINK$
  • USER$
  • USER_HISTORY$
  • XS$VERIFIERS

AUDIT_TRAIL initialization parameter is set to DB by DBUA and DBCA utilities when a database is upgraded or created.

In the previous versions when a user is granted the RESOURCE role, the UNLIMITED TABLESPACE privilege was granted. This is removed in 12c. If UNLIMITED TABLESPACE privilege required, it must be granted explicitly.

The ORAPWD utility’s  IGNORECASE option is deprecated. The default is N. Similarly the SEC_CASE_SENSITIVE_LOGON parameter is deprecated as well.