RelationalDBDesignRelationalDBDesign


Create Database   «Prev  Next»

Running PUPBLD Script - Exercise

Create the product user profile

Objective:Create the product user profile in the COIN database.

Exercise scoring

This exercise is worth a total of five points. It's auto-scored; when you've completed the exercise, click the OK, I'm Done button at the bottom of the page to receive full credit.

Instructions

Run the PUPBLD script to create the product user profile in your COIN database. When you are done, click the Submit button.
Hints
Remember that the script is named PUPBLD.SQL, and that it is found in the sqlplus\admin directory underneath the Oracle home directory. For Oracle12c on Windows, this will likely be
C:\app\OracleHomeUser1\product\12.1. 0\dbhome_1 folder.

On a UNIX system, look in $ORACLE_HOME/sqlplus/admin. With earlier releases of Oracle on Windows NT, you might look in the dbs directory. The location of the file has changed over the years.
Remember that you must log in as SYSTEM in order to run the PUPBLD script.