创建ORA 表空间

DROP TABLESPACE TBS_TEMP

--CREATE USER TABLESPACE

CREATE TABLESPACE "TBS_MONG" DATAFILE

'F:\ORACLE\ORADATA\QA\TBS_MONG.DBF' SIZE 125829120 REUSE

AUTOEXTEND ON NEXT 655360 MAXSIZE UNLIMITED

LOGGING ONLINE PERMANENT BLOCKSIZE 8192

EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO

--CREATE TEMP TABLESPACE

CREATE TEMPORARY TABLESPACE "TBS_TEMP" TEMPFILE

'F:\ORACLE\ORADATA\QA\TBS_TEMP.DBF' SIZE 41943040 REUSE

AUTOEXTEND ON NEXT 655360 MAXSIZE UNLIMITED

EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576

drop user mong0417 cascade;

create user mong0417

identified by mong0417test

default tablespace tbs_mong

temporary tablespace tbs_temp;

grant connect, resource to mong0417;