创建日志文件组语句

 CREATE LOGFILE GROUP

CREATE LOGFILE GROUP logfile_group
    ADD UNDOFILE 'undo_file'
    [INITIAL_SIZE [=] initial_size]
    [UNDO_BUFFER_SIZE [=] undo_buffer_size]
    [REDO_BUFFER_SIZE [=] redo_buffer_size]
    [NODEGROUP [=] nodegroup_id]
    [WAIT]
    [COMMENT [=] 'string']
    ENGINE [=] engine_name

 ALTER LOGFILE GROUP

ALTER LOGFILE GROUP logfile_group
    ADD UNDOFILE 'file_name'
    [INITIAL_SIZE [=] size]
    [WAIT]
    ENGINE [=] engine_name

 DROP LOGFILE GROUP

DROP LOGFILE GROUP logfile_group
    ENGINE [=] engine_name

 

posted @ 2020-08-17 05:51  wongchaofan  阅读(259)  评论(0)  编辑  收藏  举报