Listen Software解决方案 “How To” 系列4:创建数据库

Listen Software解决方案 “How To” 系列4:创建数据库(5)                             select status, instance from v$thread;

                            查看数据文件
                            select name from v$datafile;

                            查看日志文件
                            select member from v$logfile;

                            查看控制文件
                            select name from v$controlfile;

                             检验系统创建状态
                            select file_name from dba_data_files
                            where tablespace_name='SYSTEM';

                            查看数据库用户