101创建表空间及用户脚本 刘晓杰

CREATE TABLESPACE CMB_BMSD
LOGGING DATAFILE 'D:\oracle\product\10.2.0\oradata\orcl\CMB_BMSD.dbf' SIZE 1024M
autoextend on next 1024M extent management local;

---alter database datafile 'D:\oracle\product\10.2.0\oradata\orcl\CMB_BMSD.dbf' resize 3084M;
---alter database datafile 'D:\oracle\product\10.2.0\oradata\orcl\CMB_BMSD.dbf' autoextend on;
--select file_name from dba_data_files where tablespace_name = 'CMB_BMSD';
--ALTER TABLESPACE CMB_BMSD ADD DATAFILE 'D:\oracle\product\10.2.0\oradata\orcl\CMB_BMSD_5.dbf' SIZE 3084M autoextend on next 1024M ;

create user bcdl_fj
identified by bcdl_fj
default tablespace CMB_BMSD
Temporary TABLESPACE Temp;

grant connect to bcdl_fj;
grant resource to bcdl_fj;

grant create database link to bcdl_fj;
grant create materialized view to bcdl_fj;
grant create procedure to bcdl_fj;
grant create public synonym to bcdl_fj;
grant create role to bcdl_fj;
grant create sequence to bcdl_fj;
grant create synonym to bcdl_fj;
grant create table to bcdl_fj;
grant create trigger to bcdl_fj;
grant create type to bcdl_fj;
grant create view to bcdl_fj;
grant unlimited tablespace to bcdl_fj;
grant dba to bcdl_fj;