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
תגיות
- Oracle (Computer file)
- Oracle7.3
- Oracle 7.3
- Personal Oracle7
- Personal Oracle 7
- Database management.
- Relational databases.
- nne Relational data bases
- nne Data base management
- Data services (Database management)
- Database management services
- DBMS (Computer science)
- Generalized data management systems
- Services, Database management
- Systems, Database management
- Systems, Generalized database management
יודעים עוד על הפריט? זיהיתם טעות?