- 临时表空间
CREATE TEMPORARY TABLESPACE JKFW_TEMP
TEMPFILE 'D:appAdministratororadataNewDBDB_TEMP.DBF'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
- 表空间
CREATE TABLESPACE DB_DATA
LOGGING
DATAFILE 'D:appAdministratororadataNewDBDB_DATA.DBF'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
- 用户
CREATE USER NEWUSER IDENTIFIED BY BD123
ACCOUNT UNLOCK
DEFAULT TABLESPACE DB_DATA
TEMPORARY TABLESPACE DB_TEMP
- 授权
GRANT CONNECT,RESOURCE TO NEWUSER;
GRANT DBA TO NEWUSER;
网友评论