分区数据库表空间要建在分区组中啊,先建分区组,再建表空间CREATE DATABASE PARTITION GROUP "NG_ALL" ON DBPARTITIONNUMS (0, &nbs...
显示全部分区数据库表空间要建在分区组中啊,先建分区组,再建表空间
CREATE DATABASE PARTITION GROUP "NG_ALL" ON DBPARTITIONNUMS
(0,
1,
2,
3,
4,
5,
6,
7);
CREATE USER TEMPORARY TABLESPACE "USERSPACE" IN DATABASE PARTITION GROUP NG_ALL PAGESIZE 16384 MANAGED BY DATABASE
USING (DEVICE '/dev/rtbs_user_16g_00' 1179584) ON DBPARTITIONNUMS (0)
USING (DEVICE '/dev/rtbs_user_16g_10' 1179584) ON DBPARTITIONNUMS (1)
USING (DEVICE '/dev/rtbs_user_16g_20' 1179584) ON DBPARTITIONNUMS (2)
USING (DEVICE '/dev/rtbs_user_16g_30' 1179584) ON DBPARTITIONNUMS (3)
USING (DEVICE '/dev/rtbs_user_16g_40' 1179584) ON DBPARTITIONNUMS (4)
USING (DEVICE '/dev/rtbs_user_16g_50' 1179584) ON DBPARTITIONNUMS (5)
USING (DEVICE '/dev/rtbs_user_16g_60' 1179584) ON DBPARTITIONNUMS (6)
USING (DEVICE '/dev/rtbs_user_16g_70' 1179584) ON DBPARTITIONNUMS (7)
EXTENTSIZE 16
PREFETCHSIZE 16
BUFFERPOOL BP16
OVERHEAD 10.500000
TRANSFERRATE 0.140000
FILE SYSTEM CACHING
DROPPED TABLE RECOVERY OFF;
CREATE TEMPORARY TABLESPACE "TEMPSPACE" IN DATABASE PARTITION GROUP NG_ALL PAGESIZE 16384 MANAGED BY DATABASE
USING (DEVICE '/dev/rtbs_sys_16g_00' 1179584) ON DBPARTITIONNUMS (0)
USING (DEVICE '/dev/rtbs_sys_16g_10' 1179584) ON DBPARTITIONNUMS (1)
USING (DEVICE '/dev/rtbs_sys_16g_20' 1179584) ON DBPARTITIONNUMS (2)
USING (DEVICE '/dev/rtbs_sys_16g_30' 1179584) ON DBPARTITIONNUMS (3)
USING (DEVICE '/dev/rtbs_sys_16g_40' 1179584) ON DBPARTITIONNUMS (4)
USING (DEVICE '/dev/rtbs_sys_16g_50' 1179584) ON DBPARTITIONNUMS (5)
USING (DEVICE '/dev/rtbs_sys_16g_60' 1179584) ON DBPARTITIONNUMS (6)
USING (DEVICE '/dev/rtbs_sys_16g_70' 1179584) ON DBPARTITIONNUMS (7)
EXTENTSIZE 16
PREFETCHSIZE 128
BUFFERPOOL BP16
OVERHEAD 10.500000
TRANSFERRATE 0.140000
FILE SYSTEM CACHING
DROPPED TABLE RECOVERY OFF;
收起