RelationalDBDesign
Technology
Search
SiteMap
RedhatLinuxSys
Seomining
Advanced Oracle Tuning
Advanced SQL
Backup Recovery Options
Basic SQL
DB Admin Features
DB Creation Architecture
Extended DB Features
Managing DB Objects
Managing Connectivity
Network Configuration
Oracle BU Features
Oracle DB Recovery
Network Administration
Oracle Network Topology
Oracle SQL Extensions
Oracle SQL Tuning
8i PL/SQL Programming
Performance Tuning
PL/SQL Stored Objects
PL/SQL Programming
Relational DB Analysis
Relational DB Design
Tech Interview Questions
Tuning Oracle Instance
PL/SQL Objects
User Defined Functions
Creating Oracle Procedure
Creating Oracle Trigger
Using Oracle Parameters
Download Course Project
Download the Course Project file
Objective:
Download the Course Project files for all exercises and the optional files for On-Your-Own exercises
This exercise is not scored and is an optional exercise.
When you have completed the exercise, click the
Submit
button.
Follow these steps to complete the exercise:
Click the link below.
PetStore Link
Your browser will ask you what you want to do with the file. Choose to save it to disk.
Specify that the file be saved on the C:\ drive.
This is the default folder for Windows Vista or Windows 7.
Right mouse click the file to edit the file with your editor.
If you do not have an Oracle database to use during the course, skip the rest of these steps. Otherwise, continue with these steps to install the Course Project on your database.
Open the petstore.sql file in a text editor.
A few lines into the script is the following line:
CONNECT PETSTORE/GREATPETS;
This line only works if you run Oracle on your own computer.
If you are running on a networked database, modify the line to include your database server name. For example, if your database server was named
FRANCE
, modify the line to say:
CONNECT PETSTORE/GREATPETS@FRANCE;
Save the file with the change. Keep the same name for the file.
Get to a command prompt and change directories to the directory where you stored your file.
If you are running on Windows , select Start/Programs/Accessories/ Command Prompt.
On Unix, start a terminal window if needed.
The command for changing to a directory in Windows and Unix is:
cd directoryname
Be sure to type the full path of the directory.
Type this command at the operating system prompt:
Sqlplus username/password@server
You must log in as a valid Oracle DBA.
The default user name and password of the Oracle DBA is SYSTEM and MANAGER.
If you are using a database on your local computer, you can leave out the "@server" portion.
Otherwise, fill in the name of the database server on your network. This starts up SQL*Plus.
You will see a prompt that looks like this:
SQL>
Execute the complete script by typing this line and pressing ENTER:
start petstore.sql
When the script is done, you will automatically return to your operating system prompt.
Exit the operating system window (not always needed in Unix) by typing
EXIT
and pressing ENTER.
You now have installed the PETSTORE user and its data in your Oracle database.
For the purposes of this course, we will assume that you have placed your course downloads in the My Documents folder.
If you have Windows NT, or choose to place it elsewhere, make a note of the folder name so you can find it later.