Please enable JavaScript.
Coggle requires JavaScript to display documents.
Topic 3 : Managing Tables, Indexes and Constraints (3.1 Managing DB…
Topic 3 : Managing Tables, Indexes and Constraints
3.1 Managing DB storage
View DB storage structure information
Database storage task
Creating tablespace
Modifying tablespace
Dropping tablespace
Reclaiming unused space
Various DB storage structure
Online Redo Log Files
Rollback segments
Control Files
Data Files
Tablespace
Managing Online Redo Log
What is DB storage structure?
Managing Undo Data
3.2 Managing schema objects
What is schema object?
Schema Object Management Privileges
3.5 Managing Views
Displaying views
Deleting views
Create views
3.4 Managing Indexes
Viewing indexes
Deleting indexes
Create indexes
Index attributes
Indexes and performance
3.3 Managing tables
Viewing Table Data
Modifying table attributes
Viewing tables
Deleting a table
Create tables
Table Column Attributes
Table level constraints
Table types