Tuesday, August 2, 2011
Automatic Backup
http://www.oracle-base.com/articles/10g/OracleDataPump10g.php
batch file for automatic dataexporter.
echo off
set baseDir=c:\backup\
set vDirName=%date:~0,2%%date:~3,2%%date:~6,4%
set vDumpFileName=%vDirName%-%time:~0,2%-%time:~3,2%-%time:~6,2%
set backupDir=%baseDir%%vDirName%
mkdir %backupDir%
echo direcotr create Date:%baseDir%%vDirName%
echo %vDumpFileName%
expdp scott/naveed schemas=SCOTT directory=TEST_DIR dumpfile=%vDumpFileName%.DMP logfile=%vDumpFileName%.log
move c:\backup\%vDumpFileName%.log c:\backup\%vDirName%
move c:\backup\%vDumpFileName%.DMP c:\backup\%vDirName%
echo successfuly moved.
batch file for automatic dataexporter.
echo off
set baseDir=c:\backup\
set vDirName=%date:~0,2%%date:~3,2%%date:~6,4%
set vDumpFileName=%vDirName%-%time:~0,2%-%time:~3,2%-%time:~6,2%
set backupDir=%baseDir%%vDirName%
mkdir %backupDir%
echo direcotr create Date:%baseDir%%vDirName%
echo %vDumpFileName%
expdp scott/naveed schemas=SCOTT directory=TEST_DIR dumpfile=%vDumpFileName%.DMP logfile=%vDumpFileName%.log
move c:\backup\%vDumpFileName%.log c:\backup\%vDirName%
move c:\backup\%vDumpFileName%.DMP c:\backup\%vDirName%
echo successfuly moved.
Tuesday, December 14, 2010
How to aviod locks
Declareis_locked boolean := false;dummy VARCHAR2(2);BeginBeginSelect null INTO dummy from mytablewhere rowid = :myblock.rowidfor update nowait;exception when Others thenIf sqlcode = -00054 Thenis_locked := True;End If; end;IF is_locked thenShowmessage('Another user is updating this record. Try again later.');raise form_trigger_failure;ElseLOCK_RECORD;If Not Form_success ThenRAISE form_trigger_failure;End If;End if;End;
http://forums.oracle.com/forums/thread.jspa?threadID=322077
http://forums.oracle.com/forums/thread.jspa?threadID=322077
Subscribe to:
Posts (Atom)
