连接
connect sys/123456 as SYSDBA
临时表空间
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE 'C:\oraclexe\oradata\demo\demo_temp01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
表空间
CREATE TABLESPACE demo_data
LOGGING
DATAFILE 'C:\oraclexe\oradata\demo\demo_DATA01.DBF'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
创建用户
CREATE USER demo IDENTIFIED BY 123456
DEFAULT TABLESPACE demo_data
TEMPORARY TABLESPACE test_temp;
alter user demo quota unlimited on demo_data;
授权
GRANT
CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,
ALTER ANY TABLE, ALTER ANY PROCEDURE,
DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,
SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE
TO demo;
connect sys/123456 as SYSDBA
临时表空间
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE 'C:\oraclexe\oradata\demo\demo_temp01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
表空间
CREATE TABLESPACE demo_data
LOGGING
DATAFILE 'C:\oraclexe\oradata\demo\demo_DATA01.DBF'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
创建用户
CREATE USER demo IDENTIFIED BY 123456
DEFAULT TABLESPACE demo_data
TEMPORARY TABLESPACE test_temp;
alter user demo quota unlimited on demo_data;
授权
GRANT
CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,
ALTER ANY TABLE, ALTER ANY PROCEDURE,
DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,
SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE
TO demo;