thanks guys responnya... kemarin habis ngirim mail, sambil nunggu acc moderator, sempet jg nanya2 ama temen yg lebih senior. mirip ama solusinya mas Bowo, beda dikit.
sy make OEM (oracle enterprise manager), offline kan TS, pindah file pake explorer, ganti lokasi datafile TS di OEM, online-kan lagi, beres. walo masih di server2an, belum beneran :D. besok sabtu mungkin baru bisa ketemu server yg beneran. scriptnya dari OEM, sy copy, +- begini : ALTER TABLESPACE "MYTS" OFFLINE NORMAL; ** jalankan pindah data file dari explorer.... ALTER DATABASE RENAME FILE 'C:\ORACLE\ORADATA\MYDATA\MYTS_1.ORA' TO 'D:\ORACLE\ORADATA\MYDATA\MYTS_1.ORA'; ALTER DATABASE RENAME FILE 'C:\ORACLE\ORADATA\MYDATA\MYTS_2.ORA' TO 'D:\ORACLE\ORADATA\MYDATA\MYTS_2.ORA'; ALTER TABLESPACE "MYTS" ONLINE; selesai... database nya g perlu dimatikan dulu. kalo offline, sptnya udah gak dilock kok. (CMIIW) learn something, baru tahu cara login as sysdba. selama ini make : sqlplus sys/[EMAIL PROTECTED] as sysdba -> ??? he he..., ternyata begitu to caranya?? pake /nolog thanks all... salam, huda -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> 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/
