[Oracle]分享：我的oracle9i学习笔记（1）

文章作者 100test 发表时间 2007:03:14 13:55:03
来源 100Test.Com百考试题网

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

0select * from v$dba_users.

grant 0select on table_name to user/rule.

0select * from user_tables.

0select * from all_tables.

0select * from dba_tables.

revoke dba from user_name.

shutdown immediate

startup nomount

0select * from v$instance.

0select * from v$sga.

0select * from v$tablespace.

alter session set nls_language=american.

alter database mount.

0select * from v$database.

alter database open.

desc dictionary

0select * from dict.

desc v$fixed_table.

0select * from v$fixed_table.

set oracle_sid=foxconn

0select * from dba_objects.

set serveroutput on