Search results

Views_as_tables Parameter In Datapump Of Oracle 12c

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

Take export of this view as 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 view has imported as table.

No comments:

Post a Comment