ä¸ã设置Linuxçµèå符éï¼ä½¿å
¶è·çµèä¸çOracleæ°æ®åºå符éä¸è´ï¼
å¨Linuxå½ä»¤è¡çé¢ï¼
æ¥è¯¢Oracleæ°æ®åºå符éï¼
select * from nls_database_parameters t where t.parameter=âNLS_CHARACTERSETâ;
æ¥è¯¢ç»æï¼ZHS16CGB231280
ç¶åvi /home/oracle/.bash_profile
export NLS_LANG=american_america.ZHS16CGB231280
source /home/oracle/.bash_profile
äºã导åºå±äºwcallç¨æ·çOracleæ°æ®åº
exp wcall/wcall@eoss file=wcall.dmp owner=wcall; //导åºæ°æ®åº
ä¸ãå¨Windowsä¸å®è£
Oracle.10g.for.Windowsï¼ï¼ç¤ºä¾ä¸æ°æ®åºå®è£
å¨Dçï¼å¦ææç
§å¨å
¶ä»ç£çï¼ä¸é¢å建表空é´çæ¶åï¼éè¦åç¸åºçä¿®æ¹ï¼ç¶åå建æ°æ®åºeossï¼æ³¨æå®è£
çæ°æ®åºå符éè¦è·åæ¥æ°æ®åºçç¸åãç¶åæå¼SQLPLUSï¼ç¨systemå¸æ·ç»éåå建ç¨æ·wcallã
create user wcall identified by wcall; //å建ç¨æ·
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE SESSION TO wcall; //æäºæé
create tablespace CC_CALL
logging
datafile 'D:\oracle\product\10.1.0\Db_1\cc.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local; //å建表空é´CC_CALL
create tablespace CC_CALL_HIS
logging
datafile 'D:\oracle\product\10.1.0\Db_1\cc_his.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local; //å建表空é´CC_CALL_HIS
åã导å
¥æ°æ®åº
IMP wcall/wcall@eoss fromuser=wcall touser=wcall file=wcall.dmp STATISTICS =none;
温馨提示:答案为网友推荐,仅供参考