Setting up Oracle Expert

Suggestions for Creating the Repository

The necessary set of schema objects for the Oracle Export repository are created when the XPOCR.SQL script is run. This script is run with the SMPCRE.SQL script when you create the Oracle Enterprise Manager repository. See "Setting up the Repository" .

Oracle Expert places its repository in the default tablespace of the user account to which you are connected when creating the repository. Because of this, it is recommended that you create a new user account so that the repository can be created in its own tablespace. In addition, as described in the Optimal Flexible Architecture (OFA) Standard, there are several benefits for separating segments into special purpose tablespaces. For this reason, it is recommended that you create a new tablespace and the newly-created user be customized to use this tablespace as its default tablespace.

Note: Because Oracle Expert does not explicitly specify the size of the tables and indexes it creates, these objects are created using the default storage parameters for the tablespace in which they are to be stored. As a result, if the tablespace runs out of space before all of the schema objects are created, an error will occur. In this case, you need to either decrease the INITIAL extent size of the user's default tablespace or increase the overall tablespace size by adding another datafile.

You can use the following suggested steps before you create the Oracle Expert repository:

1. From the Oracle Enterprise Manager program group, double-click on the SQL Worksheet icon to launch the tool. For information on starting Oracle Enterprise Manager and tools, see "Starting Oracle Enterprise Manager" .

2. Using the Login Information dialog box to connect to the administrator account on the database. See "Login Information" .

3. Create a special tablespace for the Expert repository.

CREATE TABLESPACE XP_TS DATAFILE '<datafile>' <size>;

Attention: For an example of how to run a SQL script or enter a SQL command with SQL Worksheet, refer to "Setting up the Repository" .

4. Create an XP user account where the user's default tablespace is the newly-created tablespace and the user's temporary tablespace is a tablespace dedicated to temporary segments.

CREATE USER XP IDENTIFIED BY <password> 
       DEFAULT TABLESPACE XP_TS 
       TEMPORARY TABLESPACE <temporary_tablespace>; 

5. Grant the CONNECT and RESOURCE roles and the SELECT ANY TABLE privilege to this user account.

GRANT CONNECT, RESOURCE, SELECT ANY TABLE TO XP;

6. Disconnect from the administrator account.

DISCONNECT;

7. Exit SQL Worksheet.

Running XPVIEW.SQL