sqlplus output from query with xmlelement

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

RE: sqlplus output from query with xmlelement

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

supplying dblink name to package at runtime

to the refcursor, then open the refcursor, etc. etc. Is this the only way to do it? thanks bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: sqlplus /nolog

Title: sqlplus /nolog it starts sqlplus without logging in to a database - -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 29, 2002 8:29 AMTo: Multiple recipients of list ORACLE-LSubject: sqlplus /nolog Hi! I was wondering

db feature comparison?

support and the like. Looking specifically for DB2 and Sybase as compared to Oracle, but others will help, too. thanks bill magaliff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: Data modeling question

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: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: full exp/imp of user to new tablespace; same user

Title: full exp/imp of user to new tablespace; same user Richard: if all of the objects are going into a single tablespace, make sure that new user has default tablespace set properly to the new TS and that s/he has a proper quota on that TS (I start with UNLIMITED). Also, make sure that

RE: full exp/imp of user to new tablespace; same user

: Magaliff, Bill [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 07, 2002 8:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: full exp/imp of user to new tablespace; same user Richard: if all of the objects are going into a single tablespace, make sure

how to avoid mutating table error in triggers

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

RE: RE: How-To or Good Practices on Code Releases

over. Missed out on volume testing. Took 2 cuppas and 3 smokes before it was done. Raj Magaliff, Bill Bill.Magaliff@lenTo: Multiple recipients of list ORACLE-L ORACLE-L@fatcitS

data modeling question - child table with multiple parents

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

RE: data modeling question - child table with multiple parents

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

RE: data modeling question - child table with multiple parents

is easier to manage. HTH Jared Magaliff, Bill [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/31/2002 01:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:data modeling question - child table

RE: data modeling question - child table with multiple parents

the ADDRESS table itself. Any and all thoughts, comments, opinions, experiences are most welcome. Thanks! bill magaliff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: User with less privileges...

(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: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: data modeling question - child table with multiple parents

Title: RE: data modeling question - child table with multiple parents same here - we don't reuse addresses so the table gets quite huge -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 31, 2002 6:09 PMTo: Multiple recipients of list

RE: data modeling question - child table with multiple parents

, experiences are most welcome. Thanks! bill magaliff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: User with less privileges...

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

RE: dropping a user's objects

objects. -bill -Original Message- Sent: Thursday, August 08, 2002 4:35 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Bill, Wouldn't DROP TABLE CASCADE CONSTRAINTS be easier, or do you have some particular reason for doing it this way? Jared Magaliff, Bill [EMAIL PROTECTED] Sent

RE: dropping a user's objects

this new script. have beer. Now of course, this will not be as fast as a parallel DROP TABLE user.tab CASCADE CONSTRAINTS, but hey, more time to have beer. hth, Jack --- Magaliff, Bill [EMAIL PROTECTED] wrote: Good day, all: I have a PL/SQL routine that I use to drop all objects owned

RE: PL/SQL Editor.

://www.orafaq.com -- Author: Magaliff, Bill 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

db locking quandry

for thoughts of where to look next . . . thanks -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: db locking quandry

not been seen since. I guess we could have enabled Dead Connection Detection but we decided to fix it at the source. HTH Tony Aponte Home Shopping Network, Inc. -Original Message- From: Magaliff, Bill [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 2:19 PM To: Multiple

RE: db locking quandry

RETRANSMISSIONS -Original Message-From: Magaliff, Bill [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 20, 2002 2:24 PMTo: Aponte, Tony; [EMAIL PROTECTED]Subject: RE: db locking quandry Can you point me to the note on MetaLink that had this TCP setting

RE: db locking quandry

WHERE df.file_id = buf.file# GROUP BY df.tablespace_name, df.file_name; Barb -- From: Magaliff, Bill[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: db locking

RE: List of all zip codes,city,state to load into table.

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: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: PL/SQL Editor

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

RE: PL/SQL Editor

(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: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: PL/SQL Editor

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: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network

RE: RE: PL/SQL Editor

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

RE: What is an API?

wow - what a great web site! thanks! -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 28, 2002 2:03 PMTo: Multiple recipients of list ORACLE-LSubject: RE: What is an API? Application Programming Interface ...

RE: PL/SQL Editor

: Wednesday, August 28, 2002 12:52 PM Benthicsoftware has a good series of editors. They are all about US$30 a piece or so. Not as powerfull as TOAD but if you are just doing PL/SQL Development they work great. From: Magaliff, Bill [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple

RE: IMPORT sloooowwww

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

Oracle Parner Network

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

RE: How to speed up import

') 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.com -- Author: Magaliff, Bill

foreign key indexes and parent-table locking

consistency. Can anyone help by either translating this last part or rephrasing it? Or explaining the issue differnetly? Thanks bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: foreign key indexes and parent-table locking

. This will be much easier to understand than the 'documentation' Jared Magaliff, Bill [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/05/2002 02:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:foreign

RE: foreign key indexes and parent-table locking

: [EMAIL PROTECTED] The theory will make much more sense after you see it in action. Jared Magaliff, Bill [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/06/2002 07:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc

RE: View Locks

alternative to view locks on tables. Regards, Manoj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Re: View Locks

://www.orafaq.com -- Author: Magaliff, Bill 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

RE: Decode

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

RE: Estat Bstat

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: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: OSUSER in V$SESSION capture in procedure?

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

RE: New bee: How to convert 'LONG' data

-- Author: Magaliff, Bill 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, send

changing db name

in the process by putting their new names in the create controlfile script? thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

sql plus help - display more text on a line

-- Author: Magaliff, Bill 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

RE: For real Gurus only

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

rman duplicate dbid?

an error when registering the second that it's already registered. they are distinct db's . . . I tried unregistering one and then retrying, and again I get the same DBID for both. any ideas? thanks, y'all -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff

RE: rman duplicate dbid?

the same DBID for both. any ideas? thanks, y'all -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: foreign key what???? help!!

Title: RE: foreign key what help!! are you loading more than one table? could you be loading child records b4 the parents are inserted? -bill -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, June 03, 2002 6:13 PMTo: Multiple recipients

db link service name resolution via Oracle Names?

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

RE: db link service name resolution via Oracle Names?

a database or client doing the lookup. Now previous versions of ONames did a very nice job of allowing you to create global database links, but version 8.1 messed that up REAL bad. Dick Goulet Reply Separator Author: Magaliff; Bill [EMAIL PROTECTED] Date

817 intelligent agent resolves to wrong dns entry

: Magaliff, Bill 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, send

RE: How to move 200 GB db from prod to dev?

Title: How to move 200 GB db from prod to dev? 1) use RMAN to clone the db; or 2) create the new dev db with the required users but without all the data/index tablespaces, and use transportable tablepsace feature to move tablespaces/data files . . . export/import of meta-data is quick -

how to you stop an export?

how do you stop an command-line export? press CTL-C countless times and ususally just stops the current table . . . usually end up killing the entire session. was hoping there's a different way? thx bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill

RE: Cleanup of child records...

Title: Cleanup of child records... delete from child_table where fk_field not in (select pk_field from parent_table); or delete from child_table where not exists (select pk_field from parent_table where parent_table.pk_field = child_table.fk_field); not exists usually out performs not

two different 9i install problems!

restore the original versions of these files. Then get prompted to insert my original Windows CD any and all help appreciated thanks bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: sequence question

what do you mean about losing numbers after an import/export? -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Friday, June 14, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: Re: sequence question Bigp Remember that when you

autostart 8.1.7 intelligent agent on Solaris

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

changing passwords for INTERNAL and SYS on Unix

and INTERNAL linked in the same way? Do I need to change SYS password and then recreate the password file for INTERNAL password? thanks much bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services

RE: address table

-- Author: Magaliff, Bill 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, send

conferences - IOUG vs OOW

://www.orafaq.com -- Author: Magaliff, Bill 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

RE: conferences - IOUG vs OOW

--- Magaliff, Bill [EMAIL PROTECTED] wrote: Having never been to either and wanting to plan for one, am I to infer from some of this discussion that for real content (as opposed to marketing fluff), THE conference to attend would be IOUGLive, as opposed to Oracle Open World? -bill -- Please

RE: conferences - IOUG vs OOW

SIG in two weeks -- since Cary's company Hotsos is giving a clinic in NYC, we've got two of his partners coming to give a presentation on using the 10046 trace files. Rachel --- Magaliff, Bill [EMAIL PROTECTED] wrote: thanks to both of you, Rachel and Stephen . . . clears it up for me. btw I

Using XML in the dba

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

RE: Using XML in the dba

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

RE: Copy tables and indexes etc from one db to another

command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

anyone know how to change tablespace names?

: Magaliff, Bill 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, send an E

access another user's data in a stored procedure - BECOME USER pr

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

good pl/sql coding/debugging tool?

pl/sql constructs (i.e., records, types, etc.) any comments/feedback/suggestions from the group would be greatly appreciated . . . thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: Any scripts to check the health of the database

') 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.com -- Author: Magaliff, Bill INET

RE: Syntax For Dropping a default value?

://www.orafaq.com -- Author: Magaliff, Bill 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

errors with CREATE SYNONYM procedure

|| ' for ' || v_lwowner || '.' || v_objname; execute immediate (v_sql); end; / -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: errors with CREATE SYNONYM procedure

://www.orafaq.com -- Author: Magaliff, Bill 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

AFTER CREATE trigger help, please

nothing when creating a new table . . . any ideas, please?? thanks, all -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: AFTER CREATE trigger help, please

] Bill, A trigger cannot display output. Where would it go? A trigger does not run in an interactive session, it runs in the database independently, regardless of the presence or absence of a SQL Plus session. Jared Magaliff, Bill [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/10/2002 09

why does DBCA (DB Create Assist) reassign default tablesepace for

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

Trigger or ????

Title: Trigger or try a cron job (if unix) or at job (if NT) -Original Message-From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 14, 2002 10:58 AMTo: Multiple recipients of list ORACLE-LSubject: Trigger or I have a need to reset a sequence

RE: trouble importing

-- Author: Magaliff, Bill 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

RE: trouble importing

meg have not shown a corresponding increase in speed, at least in my experience. HTH, Jared Magaliff, Bill [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/16/2002 09:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc

RE: how to grant selct on all the ables in schema

send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

procedure entry point kpuhhmrk cannot be located in oraclient8.dl

: Magaliff, Bill 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, send an E

RE: procedure entry point kpuhhmrk cannot be located in oraclient

that you should check with the supplier of your software. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Magaliff, Bill [SMTP:[EMAIL PROTECTED]] Sent: Thu, January 31, 2002 6:51 PM To: Multiple recipients of list ORACLE-L Subject: procedure entry

dbms_stats question

if you don't specify a partition name when executing dbms_stats.gather_table_stats, will Oracle gather stats for each partition separately? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: How to find out Oracle patch applied

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

RE: Installing 8i on Windows 2000 Server / Pentium 4

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

RE: Changing dump destinations in init.ora

: http://www.orafaq.com -- Author: Magaliff, Bill 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

SET TRANSACTION for a Distributed Transaction

the SET TRANSACTION would use a local RBS . . . any ideas/comments on writing putting something like this together? Thanks -bill magaliff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858

using dbms_output.put_line to write out a blank line

-- Author: Magaliff, Bill 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

RE: using dbms_output.put_line to write out a blank line

tried this - it outputs a black square: -Original Message- Sent: Mon, February 25, 2002 3:23 PM To: Multiple recipients of list ORACLE-L You could try: dbms_output.put_line(chr(13)); Magaliff, Bill wrote: anyone know how to use dbms_output.put_line to write out a blank line

Import placing data into wrong tablespace

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

RE: Import placing data into wrong tablespace

-- Author: Magaliff, Bill 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

poor query performance

+ minutes. T1 has about 57K rows T2 has about 29500 rows other queries with costs in the 700 range are pretty quick - this one's a dog any ideas? thanks Bill Magaliff Framework, Inc. 914-631-2322 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL

Cost vs Rule

dramatically enough to make any real difference in execution time. thx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: Cost vs Rule

next? I've been unable to alter the costs dramatically enough to make any real difference in execution time. thx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: Cost vs Rule

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

RE: Cost vs Rule

To: Multiple recipients of list ORACLE-L How much have you played with Oracle Hints??? -Joe --- Magaliff, Bill [EMAIL PROTECTED] wrote: I work in a dev shop - most of the sql is canned and pretty basic. We've been running CBO in all of our dev environments, but we have a few long txns that just

RE: Cost vs Rule

. Where to go next? I've been unable to alter the costs dramatically enough to make any real difference in execution time. thx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: Cost vs Rule

://www.orafaq.com -- Author: Magaliff, Bill 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

Passing in NULL via SQL ACCEPT

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

  1   2   >