OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » export problem

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

export problem [message #224093]

Tue, 13 March 2007 01:19

mudalimuthu
Messages: 64
Registered: May 2005
Location: Bangalore

Member

i have one user at oracle 10g xe server
while exporting a particular table through 8 i client i am getting the following error

C:\>exp mfgtest/log@xe tables=exprset file=t1.dmp

Export: Release 8.1.5.0.0 - Production on Tue Mar 13 11:35:48 2007

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta
Export done in WE8ISO8859P1 character set and UTF8 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table EXPRSET
EXP-00003: no storage definition found for segment(5, 68987)
Export terminated successfully with warnings.

note:
i am not able to export only this table (exprset) wht would be the problem?
but i can export all the other tables.

thanks in advance
Muthu

Report message to a moderator

Re: export problem [message #224112 is a reply to message #224093]

Tue, 13 March 2007 02:26

Frank
Messages: 7901
Registered: March 2000

Senior Member

Why don't you use the 10g client?

Report message to a moderator

Re: export problem [message #224135 is a reply to message #224112]

Tue, 13 March 2007 04:01

mudalimuthu
Messages: 64
Registered: May 2005
Location: Bangalore

Member

WE HAVE MULTIPLE SERVERS ORACE9I, 10G AND 8I IN OUR NETWORK.

IS THERE ANY ALTERNATIVE SOLUTION FOR THE ABOVE PROBLEM?

Report message to a moderator

Re: export problem [message #224146 is a reply to message #224093]

Tue, 13 March 2007 04:21

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

mudalimuthu

i am not able to export only this table (exprset) wht would be the problem?

So what differs 'exprset' table from all the others? Does it have different storage parameters? Something else? Perhaps these differences will give you the answer.

Report message to a moderator

Re: export problem [message #224239 is a reply to message #224093]

Tue, 13 March 2007 08:20

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

8.1.5.0.0 is an early version of 8i (possibly the earliest). It might not support exporting of 10gR2.

Report message to a moderator

Re: export problem [message #224336 is a reply to message #224146]

Tue, 13 March 2007 23:24

mudalimuthu
Messages: 64
Registered: May 2005
Location: Bangalore

Member

how to find out
in which tablespace the exprset table is stored ?

Report message to a moderator

Re: export problem [message #224338 is a reply to message #224336]

Tue, 13 March 2007 23:48

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

select tablespace_name
from user_segments
where segment_name = UPPER('exprset');

regards
Taj

Report message to a moderator

Re: export problem [message #224350 is a reply to message #224093]

Wed, 14 March 2007 01:12

mudalimuthu
Messages: 64
Registered: May 2005
Location: Bangalore

Member

but ALL THE TABLES ARE IN THE SAME TABLESPACE.

I HAVE CLOB DATATYPE FIELD IN THIS TABLE. BUT SO MANY OTHERS TABLES ALSO HAVING THE CLOB DATATYPE FIELDS.

WHT WOULD BE THE PROBLEM

Report message to a moderator

Re: export problem [message #224351 is a reply to message #224350]

Wed, 14 March 2007 01:17

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
http://searchoracle.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid41_gci1235278,00.html

hope this helps
regards
Taj

Report message to a moderator

Previous Topic:	ulcase files
Next Topic:	SQL Loader date time conversion problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 20:49:52 CST 2024