Database Utilities (MOSC)

MOSC Banner

Tablespace import

edited Mar 9, 2017 10:01AM in Database Utilities (MOSC) 3 commentsAnswered ✓

Hello all,

We are trying to import one tablespace to other tablespace in same database.

The one which we are trying to import doesnot have separate TABLE and INDEX physical file.

While importing it is throwing error as target tablespace have separate table and index physical files.

;;;
Import: Release 12.1.0.2.0 - Production on Fri Feb 17 13:56:07 2017

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01": 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center