■表空间建立步骤
sqlplus system/system
sqlplus USER111/USER111
■表空间作成(TEMPORARY)
CREATE TABLESPACE TEMPORARY
DATAFILE 'C:\app\Administrator\oradata\orcl\temporary.dbf' size 1000M
AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
■表空间作成(TABLESPACE111)
CREATE TABLESPACE TABLESPACE111
DATAFILE 'C:\app\Administrator\oradata\orcl\TABLESPACE111_data01.dbf' size 1000M
AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
■表空间作成(TABLESPACE111_I)
CREATE TABLESPACE TABLESPACE111_I
DATAFILE 'C:\app\Administrator\oradata\orcl\TABLESPACE111_I_data01.dbf' size 1000M
AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
■data文件确认
select * from dba_tablespaces;
■表空间确认
select * from dba_data_files;
■表空间を削除
--(例)表空间(表空间名:test_tbs)を削除する。
DROP TABLESPACE test_tbs INCLUDING CONTENTS
AND DATAFILES CASCADE CONSTRAINTS
;
■用户建立步骤
CREATE USER USER111
IDENTIFIED BY USER111
DEFAULT TABLESPACE TABLESPACE111
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
/
GRANT CONNECT TO USER111
/
GRANT RESOURCE TO USER111
/
GRANT CREATE VIEW TO USER111
/
GRANT UNLIMITED TABLESPACE TO USER111
/