当前页面位置: » 丰搜网 » 文档中心 » 详细内容
[oracle]分享：我的oracle9i学习笔记 （1）
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$controlfile_record_section;
select * from v$tempfile;
/*备份控制文件*/
alter database backup controlfile to '../filepath/control.bak';
