From daemon Sat Dec 30 14:25:16 1995 Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65v3.0/1.1.8.2/01Aug94-0142PM) id AA03310; Sat, 30 Dec 1995 14:25:12 -0500 Message-Id: <9512301925.AA03310@alice.jcc.com> Received: from CCVM.SUNYSB.EDU by ccvm.sunysb.edu (IBM VM SMTP V2R3) with BSMTP id 2755; Fri, 29 Dec 95 12:11:03 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 7714; Fri, 29 Dec 1995 12:10:45 -0500 Date: Fri, 29 Dec 1995 12:06:37 EST Reply-To: "ORACLE database mailing list." Sender: "ORACLE database mailing list." From: "TSAWMILL.US.ORACLE.COM" Subject: Re: Need Help Rebuilding an Index X-To: oracle-l@ccvm.sunysb.edu To: Multiple recipients of list ORACLE-L --Boundary-7578184-0-0 You know, upon further consideration, you don't really need the cold backups since all you are re-creating are indexes. No tables in that tspace, right? Tim Sawmiller tsawmiller@us.oracle.com "I speak for me and no else!" --Boundary-7578184-0-0 Content-Type: message/rfc822 Date: 29 Dec 95 08:18:17 From:"Joe Johnson " To: Multiple,recipients,of,list,ORACLE-L,ORACLE-L@CCVM.SUNYSB.EDU Subject: Need Help Rebuilding an Index Reply-to: ORACLE-L@CCVM.SUNYSB.EDU X-Orcl-Application: Sender: "ORACLE database mailing list." X-To: oracle-l@ccvm.sunysb.edu Hi. I need to rebuild an index on a big table and don't have enough adjacent free space in that tablespace to do it. This tablespace (LGIDX) contains only large (>50MB) indexes. Right now, it contains only 5 objects. These objects are also indexes. The tablespace would be big enough to hold these indexes *plus* the one I'm attempting to rebuild *if* it was not fragmented. Here's what I would like to do: 1. Make a cold backup 2. Create a script to re-build the indexes that already exist in that tablespace. 3. Drop the tablespace using "alter tablespace LGIDX offline drop" 4. Re-create the tablespace using (same size, on same disk drive): SQLDBA> create tablespace LGIDX datafile '/u15/oradata/plgidx001.dbf' size 250M, '/u15/oradata/plgidx002.dbf' size 250M default storage ( initial 10M next 10M minextents 1 maxextents 99 pctincrease 0) online; 5. Re-create the indexes in the newly de-fragmented tablespace using the script I created in #2. 6. Make another cold backup. Will this work? Or should I just add another datafile to the LGIDX tablespace and skip all this extra work? Thanks! Joe Johnson Highland Community College --Boundary-7578184-0-0--