./categories/server
Tibero tbexport·tbimport
password=PASS는 플레이스홀더. 문서 데모 기본값tibero는 실계정 아님.
모드
full | user | table 중 하나만. import 전 tablespace·user 준비. FROMUSER면 TOUSER 필수.
# export (로컬)
tbexport username=sys password=PASS port=8629 sid=SID file=out.dat full=y
tbexport username=sys password=PASS port=8629 sid=SID file=out.dat user=SCHEMA
tbexport username=sys password=PASS port=8629 sid=SID file=out.dat table=SCHEMA.TBL
# export (원격 — 파일은 원격에 생성)
tbexport username=sys password=PASS ip=HOST port=8629 sid=SID file=out.dat full=y
# import
tbimport username=sys password=PASS port=8629 sid=SID file=out.dat full=y
tbimport username=sys password=PASS port=8629 sid=SID file=out.dat fromuser=A touser=B
관련 링크: https://m.blog.naver.com/PostView.nhn?blogId=songsunsang&logNo=110168989386
./comments