创建与管理Oracle分区表和本地索引的实例解析
作者:IT科技 来源:数据库 浏览: 【大中小】 发布时间:2025-11-05 11:54:03 评论数:
复制SQL> connect eygle/eygle Connected. SQL> CREATE TABLE dbobjs 2 (OBJECT_ID NUMBER NOT NULL,创建 3 OBJECT_NAME varchar2(128), 4 CREATED DATE NOT NULL 5 ) 6 PARTITION BY RANGE (CREATED) 7 (PARTITION dbobjs_06 VALUES LESS THAN (TO_DATE(01/01/2007, DD/MM/YYYY)), 8 PARTITION dbobjs_07 VALUES LESS THAN (TO_DATE(01/01/2008, DD/MM/YYYY))); Table created. SQL> COL segment_name for a20 SQL> COL PARTITION_NAME for a20 SQL> SELECT segment_name, partition_name, tablespace_name 2 FROM dba_segments 3 WHERE segment_name = DBOBJS; SEGMENT_NAME PARTITION_NAME TABLESPACE_NAME -------------------- -------------------- ------------------------------ DBOBJS DBOBJS_06 EYGLE DBOBJS DBOBJS_07 EYGLE 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.