오라클 db 백업-(exp) 명령

디비사랑넷에도 답글을 달았는데.. 같은 질문이 잇네요.. ㅎㅎㅎ

ora102:/d2/product/ora102> exp test1/test1 file=expdat.dmp full=y;


Export: Release 10.2.0.1.0 - Production on Mon Aug 13 13:42:06 2007


Copyright (c) 1982, 2005, Oracle. All rights reserved.



Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning and Data Mining options

EXP-00023: must be a DBA to do Full Database or Tablespace export

(2)U(sers), or (3)T(ables): (2)U >


Export grants (yes/no): yes >


Export table data (yes/no): yes >


Compress extents (yes/no): yes >


Export done in KO16MSWIN949 character set and AL16UTF16 NCHAR character set

. exporting pre-schema procedural objects and actions

. exporting foreign function library names for user TEST1

. exporting PUBLIC type synonyms

. exporting private type synonyms

. exporting object type definitions for user TEST1

About to export TEST1's objects ...

. exporting database links

. exporting sequence numbers

. exporting cluster definitions

. about to export TEST1's tables via Conventional Path ...

. . exporting table T1 4 rows exported

. . exporting table T2 4 rows exported

. exporting synonyms

. exporting views

. exporting stored procedures

. exporting operators

. exporting referential integrity constraints

. exporting triggers

. exporting indextypes

. exporting bitmap, functional and extensible indexes

. exporting posttables actions

. exporting materialized views

. exporting snapshot logs

. exporting job queues

. exporting refresh groups and children

. exporting dimensions

. exporting post-schema procedural objects and actions

. exporting statistics

Export terminated successfully with warnings.

ora102:/d2/product/ora102> imp test/test file=expdat.dmp full=y;


Import: Release 10.2.0.1.0 - Production on Mon Aug 13 13:42:25 2007


Copyright (c) 1982, 2005, Oracle. All rights reserved.



Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning and Data Mining options


Export file created by EXPORT:V10.02.01 via conventional path


Warning: the objects were exported by TEST1, not by you


import done in KO16MSWIN949 character set and AL16UTF16 NCHAR character set

. importing test1's objects into TEST

. . importing table "T1" 4 rows imported

. . importing table "T2" 4 rows imported

Import terminated successfully without warnings.



위의 예제처럼 하면 됩니다.

 

출처 : http://ikinox.tistory.com/entry/%EC%98%A4%EB%9D%BC%ED%81%B4-db-%EB%B0%B1%EC%97%85-exp-%EB%AA%85%EB%A0%B9