Home » RDBMS Server » Server Administration » Import a DMP From Oracle 7.3
Import a DMP From Oracle 7.3 [message #170181] Tue, 02 May 2006 08:18 Go to next message
sergioms
Messages: 5
Registered: February 2006
Junior Member
how to, import a dmp data pump file, using ORACLE 10g express edition ?

I was try with impdp ..
Re: Import a DMP From Oracle 7.3 [message #170182 is a reply to message #170181] Tue, 02 May 2006 08:29 Go to previous messageGo to next message
sergioms
Messages: 5
Registered: February 2006
Junior Member
D:\ORACLEXE\app\oracle\product\10.2.0\server\BIN>impdp WMSBK/bklwms DIRECTORY=im
portacao DUMPFILE=atual.dmp LOGFILE=import.log

Import: Release 10.2.0.1.0 - Production on Terþa-Feira, 02 Maio, 2006 10:26:13

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Conectado a: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

ORA-39002: operaþÒo invßlida
ORA-39070: NÒo Ú possÝvel abrir o arquivo de log.
ORA-29283: operaþÒo de arquivo invßlida
ORA-06512: em "SYS.UTL_FILE", line 475
ORA-29283: operaþÒo de arquivo invßlida
Re: Import a DMP From Oracle 7.3 [message #170204 is a reply to message #170181] Tue, 02 May 2006 10:01 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
<cm10gu-oracle@sdb2b.hitbox.com:/a/oracle:> oerr ora 39002
39002, 00000, "invalid operation"
// *Cause: The current API cannot be executed because of inconsistencies
// between the API and the current definition of the job.
// Subsequent messages supplied by DBMS_DATAPUMP.GET_STATUS
// will further describe the error.
// *Action: Modify the API call to be consistent with the current job or
// redefine the job in a manner that will support the specified API.
<cm10gu-oracle@sdb2b.hitbox.com:/a/oracle:> oerr ora 39070
39070, 00000, "Unable to open the log file."
// *Cause: Errors were detecting while opening the log file. Subsequent
// messages will detail the problems.
// *Action: Fix the problems outlined in the secondary messages.
<cm10gu-oracle@sdb2b.hitbox.com:/a/oracle:> oerr ora 29283
29283, 00000, "invalid file operation"
// *Cause: An attempt was made to read from a file or directory that does
// not exist, or file or directory access was denied by the
// operating system.
// *Action: Verify file and directory access privileges on the file system,
// and if reading, verify that the file exists.
<cm10gu-oracle@sdb2b.hitbox.com:/a/oracle:> oerr ora 29283
29283, 00000, "invalid file operation"
// *Cause: An attempt was made to read from a file or directory that does
// not exist, or file or directory access was denied by the
// operating system.
// *Action: Verify file and directory access privileges on the file system,
// and if reading, verify that the file exists.
Re: Import a DMP From Oracle 7.3 [message #170228 is a reply to message #170204] Tue, 02 May 2006 15:17 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
From metalink Note:132904.1


...

1. Migration to Oracle9i release 2 - 9.2.0.x :
   -------------------------------------------
   Direct migration with a full database export and full database import
   is only supported if the source database is:
   - Oracle7 : 7.3.4
   - Oracle8 : 8.0.6
   - Oracle8i: 8.1.7
   - Oracle9i: 9.0.1

2. Migration to Oracle10g release 1 - 10.1.0.x :
   ---------------------------------------------
   Direct migration with a full database export and full database import
   is only supported if the source database is:
   - Oracle8 : 8.0.6
   - Oracle8i: 8.1.7
   - Oracle9i: 9.0.1 or 9.2.0

3. Migration to Oracle10g release 2 - 10.2.0.x :
   ---------------------------------------------
   Note that you must first apply the specified minimum patch release
   (or any higher patch release) !
   Direct migration with a full database export and full database import
   is only supported if the source database is:
   - Oracle8i :  8.1.7.4
   - Oracle9i :  9.0.1.4 (or higher) or 9.2.0.4 (or higher)
   - Oracle10g: 10.1.0.2 (or higher)

...
Previous Topic: Connecting Toad with Oracle 10g
Next Topic: UNDO_RETENTION
Goto Forum:
  


Current Time: Fri Sep 27 02:37:00 CDT 2024