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

--ALTER SYSTEM KILL SESSION '7, 39';


drop user marina cascade;
create user marina identified by yas3315 default tablespace marina temporary tablespace temp;
grant dba to marina;

impdp system/orc1 schemas=yas directory=dumpdmp dumpfile=yasdb.dmp logfile=imp_yasdb.log remap_schema=yas:marina  remap_tablespace=yas:marina