Mas bowo, sudah berhasil deng, saya sudah bisa export data yg di perlukan. terima kasih banyak atas bantuan nya.
oh ya nanya lagi, bila saya running dengan database yg baru aja di start ini dengan kondisi database yg bermasalah tersebut (tp skrg sudah up) gimana mas bowo ? lebih baik saya install ulang database kemudian export hasil dmp atau running dengan database yg ada aja ? dan undo management harus di balikkan kembali ke parameter auto atau tidak usah ? karena sepertinya undo tbs bermasalah/corrupt ? atau saya harus create tablespace undo lagi ?? many thanks for your help. On Fri, Apr 9, 2010 at 11:29 AM, Andes Febrian <[email protected]> wrote: > 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 > -- 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/
