Extended DB Features
Oracle SQL Extensions
Local Index Partition
Dropping Oracle Partitions
Drop Truncate Partitions
Clustered Tables Advantages
Oracle Hash Cluster
Creating Oracle Cluster
Size Cluster Properly
Oracle Clustering Advantages
Export Table Data
Creating Table Index
Enable Audit Feature
Purge Audit Trail
National Character Set
Creating an index-organized table - Exercise
Creating an index-organized table
Create an index-organized table
This exercise will be graded on your submission to the tutor. You will receive 10 points for this exercise, and you may receive partial credit.
In a previous course, you created a script file with the SQL statements needed to create the tables in your COIN database, complete with additional indexes and constraints. In this exercise, you will write a script that will make one of the tables an index-organized table.
The table you should create is the COIN table, and it contains the following columns:
The primary key for the columns is the
Write a script that will create the COIN table as an index-organized table.
You will write a standard
statement with just a couple of extra keywords.
For the purposes of this exercise, you may assume that the COIN table is appropriate for use as an index-organized table, which may or may not be true, depending on the usage characteristics of the database and its applications.
Submitting your exercise
Submit your answer in the text box below.