OraFAQ Forum: Server Utilities » can data pump only export/import views also.

Home » RDBMS Server » Server Utilities » can data pump only export/import views also.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

can data pump only export/import views also. [message #220998]

Fri, 23 February 2007 02:01

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

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Re: can data pump only export/import views also. [message #221249 is a reply to message #221034]

Sun, 25 February 2007 23:52

kukreja
Messages: 33
Registered: February 2007

Member

Thanks mahesh ,its working fine

Report message to a moderator

Previous Topic:	SQLLDR bad file due to special characters
Next Topic:	Can we validate the exported DMP file? (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 20:20:03 CST 2024