Perl for Oracle Dbas

object orientation, in Perl  

objects

       creating  

               with PDBA Toolkit script  

       dropping  

       examining space of with maxext.pl  

       gathering information about  

       monitoring size /number of extents in  

OCI (Oracle Call Interface)   2nd  

       datatype mapping functions  

       DML capabilities in  

       features  

       functions  

               categories of  

               one-to-one mapping with Oracle::OCI  

               table of  

       installing Perl DBI and  

       invoking with Oracle::OCI  

       navigational functions  

       Oracle::PLSQL, future availability  

       Perl DBI and, code example illustrating integration of  

       procedure functions  

       relational functions  

       type functions  

       Version 8.1 demonstration programs, table of  

       web resources for  

OCIExtProcContext  

       using Perl DBI for host callbacks  

Open Perl IDE  

OpenBSD, installing Perl from from prebuilt package  

OpenSSL program  

operating system commands, Perl and  

operating systems  

operating systems documentation, regarding Perl  

OPS$ Oracle accounts, security of  

OptiPerl (Perl IDE)  

.ora files, configuration of, setting up external procedures  

ora_explain.PL  

ora_module_name attribute (Perl DBI)  

ora_oratab_orahome attribute (Perl DBI)  

ora_perl_boot.pl bootstrap file   2nd  

       using after installation  

ora_session_mode attribute (Perl DBI)  

Orac   2nd  

       directories for storing personal options  

       downloading  

       installing  

       personalizing  

       running  

        user options, table of  

       using DDL::Oracle with  

               example program  

orac_dba.pl program icon  

Oracle

       client libraries, Cygwin installation under DBD::Oracle installation   2nd  

       data dictionary

               PDBA repository and  

               tables in PDBA repository  

       database server, connecting to   [See OCI]

       databases

               limiting resource consumption  

               NULL values and  

               space problems on  

               transfering data to  

       date format, XML::XMLtoDBMS and  

       DDL and  

       embedding Perl into  

       environment variables

               DBD::Oracle and  

                predefining  

       external procedures, resources  

       schemas, comparing   [See SchemaDiff]

       server, parallel server management   [See OCI]

       user privileges, Oracletool selection reports  

       versions of  

       XML and  

Oracle Call Interface   [See OCI]

Oracle DDL from Oracle8i databases, reverse-engineering   [See DDL::Oracle]

Oracle Enterprise database server

       mapping datatypes   [See OCI, datatype mapping functions]

       navigating between objects supplied by   [See OCI, navigational functions]

ORACLE not available errors, on Linux SuSE 7.73 with Oracle9i  

Oracle Technology Network (OTN)  

oracle user

       building Perl for  

               resetting PATH variable  

       creating from command line  

       HOME directory  

Oracle/Perl

       architecture  

       tools for DBAs  

Oracle::OCI  

       architecture compared to Perl DBD::Oracle  

       C language vs.  

       coding with  

               mixing modules, code example  

               Perl DBI and DBD::Oracle code example  

               pure Oracle::OCI code example  

               requirement  

       future of  

       installation directories  

       installing

               on Unix  

               on Win32  

       invoking OCI with  

       mail archive  

       relationship to Perl DBD::Oracle  

       resources for further information  

       setting environment  

       troubleshooting installation  

       versions of  

Oracle::OCI Project, contributing to  

Oracle::PLSQL, future availability  

ORACLE_BASE variable, cm.conf and  

ORACLE_HOME variable

       Apache and  

       cm.conf and  

       DBD::Oracle and  

       Karma and  

       Orac and  

       Oracletool and   2nd  

       PDBA Toolkit and  

       Perl DBI Hello World example  

       SchemaView-Plus and  

       setting up external procedures  

ORACLE_SID variable

       DBD::Oracle and  

       Oracle::OCI and  

       PDBA Toolkit and  

Oracle_SID_AlertLogMon, testing  

ORACLE_USERID variable

       DBD::Oracle and   2nd  

       Oracle::OCI and  

       PDBA Toolkit installation  

Oracle8, data dictionary tables, PDBA repository and  

Oracle8i

       editing pdba_tbs8i.sql  

       LMTs in  

Oracle9i

       installing Oracle::OCI on

               ./boot test compilation errors  

       installing Oracle::OCI on Linux SuSE 7.73, ORACLE not available errors  

       Oracletool connection options  

       patching DBD::Oracle  

       setting up external procedures with PLExtProc  

Oracle9i Application HTTP Server (iAS), web resource  

OracleNet  

Oracletool  

       adding SQL scripts to  

       connection options  

       initialization parameters  

       installing

               on Unix  

               on Win32  

       monitoring databases with  

       Preferences/privileges  

       security  

       selection reports, Oracle user privileges  

       v2.0 features  

       web resource for   2nd  

OraExplain   2nd  

oramon account, PDBA Toolkit installation  

oratabFile parameter (chkalert.pl)  

orclALRT.log  

osname method (PDBA module)  

OTN (Oracle Technology Network)  

OWA package  

OWA_COOKIE package  

OWA_IMAGE package  

OWA_OPT_LOCK package  

OWA_PATTERN package  

OWA_TEXT package  

OWA_UTIL package