Export return error message ORA-00942
Hi,
I've installed an Oracle 9.2.0.4.0 on RHEL5. The Oracle Instance for this server was nios3. This is our testing server and I want to dump a database from our production server to this database.
Our production server was RP1. Oracle installed was 9.2.0.1.0 on HP-UX B.11.11 you 900/800. It Oracle instances was nios1
From our testing server, i've run a command exp user/password@nios1 full=y dump=/dump/rp1.dmp log=/dump/rp1.log direct=y. It return an error as mentioned below.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.1.0 - Production
I've installed an Oracle 9.2.0.4.0 on RHEL5. The Oracle Instance for this server was nios3. This is our testing server and I want to dump a database from our production server to this database.
Our production server was RP1. Oracle installed was 9.2.0.1.0 on HP-UX B.11.11 you 900/800. It Oracle instances was nios1
From our testing server, i've run a command exp user/password@nios1 full=y dump=/dump/rp1.dmp log=/dump/rp1.log direct=y. It return an error as mentioned below.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.1.0 - Production
0