Oracle Tools for Application and Database Modeling and Design

Preparation (NT) (95/98)| Generation | Usage | Common Problems

Generating a Designer 2000 Repository

Step 1: Log on to Oracle

You are now ready to begin the process of creating the repository. Open up the Repository Administration Utility and log in with the owner account you just created (Figure 2.1, 2.2).

Figure 2.1: The Designer 2000 Repository Administration Utility Connect Dialog

Figure 2.2: Designer 2000 Repository Administration Utility with no Repository Installed

Step 2: Installation Setup and Pre-Check

Hit the install button. A dialog will pop up asking what tablespaces are to be used in creating the repository (Figure 2.3). The ones on the left are for the indexes, so use the index tablespace (des2_i in the example) for all of the index tablespaces. Make sure the table tablespace(des2 in the example) is selected for each of the ones on the right. If you are the only one using this repository, go with a small size repository, you will see better performance. Hit the 'pre-check' button to make sure all required privileges are met (Figure 2.4). If they are, hit 'OK' and you are ready for installation.

Figure 2.3: Repository Tablespace Setup

Figure 2.4: Operation Requirements Pre-Check (everything looks ok!)

Step 3: Begin the Installation

'Start' will get the process going. What follows is about 2-3 hours (depending on processor) of automated scripting in which you do not need to be in front of your computer (Figure 2.5). (A common error ocurrs here in which the SGA has not been adequately expanded to handle the repository installation. See ORA-04031 - Unable to allocate bytes of shared memory if you receive this error.) WARNING: Do not e xecute any SQL statements during this process... doing so may cause irreparable damage to the repository (Figure 2.6). Wait until the repository generation is complete before moving on to the next step (Figure 2.7).

Figure 2.5: Import Script Execution

Figure 2.6: Installation Status

Figure 2.7: Installation Complete!

Step 4: Creating the Manager and User Accounts

Do not use the owner account to access Designer 2000 as a user. At a minimum, create 2 accounts (a manager and a user) for the application systems we will be creating. These users will need tablespace for both permanent tables as well as temporary worki ng tables. Look back at our tablespace listing:

select tablespace_name, sum(bytes)/1024/1024 from dba_free_space group by tablespace_name;
notice the tablespace USER_DATA. You could use this as the default tablespace for the manager and user account, but creating a new tablespace for these accounts will provide more flexibility should you need it. Just like you created the des2 and des2_i tablespaces, create one for use as the default user space for the accounts. For example:

create tablespace des2_users datafile 'd:\orant\database\des2users.ora' size 50M default storage (initial 100k next 100k pctincrease 5);
will create a 50MB tablespace, plenty of room for tables (Figure 2.8). Similar to the owner account, the statements:

create user rep_manager identified by demo default tablespace des2_users temporary tablespace temporary_data;

create user rep_user identified by demo default tablespace des2_users temporary tablespace temporary_data;
will create the repository manager and user accounts. One important note before granting privileges to the user accounts... when you created the owner account, you issued a grant resource statement on that account. This created an unlimited quota for the user on the default tablespace (des2). Should you want the manager and user accounts to have unlimited quota on their respective default tablespace, go ahead and issue the statements (Figure 2.9):

grant resource to rep_manager;
grant resource to rep_user;
Should you want to put quotas on these user accounts (for instance, if you have multiple user accounts), issue the statement (Figure 2.10):

alter user [account] quota [limit]M on [default tablespace];
So for the example, the statements:

alter user rep_user quota 10M on des2_users;

alter user rep_manager quota 10M on des2_users;
would create 10MB quotas on the des2_users tablespace for both accounts.

Figure 2.8: Create the Default Tablespace and Accounts

Figure 2.9: Setting Unlimited Quotas

Figure 2.10: Setting Specific Quotas

Step 5: Setting Manager and User Account Privileges

Each account needs 5 privileges to work in Designer 2000, create session, alter session, create table, create synonym, and create sequence. For example:

grant create session, alter session, create table, create synonym, create sequence to rep_manager;

grant create session, alter session, create table, create synonym, create sequence to rep_user;
will grant all required privileges to the accounts (Figure 2.11).

Figure 2.11: Granting Privileges for the Manager and User Accounts

NEXT: Using the Designer 2000 Repository

Main Page About the Book Student Resources Oracle Resources Instructor Resources Contact Us

1999 Prentice-Hall, Inc., A division of Pearson Education, Upper Saddle River, New Jersey 07458 Legal Statement
Comments should be directed to