Oracle导入数据库方法

Oracle导入数据库方法

在使用oracle导入dmp数据库时的几个步骤如下：

-- 1.创建临时表空间
create temporary tablespace TEST_TEMP
tempfile 'D:\app\data\TEST_TEMP.dbf'
size 50m
autoextend on next 50m 
maxsize 1024m
extent management local
-- 2.创建表空间
create tablespace TEST
datafile 'D:\app\data\TEST.dbf' 
size 3072M
autoextend on 
next 100M maxsize unlimited logging
extent management local autoallocate
segment space management auto;
-- 3.创建用户
create user TEST identified by TEST 
default tablespace TEST
temporary tablespace TEST_TEMP;
-- 4.给用户授权
grant connect,resource to TEST;
grant DBA,resource to TEST;
-- 5.导入数据库
imp TEST/TEST@127.0.0.1/orcl file=D:\backup\TEST.dmp log=D:\backup\TEST.log full=y;