oracle用哪个用户创建表空间,Oracle用定名创建表空间和用户

Oracle用命名创建表空间和用户

创建临时表空间 :

CREATE TEMPORARY TABLESPACE test_temp

TEMPFILE 'D:\app\Administrator\oradata\orcl\test_temp01.dbf '

SIZE 32M

AUTOEXTEND ON

NEXT 32M MAXSIZE 2048M

EXTENT MANAGEMENT LOCAL;

创建用户表空间:

CREATE TABLESPACE test_data

LOGGING

DATAFILE 'D:\app\Administrator\oradata\orcl\TEST_DATA01.DBF'

SIZE 32M

AUTOEXTEND ON

NEXT 32M MAXSIZE 2048M

EXTENT MANAGEMENT LOCAL;

创建用户并制定表空间:

CREATE USER test_user IDENTIFIED BY 12345

DEFAULT TABLESPACE TEST_DATA

TEMPORARY TABLESPACE TEST_TEMP;

给用户赋予权限：

Grant connect,resource,dba to test_user;