第三章 專項練習

本章主要練習數据庫的一些基本操作，包括安裝軟件，創建數据庫……

[@more@]

動態性能視圖從來不用复數，數据字典通常使用復數。

動態性能視圖能在 Mount 級查詢！

-- 創建用戶，更改口令
-- 增加表空間，增加數据文件，更改用戶默認表空間
SYS@HUIYI>create user user01 identified by user01;

User created.

SYS@HUIYI>alter user user01 identified by aa;

User altered.

SYS@HUIYI>create tablespace tbs02
  2  datafile 'g:a9ioradatatbs02.dbf' size 20M autoextend off
  3  /

Tablespace created.

SYS@HUIYI>alter tablespace tbs02
  2  add datafile 'g:a9ioradatatbs022.dbf' size 20M autoextend off
  3  /

Tablespace altered.

SYS@HUIYI>col name format a50
SYS@HUIYI>select t.name,f.name
  2   from v$tablespace t,v$datafile f
  3  where t.ts#=f.ts#;

NAME                                               NAME
-------------------------------------------------- --------------------------------------------------
SYSTEM                                             G:A9IORADATAHUIYISYSTEM01.DBF
UNDOTBS1                                           G:A9IORADATAHUIYIUNDOTBS01.DBF
DRSYS                                              G:A9IORADATAHUIYIDRSYS01.DBF
EXAMPLE                                            G:A9IORADATAHUIYIEXAMPLE01.DBF
INDX                                               G:A9IORADATAHUIYIINDX01.DBF
ODM                                                G:A9IORADATAHUIYIODM01.DBF
TOOLS                                              G:A9IORADATAHUIYITOOLS01.DBF
USERS                                              G:A9IORADATAHUIYIUSERS01.DBF
XDB                                                G:A9IORADATAHUIYIXDB01.DBF
TBS01                                              G:A9IORADATATBS01.DBF
TBS02                                              G:A9IORADATATBS02.DBF
TBS02                                              G:A9IORADATATBS022.DBF

12 rows selected.

SYS@HUIYI>alter user user01 default tablespace tbs01;

User altered.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8799875/viewspace-903000/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8799875/viewspace-903000/