VIEWS_AS_TABLES parameter has been introduced in datapump of 12c. With this, we can export a view from a source database and import as a table in a target database.

Create a view:

 

Take export of this view as a table using views_as_tables parameter:

Now drop the view and import the same from the export dump which we have taken.

 

Now check the object_type:

We can see DBA_VIEW which we exported as the view has imported as a table.

About The Author

Leave a Reply