---
title: "增加分区索引"
author: "hotjava"
date: "2008-04-29T11:17:01Z"
tags: []
slug: "untitled"
draft: false
lastmod: "2008-04-29T11:17:01Z"
id: 187942
url: "https://hotjava.iteye.com/blog/187942"
---

create index INDEX_CONNECTOR_DEVICE on CONNECTOR (DEVICE_ID)
local
(
	partition idx_1 tablespace TRMSDATA,

	partition idx_2 tablespace TRMSDATA,

	partition idx_3 tablespace TRMSDATA,

	partition idx_4 tablespace TRMSDATA,

	partition idx_5 tablespace TRMSDATA,

	partition idx_6 tablespace TRMSDATA,

	partition idx_7 tablespace TRMSDATA,

	partition idx_8 tablespace TRMSDATA,

	partition idx_9 tablespace TRMSDATA,

	partition idx_10 tablespace TRMSDATA,

	partition idx_11 tablespace TRMSDATA,
);