Home » RDBMS Server » Server Utilities » exp/imp of selected oracle view (oracle 10.2, linux)
exp/imp of selected oracle view [message #476248] Wed, 22 September 2010 06:08 Go to next message
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 #476252 is a reply to message #476248] Wed, 22 September 2010 06:16 Go to previous messageGo to next message
Michel Cadot
Messages: 58605
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do it with DBMS_METADATA.GET_DDL.

Regards
Michel
Re: exp/imp of selected oracle view [message #476275 is a reply to message #476252] Wed, 22 September 2010 07:58 Go to previous messageGo to next message
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?
Re: exp/imp of selected oracle view [message #476276 is a reply to message #476275] Wed, 22 September 2010 07:59 Go to previous messageGo to next message
BlackSwan
Messages: 22515
Registered: January 2009
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/
Re: exp/imp of selected oracle view [message #476278 is a reply to message #476275] Wed, 22 September 2010 08:47 Go to previous messageGo to next message
Michel Cadot
Messages: 58605
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
cant we do anything with TOAD?

Throw it away?

Regards
Michel
Re: exp/imp of selected oracle view [message #476390 is a reply to message #476278] Thu, 23 September 2010 01:16 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 19320
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 Go to previous messageGo to next message
ramoradba
Messages: 2452
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
Re: exp/imp of selected oracle view [message #476409 is a reply to message #476398] Thu, 23 September 2010 02:42 Go to previous messageGo to next message
Littlefoot
Messages: 19320
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you oversleep the last 4 messages? ./fa/1774/0/
Re: exp/imp of selected oracle view [message #476412 is a reply to message #476409] Thu, 23 September 2010 02:46 Go to previous message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Yes ....
Previous Topic: Tablespace for Importing objects.
Next Topic: SQL Loader - Error
Goto Forum:
  


Current Time: Mon Jul 28 13:55:58 CDT 2014

Total time taken to generate the page: 0.24989 seconds