创建表空间

CREATE TABLESPACE "TBS_ETL_META"

LOGGING

DATAFILE '/opt/oracle/oradata/etl/TBS_ETL_META.dbf' SIZE 4000M

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

 

创建临时表空间

create temporary tablespace portalco_tmp

    tempfile

     '/opt/oracle/oradata/portalclm/portalco_tmp.dbf' size 100m    

    extent management local

segment space management manual;

 

创建用户

SQL> CREATE USER ETLMETA

2 IDENTIFIED BY "ETLMETA"

3 DEFAULT TABLESPACE TBS_ETL_META

4 TEMPORARY TABLESPACE TBS_ETL_TEMP

5 PROFILE DEFAULT;