466
技術社區[雲棲]
oracle中創建表空間，用戶，授權，表結構的例子
-- 創建表空間
CREATE TABLESPACE blog
DATAFILE 'F:/oracledata/blog01.dbf' size 200M
EXTENT MANAGEMENT local;
-- 創建用戶
CREATE USER blog IDENTIFIED BY blog
DEFAULT TABLESPACE blog;
-- 授予權限
GRANT connect, resource TO blog;
-- 使用blog用戶連接數據庫
CONNECT blog/blog;
-- 創建博客信息表
CREATE TABLE userinfo (
id VARCHAR2(32) NOT NULL,
name VARCHAR2(32) NOT NULL,
password VARCHAR2(32) NOT NULL,
CONSTRAINT userinfo_pk PRIMARY KEY (id),
CONSTRAINT userinfo_unique_name UNIQUE ( name )
);
-- 創建網絡日誌表
CREATE TABLE message (
id VARCHAR2(32) NOT NULL,
title VARCHAR2(32) NOT NULL,
content VARCHAR2(2000),
user_id VARCHAR2(32),
CONSTRAINT message_pk PRIMARY KEY (id),
CONSTRAINT message_user FOREIGN KEY (user_id) REFERENCES userinfo(id)
);
-- 創建讀者評論信息表
CREATE TABLE replymessage (
id VARCHAR2(32) NOT NULL,
username VARCHAR2(64) NOT NULL,
title VARCHAR2(32) NOT NULL,
content VARCHAR2(2000),
message_id VARCHAR2(32) NOT NULL,
CONSTRAINT replymessage_pk PRIMARY KEY (id),
CONSTRAINT replymessage_message FOREIGN KEY (message_id) REFERENCES message(id)
);
最後更新：2017-04-02 04:26:02