디비사랑넷에도 답글을 달았는데.. 같은 질문이 잇네요.. ㅎㅎㅎ
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.
위의 예제처럼 하면 됩니다.
