exp导出
# exp basename/password file=/home/Oracle/basename.dmp owner=basename;
例:exp base123/123 file=/home/Oracle/base123.dmp owner=base123;
imp导入
# imp basename/password file=/home/oracle/basename.dmp fromuser=basename;
例:imp base123/123 file=/home/Oracle/base123.dmp owner=base123;
注意:导入导出时注意下路径权限
执行exp/imp后面跟着的路径要是Oracle用户下的,否则没有权限,无法执行导入导出。
报错:ErroMessage:failed to open for write/read