utk redolog gak bisa diubah sizenya.
Harus didrop dan recreate ulang.
Sebelum di-drop, pastikan status di v$log tidak ACTIVE
atau CURRENT (dgn cara: alter system archive log
current).
Lalu drop
alter database drop logfile group x;
lalu recreate
alter database add logfile group x ('file1','file2');
regards,
tomi
--- Reka Sukamto <[EMAIL PROTECTED]> wrote:
> Dear All
>
> Mohon bantuannya ,
>
> Gmn syntax untuk merubah logfile? Udh dicoba dengan
> syntax berikut tp masih
> erorr
>
> alter database orc1
> drop logfile group MEMBER
> 'D:\ORANT\DATABASE\LOG3ORC1.ORA';
>
> alter database orc1
> drop logfile group 'D:\ORANT\DATABASE\LOG3ORC1.ORA';
>
> Saya menggunakan DB 8.0.5 dan OS win NT
> Mohon penjelasanya, terima kasih
>
>
> Reka
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
Mirror: http://indooracle.wordpress.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.blogspot.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/
