Powered By Blogger

Wednesday, January 26, 2011

Export into multiple Dump files

It creates 4 dumpfiles each the size of 5 GB.Please check the below script.

exp "'sys/passwd as sysdba'" buffer=314572800 file='\\Serv103\db1_backup\backup_%date:~4,2%_%date:~7,2%_%date:~10%_first.dmp' '\\Serv103\db1_backup\backup_%date:~4,2%_%date:~7,2%_%date:~10%_second.dmp' '\\Serv103\db1_backup\backup_%date:~4,2%_%date:~7,2%_%date:~10%_third.dmp' '\\Serv103\db1_backup\backup_%date:~4,2%_%date:~7,2%_%date:~10%_fourth.dmp'

log=C:\Backup\backup_%date:~4,2%_%date:~7,2%_%date:~10%.log FILESIZE=5GB Full=yes statistics=none

No comments:

Post a Comment