dba_jobs nls_env

How does dba_jobs decide what it's nls_env values are?. They seem to vary according to whether I queue the job from a windows client or from unix. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services

bind variables in VB using OO4O

Does anyone have examples of how to use bind variables in VB when using OO4O? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

snmp from Oracle?

A bit off the wall this one... Anyone ever tried to monitor other devices on the network from a pl/sql or java package using snmp? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: seperate external procedure listeners for different SIDs

from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

seperate external procedure listeners for different SIDs

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: seperate external procedure listeners for different SIDs

) (ORACLE_HOME = /u03/app/oracle/product/9.2.0.1.0) (PROGRAM = extproc) (ENV = EXTPROC_DLLS=ANY) ) ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: undotbs01.dbf just keeps growing

ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: undotbs01.dbf just keeps growing

his book for a few minutes ) HTH Jared On Tue, 2003-12-30 at 03:29, John Dunn wrote: I have recently installed Standard Engine 9.2 on AIX 5.2 and notice that the undotbs01.dbf file just keeps on growing. It is now over 1 GB. What could be the reason for this? Can I limit it's size

undotbs01.dbf just keeps growing

://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing

RE: java package to run OS command

may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

java package to run OS command

I need a java package that will allow me to run OS commands(Unix) from a stored procedure. Anyone got one? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: java package to run OS command

Which book is that? -Original Message- Sent: 04 December 2003 14:35 To: Multiple recipients of list ORACLE-L its in tom kytes first book. might be on his webpage. From: John Dunn [EMAIL PROTECTED] Date: 2003/12/04 Thu AM 08:49:25 EST To: Multiple recipients of list ORACLE-L

RE: java package to run OS command

To: Multiple recipients of list ORACLE-L its in tom kytes first book. might be on his webpage. From: John Dunn [EMAIL PROTECTED] Date: 2003/12/04 Thu AM 08:49:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: java package to run OS command I need a java package

shutting down oracle on AIX during machine shutdown

Does everyone use the method documented in the install docs (write a script called shut to call dbshut and use this instead of shutdown), or are other methods used? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City

oracle 9i client and OO4O

Which install option is required to install OO40. I do not really want to install all the database admin stuff on my users PCs John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: How to call unix shell scripts from 'C'?

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

hot back up script got Oracle 9

Can anyone point me to a definitive hot back up script for Oracle 9 on AIX, please John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Oracle client and DNS

-- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list

export hangs

FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

RE: 9i on Redhat9 agent does not start...

Title: Message see http://codah.net/install-oracle9iR2-on-redhat9.html it might help. -Original Message-From: Anjan Thakuria [mailto:[EMAIL PROTECTED]Sent: 20 August 2003 20:05To: Multiple recipients of list ORACLE-LSubject: 9i on Redhat9 agent does not start...

dbca and finish button

: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself

RE: dbca and finish button

not create the database! Am I missing something here? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

speeding up conventional path sqlldr

POSITION(1100:1102) CHAR ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

sqlldr questions

-- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send

utl_file on Redhat Linux Oracle 9 standard engine

,var_current_line,998); John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: utl_file on Redhat Linux Oracle 9 standard engine

,998); John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

FW: java permissions

' ) ; where DIRECTORV5 is my user But that hasn't helped. Any ideas what's wrong? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Oracle 9 on redhat 9...kernal settings

I have 512 MB RAM in my Redhat Linux intel machine running Oracle 9. What should I set the Kernal parameters to. shmmax, shmmni, shmall, sem JD -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services

Oracle on Linux

? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oracle on Linux

install Oracle 9? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

utl_file performance

I am told that utl_file performance is improved under Oracle 9 . Does anyone have any comparisons of UTL_FILE performance between 8.1.7 and 9.2? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services

RE: utl_file_dir and 9i

expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message-From: John Dunn [mailto:[EMAIL PROTECTED]Sent: Monday, March 17, 2003 4:03 AMTo: Jamadagni, RajendraSubject: RE: utl_file_dir and 9i Raj

utl_file_dir and 9i

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: utl_file_dir and 9i

to subdirectories? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

64 bit shared library

on AIX?# John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

bulk load of data

or discussion threads you can point me at please do so. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

bulk load of data

or discussion threads you can point me at please do so. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Upgrade to AIX 5.2

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Upgrade to AIX 5.2

: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: Upgrade to AIX 5.2

box to AIX 5.2 We have both Oracle 8.1.7(32 bit) and Oracle 9i Release 2(9.2.0.1.0) (64 bit) installed on that box. Will upgrading to AIX 5.2 cause any problems for Oracle? Any issues etc?? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET

RE: Upgrade to AIX 5.2

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Preventing select on table

) would work fine. Can anyone think of a simple solution, or do I have to do this the hard way (rewrite whole thing to use a sequence number as the primary key, and have Customer as an updatable bit of text). -Original Message- From: John Dunn Sent: 17

