exp, imp

exp username/password@
exp userid=username/password file=c:\...

drop user 계정이름 cascade;

create user [username] identified by [password]
default tablespace [tablespace_name]
temporary tablespace temp;

grant connect, dba, resource, EXP_FULL_DATABASE, IMP_FULL_DATABASE to [username];

 

리눅스

su - 계정명

exp userid=username/password file=/home/...

 

재시작

su -l oracle

lsnrctl stop

sqlplus /nolog

SQL > connect /as sysdba

SQL > shutdown abort

SQL > startup

SQL > exit

lsnrctl start