Exp/Imp from 1 Solaris box to another [message #72612] |
Thu, 31 July 2003 13:23 |
Michele
Messages: 77 Registered: December 2000
|
Member |
|
|
Hello,
I need to write a cron job on my solaris machine that exports data from an oracle 8i database on another solaris machine on our network and then imports the data into an Oracle 9i database that is sitting on the machine that is launching the cron job.
Can this be done? Where does the export get dumped? On the machine that is running the script or the machine that is being called?
I have a database link that is created between machines but I am not sure if that needs to be in the script.
As of now, I have the below but I am not sure if I am on the right track:
ORACLE_SID=oracle8i
export ORACLE_SID
exp userid=8i/8i file=weeklyLdat.dmp log=weeklyLdatExp.log tables=(8i.COMPANY,8i.COMNUMBR) rows=y
ORACLE_SID=oracle91
export ORACLE_SID
imp userid=9i/9i file=weeklyLdat.dmp fromuser=8i touser=9i tables=(9i.COMPANY,9i.COMNUMBR)
log=weeklyLdatImp.log rows=y
Any help would be appreciated. Thanks
Michele
|
|
|
|
|