Oracle命令--创建表空间、创建临时表空间、创建用户

创建表空间
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;