【正文】 l 第一章:日志管理　　 log switches　　sql alter system switch logfile?！　?checkpoints　　sql alter system checkpoint?！　?online redo log groups　　sql alter database add logfile [group 4]　　sql (39。/disk3/39。,39。/disk4/39。) size 1m。　　 online redo log members　　sql alter database add logfile member　　sql 39。/disk3/39。 to group 1,　　sql 39。/disk4/39。 to group 2?！　?the name of the online redo logfile　　sql alter database rename file 39。c:/oracle/oradata/oradb/39?！　ql to 39。c:/oracle/oradata/39?！　?online redo log groups　　sql alter database drop logfile group 3?！　?online redo log members　　sql alter database drop logfile member 39。c:/oracle/oradata/39?！　?online redo log files　　sql alter database clear [unarchived] logfile 39。c:/oracle/39?！　?logminer analyzing redo logfiles　　a. in the specify utl_file_dir = 39。 39?！　. sql execute (39。39。,39。c:\oracle\oradb\log39。)?！　. sql execute dbms_logmnr_add_logfile(39。c:\oracle\oradata\oradb\39。,　　sql )?！　. sql execute (39。c:\oracle\oradata\oradb\39。,　　sql )。　　e. sql execute (dictfilename=39。c:\oracle\oradb\log\39。)?！　. sql select * from v$logmnr_contents(v$logmnr_dictionary,v$logmnr_parameters　　sql v$logmnr_logs)。　　g. sql execute 。l 第二章:表空間管理　　 tablespaces　　sql create tablespace tablespace_name datafile 39。c:\oracle\oradata\39。 size 100m,　　sql 39。c:\oracle\oradata\39。 size 100m minimum extent 550k [logging/nologging]　　sql default storage (initial 500k next 500k maxextents 500 pctinccease 0)　　sql [online/offline] [permanent/temporary] [extent_management_clause]　　 managed tablespace　　sql create tablespace user_data datafile 39。c:\oracle\oradata\39?！　ql size 500m extent management local uniform size 10m?！　?tablespace　　sql create temporary tablespace temp tempfile 39。c:\oracle\oradata\39?！　ql size 500m extent management local uniform size 10m。　　 the storage setting　　sql alter tablespace app_data minimum extent 2m。　　sql alter tablespace app_data default storage(initial 2m next 2m maxextents 999)?！　?tablespace offline or online　　sql alter tablespace app_data offline。　　sql alter tablespace app_data online?！　?tablespace　　sql alter tablespace app_data read only|write?！　?tablespace　　sql drop tablespace app_data including contents?！　?automatic extension of data files　　sql alter tablespace app_data add datafile 39。c:\oracle\oradata\39。 size 200m　　sql autoextend on next 10m maxsize 500m?！　?the size fo data files manually　　sql alter database datafile 39。c:\oracle\oradata\39。 resize 200m?！　?data files: alter tablespace　　sql alter tablespace app_data rename datafile 39。c:\oracle\oradata\39。　　sql to 39。c:\oracle\39。　　 data files:alter database　　sql alter database rename file 39。c:\oracle\oradata\39。　　sql to 39。c:\oracle\39。l 第三章:表　　 a table　　sql create table table_name (column datatype,column datatype]....)　　sql tablespace tablespace_name [pctfree integer] [pctused integer]　　sql [initrans integer] [maxtrans integer]　　sql storage(initial 200k next 200k pctincrease 0 maxextents 50)　　sql [logging|nologging] [cache|nocache]　　 an existing table　　sql create table table_name [logging|nologging] as subquery　　 temporary table　　sql create global temporary table xay_temp as select * from xay?！　n mit preserve rows/on mit delete rows　　 = (average row size initial row size) *100 /average row size　　pctused = 100pctfree (average row size*100/available data space)　　 storage and block utilization parameter　　sql alter table table_name pctfree=30 pctused=50 storage(next 500k　　sql minextents 2 maxextents 100)。　　 allocating extents　　sql alter table table_name allocate extent(size 500k datafile 39。c:/oracle/39。)。　　 tablespace　　sql alter table employee move tablespace users?！　?of unused space　　sql alter table table_name deallocate unused [keep integer]　　 a table　　sql truncate table table_name?！　?a table　　sql drop table table_name [cascade constraints]?！　?a column　　sql alter table table_name drop column ments cascade constraints checkpoint 1000?！　lter table table_name drop columns continue?！　?a column as unused　　sql alter table table_name set unused column ments cascade constraints。　　alter table table_name drop unused columns checkpoint 1000?！　lter table orders drop columns continue checkpoint 1000　　data_dictionary : dba_unused_col_tabsl 第四章:索引　　 functionbased indexes　　sql create index on (quantityquantity_shipped)。　　 a Btree index　　sql create [unique] index index_name on table_name(column,.. asc/desc) tablespace　　sql tablespace_name [pctfree integer] [initrans integer] [maxtrans integer]　　sql [logging | nologging] [nosort] storage(initial 200k next 200k pctincrease 0　　sql maxextents 50)?！　?index)=(maximum number of rowsinitial number of rows)*100/maximum number of rows　　 reverse key indexes　　sql create unique index xay_id on xay(a) reverse pctfree 30 storage(initial 200k　　sql next 200k pctincrease 0 maxextents 50) tablespace indx?！　?bitmap index　　sql create bitmap index