Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2014/03/21(15:09) from 203.237.213.6 | |
ÀÛ¼ºÀÚ : ÁÖÀÎÀå | Á¶È¸¼ö : 3089 , ÁÙ¼ö : 16 |
[Oracle] 11g¿¡¼ pump·Î ¹ÞÀº°Å impdp·Î importÇϱâ |
---|
system°èÁ¤À¸·Î ·Î±×ÀÎÇؼ ¹Ì¸® »ç¿ëÀÚ°èÁ¤ / Å×ÀÌºí½ºÆäÀ̽º(µ¿ÀÏÇÏ°Ô) ¸¸µé¾î³õ°í SQL> select * from dba_directories; # impdp system/¾ÏÈ£ dumpfile=wsgw__pump.dmp directory=DATA_PUMP_DIR logfile=aa.log TABLES=À¯Àú¸í.COMM_APV_STAT # impdp system/¾ÏÈ£ dumpfile=wsgw__pump.dmp directory=DATA_PUMP_DIR logfile=aa.log TABLES=À¯Àú¸í.HAI_QDBINP @ SQLDeveloper·Î »ÌÀ»¶§, xls·Î »ÌÀ»°Í...(xlsx ¸»°í) |