本地oracle建表空间，建表语句

全局数据库

system/sys

Aa123456

 

dlzx帐号：dlzx

dlzx密码：bj601

 

create temporary tablespace dlzx_temp

tempfile 'D:\work_soft\oracle\orcl\dlzx_temp.dbf'

size 50m

autoextend on

next 50m maxsize 2048m

extent management local;

 

create tablespace dlzx_data

logging

datafile 'D:\work_soft\oracle\orcl\dlzx_data.dbf'

size 50m

autoextend on

next 50m maxsize 2048m

extent management local;

 

create user dlzx identified by bj601

default tablespace dlzx_data

temporary tablespace dlzx_temp;

 

grant connect,resource,dba to dlzx;