oracleµÄ³õ¼¶Ñ§Ï°±Ê¼Ç

--²é¿´¿ØÖÆÎļþ
select * from v$controlfile;
select type,record_size,records_total,records_used
 from v$controlfile_record_section where type='DATAFILE';
 
 --db_block_size=8192
 --Êý¾Ý×Öµäǰ׺
 --allÏÔʾËùÓпɷÃÎʵĶÔÏóÐÅÏ¢
 --user dba v$
 
 --²é¿´±íÐÅÏ¢
 select * from dba_data_files;
 
 select owner,object_name,object_type from all_objects
 
 select * from dba_all_tables
 
 --Êý¾Ý×ÖµäÃû³Æ
 --dba_table,dba_tab_columns,dba_views,dba_synonyms,dba_sequences,dba_counstraints,dba_indexes,
 --dba_triggers,dba_source,dba_segments,dba_extents,dba_objects,cat,tab,dict
 --Êý¾Ý¿âÊý¾Ý×Öµä
 --v$database ,dba_tablespaces,dba_data_files,dba_free_space,v$instrance,v$parameter,v$system_parameter
create user teacher
identified by teacher123
default tablespace users
temporary tablespace temp
grant connect to teacher;
grant resource to teacher;--ÔÊÐíÓû§Ê¹ÓÃÊý¾Ý¿âµÄ±í¿Õ¼ä
grant select on scott.emp to teacher; --ÊÚÓèteacher²é¿´scott.empµÄȨÏÞ
--ÐÞ¸ÄÓû§
alter user teacher
identified by teacher;
alter user teacher
account lock
alter user teacher
default tablespace users
temporary tablespace temp;
--ɾ³ýûÓÐģʽ¶ÔÏóÓû§
drop user teacher
--ɾ³ýÓÐģʽ¶ÔÏóÓû§
drop user teacher cascade
--ϵͳȨÏÞcreate drop alter
--¶ÔÏóȨÏÞ insert update select
grant create session,dba to teacher;--ÊÚȨ
revoke select on scott.emp from teacher;--ȨÏÞÊÕ»Ø
--´´½¨±í¿Õ¼ä
create tablespace rb_seges
datafile 'd:/database/datafile_1' size 50m;
--´´½¨Áãʱ¿Õ¼ä£¿£¿
create temporary tablespace temp;
--¸ø±íÔö¼Ó10m
alter tablespace rb_seges
add datafile 'filename1' size 10m;
--ÉèÖÃrb_segesΪĬÈϱí¿Õ¼ä
alter database default tablespace rb_seges;
--ɾ³ý±í¿Õ¼ä¼°ÆäËùÓеÄ×Ö¶Î
drop tablespace rb_seges including contents;
--±í¿Õ¼äºÍÊý¾ÝÎļþÓйصÄÊý¾Ý×Öµä
--dba_data_filesÊý¾ÝÎļþºÍ±í¿Õ¼äµÄÐÅÏ¢
--dba_tablespaces±í¿Õ¼äÐÅÏ¢
--dba_free_space¿ÕÏпռäÐÅÏ¢
--OracleÊý¾ÝÀàÐÍ
--Êý×Ö