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 … Read more