Home » RDBMS Server » Server Utilities » IMP-00002: error
IMP-00002: error [message #239852] Wed, 23 May 2007 08:10 Go to next message
lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND
Member
I am getting the IMP-00002 error for an import. Exported dump was gzipped without a *.dmp extension. Are there any suggestions? Oracle attempts to add the extension but it fails with the error.

here is my syntax for the import

imp file=/fiberdrive/fromdte/eas_dmp log=eas_dmp full=y Embarassed
Re: IMP-00002: error [message #239855 is a reply to message #239852] Wed, 23 May 2007 08:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
kayak[MTXH01]> exp / file=t owner=ops$mcadot

Export: Release 8.1.7.4.0 - Production on Wed May 23 15:16:37 2007

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


Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production
Export done in US7ASCII character set and WE8DEC NCHAR character set
server uses WE8DEC character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user OPS$MCADOT
. exporting object type definitions for user OPS$MCADOT
About to export OPS$MCADOT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export OPS$MCADOT's tables via Conventional Path ...
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting snapshots
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
Oracle doesn't care abour extension:
kayak[MTXH01]> imp / file=t full=y

Import: Release 8.1.7.4.0 - Production on Wed May 23 15:16:49 2007

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


Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production

Export file created by EXPORT:V08.01.07 via conventional path
import done in US7ASCII character set and WE8DEC NCHAR character set
import server uses WE8DEC character set (possible charset conversion)
. importing OPS$MCADOT's objects into OPS$MCADOT
Import terminated successfully without warnings.

The error comes from another thing.
Maybe we can help you if you post your log.

Regards
Michel
Re: IMP-00002: error [message #239955 is a reply to message #239855] Wed, 23 May 2007 13:52 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
are you calling the gzipped file in your imp command
or you first gunzip/upzip it and they you tried??

ist unzip it then try to import.

[Updated on: Wed, 23 May 2007 13:53]

Report message to a moderator

Previous Topic: Oracle Redo log Multiplexing
Next Topic: sql loader issue
Goto Forum:
  


Current Time: Tue Dec 06 08:50:45 CST 2016

Total time taken to generate the page: 0.25079 seconds