Oracle Point, Oracle Life.

Applied to: Oracle Developer Suite 10.1.2.0.2

Oracle Developer Suite As an important database design tool, Oracle Designer is used to implement oracle database design and ER planning. To have Oracle Designer working, it’s required to create a Core Repository before using it.

To create Core Repository, go Oracle Developer Suite – DevSuiteHome –> Designer –> Repository Administration Utility. With successful logging on the target database where you want to create repository, you can start to install new repository via that utility. But, before you start to do it, it’s better to explicitly grant following privileges to repository owner as oracle DBA role:

• EXECUTE ON DBMS_LOCK
• EXECUTE ON DBMS_PIPE
• SELECT ON DBA_ROLLBACK_SEGS
• SELECT ON DBA_SEGMENTS
• SELECT ON V_$NLS_PARAMETERS
• SELECT ON V_$PARAMETER

Ignoring explicit granting might results in the following problem while creating new core repository:

• ORA-04063: package body “SCOTT.JR_WORKAREA” has errors

Even we can do re-compilation after repository is created by granting necessary privileges to repository owner, it’s still strongly recommended to do it before we create repository.

In addition, after core repository is created, it’s very likely that attempt to log on Designer would fail with following error:

• CDR-20043: Non-versioned repository has no workarea or insufficient privileges

Popularity: 57% [?]