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

Home -> Community -> Mailing Lists -> Oracle-L -> How to find exact value to resize a datafile

How to find exact value to resize a datafile

From: Hermanto P <hermanto_p_at_aprilasia.com>
Date: Wed, 08 Aug 2001 20:29:51 -0700
Message-ID: <F001.003655A5.20010808203544@fatcity.com>

> Hi gurus,
> Please help me to find out the quickest way regarding finding the exact
> value to resize a datafile.
> It comes from an errror :
>
> *** PROGRAM-VERSION
> -- 011
> --
> -- LINE ACCESS RESULT FILE KEY
> -- 7384 READ-NO FOUND MSF010 SC C1
> -- 8063 STARTGE FOUND MSF710 DT-20 20010727 W
> -- 8063 READNXT FOUND MSF710 DT-20 20010727 W001
> -- 8063 READNXT FOUND MSF710 DT-20 20010727 W002
> -- 8063 READNXT NOT FOUND MSF710 DT-20 20010727 W002
> -- 8063 ENDBR-F MSF710 DT-20 20010727 W002
> -- 8091 STARTGE FOUND MSF064 3K8MPHE 00018602
> -- 8091 READNXT FOUND MSF064 3K8MRAPP000000180018M3K71220
> 19950410
> -- 8091 ENDBR-F MSF064 3K8MRAPP000000180018M3K71220
> 19950410
> -- 7992 WRITE-H MSF710 DT-20 20010727 W003
> -- LAST SQL ERROR WAS:+1654 SQL WARNING FLAGS:<********> SQL MESSAGE:
> -- ORA-01654:MIMSPROD.MSF71001IX0 by 1000 in tablespace M3013S_IDXMSF700
> -- Os Return Code 1654 Function:$UNDEFINED$=DEIBFN
> -- TP Return Code 6 Text:OTHER..,
>
> Actually I try the solution like this :
> - find out the next extent for the segment.
> select next_extent from dba_segments
> - resize it.
>
> Any comments or correction about this ??
> Thanks for your advise.
>
> Warm Regards,
>
> Hermanto P
> Application Engineer
> PT Riau Andalan Pulp And Paper - IT/IS Dept.
> Phone : (0761) - 491147 / 491354
> HP : 0812-752-3092
> "Dream as if you'll live forever, live as if you'll die today"
>
>
>

-- 
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).
Received on Wed Aug 08 2001 - 22:29:51 CDT

Original text of this message

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