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
沒有留言:
張貼留言