RadarURL
Skip to content
조회 수 872 추천 수 0 댓글 0
?

단축키

Prev이전 문서

Next다음 문서

크게 작게 위로 아래로 댓글로 가기 인쇄
?

단축키

Prev이전 문서

Next다음 문서

크게 작게 위로 아래로 댓글로 가기 인쇄

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

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

TAG •
?

List of Articles
번호 제목 글쓴이 날짜 조회 수
» 오라클 db 백업-(exp) 명령 JaeSoo 2014.03.24 872
5 Oracle 리눅스에서 백업하는 방법 JaeSoo 2014.03.24 1029
4 Database 모든 테이블 컬럼 정보 받아오는 쿼리 [오라클] JaeSoo 2014.02.07 1794
3 테이블 정의서 (table layout) 출력하기 [오라클] JaeSoo 2014.02.07 2740
2 오라클(Oracle) 테이블스페이스(TableSpace) 정리 JaeSoo 2012.07.20 7846
1 Oracle 10g XE JDBC 연결하기 JaeSoo 2007.10.10 11396
Board Pagination Prev 1 2 Next
/ 2

PageViews   Today : 126   Yesterday : 1,277   Total : 20,249,346  /  Counter Status   Today : 58   Yesterday : 424   Total : 1,539,282
Site Info   Member : 247  /  Total documents : 1,243   New documents : 0  /  Total comments : 26

Edited by JAESOO

sketchbook5, 스케치북5

sketchbook5, 스케치북5

나눔글꼴 설치 안내


이 PC에는 나눔글꼴이 설치되어 있지 않습니다.

이 사이트를 나눔글꼴로 보기 위해서는
나눔글꼴을 설치해야 합니다.

설치 취소