OraFAQ Forum: Server Utilities » Error while using Export and Import from oracle client

Home » RDBMS Server » Server Utilities » Error while using Export and Import from oracle client

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

Error while using Export and Import from oracle client [message #74184]

Fri, 01 October 2004 04:32

T. Sri Sai Krishna
Messages: 17
Registered: May 2002

Junior Member

Hi,

I have oracle 9i client installed on my windows system and I am connecting to an oracle 9i database on an unix server in the same network.

When I try to export from the system prompt I get this error.

exp scott/tiger@server1 File=emp.dat Tables=emp Rows=yes Indexes=yes

Export: Release 9.2.0.1.0 - Production on Fri Oct 1 18:01:10 2004

Copyright (c) 1982, 2002, Oracle Corporation.� All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully

I am able to connect and work on the database schemas with ease. But when I try exporting the data I keep getting this error. Could anyone explain why this is happening.

Thanks in advance,

SriSai

Report message to a moderator

Re: Error while using Export and Import from oracle client [message #74188 is a reply to message #74184]

Fri, 01 October 2004 06:51

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

always use the lower version of exp/imp against the higher version of exp/imp.
else
You need to install the higherversion views (9.2), in the lower version (9.0) ( which you may not want to)
from the higher version client,
login as sys and run the $ORACLE_HOME/rdbms/admin/catexp.sql

Report message to a moderator

Re: Error while using Export and Import from oracle client [message #74295 is a reply to message #74184]

Fri, 05 November 2004 00:46

Sanjay Kakkar
Messages: 2
Registered: July 2002

Junior Member

facing an error while importing dump into (oracle 9i)
eror no ORA 1400 <<null>>

how can i avoid the same.

Pl advise,

regards,

Report message to a moderator

Previous Topic:	Why Oracle8i could not installed?
Next Topic:	Problem with Import / Export

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 08:26:41 CDT 2024