') 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: Tim Gorman
INET: [EMAIL
...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, October 07, 2002 8:13 AM
Tim, et.al,
We use rman on 8.0.6.3 databases. One of our duvelopers was trying to
delete records from a table and her query deleted everything from the
table. This caused
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: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538
information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Headlines page. A News Notes document containing the alerts has
been published on the My Headlines page entitled Oracle Security Alerts
#42, 43 and 44 Issued October 4, 2002.
Thank you!
The Oracle Support Tea
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnston, Tim
Headlines page entitled Oracle Security Alerts
#42, 43 and 44 Issued October 4, 2002.
Thank you!
The Oracle Support Tea
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnston, Tim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
://www.orafaq.com
--
Author: Tim Gorman
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
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
, 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: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City
--
Author: Tim Gorman
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
the cold backup?
Kind of like Oracle Directory Server: You can't back it up hot either.
I've not worked with OID; why can't it be backed up hot?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858
the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
On Thu, Oct 03, 2002 at 06:38:28AM -0800, Jesse, Rich wrote:
Already did -- and deftly checking the list archives I see that MS Lookout
has once again thwarted me by throwing away a reply by Tim Bunce himself.
That'll be this one...
Tim [also who skims oracle-l sometimes...]
On Tue, Oct 01
not be useful to
assume that to be the case...
Thanks
Raj
Wow! Crazy situation! Best of luck -- sorry not to offer any real help...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
!
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 6:03 PM
Thanks Tim for your response to this. I agree with you. For now, I have
come up with this theory :
I feel that the Unable to use system rollback tablespace errors
(failover_mode = (type=select)(method=basic))
)
)
Hope this helps...
-Tim
- Original Message -
From: "Hemant K Chitale" [EMAIL PROTECTED]
To: "Multiple recipients of list ORACLE-L"
[EMAIL PROTECTED]
Sent: Wednesday, October 02, 2002 10:13
AM
Subject
...Ken wasn'tcomplaining about the
performance of the sequences, but rather about the performance of millions of
queries on SYS.DUAL..
.
- Original Message -
From:
Nick
Wagner
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, October 02, 2002 4:53
PM
: http://www.orafaq.com
--
Author: Tim Gorman
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
PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, October 02, 2002 8:29 PM
Tim, TAF still requires the application to be
programmed with Oracle8 OCI and greater. TAF is a
combination of OCI and net services to allow the
failover to occur. This requirement is still
documented in the Oracle9i R2
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: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services
into more detailed investigations I thought I'd ask for
any words of experience here.
I'll happily summarise to the list if people send info to me directly.
Thanks.
Tim.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Bunce
INET: [EMAIL PROTECTED]
Fat City Network
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: Tim Gorman
INET: [EMAIL PROTECTED]
Fat
Title: RE: datafile sizing question
Do your own testing. Don't rely on
papers. Prove it yourself. It's easy.
There are two types of "performance" implied in
this discussion about extent allocation and deallocation:
performance of SQL statements like SELECT, INSERT,
UPDATE, DELETE (i.e.
about
Oracle database Fragmentation on www.orapub.com, Cary Millsap's Oracle7
Space Management or Juan Loaiza et al's How to Stop Defragmenting and
Start Living both on www.hotsos.com, or Tim Gorman's Myths about Extents
and Performance at www.evdbt.com/papers.htm...
- Original Message
All that he is referring to is the possibility that
"mixing-n-matching" will cause the same SQL statement to be hashed differently,
thus stored individually in the Shared SQL Area cache, thus more "hard parses"
unnecessarily. More "hard-parses" is indeed "more work"...
Though technically
umbers of Extents
100-200 Extents we Consider as a Candidate for
DE-Fragmentation using exp/imp OR ALTER TABLE/INDEX ... MOVE
with Bigger Extent Sizes
Oracle 8.1.7
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: Monday, September 30, 2002 7:48
e-mail to interested parties and tell them
you'll fill in any gaps when you have caught up on lost time. If the
problem has been resolved, details of how are of a mainly historical nature
anyhow - right?
Tim: Can you give me the ISBN's to some of your novels. What!!! You haven't
written any yet
Trans 2 on Tablespace Y
Alter Tablespace Y to read only ( it waits )
End Trans 2
Notice Alter is still waiting
Attempt to start Trans 3 on Tablespace Y ( You will get an error )
Start Trans 4 on Tablespace X
End Trans 1
Notice Alter completes
HTH
Tim
-Original Message-
Sent: Friday
matter if it hangs since it won't hold anything else up... The only problem
is that is the database crashes while the file is pending read only, the
file needs media recovery on restart...
Tim
-Original Message-
Sent: Friday, September 27, 2002 3:24 PM
To: Multiple recipients of list
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: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
As long as we are sure to acknowledge the authorship of
Simon Traviglia (sp?), the original author of BOFH...
There are several websites posting the BOFH saga;
search by the keyword "bofh" on www.google.com to get the correct spelling of
Simon's last name...
- Original Message -
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
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: Johnston, Tim
INET: [EMAIL PROTECTED
: Tim Gorman
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 an E
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: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
') 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: Tim Gorman
INET
--
Author: Tim Gorman
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
). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing
the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
e the script, but it is the
one that I think most about removing, mostly because it has aged rather worse
than I. I've been thinking about rewriting it and bringing it up to date,
but other things always get in the way...
Hope this helps...
-Tim
- Original Message -
From:
M
if this was true it might be difficult to gauge where you
are currently since you probably don't know how many rows you had processed
in the previous transaction(s)...
For query purposes, V$SESSION.TADDR joins to V$TRANSACTION.ADDR...
Hope this helps...
-Tim
- Original Message
Delimiting each column with surrounding
double-quotes as well as commas is pretty standard...
Another standard approach is to delimit with a
character that is less likely to be part of the data, such as the "tilde" or "~"
character...
- Original Message -
From:
Naveen
it...
Hope this helps...
Thanks!
-Tim
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 19, 2002 12:38 PM
We are planning to move to raw devices for all our existing file systems.
Our database size is around 400 Gig. What
that only OWS can diagnose and overcome...
...need my coffee, NOW!
- Original Message -
From: Tim Gorman
To: [EMAIL PROTECTED]
Sent: Thursday, September 19, 2002 7:03 AM
Subject: Re: Lost ofall redo logs
One correction...
The undocumented "_corrupted_rollback_segments"
par
w database. Using these parameters will put the database on life-support
for a short time only, hopefully long enough to extract its data. It would
be foolish to entrust new data to it ever again...
Hope this helps...
-Tim
- Original Message -
From: "K Gopalakrishnan" [EMAIL PRO
What version? What is the definition of table A? Have you enabled parallel
DML? What about the append hint? According to the docs it is supposed to
be automatic with the parallel hint but...
Tim
-Original Message-
Sent: Wednesday, September 18, 2002 3:39 PM
To: Multiple recipients
: 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: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services
--
Author: Tim Gorman
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
it up...
Tim
-Original Message-
Sent: Wednesday, September 18, 2002 6:13 AM
To: Multiple recipients of list ORACLE-L
Hi Everybody,
I have created two Package
Pkg1 and Pkg2
Inside Pkg1, I have defined PL/SQL Table Data Type
Type Pkg1_DataType
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: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538
://www.orafaq.com
--
Author: Tim Gorman
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
with features
like Oracle9i Data Guard in the picture now, but feel free to use the paper
and/or the presentation as a starting point. It started life some 5 years
ago as exactly the kind of presentation you are describing...
Hope this helps...
-Tim
- Original Message -
To: Multiple recipients
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: Johnston, Tim
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858
: Johnston, Tim
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
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: Johnston, Tim
INET: [EMAIL PROTECTED]
Fat City Network
DoesAUDIT SESSION tracks jobs run from
DBMS_JOB? If so, then that makes an OK job history (including elapsed time
as well as logical I/O and physical I/O consumed)...
- Original Message -
From:
Vladimir Barac
To: Multiple recipients of list ORACLE-L
Sent:
).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
e-----From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 04, 2002
2:28 AMTo: Multiple recipients of list
ORACLE-LSubject: Re: OPS Sequences: nocache == order
??
Mladen,
Is there any way to have developers/users
access the sequence via a functio
information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858
t it
uses...
If they don't like the idea of using a stored
function to get the sequence number, then tell 'em that "it's more ANSI standard
that way" and it's "database independent". That gets 'em every
time...
Hope this helps...
-Tim
- Original Message -
From: &q
FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE
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: Tim Gorman
INET: [EMAIL PROTECTED
rep, surely... :-)
- Original Message -
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, August 28, 2002 2:25 AM
Hi
Tim Wrote
Buying an NVRAM unit would probably be more sensible, since
at least then you have some probability of the file-system
Check www.benthicsoftware.com
I've used Golden for a couple years now and love it for the same reasons as
Philip... I also use PLEdit (their PL/SQL editor)... Similar to Golden in
that it is simple and fast... Not as powerful as some of the others tools
but not too bad either...
Tim
(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: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
Title: RE: Encryption of data
I imagine they lost their job soon
thereafter... :-)
- Original Message -
From:
Marul Mehta
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, August 20, 2002 11:05
AM
Subject: Re: Encryption of data
What about encrypting
"SQL*Net more data to client" (as opposed
to"from client") seems to indicate that flow is from server to client,
which doesn't seem appropriate for SQL statements...
- Original Message -
From:
Johnson, Michael
To: '[EMAIL PROTECTED]' ; 'Tim Gorman'
VSD is only a clustered representation of LV
(logical volume) within IBM's LVM (logical volume manager). The reason you
can't get answers from IBM is because they wroteVSDs and
HSDsspecifically for Oracle and OPS only, so it is not "mainstream" AIX;
they really aren't familiar with it.
Depending on the application,couldn't
theselarge pausesbe performance problems in the client
program? Not a server tuning issue nor a SQL*Net tuning issue at
all? For example, if the client program was pausing a long time between
FETCH commands, processing previously fetched data? Or would
information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--
Author: Tim Gorman
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
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, August 19, 2002 10:53 AM
I'm not recommending 7.3.4 for the repository
Why not?
It seems to be the most stable 7+ version available. :)
Jared
Tim Gorman [EMAIL PROTECTED
Title: RE: Index move
Go get 'em, big guy!
- Original Message -
From:
Anjo Kolk
To: Multiple recipients of list ORACLE-L
Sent: Monday, August 19, 2002 11:43
AM
Subject: Re: Index move
"having the index on a different
disk from the table should give you
-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: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538
: http://www.orafaq.com
--
Author: Tim Gorman
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
).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--
Author: Tim Gorman
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
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: Tim Gorman
INET: [EMAIL PROTECTED
Script "gen_recompile.sql" online at http://www.EvDBT.com/tools.htm...
As written, it will not execute the generated
"run_recompile.sql" script; you'll have to uncomment the HOST command at
the bottom to do that. I like to leave it with it's teeth pulled however
-- at least at first -- so I
es things in dependency order. So
far,
this capability eludes me. I use Oracle 8.0.5 -
8.1.7.4.
Cheers,
Mike
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: Saturday, August 17, 2002 8:48
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Good post, Kirti!
Quote...
"Oracle Corp. says its customers are moving toward
data stores of huge size and complexity, spread over multiple locations. The
company says its products will not only evolve to handle those kinds of jobs,
but will also do them extraordinarily well. "Over the
ALL_ROWS and FIRST_ROWS have serious problems when
querying the data dictionary in all versions of Oracle from v7.x to v8.1.x (see
previous posting on 10-Aug, subject "Re: OPTIMIZER_MODE recommendation for
9.2"), documented in bug #564434. The situation is finally fixed in 9iR2,
and
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: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim
the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access
Title: RE: Transferring data from one table to another
SQL*Plus COPY command can do it, truncating the
contents of the LONG after the length specified by by SET LONG
command...
- Original Message -
From:
Shaw
John-P55297
To: Multiple recipients of list ORACLE-L
the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access
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: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858
(like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
), then the calculated volume will be unduly high as
well. But it's probably better to err on the high side anyway...?
Hope this helps...
-Tim
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 14, 2002 6:08 AM
Hi List,
I want to put my databse
send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access
the RAISE_APPLICATION_ERROR command.
Hope this helps!
-Tim
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 14, 2002 4:08 PM
OK, I admit up front I'm not a pl/sql programmer. And I really did try to
look this up. Honest.
Took me a VERY
objects more carefully and
appropriately...
Hope this helps...
-Tim
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 13, 2002 1:48 AM
Hi All,
Oracle 8.0.5
AIX 4.3.3
We have a database that showed an ORA-1575 every minute for 30
this helps...
-Tim
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, August 12, 2002 11:48 PM
All
I have a meeting tomorrow where I am going to point out why SAN and Oracle
does not go very well together. Here are my thoughts. Can you pick holes
and it should provide some good guidance
on setting up queues for your own particular environment and requirements,
even if the ConcMgr terminology has maybe changed for R11i...
Hope this helps...
-Tim
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent
501 - 600 of 1011 matches
Mail list logo
