Creating Core Repository for Oracle Designer
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
Last 3 posts in My Reference, OraclePoint
- Troubleshooting 01157 and 01110 errors while recreating Oracle 10g Undo tablespace - June 30th, 2009
- Using Crontab to Create Statspack Reports - April 23rd, 2009
- SQL Injection Testing Tool - November 6th, 2008
Popularity: 46% [?]
August 19th, 2009 at 4:18 pm
This worked great, thanks so much
September 25th, 2009 at 3:39 pm
useful information. It’s really good
September 28th, 2009 at 10:09 am
Such an enjoyable read, and fantastic comments