OraFAQ Forum: Server Utilities » exp/imp of selected oracle view

Home » RDBMS Server » Server Utilities » exp/imp of selected oracle view (oracle 10.2, linux)

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

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

Report message to a moderator

Re: exp/imp of selected oracle view [message #476252 is a reply to message #476248]

Wed, 22 September 2010 06:16

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Do it with DBMS_METADATA.GET_DDL.

Regards
Michel

Report message to a moderator

Re: exp/imp of selected oracle view [message #476275 is a reply to message #476252]

Wed, 22 September 2010 07:58

goracle9
Messages: 136
Registered: December 2006

Senior Member

i m getting this error

ORA-24813: cannot send or receive an unsupported LOB

cant we do anything with TOAD?

please any other way?

Report message to a moderator

Re: exp/imp of selected oracle view [message #476276 is a reply to message #476275]

Wed, 22 September 2010 07:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I don't know what you have.
I don't know what you do.
I don't know what you see.
It is really, Really, REALLY difficult to fix a problem that can not be seen.
use COPY & PASTE so we can see what you do & how Oracle responds.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: exp/imp of selected oracle view [message #476278 is a reply to message #476275]

Wed, 22 September 2010 08:47

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

cant we do anything with TOAD?

Throw it away?

Regards
Michel

Report message to a moderator

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.

Report message to a moderator

Re: exp/imp of selected oracle view [message #476394 is a reply to message #476390]

Thu, 23 September 2010 01:28

Littlefoot
Messages: 21807
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

Re: exp/imp of selected oracle view [message #476398 is a reply to message #476394]

Thu, 23 September 2010 01:43

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

ORA-24813:
cannot send or receive an unsupported LOB

Cause:	 An attempt was made to send a LOB across the network, 
but either the server does not support the LOB sent by the client, 
or the client does not support the LOB sent by the server. 
This error usually occurs when the client and server are running different versions of Oracle.

Action:	 Use a version of the Oracle that supports the LOB on both the client and the server.

Solution already provided By Michel

sriram

Report message to a moderator