12c EXPDP
New Features 12c EXPDP
While i am testing Oracle 12c i notice new features in expdp , which you can export view like the following :
SQL> create table test ( id number);
Table created.
SQL> create view test_vw as select * from test ;
View created.
SQL> create directory dump as '/u01/dump';
Directory created.
SQL> grant read,write on directory dump to hyd ;
Grant succeeded.
[oracle@test12c u01]$ expdp directory=dump dumpfile=test.dmp logfile=test.log VIEWS_AS_TABLES=test_vw
Export: Release 12.1.0.1.0 - Production on Wed Jun 26 18:33:52 2013
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
Username: hyd
Password: hyd123
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "HYD"."SYS_EXPORT_TABLE_01": hyd/******** directory=dump dumpfile=test.dmp logfile=test.log VIEWS_AS_TABLES=test_vw
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/VIEWS_AS_TABLES/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type TABLE_EXPORT/VIEWS_AS_TABLES/TABLE
. . exported "HYD"."TEST_VW" 0 KB 0 rows
Master table "HYD"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for HYD.SYS_EXPORT_TABLE_01 is:
/u01/dump/test.dmp
Job "HYD"."SYS_EXPORT_TABLE_01" successfully completed at Wed Jun 26 18:34:15 2013 elapsed 0 00:00:17
Drop the view
SQL> drop view Test_vw ;
View dropped.
Import the View
impdp directory=dump dumpfile=test.dmp logfile=test.log VIEWS_AS_TABLES=test_vw
While i am testing Oracle 12c i notice new features in expdp , which you can export view like the following :
SQL> create table test ( id number);
Table created.
SQL> create view test_vw as select * from test ;
View created.
SQL> create directory dump as '/u01/dump';
Directory created.
SQL> grant read,write on directory dump to hyd ;
Grant succeeded.
[oracle@test12c u01]$ expdp directory=dump dumpfile=test.dmp logfile=test.log VIEWS_AS_TABLES=test_vw
Export: Release 12.1.0.1.0 - Production on Wed Jun 26 18:33:52 2013
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
Username: hyd
Password: hyd123
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "HYD"."SYS_EXPORT_TABLE_01": hyd/******** directory=dump dumpfile=test.dmp logfile=test.log VIEWS_AS_TABLES=test_vw
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/VIEWS_AS_TABLES/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type TABLE_EXPORT/VIEWS_AS_TABLES/TABLE
. . exported "HYD"."TEST_VW" 0 KB 0 rows
Master table "HYD"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for HYD.SYS_EXPORT_TABLE_01 is:
/u01/dump/test.dmp
Job "HYD"."SYS_EXPORT_TABLE_01" successfully completed at Wed Jun 26 18:34:15 2013 elapsed 0 00:00:17
Drop the view
SQL> drop view Test_vw ;
View dropped.
Import the View
impdp directory=dump dumpfile=test.dmp logfile=test.log VIEWS_AS_TABLES=test_vw