users

select * from all_users;

create schema(users)

select tablespace_name from user_tablespaces;

select USERNAME, DEFAULT_TABLESPACE from DBA_USERS;

select USERNAME, DEFAULT_TABLESPACE from DBA_USERS where DEFAULT_TABLESPACE = 'DEV_DB';

create tablespace

conn fxwl/fxwl
select USERNAME, DEFAULT_TABLESPACE from DBA_USERS;

CREATE TABLESPACE  EAS_D_FXWL_STANDARD
    DATAFILE '+SSD_DATA' SIZE 10000M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
    EXTENT MANAGEMENT LOCAL AUTOALLOCATE
    LOGGING
    ONLINE
    SEGMENT SPACE MANAGEMENT AUTO
    /

create user fxwl identified by fxwl default tablespace EAS_D_FXWL_STANDARD quota unlimited on EAS_D_FXWL_STANDARD;

grant dba to fxwl;

impdp \"system as sysdba\" schemas=fxwl directory=dump_dir dumpfile=FXWL_201611030600.DMP logfile=impdpFrom11.2.0.1.log table_exists_action=replace

D:\ORACLE\ORADATA\FXWL\SYSTEM01.DBF
D:\ORACLE\ORADATA\FXWL\SYSAUX01.DBF
D:\ORACLE\ORADATA\FXWL\UNDOTBS01.DBF
D:\ORACLE\ORADATA\FXWL\USERS01.DBF
D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD101.ORA
D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD102.ORA
D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD103.ORA
D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD104.ORA
D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD105.ORA
D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD106.ORA
D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD107.ORA