exp/imp of selected oracle view [message #476248] |
Wed, 22 September 2010 06:08 |
goracle9
Messages: 136 Registered: December 2006
|
Senior Member |
|
|
Dear all
i need to exp/import select ted tables and views
i know how to do exp/imp tables, but how to do views
please let me know. my product 10g/linux
thanks
|
|
|
|
|
|
|
Re: exp/imp of selected oracle view [message #476390 is a reply to message #476278] |
Thu, 23 September 2010 01:16 |
goracle9
Messages: 136 Registered: December 2006
|
Senior Member |
|
|
hello experts,
i m trying to export a view only
expdp saladmin/passwd directory=workplace dumpfile=salview.dmp logfile=salview.log INCLUDE=VIEW:"IN('PROSP_VIEW')"
is it correct way?
result is
Export: Release 10.2.0.1.0 - Production on Thursday, 23 September, 2010 9:05:16
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production
Starting "SALADMIN"."SYS_EXPORT_SCHEMA_01": saladmin/******** directory=workplace dumpfile=salview.dmp logfile=salview.log INCLUDE=VIEW:IN('PROSP_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 "SALADMIN"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SALADMIN.SYS_EXPORT_SCHEMA_01 is:
/u05/test/salview.dmp
Job "SALADMIN"."SYS_EXPORT_SCHEMA_01" successfully completed at 09:06:39
it means my view only exported???
please explain.
|
|
|
Re: exp/imp of selected oracle view [message #476394 is a reply to message #476390] |
Thu, 23 September 2010 01:28 |
|
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Import contents of the export file into another user (possibly a newly created one, which doesn't have any objects), and you'll see.
P.S. Forgot to mention: IMP utility offers the SHOW parameter which only lists contents of the export file. I didn't use IMPDP much, but I *think* that this option isn't available (or it is named differently). IMPDP HELP=Y doesn't show it, and - at the first glance - I didn't see it in the documentation either. Perhaps someone else will know better.
[Updated on: Thu, 23 September 2010 01:34] Report message to a moderator
|
|
|
|
|
|