Windows XP SP2 + Oralce 9i
exp++.bat
1 set sid=portal
2 set username=portal
3 set password=portal
4 set connect=%username%/%password%@%sid%
5 set back_path=D:\oracle
6 set date_string=%date:~0,4%_%date:~5,2%_%date:~8,2%
7 set time_string=%time:~0,2%_%time:~3,2%_%time:~6,2%
8 set file_string=%back_path%\portal_%date_string%_%time_string%
9 exp %connect% buffer=20000000 file=%file_string%.dmp log=exp_%file_string%.log owner=portal
imp++.bat
1 set dmp_source=%1
2 set sid=his
3 set username=his_dba
4 set password=his_dba
5 set connect=%username%/%password%@%sid%
6 set back_path=D:\oracle
7 set date_string=%date:~0,4%_%date:~5,2%_%date:~8,2%
8 set time_string=%time:~0,2%_%time:~3,2%_%time:~6,2%
9 set output_string=%back_path%\portal_%date_string%_%time_string%
10 set source_string=%back_path%\%dmp_source%
11 imp %connect% file=imp_%source_string% log=%output_string%.log FROMUSER=portal
Change CHARACTER SET
1 ALTER DATABASE CHARACTER SET UTF8
2 NLS_CHARACTERSET
3 ZHS16CGB231280
4 ZHS16GBK
5 AL32UTF8
6 UTF8
posted on 2006-08-07 14:10
rox 阅读(1554)
评论(3) 编辑 收藏 所属分类:
AJAX