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!

import only tables by excluding views

ora_learner36Aug 25 2020 — edited Aug 26 2020

Hi All,

Hope all are doing good.

I have exported a completed schema in a test.dmp using exp utility.

Now I want to import only the schema tables(250 tables) from the test.dmp file but not its views because views are already there in the database.

How can i achieve this?

Your help will be appreciated, thanks in advance.

EBS:12.1.1

DB:11.2.0.3

OS:RHEL 6

This post has been answered by L. Fernigrini on Aug 25 2020

Jump to Answer

Added on Aug 25 2020

#general-database-discussions

3 comments

845 views