Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Tablespace

Re: Tablespace

From: Ioana Bunea <ioanabunea_at_hotmail.com>
Date: Wed, 27 Dec 2000 09:49:42 -0600
Message-Id: <10723.125359@fatcity.com>


liked this:

http://www.orapub.com//exec//genesis.cgi?p1=sub&p2=abs121

>From: "Ron Rogers" <RROGERS_at_galottery.org>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Tablespace
>Date: Wed, 27 Dec 2000 06:00:28 -0800
>
>Kevin,
>The defrag of a tablespace is not easy. I do not know about 8.1.6 but on 7x
>you should have plenty of time on the server with no access by users. The
>steps I have used is to:
>TAKE A BACKUP OF YOUR DATABASE!!!!!
>1. list all of the tables in the tablespace including their size
>requirements.
>2. export all of the listed tables.
>3. drop the tables from the tablespace and coalesce the tablespace.
>4. recreate the tables trying to use uniform extent sizes.
>5. import the table data.
>6. check grants, synonyms, views, packages that used the tables.
>It takes time and accuracy......
>ROR mm
>
> >>> kevin_at_dulcian.com 12/22/00 03:51PM >>>
>RE: How much beer should a DBA consume? (Lots)Hi all,
> Does anybody here know how to defrag a tablespace? Because I do not
>even hava a clue? Thanks in advance.
>Oracle 8.1.6 DB
>
>Kevin Kostyszyn
>Dulcian, Inc
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ron Rogers
> INET: RROGERS_at_galottery.org
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).



Get your FREE download of MSN Explorer at http://explorer.msn.com Received on Wed Dec 27 2000 - 09:49:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US