ORACLE 10 (付首昕)学习笔记-第4课-命令。

ORACLE 10 学习笔记-第4课-命令。

1.commit;rollback;
2.select * from dictionary;
describe dba_users;
select * from dba_users;
select name from v$controlfile;
3.
alter database drop logfile group 3
select archiver from v$instance;
alter tablespace userdata read only;
4.
select tablespace_name, file_name,autoextensible from dba_data_files;
alter tablespace user_data add datafile '/u01/oradata/userdata03.dbf' size 200M;
alter database rename file '/u01/oradata/system01.dbf' to '/u03/oradata/system01.dbf';
select segment_name, tablespace_name, extents,blocks
from dba_segments where owner='hr';
5.
select tablespace_name,count(*),max(blocks),sum(blocks)
from dba_free_space group by tablespace_name;
6.
set transaction read only;
set transaction isolation level serializable;
alter system set undo_tablespace=undotbs;
select end_time,begin_time,undoblks from v$undostat;
select department_id, rowid from hr.departments;
7.创建临时表
create global temporary table hr.employees_temp
as select * from hr.employees;
8.截取表
truncate table hr.employees;
select role,password_required from dba_roles;