How To Import Objects Into Different Tablespace Other Than From Which They Have Exported (Doc ID 285417.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 9.2.0.7 - Release: 8.1.7 to 9.2
Information in this document applies to any platform.

Goal

1. Moving a particular user's tables from one tablespace to another.
2. Importing objects into different tablespace other than from which they have exported

Import decides a tablespace to create objects as following:

- if a user's quota allows it, the user's tables are imported into the same tablespace from which they were exported. However, if the tablespace no longer exists or the user does not have the necessary quota, the system uses the default tablespace for that user as long as the table is unpartitioned, contains no LOB or VARRAY columns, is not a type table, and is not an index-only table with an overflow segment.

Solution

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 hundreds of Community platforms