Oracle em

http://localhost:1158/em/console/logon/logon

修改使用者tuser改用TABLESPACE

ALTER USER "tuser" DEFAULT TABLESPACE "USER01"

增加資料庫空間

ALTER TABLESPACE "USER01" ADD DATAFILE 'c:\Oracle\USER01.DBF' SIZE 30G

增加temp空間

ALTER TABLESPACE "TEMP" ADD TEMPFILE 'c:\Oracle\TEMP02.DBF' SIZE 30G

CREATE TABLE "PUSER"."iis"

( "SDATE" VARCHAR2(20),

"STIME" VARCHAR2(20)

) TABLESPACE "USERS"