오라클 간단한 dmp 파일 import

오라클 간단한 dmp 파일 import

cmd 치고

c:\>imp id/pw@serviceName file=gisa.dmp fromuser=dmp내id touser=id

아래와 같이 나오면 성공

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Productio

n

Export file created by EXPORT:V11.02.00 via conventional path

import done in KO16MSWIN949 character set and AL16UTF16 NCHAR character set

import server uses AL32UTF8 character set (possible charset conversion)

. . importing table           "GISA_EXAM"          100 rows imported

. . importing table        "GISA_EXAM_TEXT"            1 rows imported

. . importing table               "TEMP"       45 rows imported

Import terminated successfully without warnings.