新增文章

文章标题分类内容

-- 创建表空间
create tablespace GYSY datafile 'D:\Oracle11g\oradata\orcl\GYSY.dbf' size 10240m autoextend on next 50m maxsize 15360M;

-- 创建零食表空间
create temporary tablespace GYSY_TEMP tempfile 'D:\Oracle11g\oradata\orcl\GYSY_temp.dbf' size 50m autoextend on next 50m maxsize 15360M;

-- 创建用户并制定默认表空间和临时表空间
CREATE USER "GYSY" PROFILE "DEFAULT" IDENTIFIED BY "orcl" DEFAULT TABLESPACE "GYSY" TEMPORARY TABLESPACE "GYSY_TEMP" ACCOUNT UNLOCK;

-- 用户分配权限
GRANT CREATE ANY TABLE TO "GYSY";
GRANT UNLIMITED TABLESPACE TO "GYSY";
GRANT "CONNECT" TO "GYSY";
GRANT "RESOURCE" TO "GYSY";
GRANT CREATE ANY VIEW TO "GYSY";
GRANT dba TO "GYSY";

-- 第一次需要创建备份文件目录
create directory impdp_dir as 'D:\Oracle11g\impdata';

-- 用户分配目录权限
grant read,write on directory impdp_dir to "GYSY";

-- 执行导入
impdp GYSY/orcl@orcl table_exists_action=replace directory=impdp_dir dumpfile=SXRQ20200617.DMP logfile=impdp.log remap_tablespace=NNC_DATA01:GYSY,TEMP:GYSY_TEMP remap_schema=SXRQ63:GYSY

-- 如果数据库超过创建时设置的最大内存，修改最大内存
ALTER DATABASE DATAFILE 'D:\Oracle11g\oradata\orcl\GYSY.dbf' AUTOEXTEND ON NEXT 50M MAXSIZE 20480M;

-- 或者添加存储文件
alter tablespace NNC_INDEX01 add datafile 'D:\Oracle11g\oradata\orcl\NNC_INDEX02.DBF' size 1000M autoextend on next 50M maxsize unlimited;