Managing Database Storage Structures

Practice Labs Module
Time
1 hour
Difficulty
Intermediate

This module on "Managing Database Storage Structures" explores the concepts of logical and physical storage structure. You will also learn space management and the various types of tablespaces: Creating and Managing Tablespaces, Performing Operations.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Overview

Introduction

This module on Managing Database Storage Structures explores the concepts of logical and physical storage structure. You will also learn space management and the various types of tablespaces.

  • Creating and Managing Tablespaces
  • Performing Operations

Exercise 1 - Creating and Managing Tablespaces

In this exercise you will learn the following about creating and managing tablespaces:

  • Establishing connection to the database
  • Creating and maintaining tablespaces
  • Creating BIGFILE and SMALLFILE tablespaces
  • Working with Oracle Managed File tablespaces
  • Implementing extent management
  • Implementing segment space management
  • Choosing alternative tablespaces options
  • Creating temporary tablespaces
  • Creating UNDO tablespaces
  • Removing tablespaces
  • Modifying tablespaces
  • Obtaining tablespace Information
  • Performing operations on data files
  • Using Oracle Managed Files features
  • Querying data file information

Exercise 2 - Performing Operations

In this Exercise, you will learn how to:

  • Perform operations on data files
  • Use Oracle managed files features
  • Query data file information
Learning Partner
Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.