My Oracle Support Banner

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 to [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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.