sql>create directory datadmp as '경로';
sql>grant read, write on directory datadmp to 계정;
c:\>expdp system/manager schemas=SMS directory=datadmp dumpfile=SMS.DMP


계정이 생성되어있는지 확인(생성 안되어있는상태에서 성공했음)
sql>create directory datadmp as '경로';
# impdp system/manager schemas=SMS directory=datadmp dumpfile=SMS.DMP remap_schema=익스포트한계정:임포트할계정


+ Recent posts