Lock table and disallow select

until I release the lock. Is such a thing possible? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

FW: dump.sql

: High It may be found at www.cybcon.com/~jkstill It may also be found at: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOTp_id=1050919.6 Yes, it's back, still without credit. Please, no 'piracy' emails to Oracle about it. Jared John Dunn [EMAIL

Questions for Oracle list

ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

dump.sql

Where can I get then latest version of Jared's legendary script? Or is there a better alternative script for dumping and reloading table data? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services

users identified by external

It used to be (Oracle 8.0.5 think) that if you created a user identified by external (i.e.) via the OS then the user name begain with OPS$. and had to be referenced as such This does not seem to be the case in 81.1.7 on AIX. When did this change? John Dunn Sefas Innovation Ltd 0117 9154267

oracle locking question

or Rollback. This appears to be causing some locking problems, but how can any thing be locked if no rows were updated? Platform is 8.1.7 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

wrong ELF class: ELFCLASS32

: Error loading external library ORA-06522: ld.so.1: extprocPLSExtProc: fatal: /export/home/opdd4229/lib/Cfunctions.so: wrong ELF class: ELFCLASS32 What is the problem? John Dunn Sefas Innovation Ltd 0117 9154267 www.sefas.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

list java classes

How do I list java classes that have been loaded into my schema via loadjava? John Dunn Sefas Innovation Ltd 0117 9154267 www.sefas.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

functions/procedures and commits

as begin insert_the_record; end; where insert_the_record is a procedure that does the insert, but nothing else. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: AIX vs Solaris

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

use_async_io parameter

Is the use_aync_io = TRUE parameter now defunct? or do I still need it to use asynchronous IO on AIX. Platform is AIX 4.3.3 and Oracle 8.1.7 John Dunn Sefas Innovation Ltd 0117 9154267 www.sefas.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET

move USERS tablespace to locally managed

If I want to move my USERS tablespace to locally managed(without using dbms_admin.migrate_to_local), what are the steps I need to take? John John Dunn Sefas Innovation Ltd 0117 9154267 www.sefas.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET

replace lines feeds in a string

I want to replace any carriage returns and lines feeds 'OD0A' and '0A' in string, with a space. Can this be done with TRANSLATE, if so how do I code this? John Dunn Sefas Innovation Ltd 0117 9154267 www.sefas.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John

FW: kproc processes owned by Oracle on AIX

All, I have shutdown my database(but not the listener). I notice that I have a number of kproc processes owned by oracle. Why? John Dunn Sefas Innovation Ltd 0117 9154267 www.sefas.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn

Oracle daylight saving

How does Oracle handle daylight saving time changes. presumably it gets its time from the OS? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

download oracle 8.0.5 client for NT

Anyway know where I can download Oracle client for NT version 8.0.5..? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: High values

, September 19, 2002 12:21 PM To: Multiple recipients of list ORACLE-L Is there a Oracle equivalent to the Cobol HIGH-VALUES value? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

High values

Is there a Oracle equivalent to the Cobol HIGH-VALUES value? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

simple replication script

Anyone got a script or scripts for setting up VERY SIMPLE replication(one master site, one snapshot site) in 8.1.7? Including those pesky dblinks? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services

bind variables

of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Oracle 9i and memory required

Oracle 9i installation document says it requires a minimum of 512MB of memory. Anyone got it installed and running on 256MB? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: Convert PL/SQL to Java

containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services

dbms_space_admin.tablespace_migrate_to_local

Can this be used to specify the allocation, autoallocate or uniform? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: dbms_space_admin.tablespace_migrate_to_local

, autoallocate or uniform? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

creating raw devices on AIX

Where can I find info on this? The documentation refers me to the Oracle 8i Administrators refence for AIX but I cannot find it on-line -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Cannot connect to external procedure agent

This is Oracle 8.1.7.2 on AIX 5 Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

change Language on server after Oracle install

We have a AIX server with Oracle 8.1.7 installed. The language is set to ISO8859-1 English US. We want to change the language to French for testing purposes. Do we need to re-install Oracle? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET

RE: online backup and alter system switch logfile

