• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2556
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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