create schema

[xiangqy]

能否给我一个create schema 的例子，还有pl/sql 的帮助文件哪儿有？谢谢

[l2g32003]

create user user_name identified by XXXXX
default tablespace ts_Name
quota 5M on ts_name;
创建一个用户就创建了一个和用户名相同的 schema
Oracle automatically creates a schema when you create a user

当然也有单独创建 schema 的语句
CREATE SCHEMA AUTHORIZATION schema_name
CREATE TABLE new_product
(color VARCHAR2(10) PRIMARY KEY, quantity NUMBER)
CREATE VIEW new_product_view
AS SELECT color, quantity FROM new_product WHERE color = 'RED'
GRANT select ON new_product_view TO hr;

Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-02 有帮助文档

[xiangqy]

谢谢,可是我在安装完的oracle9i中,没找到pl/sql
的帮助文件,需要例外下载吗?告知下载地质

[xiangqy]

zhao dao liao ,gan ma oracle bu ba suo you de bang zhu wen jian fang dao an zhuang
pangshang ne ?
ma fan !