oracle基础命.doc

Oracle 基础命令 2010-09-04 00:05 3:oracle 启动关闭1:查找oracle报警日志所在的目录select name,value from v$parameter where name like %_dest;4：数据字典2:查看oracle数据库的名字，创建日期，日志模式select name,created,log_mode,open_mode from v$database;3:查看oracle服务器主机名，实例名，数据库版本号select host_name,instance_name,version from v$instance;4:数据库版本select * from v$version;5：控制文件所在目录select * from v$controlfile;6:查看oracle重做日志组select group#,members,bytes,status,archived from v$log;7：查看日志数据文件所在的目录select * from v$logfile;8:查看数据库日志模式archive log list9:查看表空间select tablespace_name,block_size,status,contents,loggin from dba_tablespaces;loggin：选项是查看是否启用重做日志保护。10：查看表空间的数据文件select file_id,file_name,tablespace_name,status,bytes from dba_data_files;11:查看用户创建时间select username,created from dba_users;12:查看表空间的管理模式select tablespace_name,block_size,extent_management,segment_space_management where tablespace_name LIKE JIN%;13:查看表空间的工作状态select tablespace_name,status,contents from dba_tablespaces where tablespace_name like OCEAN%;14:查看表空间文件能否自动扩展select file_id,tablespace_name,file_name,autoextensible from dba_data_files where file_id = 8 order by file_id;15:查看每个表空间的大小select file_id,file_name,tablespace_name,bytes/(1024*1024) MB from dba_data_files where tablespace_name like OCEAN% order by tablespace_name;16:查看表空间是否是自动的段空间管理select tablespace_name,block_size,extent_management,segment_space_management from dba_tablespaces where tablespace_name like OCEAN%;17:复制一个表create tables emp_tran as select * from emp;18:查看现在使用的还原表空间select name,value from v$parameter where name like %undo%;19:还原表空间的切换alter system set undo_tablespace = jianlian;20:查看数据库运行的环境变量21：查看用户下有哪些表select * from catselect table_name from user_tables;22:表的截断truncat tables 用户名.表名23:查看一个用户对象下那些是表，那些是索引SQL select object_id,object_name,object_type,status,created from dba_objects where owner = SCOTT;24：查看一个用户对象下索引和表的对应关系SQLselect index_name,table_name,tablespace_name,status from dba_indexes where owner = SCOTT25:查看一个用户对象下的表索引是否生效SQL select