Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> How to find exact value to resize a datafile
> 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