ORACLE 下新建 SCHEMA

CREATE TABLESPACE EDI

    NOLOGGING

    DATAFILE '/oracle/oradata/wmtst/data/edi01.dbf' SIZE 2048M AUTOEXTEND ON

    NEXT 200m maxsize 4096m

    EXTENT MANAGEMENT LOCAL

    ONLINE

    SEGMENT SPACE MANAGEMENT AUTO;

 

create user wmedi IDENTIFIED BY wmedi

default tablespace EDI

quota unlimited on EDI;

 

GRANT CONNECT,RESOURCE,IMP_FULL_DATABASE TO wmedi;