我的一些oracle9i学习笔记,与大家分享
来源:百度文库 编辑:神马文学网 时间:2024/05/01 10:32:49
######### 创建数据库----look $ORACLE_HOME/rdbms/admin/buildall.sql #############
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
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
我的一些oracle9i学习笔记,与大家分享
Oracle9i学习笔记|中国IT认证实验室
oracle9i笔记
我的一条研究成果与大家分享
我的一条研究成果与大家分享 .
重庆首届天使投资论坛 我的笔记分享给大家
我收集的66个FLASH效果与大家分享
我收集的66个FLASH效果与大家分享
我收集的FLASH效果与大家分享
我自己搜集的签名,与大家分享
一些美好的句子 大家齐分享
与朋友们分享我的一些人生感悟[栖息谷]
一些心得 大家分享
我做期货的方法与大家都不一样,十三年投机经验与大家分享
和大家分享一些我这些年喜欢的英文好歌(不断更新)
和大家分享一些我这些年喜欢的英文好歌
转载一些地板材种的介绍及铺设要求,与大家分享 - 家庭装修 ...
收集了一些透明FLASH素材与大家分享[转帖]
给大家一些英语学习的建议
分享学习外语的一些网站
一些学习笔记 ,陷阱,缺陷
一些美好的句子 大家齐分享;1文
给大家分享一些有趣的网站(转)
《走进我的交易室》学习笔记