Migration

#Call external bat (do not use cmd /c) and substring in bat file 

1
2
3
4
5
6
7
8
9
call C:\Production_ATV_Windows_LD\ATV.bat -L > filename.txt

FOR /F "tokens=2 delims=][" %%i in (filename.txt) do set today=%%i

call C:\Production_ATV_Windows_LD\ATV.bat -DD -FilePre %today% -Overwrite

rem set today=PPSC140429
set today=%today:~0,10% 
#Export/Import data from oracle 9i to oracle11g
  • export NLS_LANG=TRADITIONAL CHINESE_HONG KONG.AL32UTF8
  • export schema : exp usr/passwd@uatrac file=db.dmp ROWS=N log=db.log
  • edit db.dmp and change tablespace from ABC to XYZ
  • import schema : imp usr/passwd@prdrac file=db.dmp log=db.log
  • export data : exp usr/passwd@uatrac tables=ABC file=db.dmp INDEXES=N CONSTRAINTS=N GRANTS=N ROWS=Y log=db.log
  • disable insert triggers
  • import data : imp usr/passwd@prdrac file=data.dmp IGNORE=Y INDEXES=N CONSTRAINTS=N GRANTS=N ROWS=Y fromUser=abc toUser=xyz commit=y buffer=1024000 log=db.log