RE: extent management

From: Narender Akula <narender.akula_at_terralinkinternational.com>
Date: Wed, 11 Jul 2001 20:08:07 -0700
Message-ID: <F001.00348392.20010711195604@fatcity.com>

hi hermanto,
Do a export of table and use improt with indexfile option you will get nice initial extent with larger
value.
eg:
imp scott/tiger file=scott.dmp full=y indexfile=tablex.sql

modify the tablex.sql to your needs.
HTH
naren

-----Original Message-----
Sent: Thursday, 12 July 2001 14:45
To: Multiple recipients of list ORACLE-L

Hi gurus,
I have a problem with the table extent.
Actually, the table extent growth too fast. Maybe I set the extent configuration wrong. So, I have to adjust the next extent almost every two months. Now the maxextents value already reach 80 (oracle 7.3). Is there anyone knows about how I should manage the extent of table ? What I have to do if I have reach 121 maxextents value ? Thanks before for your kind advise.

Warm Regards,

Hermanto P
Application Engineer
PT Riau Andalan Pulp And Paper - IT/IS Dept. Phone : (0761) - 95529 Ext. 1147 - 1266
HP : 0812-752-3092
"Our greatest glory is not in never falling but in rising every time we fall"

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Hermanto P
  INET: hermanto_p_at_aprilasia.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Narender Akula
  INET: narender.akula_at_terralinkinternational.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 Wed Jul 11 2001 - 22:08:07 CDT