AnsweredAssumed Answered

Copy data Production development to Development environment

Question asked by cris.perezcoll on Feb 22, 2012
Latest reply on Feb 27, 2012 by fpena
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

Outcomes