传送门004

CREATE TEMPORARY TABLESPACE sjzwz_temp TEMPFILE 'd:\app\Administrator\oradata\slwzsj\sjzwz_temp.dbf' SIZE 1000m AUTOEXTEND ON NEXT 100M MAXSIZE 10g

create tablespace sjzwz_data datafile 'd:\app\Administrator\oradata\slwzsj\sjzwz_data.dbf' size 1000m reuse autoextend on next 100m MAXSIZE 15g

create tablespace sjzwz_data_tb datafile 'd:\app\Administrator\oradata\slwzsj\sjzwz_data_tb.dbf' size 1000m reuse autoextend on next 100m MAXSIZE 15g
create tablespace sjzwz_data_lob datafile 'd:\app\Administrator\oradata\slwzsj\sjzwz_data_lob01.dbf' size 1000m reuse autoextend on next 100m MAXSIZE 15g
ALTER tablespace sjzwz_data_lob add datafile 'd:\app\Administrator\oradata\slwzsj\sjzwz_data_lob02.dbf' size 1000m reuse autoextend on next 100m MAXSIZE 15g
ALTER tablespace sjzwz_data_lob add datafile 'd:\app\Administrator\oradata\slwzsj\sjzwz_data_lob02.dbf' size 1000m reuse autoextend on next 100m MAXSIZE 15g
ALTER tablespace sjzwz_data_lob add datafile 'd:\app\Administrator\oradata\slwzsj\sjzwz_data_lob03.dbf' size 1000m reuse autoextend on next 100m MAXSIZE 15g

 

posted on 2019-10-30 11:45  翀翀与兜兜!qaz  阅读(79)  评论(0)    收藏  举报