创建用户表空间授权执行脚本

create user creportalapp identified by creportalapp;

grant connect, resource to creportalapp;

--查询表空间路径
select * from dba_data_files t where Lower(t.tablespace_name)='creportalappdata';


CREATE TABLESPACE creportalappdata
LOGGING
DATAFILE '/oradata/portal/datafile/creportalappdata.dbfF'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;