| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Tablespace
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 mª¿ªm
>
> >>> 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).
 |
 |