expdp system/orc1 schemas=marina directory=dumpdmp  dumpfile=marinagccm.dmp logfile=exp_marina.log




SELECT s.sid, s.serial#, s.status, p.spid
 FROM v$session s, v$process p
WHERE s.username = 'FBGLOSSY'
and p.addr(+) = s.paddr;

--ALTER SYSTEM KILL SESSION '7, 39';
drop user marina cascade;



DROP TABLESPACE marina INCLUDING CONTENTS AND DATAFILES;

create tablespace marina DATAFILE 'marina01.dbf' SIZE 3000M AUTOEXTEND ON;



create user marina identified by gccm3315 default tablespace marina temporary tablespace temp;
grant dba to marina;

impdp system/orc1 schemas=marina directory=dumpdmp  dumpfile=marinagccm.dmp logfile=imp_marina.log