学习创建表分区的我

o(￣ヘ￣o#)


alter database cwbasem872 add filegroup ByIdGroup1


alter database cwbasem872 add filegroup ByIdGroup2


alter database cwbasem872 add filegroup ByIdGroup3




alter database cwbasem872 add filegroup ByIdGroup4




alter database cwbasem872 add filegroup ByIdGroup5




alter database cwbasem872 add filegroup ByIdGroup6


alter database cwbasem872 add filegroup ByIdGroup7




alter database cwbasem872 add filegroup ByIdGroup8




alter database cwbasem872 add filegroup ByIdGroup9




alter database cwbasem872 add filegroup ByIdGroup10

上面是文件组

下面是文件

alter database cwbasem872 add file 
(name=N'ById1',filename=N'G:\ora\数据库\data\ById1.ndf',size=5Mb,filegrowth=5mb)--要在ora下建文件夹  数据库\data
to filegroup ByIdGroup1


alter database cwbasem872 add file 
(name=N'ById2',filename=N'G:\ora\数据库\data\ById2.ndf',size=5Mb,filegrowth=5mb)--要在ora下建文件夹  数据库\data
to filegroup ByIdGroup2




alter database cwbasem872 add file 
(name=N'ById3',filename=N'G:\ora\数据库\data\ById3.ndf',size=5Mb,filegrowth=5mb)--要在ora下建文件夹  数据库\data
to filegroup ByIdGroup3




alter database cwbasem872 add file 
(name=N'ById4',filename=N'G:\ora\数据库\data\ById4.ndf',size=5Mb,filegrowth=5mb)--要在ora下建文件夹  数据库\data
to filegroup ByIdGroup4


alter database cwbasem872 add file 
(name=N'ById5',filename=N'G:\ora\数据库\data\ById5.ndf',size=5Mb,filegrowth=5mb)--要在ora下建文件夹  数据库\data
to filegroup ByIdGroup5


alter database cwbasem872 add file 
(name=N'ById6',filename=N'G:\ora\数据库\data\ById6.ndf',size=5Mb,filegrowth=5mb)--要在ora下建文件夹  数据库\data
to filegroup ByIdGroup6


alter database cwbasem872 add file 
(name=N'ById7',filename=N'G:\ora\数据库\data\ById7.ndf',size=5Mb,filegrowth=5mb)--要在ora下建文件夹  数据库\data
to filegroup ByIdGroup7


alter database cwbasem872 add file 
(name=N'ById8',filename=N'G:\ora\数据库\data\ById8.ndf',size=5Mb,filegrowth=5mb)--要在ora下建文件夹  数据库\data
to filegroup ByIdGroup8


alter database cwbasem872 add file 
(name=N'ById9',filename=N'G:\ora\数据库\data\ById9.ndf',size=5Mb,filegrowth=5mb)--要在ora下建文件夹  数据库\data
to filegroup ByIdGroup9


alter database cwbasem872 add file 
(name=N'ById10',filename=N'G:\ora\数据库\data\ById10.ndf',size=5Mb,filegrowth=5mb)--要在ora下建文件夹  数据库\data
to filegroup ByIdGroup10







地址:
http://www.cnblogs.com/knowledgesea/p/3696912.html