首页 > 代码库 > 创建表空间

创建表空间

CREATE TABLESPACE dna36 DATAFILE ‘D:\oracle\oradata\orcl\dna36.dbf‘ SIZE 100M AUTOEXTEND ON NEXT 10M maxsize unlimited;
CREATE USER dna36 IDENTIFIED BY dna36 DEFAULT TABLESPACE dna36;
GRANT CONNECT, RESOURCE, CREATE VIEW TO dna36;
GRANT dba TO dna36;