of the Oracle misconceptions I wrote about: http://www.speakeasy.org/~jwilton/oracle/switch-logfile-backups.html -- Jeremiah Wilton http://www.speakeasy.net/~jwilton John Dunn [EMAIL PROTECTED] I have a online backup script which issues the command ALTER SYSTEM SWITCH LOGFILE

online backup and archived redo logs files (Was online backup an

Wilton http://www.speakeasy.net/~jwilton John Dunn [EMAIL PROTECTED] I have a online backup script which issues the command ALTER SYSTEM SWITCH LOGFILE; immediately before copying the archived redo logs. Does this make sense? I am finding that the ARC process has

online backup script

Does anyone have an online backup script for Oracle 8.1.7 and AIX? Or can anyone provide a definitive list of the actions required to be taken? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services

online backup and alter system switch logfile

ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Installing an app on a French configured server

this character set? Or can we change an existing installation or database? Any assistance appreciated John Dunn -Original Message- From: Stephane Faroult [SMTP:[EMAIL PROTECTED]] Sent: 16 May 2002 21:24 To: Multiple recipients of list ORACLE-L Subject: Re: Installing an app on a French

screen shots of Oracle installer in action?

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

PLS-00553

Can anyone tell me what this PL/SQL error actually means? The manual says An unrecognised name appears in the character set specification John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858

upgrading to AIX 5L

Any one got any experience of upgradeing AIX from 4.3.3 to AIX 5L? Any problems for Oracle (8.1.7)?? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

subtract minute from date/time

I want to subtract a minute from a date/time How can I do this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

run PL/SQL in background

FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

RE: run PL/SQL in background

be an acceptable solution if you increase job_processes accordingly. Or you can have the procedure called by SQL*Plus conveniently wrapped into an OS sc! ! ript, and make the OS script a detached process. HTH S Faroult - Original Message - From: John Dunn [EMAIL PROTECTED

trace external procedure listener

these errors were encountered, as these errors occur very sporadically. We use the external procedure listener to run unix commands via a C routine. Oracle is 8.1.7 on AIX. T.I.A. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat

Logminer

) OF col_description; Replace it with something like: TYPE col_desc_array IS VARRAY(1000) OF col_description; and then rebuild the package. HTH, Lyubomir Petrov --- John Dunn [EMAIL PROTECTED] wrote: I get the following error when running SYS.DBMS_LOGMNR_D ERROR at line 1: ORA

Logminer - again

transaction read write; John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

dbms_jobs and redo activity

Will submitting jobs via dbms_jobs result, in itself, in transactions being writen to redo logs? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Logminer

I get the following error when running SYS.DBMS_LOGMNR_D ERROR at line 1: ORA-06532: Subscript outside of limit ORA-06512: at SYS.DBMS_LOGMNR_D, line 793 ORA-06512: at line 1 Anyone else seen this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn

list wrapped PL/SQL

Is there a query I can run to find out which PL/SQL packages are wrapped and which are not? Oracle 8.1.7 John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

selecting on time

I need to do a select based upon the time element in a date column. i.e, eg where the time is greater than 14:00 Can anyone provide an example of how to do this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City

RE: moving from unix to NT

is part of a larger application and not easily removed, you may just have to deal with modifying the PL/SQL. Of course, if you had made this stuff data driven ( meta data, if you will ), this would be a non-issue. :) Jared John Dunn [EMAIL PROTECTED] Sent by: [EMAIL

RE: moving from unix to NT

: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Oracle learning network v Oracle CBT-Select

-- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list

ORA-00600 errors

: ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [] John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

moving from unix to NT

to NT? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Unix permissions

. setting 777 permissions on the directories 2. making our application user a member of the oracle group Anyone had the same problems? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

rollback a sequence

Do values in sequences get decremented when a rollback is issued? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

pinning objects

I am investigating pinning some of the developers packages into memory. Could you please clarify how this is done. Also how can I identify which packages would beefit from pinning? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL

RE: Unix question

ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

RE: pinning objects

Message- From: John Dunn [ mailto:[EMAIL PROTECTED]] Sent: 11 January 2002 09:40 To: Multiple recipients of list ORACLE-L Subject: pinning objects I am investigating pinning some of the developers packages into memory. Could you please clarify how this is done. Also how can

java stored procedures and running rsh command

(as oracle), or from a C external procedure, but not from RUN_CMD. Do I need to do something extra in java to enable running of rsh command? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Oracle and Corba

Can anyone point me at info on integrating with Corba enabled applications from Oracle stored procedures? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

list grants

What query can i use to establish whether a user has been granted a specified privilege...e.g CREATE LIBRARY? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

  1   2   >