> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
