Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

export import schema from one DB to another DB

573157Apr 20 2007 — edited Apr 20 2007

hello all,

In DB1 we have schema1 with tables being in one tablespace and indexes in another.
Same for schema2 in DB2.

Actually, for all our schemas in all DBs, we have a tablespace for tables and another for indexes.

Is there a way to import schema1 to schema2 with the tables going directly to the tablespaces of tables and indexes going directly to the tablespace of indexes?

We are using Oracle9.2.0.6.0

Many thnx,
Hiruya

Locked Post

New comments cannot be posted to this locked post.

Locked on May 18 2007

Added on Apr 20 2007

#general-database-discussions

5 comments

590 views