DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, July 14, 2016

Exporting Views as Tables in 12c datapump


Oracle 12c introduces the possibility to export VIEWS as TABLES using the expdp parameter VIEWS_AS_TABLES:

VIEWS_AS_TABLES=[schema_name.]view_name[:table_name], ...

For example

impdp directory=exam_dir dumpfile=ocp.dmp logfile=impdp_ocp.log   views_as_tables=view1   remap_table:view1:table1

2 comments:

Anonymous said...

What is a business case/scenario as where this will be needed, is there an use-case for this to understand it better

Glassl Android said...

my use case: create views for sensitive tables with "functions" to anonymize data on production environment. export views as table for an anonymized export for test & development department.

kind regards,
Martin