ORACLE Database / WAS (iAS) / SQL 자료실 - 포기하지 않으면 실패하지 않는다!
Vote Reply Modify Delete Forward Prev Next List

  Author   : 조성환 [ ladmin ] Vote: 1074, Modifies: 8, Hit: 3094, Lines: 26, Category: Etc.
import / export 하기 [강추]
* import 하기

imp yeongu/****** file=yeongu.dmp log=yeongu_imp.log full=y

imp sukwoo/****** fromuser=sukwoo2 touser=sukwoo file=sukwoo2.dmp log=sukwoo.log commit=y rows=y ignore=y

imp system/****** fromuser=kssgs touser=kssgs file=kssgs.dmp log=kssgs.log commit=y rows=y ignore=y

(참고로 fromuser, touser 옵션을 사용할때는 full 옵션을 함께 쓸수 없다)




* export 하기

exp scott/****** owner=scott file=scott.dmp log=scott.log

exp system/******@CHUN \
file=20`date +%y-%m-%d_%T`_db_SUKWOO2.dmp \
log =20`date +%y-%m-%d_%T`_db_SUKWOO2.log \
grants=y indexes=y rows=y constraints=y triggers=y compress=y direct=n consistent=n statistics=estimate \
owner=SUKWOO2



Prev: 사용자 이전하기
Next: Database Link 사용법
2006/05/31(05:53) from 59.30.129.220
CrazyWWWBoard 2000

Vote Reply Modify Delete Forward Prev Next List
(c) Nobreak Technologies, Inc.