欢迎使用CSDN-markdown编辑器

oracle创建表空间、用户并且赋予权限

• 列表内容

创建表空间

create tablespace DSDB_DSCOC_DATA datafile 'd:\app\DSDB_DSCOC_DATA.dbf' size 64m autoextend on next 10m maxsize unlimited;create tablespace DSDB_GAYQ_DATA datafile 'G:\app\chang\oradata\orcl\DSDB_GAYQ_DATA.dbf' size 64m autoextend on next 10m maxsize unlimited;create tablespace DSDB_TZXX_DATA datafile 'G:\app\chang\oradata\orcl\DSDB_TZXX_DATA.dbf' size 64m autoextend on next 10m maxsize unlimited;create tablespace DSDB_XXBB_DATA datafile 'G:\app\chang\oradata\orcl\DSDB_XXBB_DATA.dbf' size 64m autoextend on next 10m maxsize unlimited;create tablespace DSDB_XXKB_DATA datafile 'G:\app\chang\oradata\orcl\DSDB_XXKB_DATA.dbf' size 64m autoextend on next 10m maxsize unlimited;create tablespace DSDB_YQZB_DATA datafile 'G:\app\chang\oradata\orcl\DSDB_YQZB_DATA.dbf' size 64m autoextend on next 10m maxsize unlimited;

• 创建用户

create user yqdb_hf identified by yqdb_hf default tablespace DSDB_DEFAULT_DATA temporary tablespace temp;grant resource,dba,connect,create any view,create any table,create any index,create any sequence,unlimited tablespace to yqdb_hf;