Create Database   «Prev  Next»

CREATE DATABASE command - Exercise

Executing the CREATE DATABASE command

Create your COIN database

Objective: Execute your CREATE DATABASE script

Exercise scoring

This exercise is worth a total of ten points. It is auto-scored; when you have completed the exercise, click the Submit button at the bottom of the page to receive full credit.

Instructions

It is time for you to create your COIN database. Execute the CREATE DATABASE script that you have written. If you have problems that you cannot resolve on your own, e-mail the spool file to the cyborg for help. Otherwise, click the Submit button after you create the database.

Hints

Remember to connect to the COIN instance with Server Manager and to start it using the STARTUP NOMOUNT command.
If you previously started the instance, and then exited Server Manager, you will need to reconnect before you run the CREATE DATABASE script.
Remember to spool the output from the script in case you need it for debugging purposes.
If your command fails and you need to retry it, you will need to delete any control files, redo log files, and datafiles that may have been created before the failure occurred.