RelationalDBDesign
SiteMap
Database Analysis
Database Design
Extended DB Features
Oracle SQL Extensions
Index Organized
«Prev
Next»
Extended Features
Partitioned Tables
Oracle Partitioning Explained
Partitioning Advantages
Database Partitioning
Table Range Partitioning
Index Partitioned Table
Local Index Partition
Global Index Partition
Modifying Partition Features
Dropping Oracle Partitions
Drop Truncate Partitions
Splitting Merging Partitions
Clustering Tables
Clustered Tables Advantages
Clustered vs Non-Clustered
Oracle Clustering Advantages
Creating Oracle Cluster
Size Cluster Properly
Creating Cluster Key
Oracle Hash Cluster
Creating Hash Cluster
Deleting Hash Cluster
Clustering Conclusion
Index Organized
Index Organized Tables
Advantages Disadvantages IOT
Creating Table Index
Allocate Overflow Space
Deleting Altering IOT
Reorganize IOT
Export Data IOT
Export Table Data
IOT Conclusion
Auditing Features
Auditing Oracle Entities
Enable Audit Feature
Audit SQL Statement
Access Audit Trail
Oracle System Privileges
Auditing Database Objects
Purge Audit Trail
Language Support
National Character Set
Using Profiles
Product Profile
Profile Table
Limit Command Access
Security Scheme
SQL WildCards
SQL Wildcard Characters
Removing Restriction
Target Profile
SqlPlus Utility
Creating index-organized Table - Exercise
Creating an index-organized table
Objective:
Create an index-organized table
Exercise scoring
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.
Background/overview
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:
coin_id: NUMBER
coin_date: DATE
mint_mark: VARCHAR2(20)
series: VARCHAR2(20)
denomination: VARCHAR2(10)
variety: VARCHAR2(20)
grade: VARCHAR2(10)
owner_client_id: NUMBER
country: VARCHAR2(20)
The primary key for the columns is the
coin_id
column.
Download files
Instructions
Write a script that will create the COIN table as an index-organized table.
Hints
You will write a standard
CREATE TABLE
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.
x