Oracle筆記 = =

Oracle 建立 Tablespace

create tablespace dbf
datafile '/home/app/path/to/dbf/dbfname.dbf'
size 800M
autoextend on
next 50M
maxsize UNLIMITED;

sqlplus 使用description登入(一定要是單引號 雙引號就ｇｇ了)

sqlplus user_id/p@ssw0rd'(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.123)(PORT=1521))(CONNECT_DATA=(SID=sid)(SERVER=dedicated)))'

設定能夠讀取中文日期格式

alter session set NLS_DATE_LANGUAGE = 'Traditional Chinese'