查看数据库用户
                            select username, created from dba_users;

7.运行脚本生成数据词典，完成以前创建步骤

                            创建数据词典
                            CATALOG.SQL

                           生成PL/SQL使用的对象
                            CATPROC.SQL
8.维护重演日志文件

                确定归档状态
                select log_mode from v$database;

                 确定自动归档可用
                 select archiver from v$instance;

                 添加新的日志文件组
                 ALTER DATABASE ADD LOGFILE
                (          
                    'c:\data\log3a.rdo',       
                    'e:\data\log3b.rdo'
                ) size 200k;

               查看日志文件信息
                select * from v$log_file;

上一页  [1] [2]