--4.1 创建表空间

CREATE TABLESPACE mdm_data DATAFILE 'D:\soft\Oracle\oracl\oradata\mdm_data01.dbf' SIZE 300M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;

CREATE TABLESPACE iuap_index DATAFILE 'D:\soft\Oracle\oracl\oradata\iuap_index01.dbf' SIZE 50M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;

--4.2 创建用户

CREATE USER mdmiuap IDENTIFIED BY mdmiuap DEFAULT TABLESPACE mdm_data TEMPORARY TABLESPACE temp;

--4.3 根据自己的权限设计授权

GRANT CONNECT,DBA,RESOURCE,select any dictionary TO mdmiuap;