oracle建库

create tablespace TS_INTERF_DATA
nologging
datafile '/alidata/server/oracle/oradata/oradb/ts_interf_data01' size 2000M,
'/alidata/server/oracle/oradata/oradb/ts_interf_data02' size 2000M
extent management local uniform size 1m segment space management auto;
create temporary tablespace TS_INTERF_TEMP tempfile '/alidata/server/oracle/oradata/oradb/ts_interf_temp01.dbf' size 1000M ;
create user interf identified by interf default tablespace TS_INTERF_DATA TEMPORARY TABLESPACE TS_INTERF_TEMP;
grant connect to interf;
grant resource to interf;
grant create synonym to interf;
grant create view to interf;



create tablespace TS_CUSTOMER_DATA
nologging
datafile '/alidata/server/oracle/oradata/oradb/ts_customer_data01' size 2000M,
'/alidata/server/oracle/oradata/oradb/ts_customer_data02' size 2000M
extent management local uniform size 1m
segment space management auto;
create temporary tablespace TS_CUSTOMER_TEMP tempfile '/alidata/server/oracle/oradata/oradb/ts_customer_temp01.dbf' size 1000M ;
create user customer identified by customer default tablespace TS_CUSTOMER_DATA TEMPORARY TABLESPACE TS_CUSTOMER_TEMP;
grant connect to customer;
grant resource to customer;
grant create synonym to customer;
grant create view to customer;


DROP TABLESPACE TS_CUST_TEMP INCLUDING CONTENTS AND DATAFILES;