Q:ALL_PART_COL_STATISTICS ??

From: agichen <agiNOagSPAM_at_feib.com.tw.invalid>
Date: Fri, 07 Jan 2000 01:41:15 -0800
Message-ID: <026faffc.c7ff0dff@usw-ex0102-016.remarq.com>

Hello,there

    I create a partition table mgt like follows     CREATE TABLE mgt
 (

  txday                      DATE NOT NULL,
  userkind                   NUMBER(2),
  userdpt                    VARCHAR2(8),
  userid                     VARCHAR2(20),
  trmkind                    NUMBER(2),
  trmtyp                     NUMBER(2),
  trmadr                     VARCHAR2(20))

PARTITION BY RANGE (txday)

   (
     PARTITION mgt_p01 VALUES LESS THAN (TO_DATE(' 1998-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'))

       PCTFREE    10
       PCTUSED    40
       INITRANS   1
       MAXTRANS   255
       STORAGE   (
         INITIAL     52428800
         NEXT        52428800
         PCTINCREASE 0
         MINEXTENTS  1
         MAXEXTENTS  1017


       )


       TABLESPACE data1,
     PARTITION mgt_p02 VALUES LESS THAN (TO_DATE(' 1998-03-01
00:00:00', 'SYYYY-MM-DD HH24:MI:SS'))
       PCTFREE    10
       PCTUSED    40
       INITRANS   1
       MAXTRANS   255
       STORAGE   (
         INITIAL     52428800
         NEXT        52428800
         PCTINCREASE 0
         MINEXTENTS  1
         MAXEXTENTS  1017


       )


       TABLESPACE data2..... )

  Now,I want to get the script from dictionary, I query the   ALL_PART_COL_STATISTICS,the high_value, low_value are raw type   How to get the create table script that I ran before ???

  Query ALL_PART_COL_STATISTICS right ??   Any hints ??

Rgds,
Agi

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!

Received on Fri Jan 07 2000 - 03:41:15 CST