Oracle 10g创建表空间和创建用户命令

  创建表空间 

CREATE TABLESPACE test DATAFILE 
  'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORACLE\TEST1.DBF' SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
LOGGING
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
FLASHBACK ON;

 
 

 

创建用户

CREATE USER test IDENTIFIED BY "test"
 DEFAULT TABLESPACE "TEST"
 TEMPORARY TABLESPACE "TEMP"
 PROFILE DEFAULT
 QUOTA UNLIMITED ON "TEST";

GRANT UNDER ANY TABLE TO test WITH ADMIN OPTION;

GRANT UNDER ANY TYPE TO test WITH ADMIN OPTION;

GRANT UNDER ANY VIEW TO test WITH ADMIN OPTION;


GRANT "DBA" TO test WITH ADMIN OPTION;
GRANT "OLAP_DBA" TO test WITH ADMIN OPTION;
GRANT "OLAP_USER" TO test WITH ADMIN OPTION;
GRANT "SELECT_CATALOG_ROLE" TO test WITH ADMIN OPTION;
ALTER USER test DEFAULT ROLE "DBA", "OLAP_DBA", "OLAP_USER", "SELECT_CATALOG_ROLE";

ALTER USER test QUOTA UNLIMITED ON TEST;