Oracle数据库的数据导入导出详解数据库

–备份数据库
–数据库系统用户账号
system/adminuser

–查看oracle数据库的用户
select * from all_users;
–查看oracle数据库的版本号
select * from v$version;

备份数据

sqlplus [email protected]/jnbase –可以看出oracle的版本号 version=10.2.0.1.0
exp [email protected]:1521/jnbase file=f:/nihao.dmp owner=adminuser 
C:/Users/happiness>exp [email protected]:1521/orcl file=f:/ADMINUSER.dmp full=y 
C:/Users/Administrator>exp [email protected]:1521/orcl file=d:/ADMINUSER.dmp full=y

–远程导出数据库******
exp [email protected]:1521/orcl file=E:/hello/newDataBaseBack/adminuser.dmp owner=adminuser

–本地导出数据库******
exp [email protected]:1521/orcl file=E:/hello/newDataBaseBack/adminuser.dmp owner=adminuser

–本地导入数据库******
imp [email protected]:1521/orcl file=’E:/hello/newDataBaseBack/test1122.dmp’ full=y ignore=y