导入数据库
第一步骤:先用最大权限用户登录创建数据库目录
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;
第一步骤:先用最大权限用户登录创建数据库目录
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;