|
Re: Import a DMP From Oracle 7.3 [message #170182 is a reply to message #170181] |
Tue, 02 May 2006 08:29 |
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 |
|
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 |
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)
...
|
|
|