2010年
-
编辑 删除
Oracle数据库创建表空间与用户
CREATE TABLESPACE "QONEYILONG" LOGGING DATAFILE 'G:oracleproduct10.2.0oradataqoneyilongqoneyilong.ora' SIZE 500M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; CREATE temporary tablespace "QONEYILONG_TEMP" tempfile 'G:oracleproduct10.2.0oradataqoneyilongqoneyilong_temp.ora' SIZE 100M EXTENT MANAGEMENT LOCAL; create user root identified by root default tablespace qone temporary tablespace qone_temp; grant dba to root; grant connect,resource,create view to root; GRANT
