AQ

-- Author: Ehresmann, David 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

advice

: Ehresmann, David 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

timing data

) that it is 1/100th of a second. Does anybody now where a document is located that explains this? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

encrypt back-up data

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

RE: encrypt back-up data

ou receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. -Original Message- From: Ehresmann, David [mailto:[EMAIL PROTECTED]] Sent: Friday,

RE: encrypt back-up data

via sqlnet. /peter Ehresmann, David wrote: Thanks, I will pass it along. Next question: If you are using Oracle's Advanced Encryption standard with one of the following standards: encryption algorithms supported are RC4_40, RC4_56, RC4_128, RC4_256, DES_40, 2-Key 3DES and 3-Key

RE: encrypt back-up data

Thanks! David. -Original Message- Sent: Friday, January 02, 2004 3:49 PM To: Multiple recipients of list ORACLE-L Hi The data in the database is not changed, the data is encrypted in the sql*net layer. Ehresmann, David wrote: I realize that. Is the data in the table left in its

8i to 9i import

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

export with query date field

tables via Conventional Path ... . . exporting tablePROCESSING_MESSAGES 0 rows exported Export terminated successfully without warnings. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED

index suppression and processing

have seen this problem with this table. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

latch free wait event

://www.orafaq.net -- Author: Ehresmann, David 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

package errors

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

package errors

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

last column in a table is added with a DEFAULT

: http://www.orafaq.net -- Author: Ehresmann, David 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: last column in a table is added with a DEFAULT

- From: Ehresmann, David [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 07, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: last column in a table is added with a DEFAULT Has anybody ever heard of this? I have a developer saying this is an oracle bug. It caused some

drop user

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

Oracle 7.3.2

want to know will 7.3.2 run on HP11 and if there are any issues I need to be concerned about. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Oracle 7.3.2

, with compatible set to 7.3.3.0. The Application uses some old OO stuff written in GemStone. - Kirti --- Ehresmann, David [EMAIL PROTECTED] wrote: We are going to upgrade a server from HP10.2 to HP11 or HP11i. There is an old version of Oracle 7 running on the box, Oracle 7.3.2. I looked through

LOB tablespace

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

search archives

How do I search the archives of this list? thanks, David Ehresmann PerotSystems [EMAIL PROTECTED] 972.577.6236 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

trace for error number

List, I need to trace for a specific Oracle error number, ORA-01722. Any suggestions would be appreciated. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: trace for error number

error number, ORA-01722. Any suggestions would be appreciated. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

pls-00123 Program too Large

the trigger into two pieces to cut down its size. Besides that, is there anything else to look at to get the trigger to compile. David Ehresmann PerotSystems [EMAIL PROTECTED] 972.577.6236 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET

explain plan

List , does anybody have or know where I can get a script that will explain all of the columns from the plan_table? Does anybody have any suggestions for using ultxpls.sql? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann

ora-1031

'; l_found_splitCHAR:= 'F'; l_segment_cntINTEGER := 1; David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: ora-1031

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

Named Pipes Protocol Adapter

List, Why would someone want to use Named Pipes Protocol Adapter? I have never used this, could someone educated me on this? David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services

FMON

understand that this is a mapping library and have read through Oracle9i Dba Guide Rel 2 Chapter 12 datafiles page 15. My question is do I need this dir or can I delete it? thanks David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David

Oracle Error Message syntax

that is located on metalink. thanks, David Ehresmann PerotSystems [EMAIL PROTECTED] 972.577.6236 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

8i to 9i clone

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

Oracle view riddle I am being asked , help me out here.

So why would the sql statement used to create a view run faster (significantly) than selecting from that view built with the same sql statement? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED

SCN scheme 3

List, does anybody know what this means: SCN scheme 3 It occurs it the alert log upon startup. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

trace files

I do a sqlshow parameter log. This must be a default setting? Can anybody explain these two trace files? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

JDBC thin driver losing connection

-- Author: Ehresmann, David 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

RE: LMT monitoring

If you read Jonathan Gennick's LMT article from the Nov/Dec 2000 Oracle Magazine he discusses the possible extent sizes, i.e. 64k, 1M, 8M, and finally 64M. http://www.oracle.com/oramag/oracle/00-nov/index.html?o60o8i.html David Ehresmann. -Original Message-From: Daniel W. Fink

monitor transactions over time

transaction processing. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

db create with DBCA and scripts

temp is there any other behavior during manual creation I should be aware of? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

dbms_debug

) are there performance issues with dbms_bebug? David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: dbms_debug

here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message- From: Ehresmann, David [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Subject: dbms_debug List, Does

JDK directory home

it is asking for. What is the proper location? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

rootpre.sh

: http://www.orafaq.net -- Author: Ehresmann, David 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: rootpre.sh

-- Author: Ehresmann, David 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: rootpre.sh

Q: http://www.orafaq.net-- Author: Ehresmann, David INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE you

SETGID

. Everything worked fine then. It seemed to be totally random. Anybody ever seen this behavior? David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

TOAD

do I set up his privs to allow him to make changes to another's package bodies thru TOAD? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE:

') and in the message BODY, include a line 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.net -- Author: Ehresmann, David

[no subject]

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

compatible in 9iRel2

2 (9.2) Part Number A96530-01 stating how to downgrade, but it seems to defeat the purpose of having a 9i instance. Is there any way to do this without stripping the 9i database down to 8i? David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann

RE: compatible in 9iRel2

this without stripping the 9i database down to 8i? David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: compatible in 9iRel2

is without stripping the 9i databasedown to 8i? David Ehresmann-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Ehresmann, David INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web

RE: compatible in 9iRel2

9iinstance. Is there any way to do this without stripping the 9i databasedown to 8i? David Ehresmann-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Ehresmann, David INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.co

RE: compile errors

-00905: object schema.P_MESSAGES is invalid 1/14 PLS-00304: cannot compile body of 'P_MESSAGES' without its specification thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED

compile errors

1/14 PLS-00304: cannot compile body of 'P_MESSAGES' without its specification thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: compile errors

PLS-00905: object schema.P_MESSAGES is invalid 1/14 PLS-00304: cannot compile body of 'P_MESSAGES' without its specification thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City

Sun Solaris

List, Does anybody know a Sun Solaris e-mail list/forum that's useful like this one is for Oracle? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Create Database

: Ehresmann, David 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

install of 64 and 32 bit

I am going to install 64 bit Oracle 8.1.7 on AIX 5L (5.1). There is already 32 bit Oracle on the box. Any suggestions or advice I would appreciate. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David INET: [EMAIL PROTECTED

Imp of all users tables

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

[no subject]

file that I know are there under the schema owner I get: IMP-00015 object already exists. I can't convince this guy the table is not there. What else can I do? David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David INET: [EMAIL PROTECTED