創建用戶
//創建用戶名
create user username identified by password‘’
//賦權限
Grant Connect,Resource,DBA to UserName;
plsql developer配置
下載地址
http://ah1.down.chinaz.com/201011/plsql8.04cn.zip
右擊"我的電腦" - "屬性" - "高級" - "環境變量" - "系統環境變量":
1>.選擇"Path" - 點擊"編輯", 把 "D:\Oracle\app\YM\product\instantclient_11_2;" 加入;
2>.點擊"新建", 變量名設置為"TNS_ADMIN", 變量值設置為"D:\Oracle\app\YM\product\instantclient_11_2;", 點擊"確定";
3>.點擊"新建", 變量名設置為"NLS_LANG", 變量值設置為"SIMPLIFIED CHINESE_CHINA.ZHS16GBK", 點擊"確定";
NLS_LANG若是UTF-8的話則改：AMERICAN_AMERICA.UTF8
...)
