Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> imp issue on 9.2.0.7 windows nt

imp issue on 9.2.0.7 windows nt

From: lsllcm <lsllcm_at_gmail.com>
Date: 27 Nov 2005 21:47:49 -0800
Message-ID: <1133156869.714049.117960@z14g2000cwz.googlegroups.com>


I have oracle server 9.2.0.7, running on windows 2003 server.

I use the following exp command to export one schema exp userid=user/pass_at_accela60_db file=(file_01_1016.dmp, file_02_1016.dmp,file_03_1016.dmp,file_04_1016.dmp) filesize=2147483648 owner=user

I drop the schema and import it back.

Then I use the following imp command to import the schema. imp userid=system/pass file=(file_01_1016.dmp, file_02_1016.dmp,file_03_1016.dmp,file_04_1016.dmp) fromuser=user touser=user commit=y buffer=300000000 ignore=y log=file_imp.log

After imported 50%, it always prompts "Explort error, send the error page to microsoft", and the imp program is aborted.

Can anyone help on this? Received on Sun Nov 27 2005 - 23:47:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US