How To Import Objects Into Different Tablespace Other Than From Which They Have Exported
(Doc ID 285417.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Server - Enterprise Edition - Version: 126.96.36.199 to 188.8.131.52 - Release: 8.1.7 to 9.2
Information in this document applies to any platform.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!