We have made a copy of production data to development environment, and now the jobs do not work.
We made the following steps:
1. Create a copy of production database: export NLS_LANG=AMERICAN_AMERICA.UTF8
exp userid=system/******@CLARITY owner=clarity file=exp.dmp log=exp.log
2. Copy production database to development
drop user CLARITY cascade;
exit;
create user CLARITY
identified by CLARITY
default tablespace USERS
temporary tablespace TEMP;
grant RESOURCE, CREATE SESSION, CONNECT to CLARITY;
grant UNLIMITED TABLESPACE, QUERY REWRITE to CLARITY;
grant CREATE TABLE, CREATE VIEW, CREATE TRIGGER to CLARITY;
grant DBA to CLARITY;
commit;
exit;
imp userid=system/****** fromuser=CLARITY touser=CLARITY file=exp.dmp log=imp.log
3. Reinstall all services with NSA.
Anyboy makes a copy of database and go ok?What steps are done?
Tkanks very much