Home » RDBMS Server » Server Utilities » can data pump only export/import views also.
can data pump only export/import views also. [message #220998] Fri, 23 February 2007 02:01 Go to next message
kukreja
Messages: 33
Registered: February 2007
Member
Hi

Can anybody tell me how to export or import only views through data pump.

[Updated on: Fri, 23 February 2007 03:08]

Report message to a moderator

Re: can data pump only export/import views also. [message #221034 is a reply to message #220998] Fri, 23 February 2007 05:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use INCLUDE=VIEW
C:\ora>expdp scott/tiger directory=dump_dir dumpfile=viewonly.dmp include=view

Export: Release 10.2.0.1.0 - Production on Friday, 23 February, 2007 6:27:34

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SCOTT"."SYS_EXPORT_SCHEMA_01":  scott/******** directory=dump_dir dumpfile=viewonly.dmp include=view
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Master table "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_SCHEMA_01 is:
  C:\ORA\VIEWONLY.DMP
Job "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully completed at 06:27:50
Re: can data pump only export/import views also. [message #221249 is a reply to message #221034] Sun, 25 February 2007 23:52 Go to previous message
kukreja
Messages: 33
Registered: February 2007
Member
Thanks mahesh ,its working fine
Previous Topic: SQLLDR bad file due to special characters
Next Topic: Can we validate the exported DMP file? (merged)
Goto Forum:
  


Current Time: Wed Dec 07 03:23:21 CST 2016

Total time taken to generate the page: 0.06642 seconds