RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing DB Objects
Backup Recovery
Admin Tasks
Create Database
«Prev
Next»
Creation Architecture
SQL*Plus
Describe Command
Spool Command
Database Architecture
Cycles Redo Log Files
Redo Log Info
Extract TS Information
Instance Architecture
Difference instance Database
Instance Overview
Asynchronous Process Coordination
System Global Area
System Monitor Process
Oracle Process Monitor
dbw0 Database Writer
Database Writing Time period
Writing Dirty Buffers
Checkpoint Trigger Database
Limiting Dirty Buffers
lgwr Log Writer
Llog Writing Process
Oracle Archiver Process
Archive Log List
CKPT Checkpoint Process
Other Oracle Processes
Memory Architecture
Database Buffer Cache
Oracle Shared Pool
Large Pool
Program Global Area
PGA DBWR SGA
PGA Contents
SharedServer PGA
Sort Area
Shared Server Areas
Database Creation
Redo Log File Sizes
Config Files
DBCreate Commands
Create Database Command
Create Oracle Service
Running pupbld Script
Starting Oracle Instance
Running PUPBLD Script - Exercise
Create 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 is auto-scored; when you've completed the exercise, click the
Submit
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.
Submit