LEADER 04799nam 2200649Ia 450 001 9910456640303321 005 20200520144314.0 010 $a1-282-17234-4 010 $a1-84719-629-2 010 $a9786612172342 035 $a(CKB)2430000000040707 035 $a(EBL)956356 035 $a(OCoLC)697738900 035 $a(SSID)ssj0000349330 035 $a(PQKBManifestationID)12126068 035 $a(PQKBTitleCode)TC0000349330 035 $a(PQKBWorkID)10348388 035 $a(PQKB)11123866 035 $a(MiAaPQ)EBC956356 035 $a(PPN)228026210 035 $a(Au-PeEL)EBL956356 035 $a(CaPaEBR)ebr10433560 035 $a(CaONFJC)MIL217234 035 $a(EXLCZ)992430000000040707 100 $a20090828d2009 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aOracle 10g/11g data and database management utilities$b[electronic resource] $emaster twelve must-use utilities to optimize the efficiency, management, and performance of your daily database task /$fHector R. Madrid 210 $aBirmingham, U.K. $cPackt Publishing Ltd.$d2009 215 $a1 online resource (432 p.) 225 1 $aFrom technologies to solutions 300 $aIncludes index. 311 $a1-84719-628-4 327 $aCover; 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 327 $aImproving 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 327 $aDirect path load prosDirect path load cons; Loading Large Objects (LOBs); Loading multimedia files; Resumable load; Parallel load; General performance booster tips; Summary; 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 327 $aDynamically changing the external referenceOracle 11g External Table enhancements; Summary; 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) 327 $aFaster 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; Summary; 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 327 $aLoss of a temporary datafile 330 $aMaster 12 must-use Oracle Database Utilities with this book and eBook 606 $aDatabase management 606 $aRelational databases 608 $aElectronic books. 615 0$aDatabase management. 615 0$aRelational databases. 676 $a005.75/85 700 $aMadrid$b Hector R$0898161 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910456640303321 996 $aOracle 10g$92006784 997 $aUNINA