mas bowo, seting parameter UNDO_MANAGEMENT=MANUAL sudah bisa nih. kemudian klo udah open, create tempfile, klo di step mas bowo kasih ada alter database add tempfile, maksud nya saya create dengan perintah create tempfile <nama tablespace temp baru> atau add tempfile di tablespace temp yg lama ??
Thanks, On Fri, Apr 9, 2010 at 6:40 AM, yulius_wibowo <[email protected]>wrote: > > > > Bisa dicoba lagi dgn setting parameter: > > UNDO_MANAGEMENT=MANUAL > > bw > > > --- In [email protected] <indo-oracle%40yahoogroups.com>, Andes > Febrian <pejanta...@...> wrote: > > > > output dari statement berikut, > > $ strings system01.dbf | head -100 > > $ strings undo01.dbf | head -100 > > > > [ora...@prod prod]$ strings system01.dbf | head -100 > > }|{z > > L!2|prod > > SYSTEM > > _SYSSMU4$ > > _SYSSMU4$ > > _SYSSMU3$ > > _SYSSMU3$ > > _SYSSMU2$ > > _SYSSMU2$ > > _SYSSMU1$ > > _SYSSMU1$ > > _SYSSMU10$ > > _SYSSMU9$ > > _SYSSMU8$ > > _SYSSMU7$ > > _SYSSMU6$ > > _SYSSMU5$ > > _SYSSMU4$ > > _SYSSMU3$ > > _SYSSMU2$ > > _SYSSMU1$ > > _SYSSMU10$ > > _SYSSMU10$ > > _SYSSMU9$ > > _SYSSMU9$ > > _SYSSMU8$ > > _SYSSMU8$ > > _SYSSMU7$ > > _SYSSMU7$ > > _SYSSMU6$ > > _SYSSMU6$ > > _SYSSMU5$ > > _SYSSMU5$ > > _SYSSMU4$ > > _SYSSMU5$ > > _SYSSMU4$ > > _SYSSMU4$ > > _SYSSMU3$ > > _SYSSMU3$ > > _SYSSMU2$ > > _SYSSMU2$ > > _SYSSMU1$ > > _SYSSMU1$ > > _SYSSMU10$ > > _SYSSMU9$ > > _SYSSMU8$ > > _SYSSMU7$ > > _SYSSMU6$ > > _SYSSMU5$ > > _SYSSMU4$ > > _SYSSMU3$ > > _SYSSMU2$ > > _SYSSMU1$ > > _SYSSMU10$ > > _SYSSMU10$ > > _SYSSMU9$ > > _SYSSMU9$ > > _SYSSMU8$ > > _SYSSMU8$ > > _SYSSMU7$ > > _SYSSMU7$ > > _SYSSMU6$ > > _SYSSMU6$ > > _SYSSMU5$ > > _SYSSMU5$ > > _SYSSMU5$ > > _SYSSMU5$ > > _SYSSMU4$ > > _SYSSMU4$ > > _SYSSMU3$ > > _SYSSMU3$ > > _SYSSMU2$ > > _SYSSMU2$ > > _SYSSMU1$ > > _SYSSMU1$ > > _SYSSMU10$ > > _SYSSMU9$ > > _SYSSMU8$ > > _SYSSMU7$ > > _SYSSMU6$ > > _SYSSMU5$ > > _SYSSMU4$ > > _SYSSMU3$ > > _SYSSMU2$ > > _SYSSMU1$ > > _SYSSMU10$ > > _SYSSMU10$ > > _SYSSMU9$ > > _SYSSMU9$ > > _SYSSMU8$ > > _SYSSMU8$ > > _SYSSMU7$ > > _SYSSMU7$ > > _SYSSMU6$ > > _SYSSMU6$ > > _SYSSMU5$ > > _SYSSMU6$ > > _SYSSMU5$ > > _SYSSMU5$ > > _SYSSMU4$ > > [ora...@prod prod]$ strings undotbs01.dbf |head -100 > > }|{z > > L!2|prod > > UNDOTBS1 > > KZdyKZdyKZdyK > > wTKtwTKtwTK > > JR_GG > > KNxn > > 4...@co > > 4...@xn > > xlxn > > 4...@ic > > _JOxn > > If9xn > > 4...@xn > > 4...@ic > > 4@"T > > "TAxn > > 4@"T > > xnxn > > 4...@-6 > > Spxn > > 4...@22 > > nt xn > > T_Sxn > > 4...@xn > > '5xn > > [email protected] > > 4...@ma > > 8.4xn > > GO.xn > > _MAxn > > 4...@33 > > _SYxn > > ERTxn > > VENxn > > 4...@n > > ysixn > > 4@', > > a...@xn > > 4...@22 > > nt xn > > D_Mxn > > 4...@ah > > 4...@_m > > 4...@o. > > D_Mxn > > D_Mxn > > _Sexn > > vicxn > > 4...@va > > KAHxn > > n1xn > > 4...@tu > > &xn > > 4...@cc > > 1.6xn > > E.Exn > > menxn > > 4...@an > > BKNxn > > 4...@cc > > xnxn > > ( M r > > @YPA > > %':= > > <+>" > > CA5W > > %O=[N > > @YPA > > %':= > > <+>" > > CA5W > > %O=[N > > @YPA > > %':= > > <+>" > > CA5W > > %O=[N > > $^Z( > > @YPA > > $^Z( > > $^Z( > > $^Z( > > $^Z( > > $^Z( > > $^Z( > > %':= > > $^Z( > > $^Z( > > <+>" > > $^Z( > > $^Z( > > $^Z( > > CA5W > > $^Z( > > $^Z( > > $^Z( > > $^Z( > > $^Z( > > $^Z( > > > > Thanks, > > > > 2010/4/8 ora...@... <ora...@...> > > > > > > > > > > > > bisa keluarin output ini? > > > > > > $ strings system01.dbf | head -100 > > > $ strings undo01.dbf | head -100 > > > > > > SQL> oradebug setmypid > > > SQL> oradebug dump file_hdrs 1 > > > SQL> oradebug dump file_hdrs <no_datafile_undo> > > > > > > > > -- > > Best Regards, > > Andes > > > > > > [Non-text portions of this message have been removed] > > > > > -- Best Regards, Andes [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
