ORACLE 创建表空间和用户

Windows下打开[运行SQL命令行]

 

CONNECT / AS SYSDBA

 

--临时表空间
CREATE TEMPORARY TABLESPACE USER_TEMP
TEMPFILE 'D:\oraclexe\app\oracle\oradata\XE\USER_TEMP.DBF'
SIZE 50M
AUTOEXTEND ON
NEXT 50M MAXSIZE 20480M
EXTENT MANAGEMENT LOCAL;


--表空间
CREATE TABLESPACE USER_DATA
LOGGING
DATAFILE 'D:\ORACLEXE\APP\ORACLE\ORADATA\XE\USER_DATA.DBF'
SIZE 50M
AUTOEXTEND ON
NEXT 50M MAXSIZE 20480M
EXTENT MANAGEMENT LOCAL;


--2.建用户
CREATE USER ODUSER IDENTIFIED BY 123456  
DEFAULT TABLESPACE USER_DATA  
TEMPORARY TABLESPACE USER_TEMP;  


--3.赋权
GRANT CONNECT,RESOURCE,CREATE SESSION TO ODUSER;

GRANT DBA TO ODUSER;


COMMIT;