如何创建数据表空间
create tablespace bbfxdatafile 'c:\orawin95\database\bbfx.dat' size 60M online
default storage ( pctincrease 2 );
然后再创建用户
create user bbfx identified by bbfxdefault tablespace bbfxtemporary tablespace bbfx;
授权
grant dba, connect, resource, create table to bbfx;
create tablespace bbfxdatafile 'c:\orawin95\database\bbfx.dat' size 60M online
default storage ( pctincrease 2 );
然后再创建用户
create user bbfx identified by bbfxdefault tablespace bbfxtemporary tablespace bbfx;
授权
grant dba, connect, resource, create table to bbfx;
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_74a.htm#SQLRF01403CREATE TEMPORARY TABLESPACE:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_75a.htm#SQLRF01404CREATE USER:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_84a.htm#SQLRF01503
CREATE TABLESPACE 表空间名 LOGGING DATAFILE 'c:\DataFile.ora' SIZE 100M创建用户
CREATE USER TestUser IDENTIFIED BY PassWord有相关文档
http://otn.oracle.com/documentation/index.html