Chapter 4. Schema Object Management ................................................................................. 57
4.1. Overview .................................................................................................................... 57
4.2. Tables ........................................................................................................................ 57
4.2.1. Creating, Altering, and Dropping Tables ............................................................. 58
4.2.2. Efficient Table Management .............................................................................. 63
4.2.3. Viewing Table Data ........................................................................................... 64
4.2.4. Compressing Tables ......................................................................................... 64
4.2.5. INDEX ORGANIZED TABLE ............................................................................. 67
4.3. Constraints ................................................................................................................. 69
4.3.1. Declaring, Changing, and Removing Constraints ............................................... 69
4.3.2. Constraint States ............................................................................................. 73
4.3.3. Viewing Constraint Data ................................................................................... 75
4.4. Disk Blocks ................................................................................................................ 75
4.4.1. PCTFREE Parameter ....................................................................................... 75
4.4.2. INITRANS Parameter ....................................................................................... 76
4.4.3. Parameter Settings .......................................................................................... 76
4.5. Indexes ...................................................................................................................... 77
4.5.1. Creating and Deleting Indexes .......................................................................... 78
4.5.2. Efficient Index Management ............................................................................. 79
4.5.3. Viewing Index Data .......................................................................................... 81
4.5.4. Monitoring Index Usage ................................................................................... 82
4.6. Views ......................................................................................................................... 82
4.6.1. Creating, Changing, and Deleting Views ............................................................ 82
4.6.2. Viewing View Data ........................................................................................... 84
4.7. Sequences ................................................................................................................. 85
4.7.1. Creating, Changing, and Deleting Sequences .................................................... 85
4.7.2. Viewing Sequence Data ................................................................................... 88
4.8. Synonyms .................................................................................................................. 88
4.8.1. Creating and Deleting Synonyms ...................................................................... 88
4.8.2. Creating and Deleting Public Synonyms ............................................................ 90
4.8.3. Viewing Synonym Data .................................................................................... 91
4.9. Triggers ...................................................................................................................... 91
4.9.1. Creating and Deleting Triggers .......................................................................... 91
4.10. Partitions .................................................................................................................. 92
4.10.1. Creating Partitions ......................................................................................... 93
4.10.2. Creating Composite Partitions ......................................................................... 95
4.10.3. Creating Index Partitions ................................................................................ 96
4.10.4. Viewing Partition Data .................................................................................... 97
Chapter 5. User Management and Database Security ............................................................. 99
5.1. Managing User Accounts ............................................................................................ 99
5.1.1. Creating, Modifying, and Removing Users ....................................................... 100
5.1.2. Viewing User Data ......................................................................................... 103
iv Tibero Administrator's Guide
