Cycles Redo Log Files
Redo Log Info
Extract TS Information
Archive Log List
CKPT Checkpoint Process
dbw0 Database Writer
Writing Dirty Buffers
Oracle Process Monitor
Database Buffer Cache
Oracle Shared Pool
Redo Log File Sizes
CREATE DATABASE command - Exercise
Executing the CREATE DATABASE command
Create your COIN database
Execute your CREATE DATABASE script
This exercise is worth a total of ten points. It is auto-scored; when you have completed the exercise, click the
button at the bottom of the page to receive full credit.
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.
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.