Moving Tables Between Tablespaces Using Traditional Export/Import (EXP/IMP)
(Doc ID 1012307.6)
Last updated on JANUARY 30, 2022
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 7.0 to 12.1]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
This article discusses three ways you can move tables from one tablespace to another tablespace using traditional Export/Import utilities (exp/imp). Alternative methods exist to achieve this see:
A. On a Per Table Basis
B. On a Per User Basis
C. From user A to user B
A worked example can be seen later in the article for each of the scenarios.
It defines the steps required when moving tables from one tablespace to another. These steps require a SQL*Plus account with DBA privileges to set-up the appropriate user privileges
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!