-
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
PNRDBA
-
-
On the new machine -
Is the instance running?
If so, is the shell window you are using set with the correct ORACLE_SID? If you want to be sure about the connection, add the net service name descriptor after system/manager (so userid=system/manager@dbname), presuming, of course, your Net8 configuration files have been updated to reflect the dname for your database.
What would you be changing in the init.ora between databases? I'd do the import with the same parameters, then make any init.ora changes after the import completed in a successful manner.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|