学习创建表分区的我

最新推荐文章于 2021-07-20 15:34:00 发布

竹禾尹

最新推荐文章于 2021-07-20 15:34:00 发布

阅读量217

点赞数

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