-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT
> > > Content-Description:
> > > > > > > >
> > > > > > > > --
> > > > > > > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > > > >
___
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rachel Carmichael
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 8
fornia-- Mailing list and web hosting
services
> > ----
-
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and i
or: Rachel Carmichael
> 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 yours
---
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).
does in a typical
> > distributed
> > >query. Perhaps a driving_site hint would help here.
> > >
> > >However, that does not explain why I was able to cause it to stop
it
> > >from doing the massive sorts by serializing the target insert.
> > >
> >
gt;
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jonathan Lewis
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting serv
ted.
Thanks,
Jack Silvey
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jack Silvey
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting servi
___
> Do You Yahoo!?
> HotJobs - Search Thousands of New Jobs
> http://www.hotjobs.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: [EMAIL PROTECTED]
>
>
ge
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') 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
(like subscribing).
>
>
>
>
>
_
> Join the world's largest e-mail service with MSN
> Hotmail.
> http://www.hotmail.com
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> A
Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line con
also send the HELP command for other information
> (like subscribing).
>
> --
> Rodd Holman
> Enterprise Data Systems Engineer
> LodgeNet Entertainment Corporation
> [EMAIL PROTECTED]
> (605) 988-1373
>
>
__
: http://www.orafaq.com
--
Author: Jack Silvey
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
___
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack Silvey
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
ude 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).
__
Do You Yahoo!?
Yahoo! Autos - Get free ne
d like to see the names of the
> columns in this table,
> > their datatypes and such other details. In other
> dbmss like mysql a
> > command 'describe ' gives the
> information. What is the
> > equivalent in Oracle?
> >
> >
>
> --
> Ple
L PROTECTED] (note EXACT spelling of
> 'ListGuru') 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).
ote EXACT spelling of
> 'ListGuru') 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).
_
used. As always, test and then
test some more.
hth,
Jack
--- Jack Silvey <[EMAIL PROTECTED]> wrote:
> Imma,
>
> First thought is no - oracle implements
> function-based
> indexes by using a hidden psuedocolumn to hold the
> resultant data of the function. Since you would
EXACT spelling of
> 'ListGuru') 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).
_______
> also send the HELP command for other information
> (like subscribing).
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack Silve
nd for other information
> (like subscribing).
______
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://
gt; from). You may
> also send the HELP command for other information
> (like subscribing).
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://w
blem.
>
> please help me
>
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack Silvey
INET: [EMAIL PROTECTED]
Fat City
onnor and Jared for
> their
> help!!
>
> Gene
> --- Jack Silvey <[EMAIL PROTECTED]> wrote:
> > sorry, meant insert as select, not insert as
> append
> > --- Jack Silvey <[EMAIL PROTECTED]> wrote:
> > > Gene,
> > >
> > > This sou
te option of ANALYZE command before gathering
> new statistics using
> DBMS_STATS?
>
> Thanks,
>
> Cherie Machler
> Oracle DBA
> Gelco Information Network
>
>
>
>
>
>
] (note EXACT spelling of
> 'ListGuru') 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).
____
sorry, meant insert as select, not insert as append
--- Jack Silvey <[EMAIL PROTECTED]> wrote:
> Gene,
>
> This sounds right.
>
> Standard insert as append does freelist block
> checking
> and generates redo. Parallel DML generates minimial
> redo, just for the n
> from). You may
> also send the HELP command for other information
> (like subscribing).
______
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: h
ck down to
> > > zero, then set the increment to 1 (or whatever
> it
> > > was), there you go, no
> > > dropping the sequence.
> > >
> > > 10 to 1 odds Jared posts a nice little script
> that
> > > automates this second
> > > approach ;-)
>
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack Silvey
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Dieg
pace_proc;
>
> set term on
> set lines 135
>
>
> prompt
> prompt Free space per tablespace:
> prompt
>
>
> select tablespace_name,
> sum(decode(old,7,value)) c7,
> sum(decode(old,6,value)) c6,
> sum(decode(old,5,value)) c5,
>
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack Silvey
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
them my resume. the third page of which is
> FILLED with lists of
> presentations I have given, awards I have gotten for
> presentations I
> have given and books I have written
>
> if they STILL want me to have OCP on my resume after
> that, I don't want
> to work ther
ed through" and you can respond "yes, and I can
jump through some hoops for you too" and allow them to
say "here is an outrageous sum of money to work on our
computers."
I love this job.
jack silvey
ocp 7.3, 8.0, 8i, 9i
--- Don Granaman <[EMAIL PROTECTED]> wrote
le MV Definition :
> > >
> > > CREATE MATERIALIZED VIEW GENRELOB
> > > NOLOGGING
> > > BUILD IMMEDIATE
> > > REFRESH COMPLETE ON DEMAND
> > > DISABLE QUERY REWRITE
> > > AS SELECT DISTINCT
> > > '1' AS CLIP,
>
se see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Michael P Sale
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>
---
rnia-- Public Internet
> > access / Mailing Lists
> >
>
----
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXAC
__
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Aut
ant to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACL
o.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack Silvey
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet ac
t; Will
> someone with this cerifification make $2000 more
> over
> her professional life than she would without?
>
> So it takes a round trip ticket and three days of
> vacation. Get the company to pay for it or write it
> off as a business expense.
>
> Good in
trip ticket and three days of
vacation. Get the company to pay for it or write it
off as a business expense.
Good investment, easy money, instant credibility to
many hiring managers.
jack silvey
> On 19 Jun 2002 at 4:38, Ron Rogers wrote:
>
> Date sent:Wed, 19 Jun 2002
alter system set current_schema=x"
> statement after all.
>
> I am sure that this raises some interesting
> questions,
> if only I had time to dwell on it. Just now cleaning
> up all the broken indexes from the loads that
> abended
> when the db went down.
>
&
he
> > > recipient
> > > named above, and may be legally privileged. If
> the
> > > reader
> > > of this message is not the intended recipient,
> you
> > > are
> > > hereby notified that any dissemination,
> distribution
> > > or
> > > copying of this communicati
Paula,
what is the size of your hash_area_size,
sort_area_size, and sort_area_retained_size?
what does your explain plan look like? hashes,
sort/merge, or nested loops?
do you have a lot of parallel to parallel, parallel to
serial in your plans?
jack silvey
--- [EMAIL PROTECTED] wrote
Lee,
This is an idle wait event, meaning that the query
process is waiting on instructions from the client.
Usually this process is benign, but sometimes can
indicate that the feeding process is not providing
data in a timely fashion.
hth,
jack silvey
--- Robertson Lee - lerobe <[EM
you get to play at
work?
jack
> --- Jack Silvey <[EMAIL PROTECTED]> wrote: >
> All,
> >
> > thanks for the input. Looks like someone
> implemented
> > a
> > login trigger. haven't seen the code yet, but I
> > would
> > venture a gue
All,
thanks for the input. Looks like someone implemented a
login trigger. haven't seen the code yet, but I would
venture a guess he used the unsupported "alter system
set current_schema=x".
sometimes you live and learn, sometimes you just live!
thx,
jack silvey
--- Hate
--
Author: Jack Silvey
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,
--
Author: Jack Silvey
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,
query.
hth,
jack silvey
select
e.owner||'.'||e.segment_name segment_name,
sum(cnt) all_buffers,
sum(hot) hot_buffers,
sum(tch) touches
from
( select
min(file#||'.'||dbablk) fb,
count(*) cnt,
sum(decode(lru_flag, 8, 1, 0)) hot,
su
t; (like subscribing).
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack Silvey
INET: [EMAIL PROTECTED]
oking at as well. The plus is, it's free. and we
> don't need another
> oracle license etc etc etc
>
> and even better, it wouldn't be MY responsibility to
> maintain :)
>
> Rachel
>
> --- Jack Silvey <[EMAIL PROTECTED]> wrote:
> >
ember.
The LDAP was accessed by the Java processes and
gathered the password and username from it to login to
the database.
hth,
jack silvey
--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> One of the users here came to me to talk about
> setting up user
> authentication and wanted
smack a couple of those sessions at the UNIX level and
login right quick. make sure beforehand that this will
not lead to data corruption or anything nasty like
that. and if it does, have a heart to heart with your
manager about this app.
hth,
jack silvey
--- [EMAIL PROTECTED] wrote:
>
Just a thought, since analyze does sorting, might be a
change in sort_area_size. Did you change this param
when you upgraded? Try it with a large sort_area and
see what happens.
jack silvey
--- [EMAIL PROTECTED] wrote:
> I suggest running in parallel. Also, is the table
> parti
of grant, can anyone think of another way?
thx,
jack silvey
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack Silvey
INE
Paula,
With so much data, Oralce (or Oracle, if you prefer)
might be hash joining your tables and writing temp
hash segments.
What is your hash_area_size?
jack silvey
--- [EMAIL PROTECTED] wrote:
> Guys,
>
> Have 20Gb and 16CPUS available on host. Need to do
> large full-t
le
> >using 8 concurrent processes. Since we had no space
> to
> >grow, our ITL could not expand, and some of the
> >processes deadlocked with a similiar error.
> >
> >What is your pctfree and initrans? how many procs
> are
> >trying to insert/delete/update it
? how many procs are
trying to insert/delete/update it at once? are ALL
dying, or just some?
jack silvey
> --- Walter K <[EMAIL PROTECTED]> wrote:
> > We have an application that is periodically
> > encountering what appears to be a self-deadlock.
> Only
> > one ses
ould expect to see pq
enqueue waits of some sort, however.
Otherwise, perhaps the pq procs cannot write, but have
never had problems with our PQ procs writing before
and have done many parallel CTAS to this tablespace.
thanks,
jack silvey
__
Do Yo
ocal first during
object name resolution, it would probably use these
views instead of the data dictionary views.
This worked. The two views that I customized are below
- feel free to use.
jack silvey
ALL_ARGUMENTS:
select
u.name owner, /* OWNER */
nvl(a.procedure$,o.name) object_name, /*
O
> San Diego, California-- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, inc
[EMAIL PROTECTED] for
details.
--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> I'm sure it's #6 :)
>
>
> --- Jack Silvey <[EMAIL PROTECTED]> wrote:
> > Matt,
> >
> > 1) Storage parameter changes? Do you specify
> storage
> > at th
The jr thinks that she knows.
The mid knows that she knows.
The sr knows that she knows not.
Awareness of ignorance is the mark of true knowledge.
I like cake.
jack silvey
--- "Fink, Dan" <[EMAIL PROTECTED]> wrote:
> I agree, the Jr. DBA must focus on learning.
> Mid D
ugar again?
sometimes, this can cause an index glucose spike and
tend to make it store more fat in the leaf blocks,
especially around the middle of the index, but
sometimes on the hips too. Perhaps you are not doing
DDL on the table enough, and so the index is not
getting enough exercise.
hth,
j
output.put_line('did '||v_sql);
execute immediate v_sql;
exception
when others then
dbms_output.put_line ('problem with '||v_sql);
end;
end loop;
end;
/
jack silvey
--- "Mandal, Ashoke" <[EMAIL PROTECTED]>
wrote:
> Greetings,
>
> Here is the sc
ses
register with when they use the table) cannot grow
(no space with pctfree 0) and the extra processes will
either wait or fail with a deadlock error. To change
pctfree you will have to rebuild the table.
hth,
jack silvey
> -Original Message-
> Sent: Thursday, May 30, 2002
handy on occasion.
Did I say be careful? Might want to buff up the resume
before you start acting like the Mad Hidden Parameter
Scientist.
;)
jack silvey
--
--
-- author: jack silvey
-- about: shows hidden and non-hidden parameters
tom,
This is interesting. How did you determine max
distribution and uniform distribution? Did you use
standard deviation and variance?
regards,
jack silvey
--- "Terrian, Tom" <[EMAIL PROTECTED]> wrote:
> John,
>
> I know in a previous job, we determined that
> h
er,
pr.sid child_pq_sid,
substr(sq.sql_text,1,1000) par_sql_text
from v$px_process pr, v$px_session ps, v$session se,
v$process vp, v$sqlarea sq
where pr.sid = ps.sid
and ps.qcsid = se.sid
and ps.qcserial# = se.serial#
and se.paddr = vp.addr
and se.sql_address = sq.address(+)
order by 1,2,3,4,5
/
/j
uot; statement.
Once I put the DML statement before the transaction
statement, the query spawned off 24 processes and
finished in 16 minutes.
/jack silvey
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.
,
/jack
__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack Silvey
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX
gt; > - And some said that queries against the ODS
> were acceptable and
> > > others
> > > deemed them forbidden. And some said that if it
> looks like a data
> > > warehouse
> > > and smells like a data warehouse it verily
> indeed is a data
> &g
es and did not look at Column spread and
> sensitivity. However, I believe
> that the combination of ESTIMATE on Tables and
> COMPUTE on Indexes would
> catch most of it.
>
> As always, YMMV!
>
> John Kanagaraj
> Oracle Applications DBA
> DBSoft Inc
> (W): 408-970-7002
>
&
; > publications for $60 that will take you step by
> step through building
> > an
> > entire
> > data warehouse, including the infrastructure.
> >
> > Jared
> >
> >
> >
> >
> >
> >
> > "MacGregor, Ian A." <[EMAIL PROTECTED]>
> > S
n the future? Can
> I leave it as is numeric and create materialized
> views with it padded or
> should I bite the bullet and reload into
> char/varchar2 datatypes?
__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://laun
rt into dm_time
> values(to_date('20020101','MMDD'), 1,1,2002);
> >insert into dm_time
> values(to_date('20030101','MMDD'), 1,1,2003);
> >
> > 2 rows nice and simple
> >
> > trying to validate the dimension comes up w
ound
is to delete stats with DBMS_STATS.DELETE_TABLE_STATS
and then use ANALYZE.
There are others, like the DESC index problem that I
did not research, just noted in passing.
/jack silvey
__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Exper
ficance in more highly skewed data?
>
> Just something to consider.
>
> Cherie Machler
> Oracle DBA
> Gelco Information Network
>
>
>
>
der versions.
>
> Cherie Machler
> Oracle DBA
> Gelco Information Network
>
>
>
>
ozens of execute
> calls for each single
> SQL statement with a multi-row result source. The
> program could have
> performed the business function with a fraction of
> the db calls.
>
> Oh yes... Why did the Payroll program get *slower*
> after th
TED] (note EXACT spelling of
> 'ListGuru') 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).
__
our sample is
> representative enough, you could analyze using
> either
> estimate 49% or compute, take a snapshot of the
> stats,
> and then compare the stats from a 10,000 row
> estimate
> to those. Then, add rows to you
?
/jack silvey
__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack Silvey
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538
from). You may
> also send the HELP command for other information
> (like subscribing).
______
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
--
Please see the official ORACLE-L FAQ: http:/
n the underpillow method of
knowledge transfer.
/jack
--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> gee, and here I thought all I had to do was put the
> book under my
> pillow and let the words seep in through osmosis :)
>
>
> --- Jack Silvey <[EMAIL PROTECTED]>
I find that if I wrap my books in Saran Wrap, I can
read in the shower. And if you prop the book up on
your shoulder, you can read it backwards in the
rearview mirror during drive time. Also, if you learn
to read in your sleep, you can get LOADS of stuff
done.
;)
hth,
/jack silvey
--- Rachel
I second that emotion. the guy that wrote it is a PhD
and owns Red Brick or something. totally knows what he
is talking about. One of my top five books, best
warehousing book by far I have ever read.
/jack silvey
--- [EMAIL PROTECTED] wrote:
> Yup, $60, and worth every penny.
>
> It
scripts and contact the user
with succes or failure
# Jack Silvey
#---Oracle variable section ---
export ORACLE_SID=iron
export ORACLE_HOME=/u01/app/oracle/product/8.1.7
#---shell variable section ---
SCRIPTPATH=/u01/app/oracle/admin/iron/scripts
SQLPATH=$SCRIPTPATH/sql
SCRIPTNAME=$SQLPATH/$1
that TOAD can use dba_source, but they
have not had luck with this (might be a default role
thing, have not verified).
Opinions or other options?
Jack Silvey
__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
--
Please
warnings.
>
> Ravindra
>
__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack Silvey
INET: [EMAIL PROTECTED]
Fat Cit
ntaining: 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).
__
Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!
ermout off
> set head off
> set verify off
>
> drop table depends;
>
> create table depends as select * from
> sys.dba_dependencies tablespace tools;
>
> set termout on
>
> select '*'||lpad('
-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).
__
Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!
http://shopping.yahoo.co
ies;
>
> Depends? Like the adult diaper?
>
> Doing a little CYA?
>
> Jared
>
>
>
>
>
> Jack Silvey <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 05/09/2002 04:03 PM
> Please respond to ORACLE-L
>
>
> To
and prior name = referenced_name
and prior type = referenced_type
start with referenced_owner = upper('&1')
and referenced_name = upper('&2')
and owner is not null
/
good luck,
jack silvey
__
Do You Yahoo!?
Yahoo! Shopp
1 - 100 of 104 matches
Mail list logo
