imp, exp backup through window batch file
438932May 3 2010 — edited May 3 2010Hi all,
I have a simple backup script in window XP batch file.
exp hr/hr file=c:\dumpfiles\hr.dmp owner=hr
sqlplus sys/sys as sysdba @C:\Backup\hr.sql
c:\imp system/sys file=c:\dumpfiles\hr.dmp fromuser=hr touser=hr ingore=yes
The first two line are executed successfully but after 2nd line execution the curson is stop on "sqlplus>". Anybody knows how I change this script so that all the three operations (export, sql script, import) will be performed.
Any help would be appreciated.
Regards,