Oracle数据导入导出步骤

一、oracle 数据导出dmp文件操作步骤
1.切换 oracle用户
sqlplus / as sysdba
2. 连接conn /as sysdba

3.导出数据
exp userTest/userTest@192.168.23.123/de_uav owner=userTest file=userTest-bak.dmp log=exp.log

exp 用户名/密码@192.168.23.123/服务名 owner=用户 file=备份文件名.dmp log=exp.log

二、oracle 数据导入dmp文件操作步骤

1.创建表空间
create tablespace UAV_ROT_5G datafile '/u01/app/oracle/oradata/uav/uav_rot.dbf' size 100M autoextend on maxsize 10G;

create tablespace UAV_ROT_5G datafile '/u01/app/oracle/oradata/uav/uav_rot.dbf' size 100M autoextend on maxsize 10G;

2.创建用户

create user usertest identified by usertest default tablespace UAV_ROT_5G;

3.授权用户
grant connect,resource,dba to usertest;

4.导入数据
imp usertest/usertest@192.168.23.126/uav file=expdat.dmp log=imp.log fromuser=uav touser=usertest ignore=y statistics=none