חזרה לתוצאות החיפוש

Oracle 10g/11g data and database management utilities [electronic resource]

להגדלת הטקסט להקטנת הטקסט
  • ספר

Master 12 must-use Oracle Database Utilities with this book and eBook

כותר Oracle 10g/11g data and database management utilities [electronic resource] : master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database task / Hector R. Madrid.
מוציא לאור Birmingham, U.K. : Packt Publishing Ltd.
שנה 2009
הערות Includes index.
English
הערת תוכן ותקציר Cover
Table of Contents
Preface
Chapter 1: Data Pump
Data Pump features
Data Pump architecture
Setting up the practical scenarios
Data Pump export
Data Pump export modes
A simple Data Pump export session
Data Pump export filtering operations
Use of parameter file
Retrieve original data
Data Pump export space estimation
Dump file multiplexing
Transporting data among different versions
Data Pump export interactive mode
Data Pump restart capability
Getting information about the export job
Data Pump import
Remap function
Data Pump import network mode
Improving performance with Data PumpWorking with the Data Pump API
Data Pump 11g new features
Compression
Encrypted dump file sets
Enhancements for Data Pump External Tables
Single partition transportable for Oracle Data Pump
Overwrite dump files
XML Datatypes
Summary
Chapter 2: SQL*Loader
SQL*Loader basics
Preparing the demo environment
Our first simple load
The SQL*Loader log file
Fixed record size format load
Variable record size format load
Stream record format load
Specifying a particular character set
Load on the fly
Direct path versus Conventional path load
Direct path load prosDirect path load cons
Loading Large Objects (LOBs)
Loading multimedia files
Resumable load
Parallel load
General performance booster tips
Chapter 3: External Tables
The External Table basics
Let's setup the environment
A basic External Table
Creating External Table metadata, the easy way
Unloading data to External Tables
Inter-version compatibility
Data transformation with External Tables
Extending the alert.log analysis with External Tables
Reading the listener.log from the database
Mapping XML files as External Tables
Dynamically changing the external referenceOracle 11g External Table enhancements
Chapter 4: Recovery Manager Advanced Techniques
Recovery Manager basics
Getting started with a Recovery Manager session
Format masks used by recovery manager
What happens in a user-managed online backup?
Myths related to the online backup method
Configuring a multiplexed backup
Configuring the RMAN recovery catalog
A simple backup session
Backup compression
Fast backup compression
Improving data set compression with the ZLIB algorithm (11g only)
Faster backups through intra-file parallel backup and restore operations (11g only)Block media recovery
Backup duration and throttling
Database cloning
Database cloning procedure
Database cloning on the fly (11g only)
Inter-platform database migration
Migrate to and from an ASM environment
General backup advices
Chapter 5: Recovery Manager Restore and Recovery Techniques
Oracle database recovery
Instance failure
Media failure
Complete recovery
Incomplete recovery
Loss of data files
Queries used to diagnose data files
Loss of a non-critical datafile
Loss of a temporary datafile
סדרה From technologies to solutions
היקף החומר 1 online resource (432 p.)
שפה אנגלית
מספר מערכת 997010704309405171
תצוגת MARC

יודעים עוד על הפריט? זיהיתם טעות?