EXPORTING AND IMPORTING A VIEW AS A TABLE IN ORACLE DATABASE 12c

Oracle have finally launched the much awaited Oracle database 12c which have about 500 new features,one of the interesting feature is the Export of a View and the Importing the same as a Table,so lets do it

STEP 1) Create a table in any of the PDB,i have created a view EMP_VW in scott schema

STEP 2) Create a directory for expdp and granting permissions to scott

STEP 3) Expdp the view using views_as_tables parameter

You have successfully exported the view,now lets import the same

STEP 4) First drop the existing view

STEP 5) Iimpdb the view using views_as_tables parameter

You have successfully imported the view,but the view would get imported as a table but not as a view so lets check it

STEP 5) The view will be imported in the schema as a table but not as a view

CONGRATULATIONS!!!!!!!
You have successfully Exported and then Imported a view as a table in new Oracle Database 12c.................

Keep watching for more new features of Oracle Database 12c

NEW FEATURES OF ORACLE DATABASE 12cR1

Finally the wait is over,Oracle database 12cR1 is out now and here are the various new features of 12cR1....welcome to the cloud

https://docs.google.com/file/d/0BwFkcPmksh3uZEVMNDBueUVvd2M/edit?usp=sharing