Oracle Database Management Utilities

Oracle Database Management Utilities

Oracle is among the database programming tools preferred by database administrators worldwide. It's highly efficient and can work perfectly in various conditions. Whether the server has physical partitions or simply virtual, Oracle will help developers configure the database with the expected functions.

But even though there is a clear advantage provided by Oracle, some database administrators are finding it difficult to fully comprehend. This should be expected especially when developers have to build a database in a massive scale with various configurations. As the database gets complicated and functions specific to each server (physical or virtual) increases, understanding Oracle may not be easier. Those who are just starting in database management have to learn the basics first before moving forward to advanced functions.

This book is available for purchase at amazon.com

Read Sample Chapter 3

Read Book Review

1. Oracle 10g/11g Data and Database Management Utilities Author: Packt Publishing

   Does your database seem complicated Are you finding it difficult to work with it efficiently Database administration is part of a daily routine for all database professionals. Using Oracle Utilities administrators can benefit from improved maintenance windows optimized backups faster data transfers and more reliable security and can in general

2. Oracle Utilities - External Tables Author: Packt Publishing

   When working in data warehouse environments the Extraction--Transformation--Loading ETL cycle frequently requires the user to load information from external sources in plain file format or perform data transfers among Oracle database in a proprietary format. This requires the user to create control files to perform the load. As the format of

3. Oracle Utilities - External Tables Environment Setup Author: Packt Publishing

   Let s setup the environment Let s create the demonstration user and prepare its environment to create an External Table. The example that will be developed first refers to the External Table using the ORACLE_LOADER driver.  geshibot language oracle create user EXTTABDEMO identified by ORACLE default tablespace USERS;

4. Oracle Utilities - a Basic External Table Author: Packt Publishing

   The create table command syntax is just like any other regular table creation A B up to the point where the ORGANIZATION EXTERNAL C keyword appears this is the point where the actual External Table definition starts. Here is the source code of the External Table creation. In this case the External Table is accessed by the ORACLE_LOADER

5. Oracle Utilities - Creating External Table Metadata, The Easy Way Author: Packt Publishing

   To further illustrate the tight relationship between SQL Loader and External Tables the SQL Loader tool may be used to generate a script that creates an External Table according to a pre-existing control file. SQL Loader has a command line option named EXTERNAL_TABLE this can hold one of three different parameters NOT_USED GENERATE_ONLY

6. Oracle Utilities - Unloading data to External Tables Author: Packt Publishing

   The driver used to unload data to an External Table is the ORACLE_DATAPUMP access driver. It dumps the contents of a table in a binary proprietary format file. This way you can exchange data with other 10g and higher databases in a preformatted way to meet the other database s requirements. Unloading data to an External Table doesn t make it updateable

7. Oracle Utilities - Inter-Version Compatibility Author: Packt Publishing

   In the previous example a 10g data pump generated an External Table that was transparently read by the 11g release. Let s create an 11g data pump External Table named DP_DEPARTMENTS geshibot language oracle" create table dp_departments organization external type oracle_datapump default

8. Oracle Utilities - Data Transformation with External Tables Author: Packt Publishing

   One of the main uses of the External Tables is their support of the ETL process allowing the user to perform a data load that is transformed to the target format without an intermediate stage table. Let s read an External Table whose contents are This data can be loaded in a single command to multiple tables. Let s create several tables

9. Oracle Utilities - Extending the alert.log Analysis Author: Packt Publishing

   Extending the alert.log analysis with External Tables Reading the alert.log from the database is a useful feature which can help you to find any outstanding error messages reported in this file. geshibot language oracle" create table ALERT_LOG text_line varchar2 512 organization external

10. Oracle Utilities - Reading the listener.log from the database Author: Packt Publishing

    One particular extension of the above procedure is to read the listener.log file. This file has a specific star-delimited field file format which can be advantageous and eases the read by means of the Loader driver. The file format is as follows geshibot language oracle" 21-JUL-2008 00 39 50 CONNECT_DATA SID beta CID PROGRAM perl HOS

11. Oracle Utilities - Mapping XML files as External Tables Author: Packt Publishing

    XML has become a de facto information exchange format which is why oracle has included the XML Database XDB feature from 9.2.0. However it requires the data to be actually loaded into the database before it can be processed. An External Table allows the user to take a quick look at the contents of the external file prior to performing any further

12. Oracle Utilities - Dynamically Changing the External Reference Author: Packt Publishing

    When managing External Tables there should be an easy way to redefine the external source file. It is enough to change the External Table properties by means of an ALTER TABLE command. Let s create a stored procedure that performs this task by means of a dynamically generated DDL command. This procedure named Change_External_Table redefines

13. Oracle Utilities - Summary Author: Packt Publishing

    Managing data with External Tables is a means not only for mapping external flat files as regular but limited tables inside the database but also a tool to more efficiently perform administrative tasks such as programmatically processing database log files such as the alert.log or the listener.log files. It can be used to easily view external XML