Moving Tables Between Tablespaces Using Traditional Export/Import (EXP/IMP)
(Doc ID 1012307.6)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 7.0 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 15-Dec-2014***
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!