Oracle数据库的数据导入导出

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

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

备份数据

sqlplus adminuser/adminuser@ip/jnbase --可以看出oracle的版本号 version=10.2.0.1.0
exp adminuser/adminuser@ip:1521/jnbase file=f: ihao.dmp owner=adminuser 
C:Usershappiness>exp adminuser/adminuser@ip:1521/orcl file=f:ADMINUSER.dmp full=y 
C:UsersAdministrator>exp adminuser/adminuser@localhost:1521/orcl file=d:ADMINUSER.dmp full=y

--远程导出数据库******
exp adminuser/adminuser@ip:1521/orcl file=E:hello ewDataBaseBackadminuser.dmp owner=adminuser

--本地导出数据库******
exp adminuser/adminuser@localhost:1521/orcl file=E:hello ewDataBaseBackadminuser.dmp owner=adminuser

--本地导入数据库******
imp user_test/happiness@localhost:1521/orcl file='E:hello ewDataBaseBack est1122.dmp' full=y ignore=y