sqlplus system/manager@oracle11g
# dump table
exp ${USERNAME}/${PASSWORD}@${TNSNAME} \
FULL=y FILE=${DEST_NAME}.dmp \
LOG=${DEST_NAME}.log CONSISTENT=y
# dump all table
exp system/manager FULL=y FILE=demo.dmp LOG=demo.log
# import .dmp file
imp system/manager@oracle11g FILE=t.dmp LOG=tImp.log \
fromuser=system touser=system tables=tt
沒有留言:
張貼留言