Mastering the Oracle Stack, One Post at a Time.
Oracle Database, the related services (cloud) and various options in the database.
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
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 … Read more