04799nam 2200649Ia 450 991045664030332120200520144314.01-282-17234-41-84719-629-29786612172342(CKB)2430000000040707(EBL)956356(OCoLC)697738900(SSID)ssj0000349330(PQKBManifestationID)12126068(PQKBTitleCode)TC0000349330(PQKBWorkID)10348388(PQKB)11123866(MiAaPQ)EBC956356(PPN)228026210(Au-PeEL)EBL956356(CaPaEBR)ebr10433560(CaONFJC)MIL217234(EXLCZ)99243000000004070720090828d2009 uy 0engur|n|---|||||txtccrOracle 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. MadridBirmingham, U.K. Packt Publishing Ltd.20091 online resource (432 p.)From technologies to solutionsIncludes index.1-84719-628-4 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 modeImproving 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 loadDirect 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 TablesDynamically 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)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; 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 datafileLoss of a temporary datafileMaster 12 must-use Oracle Database Utilities with this book and eBookDatabase managementRelational databasesElectronic books.Database management.Relational databases.005.75/85Madrid Hector R898161MiAaPQMiAaPQMiAaPQBOOK9910456640303321Oracle 10g2006784UNINA