建立临时表空间
CREATE TEMPORARY TABLESPACE TEMPSPACE_SUP
TEMPFILE 'D:\worktool\tablespaces\TEMPSPACE_SUP.dbf'
SIZE 32m
AUTOEXTEND ON
NEXT 32m MAXSIZE 2048m
EXTENT MANAGEMENT LOCAL;
建立表空间
CREATE TABLESPACE TABLESPACE_SUP
LOGGING
DATAFILE 'E:\work\database\TABLESPACE_SUP.dbf'
SIZE 32m
AUTOEXTEND ON
NEXT 32m MAXSIZE 2048m
EXTENT MANAGEMENT LOCAL;
修改表空间
ALTER TABLESPACE TABLESPACE_CZ
ADD DATAFILE 'D:\worktool\tablespaces\TABLESPACE_CZ02.dbf' SIZE 32m
AUTOEXTEND ON
NEXT 32m MAXSIZE 2048m
创建帐户
CREATE USER sup IDENTIFIED BY sup
DEFAULT TABLESPACE SUP
TEMPORARY TABLESPACE TEMPSPACE_CZ;