由 macro 发布于: 2001-03-01 19:09

The following sql command shows the database log mode and if the automatic archival is enabled:

SQL> ARCHIVE LOG LIST;
为什么我看到 “ORA-01031: 权限不足”？我是用的 system 和 sys 用户进去看的。

Query the dynamic performance views V$DATABASE and V$INSTANCE to show the database log mod and the archiving mode.

SQL> select name, log_mode
2 from v$database;

NAME LOG_MODE
--------- ------------
EDITOR NOARCHIVELOG


SQL> SELECT archiver FROM v$instance;

ARCHIVE
-------
STOPPED

__________________

谢谢你抽时间看我的发言，

Macro Zeng

==================================

我正在学习 Oracle ,坚持每天写读书笔记