oracle表空间数据迁移另一个表空间,oracle11g迁移用户数据到其他表空间

oracle11g迁移用户数据到其他表空间

# 环境

操作系统

$ uname -a

Linux jinhu-db02 2.6.32-696.el6.x86_64 #1 SMP Tue Mar 21

19:29:05 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux

$ cat /etc/redhat-release

CentOS release 6.9 (Final)

数据库

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 -

64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE 11.2.0.4.0 Production

TNS for Linux: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - Production

1. 创建所需表空间

CREATE TABLESPACE TBS_PREPAID DATAFILE

'/home/oracle/oradata/orcl/datafile/tbs_prepaid01.dbf' SIZE 8G

AUTOEXTEND ON NEXT 500M;

2. expdp导出整库

expdp \'/ as sysdba\' DIRECTORY=exp_dir

DUMPFILE=expdp_full_