RAC创建表空间、用户、表

On By 去哪儿

主库创建临时表空间

create temporary tablespace orclywja 
	tempfile '+DATADG' 
    size 20m;

创建表空间

create  tablespace ywjadata
	datafile '+DATADG'
	size 100m
	autoextend on next 10m
	permanent online;

创建用户

create user jiaen
    identified by 123
    default tablespace ywjadata
    temporary tablespace TEMP
    profile DEFAULT;
    grant dba to jiaen;

创建表

create table bakup_test
(
    id    NUMBER,
    names NVARCHAR2(20)
)
tablespace ywjadata
    pctfree 10
    initrans 1
    maxtrans 255;

查询

select tablespace_name,file_name from dba_temp_files;