New User ? Sign Up  |  Sign In  |  Help
ask
Ask whatever question, you wish. Make sure you select the correct category for the question.
answer
Like to help other, then browse through the open questions to answer their questions.
discover
Find answer by browsing the resolved questions.
     
Search for questions :
My Profile
Categories

soniasaxena

Open Question Bookmark and Share

Attempt of importing triggers and DBMS_JOBS failed. How can I rectify it?

Hello friends, I have faced a problem while importing multiple schema into one schema. I have database that has 8 users, and to perform the action I have taken the dump and database and tried to import all the schemas into one schema one by one. But after performing the import operation I am unable to find some objects like triggers and DBMS_JOBS.
When I checked the log files I found that tables and views don’t exist and triggers failed to import. Regarding DBMS_JOBS I didn’t found any log file. I don’t know why this type of behavior is shown by Oracle database. Please help me to resolve this issue. Any help or suggestion will be greatly appreciated. Thanks in advance.

766 day ago

    Comment(s) (0)
    Report Abuse
   Find Intereseting  
   E-Mail to Friends  
   Bookmark  
   Subscribe to Answer Alert  
No comments yet !!!     Be the first to comment
Answers (1)

mariawillson 		This type of behavior shown by Oracle database rarely and according to me the triggers are failed because of the tables that was created against were not in a schema. And if the DBMS_JOBS package is not visible or is not present then you can import it using the INDEXFILE option which generates a script showing all the objects and further more you can use this to recreate the missing triggers and job definition. And for the missing error, I expect due to failure error has caused. This error message will not be rectified using any inbuilt utilities so, you need to use any third party Oracle Database Repair software to repair the Oracle database.
I hope your problem will be resolved using this software.

All the best!


Posted 766 days ago

( 0 )
( 0 )
    Comment(s) (0)
   Report Abuse
No comments yet !!! Be the first to comment on this answer !!!

Email this question link to friends
You must enter email-address, if name is entered and vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
Max Allowed : 5000 Characters Current Count : 0
  Your comment on this answer
Max Allowed : 5000 Characters Current Count : 0