Set 1: Introduction

Oracle Corporation, Perspection Inc.

Description

• cours magistral

& $ % Set 1: Introduction Kyle A. Gallivan Department of Mathematics Florida State University Optimization Spring 2012 1

• k. a. gallivan
• trust region methods
• j. e. dennis jr
• s. boyd
• a. nemirovskii
• r. mahony
• introduction kyle a. gallivan
• optimization
• programming assignments

Sujets

• Cours magistral
• Building
• Edition
• Cambridge University
• Optimization
• Computer programming
• Introduction
• Linear

Informations

• Publié par: figas
• Nombre de lectures: 19
• Langue: English
• Poids de l'ouvrage: 1 Mo

Extrait

Oracle9i
Database Administrator’s Guide
Release 2 (9.2) for Windows
March 2002
Part No. A95491-01Oracle9i Database Administrator’s Guide, Release 2 (9.2) for Windows
Part No. A95491 01
Copyright © 1996, 2002 Oracle Corporation. All rights reserved.
Primary Author: Craig B. Foch
Contributing Authors: Herbert Kelly III, Mark Kennedy, and Helen Slattery
The Programs (which include both the software and documentation) contain proprietary information of
Oracle Corporation; they are provided under a license agreement containing restrictions on use and
disclosure and are also protected by copyright, patent and other intellectual and industrial property
laws. Reverse engineering, disassembly or decompilation of the Programs, except to the extent required
to obtain interoperability with other independently created software or as specified by law, is prohibited.
The information contained in this document is subject to change without notice. If you find any problems
in the documentation, please report them to us in writing. Oracle Corporation does not warrant that this
document is error-free. Except as may be expressly permitted in your license agreement for these
Programs, no part of these Programs may be reproduced or transmitted in any form or by any means,
electronic or mechanical, for any purpose, without the express written permission of Oracle Corporation.
If the Programs are delivered to the U.S. Government or anyone licensing or using the programs on
behalf of the U.S. Government, the following notice is applicable:
Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are "commercial
computer software" and use, duplication, and disclosure of the Programs, including documentation,
shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement.
Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer
software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR
52.227 19, Commercial Computer Software Restricted Rights (June, 1987). Oracle Corporation, 500
Oracle Parkway, Redwood City, CA 94065.
The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently
dangerous applications. It shall be the licensee's responsibility to take all appropriate fail safe, backup,
redundancy, and other measures to ensure the safe use of such applications if the Programs are used for
such purposes, and Oracle Corporation disclaims liability for any damages caused by such use of the
Programs.
Oracle is a registered trademark, and Oracle Store, Oracle7, Oracle8, Oracle8i, Oracle9i, OracleMetaLink,
PL/SQL, Pro*C/C++, and SQL*Plus are trademarks or registered trademarks of Oracle Corporation.
Other names may be trademarks of their respective owners.Contents
Send Us Your Comments ................................................................................................................... ix
Preface............................................................................................................................................................ xi
Audience ................................................................................................................................................ xii
Organization.......................................................................................................................................... xii
Related Documentation ....................................................................................................................... xiii
Conventions.......................................................................................................................................... xiv
Documentation Accessibility .............................................................................................................. xx
What’s New in Oracle9i for Windows........................................................................................ xxi
Oracle9i Release 2 (9.2) New Features .............................................................................................. xxi
Oracle9i Release 1 (9.0.1) New Features .......................................................................................... xxii
1 Postinstallation Database Creation
Before You Create a Database........................................................................................................... 1-2
Naming Conventions for Oracle Databases ............................................................................. 1-2
Accessing Data Files and Log Files on Remote Computers ................................................... 1-3
Creating a Database Using Database Configuration Assistant ................................................. 1-3
Create a Database ......................................................................................................................... 1-4
Importing Sample Schemas ............................................................................................... 1-14
Delete a Database........................................................................................................................ 1-15
Creating a Database Manually....................................................................................................... 1-15
Creating Directories ................................................................................................................... 1-17
Exporting an Existing Database ............................................................................................... 1-17
iiiDeleting Database Files.............................................................................................................. 1-18
Modifying the Initialization Parameter File............................................................................ 1-19
Creating and Starting an Oracle Service.................................................................................. 1-20
Putting the CREATE DATABASE Statement in a Script ...................................................... 1-21
Running the CRATABASE Script .............................................................................. 1-22
Importing a Database................................................................................................................. 1-23
Updating ORACLE_SID in the Registry ................................................................................. 1-24
Backing Up the New Database ................................................................................................. 1-26
Using ORADIM Utility to Administer an Oracle Instance ...................................................... 1-27
Creating an Instance................................................................................................................... 1-29
Starting ance .................................................................................................................... 1-30
Stopping an Instance .................................................................................................................. 1-30
Modifying an Instance ............................................................................................................... 1-31
Deleting an Instance ................................................................................................................... 1-32
2 Postinstallation Configuration Tasks
Oracle interMedia ............................................................................................................................... 2-2
Configuring Oracle interMedia Audio, Video, Image, and Locator...................................... 2-3
Configuring Oracle inter Demos ..................................................................................... 2-4
Oracle Text............................................................................................................................................ 2-4
Configuring Oracle Text .............................................................................................................. 2-5
Oracle Spatial....................................................................................................................................... 2-7
Manually Configuring Oracle Spatial........................................................................................ 2-8
Shared Server Support....................................................................................................................... 2-9
Enabling Shared Server Support for Java Clients .................................................................. 2-10
EnaredSupport for Two-Task Oracle Net Clients .................................... 2-10
Disabling Shared Server Support for Two-Task Oracle Net Clients................................... 2-11
Advanced Replication...................................................................................................................... 2-12
Checking Tablespace and Rollback Segment Requirements................................................ 2-13
Adding and Modifying Initialization Parameters ................................................................. 2-13
Monitoring Data Dictionary Tables ..............................................