ALTER INDEX WTS_PK REBUILD TABLESPACE OTCM_IDX PCTFREE 10 STORAGE (
INITIAL 1M NEXT 1M PCTINCREASE 0 ) ;
HTH,
Beth
-----Original Message-----
From: j f [mailto:[Email Address Removed]
Sent: Thursday, August 29, 2002 1:51 PM
To: LazyDBA.com Discussion
Subject: RE: rebuilding primary index
Do you know what the syntax would be for this table/primary key?
CREATE TABLE WKLY_TRD_SM (
MKT_CLASS_CD VARCHAR2 (6),
ISSUE_INTRL_ID VARCHAR2 (18),
TRADE_DT DATE,
MP_ID VARCHAR2 (5),
ISSUE_SYM_ID VARCHAR2 (14) NOT NULL,
MP_IND CHAR (1),
HIGH_WHLSL_SELL_PR NUMBER (18,8) NOT NULL,
LOW_WHLSL_BUY_PR NUMBER (18,8) NOT NULL,
HIGH_RTL_SELL_PR NUMBER (18,8) NOT NULL,
LOW_RTL_BUY_PR NUMBER (18,8) NOT NULL,
TOTAL_BUY_VOL NUMBER (11) NOT NULL,
TOTAL_BUY_VOL_PT NUMBER (6,2) NOT NULL,
TOTAL_BUY_RANK NUMBER (3) NOT NULL,
TOTAL_RTL_BUY_VOL NUMBER (11) NOT NULL,
TOTAL_BUY_TRANS NUMBER (11) NOT NULL,
TOTAL_BUY_TRANS_PCT NUMBER (6,2) NOT NULL,
TOTAL_BUY_TRANS_RANK NUMBER (3) NOT NULL,
TOTAL_SELL_VOL NUMBER (11) NOT NULL,
TOTAL_SELL_VOL_PT NUMBER (6,2) NOT NULL,
TOTAL_SELL_RANK NUMBER (3) NOT NULL,
TOTAL_RTL_SELL_VOL NUMBER (11) NOT NULL,
MU_PT NUMBER (23,8) NOT NULL,
MU_PROFIT NUMBER (23,8) NOT NULL,
MU_SPRD NUMBER (18,8),
MD_PT NUMBER (23,8) NOT NULL,
MD_PROFIT NUMBER (23,8) NOT NULL,
MD_SPRD NUMBER (18,8),
TOTAL_SELL_TRANS NUMBER (11) NOT NULL,
TOTAL_SELL_TRANS_PCT NUMBER (6,2) NOT NULL,
TOTAL_SELL_TRANS_RANK NUMBER (3) NOT NULL,
CONSTRAINT WTS_PK
PRIMARY KEY ( ISSUE_INTRL_ID, TRADE_DT, MP_ID, MKT_CLASS_CD )
USING INDEX
TABLESPACE OTCM_IDX PCTFREE 10
STORAGE ( INITIAL 1048576 NEXT 20971520 PCTINCREASE 0 ))
TABLESPACE OTCMDATA NOLOGGING
PCTFREE 5
PCTUSED 90
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1048576
NEXT 209223680
PCTINCREASE 0
MINEXTENTS 10
MAXEXTENTS 2147483645
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE;
Thanks.
Jerry
>From: "Kerber, Andrew . MS-AK" <[Email Address Removed] 'j f' <[Email Address Removed] "LazyDBA. com Discussion (E-mail)" <[Email Address Removed] RE: rebuilding primary index
>Date: Thu, 29 Aug 2002 12:39:51 -0500
>
>Rebuild with a storage clause.
>
>-----Original Message-----
>From: j f [mailto:[Email Address Removed] Thursday, August 29, 2002 12:44 PM
>To: LazyDBA.com Discussion
>Subject: rebuilding primary index
>
>
>I want to rebuilt and move the primary key to another tablespace.
>
>Do I need to delete and recreate it, or can I simply rebuilt it with a
>storage clause?
>
>Same thing for other indexes.
>
>Thanks.
>
>Jerry
>
>
>
>_________________________________________________________________
>MSN Photos is the easiest way to share and print your photos:
>http://photos.msn.com/support/worldwide.aspx
>
>
>--------
>Oracle documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page