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;
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;