9inote_all.docVIP

9inote_all 我的oracle9i学习笔记 create database db01 maxlogfiles 10 maxdatafiles 1024 maxinstances 2 logfile GROUP 1 (/u01/oradata/db01/log_01_db01.rdo) SIZE 15M, GROUP 2 (/u01/oradata/db01/log_02_db01.rdo) SIZE 15M, GROUP 3 (/u01/oradata/db01/log_03_db01.rdo) SIZE 15M, datafile u01/oradata/db01/system_01_db01.dbf) SIZE 100M, undo tablespace UNDO datafile /u01/oradata/db01/undo_01_db01.dbf SIZE 40M default temporary tablespace TEMP tempfile /u01/oradata/db01/temp_01_db01.dbf SIZE 20M extent management local uniform size 128k character set AL32UTE8 national character set AL16UTF16 set time_zone=America/New_York; ############### 数据字典 ########## set wrap off select * from v$dba_users; grant select on table_name to user/rule; select * from user_tables; select * from all_tables; select * from dba_tables; revoke dba from user_name; shutdown immediate startup nomount select * from v$instance; select * from v$sga; select * from v$tablespace; alter session set nls_language=american; alter database mount; select * from v$database; alter database open; desc dictionary select * from dict; desc v$fixed_table; select * from v$fixed_table; set oracle_sid=foxconn select * from dba_objects; set serveroutput on execute dbms_output.put_line(sfasd); ############# 控制文件 ########### select * from v$database; select * from v$tablespace; select * from v$logfile; select * from v$log; select * from v$backup; /*备份用户表空间*/ alter tablespace users begin backup; select * from v$archived_log; select * from v$controlfile; alter system set control_files=$ORACLE_HOME/oradata/u01/ctrl01.ctl, $ORACLE_HOME/oradata/u01/ctrl02.ctl scope=spfile; cp $ORACLE_HOME/oradata/u01/ctrl01.ctl $ORACLE_HOME/oradata/u01/ctrl02.ctl startup pfile=../initSID.ora select * from v$parameter where name like control% ; show parameter control; select * from v$co