创建表空间
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;