• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2555
  • Last Modified:

Oracle Import Option

How to ommit import of triggers and procedures from the Oracle import (dmp) file
0
tribuna33
Asked:
tribuna33
  • 2
2 Solutions
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
for triggers you can say

triggers=N

along with the other import options.

Thanks
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
i am sorry you have to use that while exporting, so that your export dump file will not have triggers.

triggers=N -- is an option which should be given for export utility and not for import utility

While importing, since there will not be any triggers in the export dump file - we will not get them. I think we do not have an option in the import utility to restrict triggers.

Why not we just exclude the triggers and procedures which we do not want when exporting itself.

Thanks
0
 
sdstuberCommented:
if re-exporting isn't possible, or feasible

you can set ignore=Y  then remove the create trigger and create procedure privileges from the user doing the import.

it'll try to import them, but it will fail, but with ignore=Y you can continue.  
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now