1：创建临时表空间 create temporary tablespace ZLQHWEB0203 tempfile 'D:\app\Administrator\oradata\orcl\ZLQHWEB0203.dbf' size 1500m autoextend on next 50m maxsize 20480m extent management local; 2：创建数据表空间 create tablespace ZLQHWEB logging datafile 'D:\app\Administrator\oradata\orcl\ZLQHWEBdbf' size 1500m autoextend on next 50m maxsize 20480m extent management local; 第3步：创建ZLQHWEB用户并指定表空间 create user ZLQHWEB identified by ZLQHWEB default tablespace ZLQHWEB temporary tablespace ZLQHWEB0203; 第4步：给ZLQHWEB用户授予权限 grant connect,resource,dba to ZLQHWEB; 服务器存放要导入数据文件的目录 CREATE OR REPLACE DIRECTORY DATA_PUMP AS '服务器存放要导入数据文件的目录'; CREATE OR REPLACE DIRECTORY DATA_PUMP AS 'D:\app\dump' 导入: impdp 用户名/密码 DIRECTORY=DATA_PUMP(服务器存放要导入数据文件的目录) DUMPFILE=zlqhweb_20170627_23.dmp(导入的文件名) LOGFILE=zlqhweb_20170627_24.LOG （日志） REMAP_SCHEMA=从什么用户（原表用户）:到什么用户 REMAP_TABLESPACE=原表空间:现有表空间 version=10.2.0.1.0 impdp ZLQHWEB/ZLQHWEB DIRECTORY=DATA_PUMP DUMPFILE=zlqhweb_20170627_23.dmp LOGFILE=zlqhweb_20170627_24.LOG REMAP_SCHEMA=SYS:ZLQHWEB REMAP_TABLESPACE=ZLQHWEB:ZLQHWEB version=10.2.0.1.0 出现错误 ora-01918 sqlplus /nolog 创建报错用户 create user ZLQHWEB0203 identified by ZLQHWEB0203 default tablespace ZLQHWEB temporary tablespace ZLQHWEB0203; sp2-0640 未连接 conn /as sysdba 赋权 grant connect,resource,dba to ZLQHWEB0203;
转载请注明原文地址: https://www.6miu.com/read-77129.html
