Hi all
I've a DB of 16 Gigs and RAM of 6 Gigs on production. I got a full database export(All schemas of DB, not FULL=Y). I want to import it on another test machine of 500Megs. For this import, do i need to have the same values in my init.ora file as in production on my test server?? B'coz, when i'm trying to import, its saying end-of-file communication channel. Import terminated unsuccessfully finishig half the way. I tried for thrice,and got the same error at different tables. Can any help me why is this happening??

Thanks in advance,


Here i'm posting my Exporting script.

USERID=system/manager
LOG=/opt/oracle/admin/cms/logs/export.log
OWNER=cms,cmsit,cmsapp,cmsadhoc,cms2adm
CONSISTENT=Y
COMPRESS=N
ROWS=Y
#FULL=Y
FILE=/opt/oracle/admin/cms/exp/expdat1.dmp,
/opt/oracle/admin/cms/exp/expdat2.dmp,
/opt/oracle/admin/cms/exp/expdat3.dmp,
/opt/oracle/admin/cms/exp/expdat4.dmp,
/opt/oracle/admin/cms/exp/expdat5.dmp,
/opt/oracle/admin/cms/exp/expdat6.dmp,
/opt/oracle/admin/cms/exp/expdat7.dmp,
/opt/oracle/admin/cms/exp/expdat8.dmp,
/opt/oracle/admin/cms/exp/expdat9.dmp,
/opt/oracle/admin/cms/exp/expdat10.dmp,
/opt/oracle/admin/cms/exp/expdat11.dmp,
/opt/oracle/admin/cms/exp/expdat12.dmp,
/opt/oracle/admin/cms/exp/expdat13.dmp,
/opt/oracle/admin/cms/exp/expdat14.dmp,
/opt/oracle/admin/cms/exp/expdat15.dmp
FILESIZE= 2000M
--------------------

Here i's my import script: (On different machine)

userid=system/manager
log=/home/oracle/import.log
file=/u01/expdat1.dmp,
/u01/expdat2.dmp,
/u01/expdat3.dmp

Please help me