Re: triggers don't get exported, dba jobs don't run

1. verify that JOB_QUEUE_PROCESSES is above 0 in your init.ora (or alter system set job_queue_processes = n where n > 0). You may also want to play with JOB_QUEUE_INTERVAL for setting appropriate wakeup schedule for SNPx processes.
2. Sounds like a bug to me. What's your patch level? I would strongly recommend upgrading at least to 8.1.7.1 (with 8.1.7.3 being the latest patch level) both servers and clients (since exp and imp are part of client).

--
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"Peter Diesner" <peter.diesner_at_gmx.de> wrote in message
news:a4rchc$2gltp$1_at_ID-47957.news.dfncis.de...


> Hi,

> we migrated from 8.0.x under Novell Netware to 8.1.7 under Redhat 6.2.

>

> Now we've got two problems:

>

> - database jobs (dba_jobs package) don't run although they should

> - when I export the database (either fill database export or all objects of

> an specific user) and import the resulting dump into another 8.1.7

> database, the triggers get lost

>

> Do you have an idea how to solve this problems ?

>

> Thx

>

> Peter