Subscriber Count

    471

Subscribe to Posts by Email

Pages

EXPDP Import View as Table

Starting 12c, we can export a view and import it as table instead of view using data pump. SQL> create view emp_dept as select empno, ename, dept.deptno , dname from emp, dept where emp.deptno=dept.deptno; View created.

expdp directory=DBA_DATAPUMP dumpfile=test.dmp logfile=test.log VIEWS_AS_TABLES=emp_dept_vw

Processing object type TABLE_EXPORT/VIEWS_AS_TABLES/TABLE_DATA Total estimation using BLOCKS method: 16 KB Processing object […]