Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Oracle 10g/11g Data and Database Management Utilities
  • Table Of Contents Toc
Oracle 10g/11g Data and Database Management Utilities

Oracle 10g/11g Data and Database Management Utilities

4 (1)
Buy this Book
close
close
Oracle 10g/11g Data and Database Management Utilities

Oracle 10g/11g Data and Database Management Utilities

4 (1)
Buy this Book

Overview of this book

Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.
Table of Contents (18 chapters)
close
close
close
Oracle 10g/11g Data and Database Management Utilities
Icon
Oracle 10g/11g Data and Database Management Utilities
Credits
Icon
Credits
About the Author
Icon
About the Author
About the Reviewer
Icon
About the Reviewer
Preface
Icon
Preface
Lock Free Chapter
1
Data Pump
Icon
Data Pump
Icon
Data Pump features
Icon
Data Pump architecture
Icon
Setting up the practical scenarios
Icon
Data Pump export
Icon
Data Pump restart capability
Icon
Getting information about the export job
Icon
Data Pump import
Icon
Improving performance with Data Pump
Icon
Working with the Data Pump API
Icon
Data Pump 11g new features
Icon
Summary
2
SQL*Loader
Icon
SQL*Loader
Icon
SQL*Loader basics
Icon
Preparing the demo environment
Icon
Specifying a particular character set
Icon
Load on the fly
Icon
Direct path versus Conventional path load
Icon
Loading Large Objects (LOBs)
Icon
Loading multimedia files
Icon
Resumable load
Icon
Parallel load
Icon
General performance booster tips
Icon
Summary
3
External Tables
chevron up
Icon
External Tables
Icon
The External Table basics
Icon
Let's setup the environment
Icon
Inter-version compatibility
Icon
Data transformation with External Tables
Icon
Mapping XML files as External Tables
Icon
Dynamically changing the external reference
Icon
Oracle 11g External Table enhancements
Icon
Summary
4
Recovery Manager Advanced Techniques
Icon
Recovery Manager Advanced Techniques
Icon
Recovery Manager basics
Icon
Backup compression
Icon
Faster backups through intra-file parallel backup and restore operations (11g only)
Icon
Block media recovery
Icon
Backup duration and throttling
Icon
Database cloning
Icon
Inter-platform database migration
Icon
Migrate to and from an ASM environment
Icon
General backup advices
Icon
Summary
5
Recovery Manager Restore and Recovery Techniques
Icon
Recovery Manager Restore and Recovery Techniques
Icon
Oracle database recovery
Icon
Loss of data files
Icon
Loss of redo log files
Icon
Test restore
Icon
Crosscheck command
Icon
Nologging considerations
Icon
Summary
6
Session Management
Icon
Session Management
Icon
User sessions in a dedicated server architecture
Icon
Blocking sessions
Icon
Services
Icon
Resource Manager
Icon
Active Session History (ASH)
Icon
Session monitoring, the traditional way
Icon
Summary
7
Oracle Scheduler
Icon
Oracle Scheduler
Icon
Oracle Scheduler concepts
Icon
Getting started with the Oracle Scheduler
Icon
Time expression syntax
Icon
Programs
Icon
Schedules
Icon
Jobs and Job Classes
Icon
Managing the Scheduler
Icon
Data dictionary related views
Icon
Summary
8
Oracle Wallet Manager
Icon
Oracle Wallet Manager
Icon
The Oracle Wallet Manager
Icon
Oracle Wallet Manager CSR generation
Icon
Storing the Oracle Wallet in the Windows registry
Icon
Storing the Wallet in an LDAP server
Icon
Using certificates for authentication
Icon
Using the Oracle Wallet to store database credentials
Icon
Summary
9
Security Management
Icon
Security Management
Icon
Using the Oracle Wallet to encrypt backups
Icon
The enterprise user
Icon
Summary
10
Database Configuration Assistant
Icon
Database Configuration Assistant
Icon
DBCA
Icon
Database creation
Icon
Database edition
Icon
Database template management
Icon
Automatic Storage Management configuration
Icon
DBCA, Batch mode
Icon
Summary
11
Oracle Universal Installer
Icon
Oracle Universal Installer
Icon
OUI basics
Icon
OUI basic and advanced installation modes
Icon
Modes of installation
Icon
OUI command line parameters
Icon
Silent installation mode
Icon
The oraparam.ini file
Icon
OUI return codes
Icon
Installing Oracle from the Web
Icon
Recovering a lost Inventory
Icon
Cloning Oracle Home using OUI
Icon
Summary
12
Enterprise Manager Configuration Assistant
Icon
Enterprise Manager Configuration Assistant
Icon
Enterprise Manager Components
Icon
Enterprise Manager configuration
Icon
EMCA Command Line Interface
Icon
EMCA 10g Release 1
Icon
EM directory structure
Icon
Environment changes
Icon
Securing Enterprise Manager
Icon
Summary
13
OPatch
Icon
OPatch
Icon
OPatch
Icon
Downloading the latest OPatch version
Icon
OPatch requirements
Icon
OPatch syntax
Icon
Oracle maintenance using OPatch
Icon
Applying a single patch using OPatch
Icon
Querying the Oracle inventory
Icon
Rolling back a failed OPatch session
Icon
Considerations after applying a patch
Icon
OPatch in Oracle 11g
Icon
Oracle Configuration Manager Registration
Icon
Critical Patch Updates
Icon
Hot patching (11g only)
Icon
Troubleshooting OPatch
Icon
Using Enterprise Manager for software maintenance
Icon
Managing Patches in EM 11g
Icon
Summary

Dynamically changing the external reference

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 the location property. Using a stored program unit is a flexible way to perform this task. 

create procedure change_external_table
( p_table_name in varchar2
, p_file_name in varchar2
) is
begin
execute immediate 'alter table '
|| p_table_name
|| ' location ('''
|| p_file_name
|| ''')' ;
exception
when others
then
raise_application_error(sqlcode,sqlerrm) ;
end ;
/
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Oracle 10g/11g Data and Database Management Utilities
End of Section 3
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon