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