oracle导入导出

进入cmd-->

sqlplus
   sys
   as sysdba

删除表空间:

DROP TABLESPACE TSEVE_DATA INCLUDING CONTENTS AND DATAFILES;
创建表空间:
create tablespace TSEVE_DATA
logging  
datafile ‘D:\allworkplace\oracleWS\TSEVE_DATA.dbf‘
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;  
创建用户:create user networksec identified by networksec
          default tablespace TSEVE_DATA ;
给权限:grant dba to networksec;
删除用户:drop user networksec cascade;
导入数据库:
imp scott/tiger@orcl file=D:\test.dmp full=y

导出远程数据库:exp username/password@192.168.200.77/orcl file=d:\pp.dmp

导出本地数据库:exp username/password@orcl file=d:\pp.dmp

将相应的用户名密码改下即可。

oracle导入导出

标签：