| 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: decrease initial extent
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C3B9DC.A32B1840"
------_=_NextPart_001_01C3B9DC.A32B1840
Content-Type: text/plain;
charset="windows-1255"
alter table <tbl_name> deallocate unused keep 1;
Alex.
-----Original Message-----
Sent: Wednesday, December 03, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L
Is there any way to decrease the initial extent allocated to a table. It is one of the system tables, so I do not want to drop and recreate it. I can not export/import as it appear in noexp$. It has long field so I can not do alter table move.
Yechiel Adar
Mehish
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: adar76_at_inter.net.il Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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). ------_=_NextPart_001_01C3B9DC.A32B1840 Content-Type: text/html; charset="windows-1255" Content-Transfer-Encoding: quoted-printableReceived on Wed Dec 03 2003 - 14:34:25 CST
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dwindows-1255">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>RE: decrease initial extent</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>alter table <tbl_name> deallocate unused keep =
1;</FONT>
</P>
<P><FONT SIZE=3D2>Alex.</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Yechiel Adar [<A =
HREF=3D"mailto:adar76_at_inter.net.il">mailto:adar76_at_inter.net.il</A>] =
</FONT>
<BR><FONT SIZE=3D2>Sent: Wednesday, December 03, 2003 10:09 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: decrease initial extent</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Is there any way to decrease the initial extent =
allocated to a table. It is one of the system tables, so I do not want = to drop and recreate it. I can not export/import as it appear in = noexp$. It has long field so I can not do alter table move.</FONT></P>
<P><FONT SIZE=3D2>Yechiel Adar</FONT>
<BR><FONT SIZE=3D2>Mehish</FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.net" = TARGET=3D"_blank">http://www.orafaq.net</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Yechiel Adar</FONT>
<BR><FONT SIZE=3D2> INET: adar76_at_inter.net.il</FONT>
</P>
<P><FONT SIZE=3D2>Fat City Network Services -- =
858-538-5051 <A HREF=3D"http://www.fatcity.com" = TARGET=3D"_blank">http://www.fatcity.com</A></FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Mailing list = and web hosting services</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= ------</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>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).</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01C3B9DC.A32B1840-- ------=_NextPartTM-000-b097a259-7ac6-46e4-8739-a5725f9612d9-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Alexander.Feinstein_at_mitchell1.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
 |
 |