Oracle建立資料表空間和增加資料表空間

標籤：div   datafile   acl   table   lte   app   next   logs   ble   

1.建立資料表空間

create tablespace fgq datafile ‘E:\app\Administrator\oradata\fms\fgq01.dbf‘ size 1000M autoextend on next 1000M maxsize unlimited;

2.資料表空間增加

alter tablespace fgq add datafile ‘E:\app\Administrator\oradata\fms\fgq02.dbf‘ size 1000M autoextend on next 1000M maxsize unlimited;alter tablespace fgq add datafile ‘E:\app\Administrator\oradata\fms\fgq03.dbf‘ size 1000M autoextend on next 1000M maxsize unlimited;alter tablespace fgq add datafile ‘E:\app\Administrator\oradata\fms\fgq04.dbf‘ size 1000M autoextend on next 1000M maxsize unlimited;alter tablespace fgq add datafile ‘E:\app\Administrator\oradata\fms\fgq05.dbf‘ size 1000M autoextend on next 1000M maxsize unlimited;alter tablespace fgq add datafile ‘E:\app\Administrator\oradata\fms\fgq06.dbf‘ size 1000M autoextend on next 1000M maxsize unlimited;

Oracle建立資料表空間和增加資料表空間