When you import with compress=Y it puts all of the data in the table into
one extent. If this is ever going to be a source database for import into
another don't do this!!
RBG
----- Original Message -----
From: "Mahmoud Reza Zare" <mrezair_at_0racledba.com>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Tuesday, October 10, 2000 12:04 PM
Subject: Re: Defragmenting a database
> Yes,
>
> I think it's the only option you have under 8.0.5. You should export it
with COMPRESSION = ON and reimport it. As for indexes you'd better rebuild
them in a separate tablespace to gain performance increase.
>
> Under 8.1.6 you have the option of rebuilding the table rather than exp
and imp.
>
> good luck
> Mahmoud Reza Zare
>
> --- cemail_at_sprintmail.com
> > wrote:
> >
> >Some of our objects have up to 3000 extents and we are starting
> >to have load issues and performance issues. I know that I need
> >to do an export, recreate the object with a larger initial extent
> >and then import the data back in. What do you do about the constraints?
> > I don't want to go to import and then get constraint violations.
> > Do you have to export the offending object and all of the tables
> >related to it and then import them all back in at the same time?
> >
> >Also some of the objects are indexes. This is Oracle 8.0.5 on
> >HPUX. After doing the export/import on the tables would it be
> >easier to just rebuild the indexes with different storage parameters
> >versus dropping and recreating?
> >
> >-----
> >Sent using MailStart.com ( http://MailStart.Com/welcome.html )
> >The FREE way to access your mailbox via any web browser, anywhere!
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author:
> > INET: cemail_at_sprintmail.com
> >
> >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).
>
> _____________________________________________________________
> Be someone_at_0racledba.com - get your free mail from Oriole Corporation
> http://www.oriolecorp.com - Performance tools for Oracle DBAs
>
> Get email for your site ---> http://www.everyone.net
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mahmoud Reza Zare
> INET: mrezair_at_0racledba.com
>
> 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).
Received on Tue Oct 10 2000 - 13:52:57 CDT
