drop user dss_exch cascade;

drop tablespace DSSEXCH including contents and datafiles;



CREATE TABLESPACE "DSSEXCH" DATAFILE 'D:\oradata\LESTA\DSSEXCH.DBF' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;


CREATE USER "DSS_EXCH" IDENTIFIED BY "dss_exch" DEFAULT TABLESPACE "DSSEXCH" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;
GRANT CREATE SESSION TO "DSS_EXCH";
GRANT UNLIMITED TABLESPACE TO "DSS_EXCH";
GRANT "CONNECT" TO "DSS_EXCH";
GRANT "RESOURCE" TO "DSS_EXCH";

grant read,write on directory expdp_dir1 to dss_exch;



impdp USERID=\"dss_exch/dss_exch@LESTA\" DIRECTORY=expdp_dir DUMPFILE=dss_exch.dmp LOGFILE=dss_exch_imp.log SCHEMAS=dss_exch
impdp USERID=\"dss_exch/dss_exch@LESTA\" DIRECTORY=expdp_dir DUMPFILE=exchdt.dmp LOGFILE=exchdt_imp.log TABLE_EXISTS_ACTION=REPLACE