Oracle 10g Command set命令集合

Oracle 10g Command set命令集合

1.查看用户属于那个表空间 SQL>conn sys/oracle as sysdba SQL>select username,default_tablespace,temporary_tablespace from dba_users where username='SCOTT'; 2.查看用户拥有的表： SQL>conn scott/oracle SQL>select owner,table_name from all_tables where owner='SCOTT'; 3.查看数据文件的存放位置 SQL>conn sys/oracle as sysdba SQL>select * from v$dbfile; 4.查看数据库的例程名、归档模式、创建时间 SQL>select name,log_mode,created from v$database; 5.查看表空间的大小 SQL>select file#,name,bytes from v$datafile; 6.更改列名的操作 SQL>alter table abc rename column b to c; 7.修改默认的表空间 SQL>alter database default tablespace user01; 8.删除重做日志文件 SQL>alter database drop logfile member 'e:/oralce/redo02.log'; SQL>alter database drop logfile group4; 9表空间的离线操作 SQL>alter tablespace tbs_8k offline; SQL>alter tablespace tbs_8k online; 10.删除表空间 SQL>conn sys/oracle as sysdba SQL>select * from v$dbfile; SQL>drop tablespace user01 including contents and datafiles; 11.数据文件掉失，启动数据库是出现如下情况： SQL>drop tablespace datafile 8 offline; SQL>alter database open; 12.查看表空间的状态和名称 SQL>SELECT * FROM V$TABLESPACE; 13.查看用户视图操作 14.查看表的数据类型 15.查看主键名称   16.添加主键约束及删除主键 SQL>alter table dept drop constraint pk_dept;