Done. Using Grid Infrastructure and Data Movement Tools

A set of vocabulary flashcards focused on data movement and grid infrastructure tools in Oracle Database 12c.

Data Pump

A high-performance data movement tool that unloads and loads data between Oracle databases.

SQL*Loader

A tool that loads data from flat files into Oracle database tables.

External Tables

Tables with data that does not reside in the database, used with SQL*Loader for data manipulation.

Automatic Storage Management (ASM)

A volume manager and storage management solution for Oracle database files.

Oracle Restart

A feature to automatically manage the startup and monitoring of Oracle components in standalone servers.

Migration

The process of moving data from one database or schema to another using tools like Data Pump.

Fill Factor

The storage space allocated for data blocks to optimize performance.

Dump Files

Files that contain extracted data and metadata used during the Data Pump operation.

Master Table

A table maintained by Data Pump that contains job status and object information.

Service Name

The alias for a database instance used by Oracle services during runtime.

Network Mode Import

A method to import data directly from a remote database using a database link.

Temporary Files

Files that are created during operations but are not retained after completion.

Data Access Method

Methods used by Data Pump to load or unload data, which can be direct path or external table access.

ASM Instance

An instance specifically for managing Automatic Storage Management in Oracle.

Redundancy in ASM

Refers to how data is stored on disks; options include Normal, High, and External redundancy.

Database Link

A reference that allows a database to connect to another database for data access.