orcle导入导出

CREATE TABLESPACE TABLESPANCE_SZPrison
DATAFILE ‘D:\TABLESPANCE\SZPrison.DBF‘ SIZE 1000M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
CREATE USER &userName IDENTIFIED BY &password DEFAULT TABLESPACE TABLESPANCE_SZPrison; 
GRANT CREATE TABLE,CREATE VIEW,CREATE TRIGGER, CREATE SEQUENCE,CREATE PROCEDURE TO &userName;
GRANT UNLIMITED TABLESPACE TO &userName;
GRANT CREATE SESSION TO &userName;
GRANT SELECT ON V_$STATNAME to &userName;
GRANT SELECT ON V_$SESSTAT to &userName;
GRANT SELECT ON V_$SESSION to &userName;
GRANT SELECT ON V_$MYSTAT to &userName;
EXIT;

1、登录到当前数据库 sqlplus sys/orcl as sysdba

2、创建用户 create user dev_szprisonwifi identified by dev_szprisonwifi;

3、授权 grant connect to dev_szprisonwifi;

4、测试连接 sqlplus dev_szprisonwifi/dev_szprisonwifi

5、导入dmp文件 C:\Users\cassi>imp dev_szprisonwifi/dev_szprisonwifi file=‘E:\深圳监狱201601\201 6.dmp‘ fromuser=dev_szprisonwifi touser=dev_szprisonwifi

导出

C:\Users\Administrator>exp dev_szprisonwifi/dev_szprisonwifi file=‘E:\Lightrain\ dump\2016.dmp‘ owner=dev_szprisonwifi                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       

orcle导入导出

原文：http://www.cnblogs.com/huideng/p/5142660.html