Skip to Main Content

Database Software

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Extend the import/export Statement

Imran amjadApr 11 2018 — edited Apr 11 2018

Hi,

Problem Description:

While importing an oracle schema dump from one machine to another machine for my specific task, i needed from oracle that there should be some parameter(s) in the exp/imp statement that allow me to specify some specific type(s) (e.g setup/master tables in nature of their data or transactions tables in nature of their data) of table(s) to be exported/imported.

Suggestion:

There can be a flag on table level while creation or after where developer can specify that this table is a master/setup table in its data nature and another one is transaction nature and there could be more types of tables... so that when i start my export/import job i should be able to specify a parameter in the export/import statement that i am going to dump those tables which are master/setup or transaction in nature etc... so only those tables are exported/imported. It will ease the job when i need some specific type of tables to be exported/imported. 

Thanks,

Imran Amjad

Comments
Post Details
Added on Apr 11 2018
2 comments
156 views