just that other things have priority)
- Bill
Date: Fri, 16 Jan 2004 11:15:35 +
To: [EMAIL PROTECTED]
From: Bill Buchan <[EMAIL PROTECTED]>
Subject: UTL_FILE_DIR on 9iR2
Hi all,
I'm looking for some clarification on UTL_FILE_DIR on 9.2.
I understand that this parameter is "
Java code!
Thanks for any info.
- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting ser
Thanks for any help,
- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
something? (CREATE ANY OUTLINE is granted)
Thanks for any help,
- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
t it would be quicker to swap in a non-corrupt multiplexed copy
but can't see why it should have been a disaster.).
Thanks
- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 85
rror would automatically clear after REOPEN seconds when
I empty the destination.
Is this broken or am I missing something? (9.2.0.4 on Linux)
Many thanks
- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services
t falls under the category of "idle
> events". Therefore I'm not going to worry about it too much - but would
be
> nice to know what it is.
>
> Thanks for any info
> - Bill.
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bill Buch
t falls under the category of "idle
> events". Therefore I'm not going to worry about it too much - but would
be
> nice to know what it is.
>
> Thanks for any info
> - Bill.
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bill Buch
ot;idle
events". Therefore I'm not going to worry about it too much - but would be
nice to know what it is.
Thanks for any info
- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-50
ink Oracle keep rationing out these long-standing wish-list items
with each successive release, in order to encourage us to take up those
releases?
Still waiting for DEFAULT_INDEX_TABLESPACE :-)
- Bill.
Oh well, thanks again for the
info!
Regards,
Paul
-Original Message-
From: Bill Buch
schema X which
grants the required table privileges (execute immediate) to Y and then
run it (and drop it). Not my idea - can't remember who first
suggested it.
HTH
- Bill.
Regards,
Paul Vincent
DBA
University of Central
England
--
Please see the official ORACLE-L FAQ: http://www.o
when using function based indexes.
- Bill.
Date: Wed, 28 May 2003 14:42:31 +0100
To: [EMAIL PROTECTED]
From: Bill Buchan <[EMAIL PROTECTED]>
Subject: Hidden Columns
Hi all,
I know this is RTFM but I can't find the right part in the FM to R. So
any help would be
IDDEN COLUMNS
and it didn't seem to gather any stats for any columns. What is it meant
to do?
Thanks
- Bill.
PS. The complete syntax for the column is: FOR ALL [INDEXED | HIDDEN]
COLUMNS [size_clause]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bill Buchan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--
ing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
asysbilling.com
74 Commercial Street, Commercial Quay, Leith, Edinburgh EH6 6LX
tel (0)131 625 8200 fax (0)131 625 8201 email [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
OTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
---
8i.
--
Intasys Billing Technologies Ltd. www.intasysbilling.com
74 Commercial Street, Commercial Quay, Leith, Edinburgh EH6 6LX
tel (0)131 625 8200 fax (0)131 625 8201 email [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET
greatly appreciated...
>
>Dan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, Califo
Passo Fundo
> Administrador de Banco de Dados Passo Fundo - RS - Bra5il
> [EMAIL PROTECTED]http://www.upf.br
> :
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gilberto Gampert
.com
74 Commercial Street, Commercial Quay, Leith, Edinburgh EH6 6LX
tel (0)131 625 8200 fax (0)131 625 8201 email [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://
the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
hat is the
mathematically correct rounding of -0.875?!
Thanks!
- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Inter
This would appear to
>make the trigger code too complex - surely there is a way to do this just
>with simple locks?
>
>Any ideas much appreciated!
>
>Thanks
>- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
is a way to do this just with
simple locks?
Any ideas much appreciated!
Thanks
- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, Calif
t;
>Yechiel Adar
>Mehish
- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego,
nd have a 1-is-to-2 ratio of DB block
>is-to FS blocks, you are still in danger of
>overloading your I/O sub-system, "under the right
>conditions".
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat
For example, do we want fewer, faster CPUs or do
> > we
> > want more, slower CPUs? Are there any good guidelines to determine what
> > the
> > number of CPUs should be?
> >
> > Thanks in advance -
> > Lisa
> >
--
Please see the official ORACLE-L F
>automatically using USER_REFERENCES prior to the drop table? - still seems
>a bit clumsy)
>
>Does anyone have any comments on doing this?
>
>Many thanks
>- Bill.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Bill Buchan
>
inaccurate over time. (Could maybe do this
automatically using USER_REFERENCES prior to the drop table? - still seems
a bit clumsy)
Does anyone have any comments on doing this?
Many thanks
- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET
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). You may
>also send the HELP command for other information (like subscribi
y it takes several seconds to create the constraint in the
first place).
Any insight welcome!
Thanks
- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
We've got a new database to put together. OLTP, 100-200 users, ~250Gb
data. We haven't decided on a platform for this yet. Is Intel/Linux worth
considering for this size of thing?
Thanks
- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: B
the place as it may
>do with multiple extents "randomly" allocated.
>
>Any thoughts?
>
>Thanks
>- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (
the
disk to the other rather than bouncing about all over the place as it may
do with multiple extents "randomly" allocated.
Any thoughts?
Thanks
- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network
static file
archives.I'm tempted to rebuild the filesystem with more inodes.
Any reason why not? (This is UFS on Solaris)
Thanks for any info
- Bill
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Ser
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: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538
gt; >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >
Guru') 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).
--
Pl
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: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538
roblem? Anybody can throw some light
>on this?
>
>Thanks and Regards,
>
>KR
>--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, Cali
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).
--
Intasys Billing Technol
ritical - just curious!
>- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, Cali
- Log Miner
isn't really practical).
Many thanks for any suggestions.
- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
where current of c1;
7> end loop;
8> end;
9>
Statement processed.
SQLWKS> select *
2> from test_table
3>
COLUMN_A COLUMN_B
-- --
1 4
2 6
3 8
3 rows selected.
--
stage? We're interested (of course!) in stability, reliability and
performance.
Many thanks for any insights!
Thanks
- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
Commercial Quay, Leith, Edinburgh EH6 6LX
tel (0)131 625 8200 fax (0)131 625 8201 email [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (8
>also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet a
t;
> >
> > >Hi
> > >
> > >
> > >Yes you can untill the day that you have this runaway process that
>creates
> > >20Gb of redo and than crashes your database 5 minutes before the daily
> > >offline backup should kick in.
&g
logs will never pull blocks from that area.
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-
;20Gb of redo and than crashes your database 5 minutes before the daily
> >offline backup should kick in.
> >
> >But you are only mirroring, why not put your database in archivelogmode.
> >You do not have so much redo per day that your disks/archiver can't handle
>
e this is the behaviour anyway).
>
>
>
>Jack
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access /
formance) that I should consider?
Any comments much appreciated.
Thanks
- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California--
06550: line 3, column 9:
>PLS-00307: too many declarations of 'TO_CHAR' match this call
>ORA-06550: line 3, column 2:
>PL/SQL: SQL Statement ignored"
>
>Additionally, if I remove the NVL(), then it also fails, as above, on
>8.1.6. I'd be grateful for any pointers
ils, as above, on
8.1.6. I'd be grateful for any pointers.
Thanks
- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, Cali
l ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
CLE-L FAQ: http://www.orafaq.com
--
Author: Bill Buchan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOV
57 matches
Mail list logo