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 閱讀(1570)
評論(3) 編輯 收藏 所屬分類:
AJAX