导入oracle数据库

导入数据库
第一步骤：先用最大权限用户登录创建数据库目录
dos 命令中执行以下语句
sqlplus /  nolog；
conn / as sysdba;
create or replace directory dumpdir as 'E:\数据库备份文件'; 
grant read，write on directory dumpdir to public;


sqlplus 客户端执行
--删除用户
drop user test1 cascade;


--删除空间
drop tablespace test1 including contents and datafiles;



/*第2步：创建数据表空间  */


create tablespace test1 
logging  
datafile 'E:\oracleDBF\test1.dbf' 
size 50m  
autoextend on  
next 50m maxsize 10240m  
extent management local uniform size 1024k;



--创建用户

CREATE USER "test1"  IDENTIFIED 
BY "12345" DEFAULT TABLESPACE "test1" 
TEMPORARY TABLESPACE "TEMP" 
ACCOUNT UNLOCK;


--赋权限
grant connect,resource to test1;
grant select any table to test1;
grant select any dictionary to test1;
grant dba to test1;


dos 命令执行
导入实例：impdp test1/12345@orcl DIRECTORY=dumpdir DUMPFILE=test1.dmp



第二种导入方法
imp test1/12345@orcl file=E:\test1.dmp  ignore=y rows=y full=y;