i don't think it is considered a join, from what I remember it was called
"merging indexes".
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Thursday, May 31, 2001 3:11 PM
Jared/all,
A joke is exactly how I read it and is how I meant my request for HELP to
come across :).
Btw, thanks to everyone for interesting replies, reaffirming my grim
suspicions about MS idea of "archiving"...
Gary Weber
Senior DBA
Charles Jones, LLC
609-530-1144, ext 5529
-Original Mes
If you know the size of the number (in position count not value) you can use the
RPAD(sum(field),count,0) to populate the right end of the return value to zero.
ex. the sum value is = 2.5 and you want 2.50 rpad(sum(fd1,4,'0') return 2.50
BUT if the return value = 25.5 and you want 25.50 and ha
If you do a snapshot refresh then the snapshot log should be empty(correct?).
Then I would think you could reorg the master table as long as you prohibit
users from updating the master until the reorg and the recreating of the log is
complete. Thus eliminating the need to do a complete refresh of
Title: RE: Resizing Log file
Nirmal,
you need to add new groups with a new redo log size, force the switch, and drop the small redo log groups once they are not active and have been archived. Check the doco for exact syntax. You can't just resize them iirc.
Be sure to have at least two
At parse time, the optimizer determines that partition elimination can be
done -- which partitions to use is determined after the values are bound to
the query.
-Original Message-
Sent: Thursday, May 31, 2001 3:17 PM
To: Multiple recipients of list ORACLE-L
Can oracle do partition elimi
hi dba's,
In my DB, oracle 816, NT4, the redolog member's size is only 50kb. I'm
having only two groups with a single member each.
I tried with alter database command, there is only options for adding and
droping log group or member...
How can i resize it.. to increase the size 5mb.
Regards,
On Thu, May 31, 2001 at 11:17:30AM -0800, [EMAIL PROTECTED] wrote:
> Ray
> I think, you are referring to RAC, Real Application Cluster. Which
> is same as OPS with cache fusion for all scenarios. Please see my previous
> mail thread with the same subject..
--
index oracle-l
The ar
Fernando, If your current resources are limited and the
app is partitioned, you should have very few problems
implementing the App in OPS (famous last words). If HA is
a requirement and fast failover times OPS is a good pick.
Just make sure the ends justify the means. Some people
have good e
Hi
Some time I am receiving the following information in alert logs.
"ORA-60: Deadlock detected." and .trc file generated.Let me know what to
do to prevent such error.
Thanks
-seema
_
Get your FREE download of MSN Explorer at ht
> -Original Message-
> From: Fisher, Julie [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 31, 2001 6:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: How to encrypt Password in Export script file ?
>
> I also did this on all my databases - works very slick.
>
> Ju
As Kevin Lange pointed out, you need the correct access to UTL_TCP.
If you have access to this package through a role, you won't be
able to do this. You must login as sys and give an explicit grant:
e.g. grant execute on sys.utl_tcp to scott;
Whe you say that the package is shown as valid i
No need to copy the whole file to the standby when adding a datafile! Just wait
for recovery to fail on the new file (ORA-01670), then type on the standby (in
'mount standby database' mode):
SQL> alter database create datafile '' as '';
As long as you are using identical paths on both primary a
I'm looking for recommendations for Windows based s/w
that does the equivalent of SCCS/RCS on Unix. A command
line interface is a requirement; GUI is optional.
TIA & HAND!
--
Charlie Mengler Maintenance Warehouse
[EMAIL PROTECTED] 10641 Scripps Summit
Richard,
Thanks! Now let me know if the book is actually useful...
I think you are going to have to bite the bullet and do the rebuild with
logging. And, since this is something you may have to do over and over
again, I'd create that extra tablespace and datafile and leave them there on
both
I think you mean bitmap join indexes which is a new feature in 9i.
Regards,
Waleed
-Original Message-
Sent: Thursday, May 31, 2001 1:08 PM
To: Multiple recipients of list ORACLE-L
There is certainly something new called an index join around in 8i.
[EMAIL PROTECTED] wrote:
> I wonder
Title: RE: what's hash-join
Hi Lisa,
You're correct.
I'm sure you know, but I'd like to add that
hash join usually works faster than over
methods
when there are no good selective conditions
in the
clause WHERE.
Regards,
Ed
Hi Kevin,
It's quick if you have the temp space
to s
Title: digital tru64 unix
Hello everyone,
Anyone out there running Oracle on this flavor of Unix? If so can you please email me directly?
I don't have a Unix box to play with and I have a few simple performance questions. I'm also looking in the online doco and I don't see what I'm looki
Ray, Oracle9i RAC (Real Application Clusters) is or was
(depending on your perspective) Oracle Parallel Server.
Compaq is working with Oracle to pre-install and ship
Oracle9i on there NT boxes (not sure about TRU64 or
OpenVMS platforms), so you just turn it on and it works.
Oracle9i replicati
I thought everyone would realize this is a joke. It's been
appearing with some regularity in a mocking tone of
someone that posted it seriously a couple of weeks ago.
Sigh... Maybe I am just having a bad day.
Jared
On Wednesday 30 May 2001 23:50, Jared Still wrote:
> Are you an idiot?
>
>
We put the code in a file on Unix (our server platform) and in the change
request form, provide the file name and location. The DBA will log in as the
schema owner and simply run the file. Any errors are reported back to
developer who requested the change. All the SQL code is archived using SCCS.
It apparently is only on NT, and unless you have the password,
which is known only to Oracle Support Personnel, you can't
use it.
http://www.ixora.com.au/q+a/0101/23224038.htm
Jared
On Thursday 31 May 2001 12:10, K Gopalakrishnan wrote:
> Hi !
>
>
> The simple thing is you can edit the databl
What do you mean by 'the system is not set up'. How do you verify that?
We had problems with datafiles larger then 2 G and just turned autoextend
off on all datafiles.
I didn't know the system may or may not be set up to handle specific file
size limit. Is it documented?
Please explain. Thank y
Never say never :)
I opted for 4 GB files in a larger database which is living happily on EMC
Sym box. If hardware and software allow for fewer, easier managed large
files...why not? This is scratching the surface of course...
Gary Weber
Senior DBA
Charles Jones, LLC
609-530-1144, ext 5529
I want to know if it is allowable to kill programmers who say "these are the
rules for data in this column" but then don't enforce those same rules.
Rachel (rolling up her sleeves, putting on the rubber gloves to begin data
scrubbing really BAD data)
>From: Jared Still <[EMAIL PROTECTED]>
>Re
Helmut Daiminger wrote:
>
> Hi!
>
> I have a SQL problem here, which I can't solve.
>
> I have a B-tree structure in a table (parentID, childID).
>
> If a parent has kids then select those kids. If not, select this parent.
>
> How do I code this in SQL? I tried using "connect by" but this doe
Folks,
Just got an e-mail from my Damager that there is a concern about the cost
of TOAD licensees and an effort is being made to find a suitable
replacement. Evaluation of PL/SQL Developer by Allround Automations is
underway. Anyone knows the pros/cons of using this (PL/SQL Developer)
product in
Ray
I think, you are referring to RAC, Real Application Cluster. Which is same as OPS with cache fusion for all scenarios. Please see my previous mail thread with the same subject..
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com
Ray Stell <[EMAIL
Rachel, OPS or in 9i RAC (Hate name changes confuses
everyone) raw devices are a requirement of the OS not
Oracle. So whether you are using 7, 8, 8i, 9i you can use
filesystems for OPS (RAC) if the OS supports multiple
concurrent mounts on the same filesystem from multiple
nodes. This is the
nah. you aren't, the rest of us are :)
>From: Jared Still <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: OT: Archiving not possible with SQL Server?
>Date: Thu, 31 May 2001 11:38:08 -0800
>
>
>I thought everyone wo
Hi Anita,
Ironically that is just what I am trying to do. (ie implement a storage plan
which will address the issues discussed in the paper) To your other point, I
understand oracle's position, but if I can prohibit changes to the master
during the reorg/rebuild, is this still an issue?
Is it possible that there is an error in your init file? I have had this
problem before with Oracle 8.0.5 on NT, I had to reboot :) the machine and
then it worked, very strange.
Kev
-Original Message-
Singh
Sent: Thursday, May 31, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L
On Thursday 31 May 2001 10:07, Mogens Nørgaard wrote:
> There is certainly something new called an index join around in 8i.
That wouldn't be considered a new type of join though would it?
Just using indexes as a data source for the join. They shoulda done
this a long time ago.
Jared
--
Pleas
Dick, I am not sure which platform you where using for
OPS, but you have to use raw device's. Unless you are
using OpenVMS or Compaq TRU64 v5.1 you have to use raw
devices for datafiles, controlfiles and online redo logs.
Archive logs have to go to a file system. Now there are
some unsupporte
Steve,
If you are going to pull code from v$sqlarea, you will also want
to use v$sqltext.
In that case, look up the paper at www.hotsos.com about joining
v$sqltext and v$sqlarea, as the hash_value is defined as a
different data type in each. This affects all releases prior to
8.0.5.
Also, yo
I was thinking the 18's where a better idea now that everyone agrees.
However, I can't go with more than 4 drives unfortunately, this is on a Dell
Precision 410. I could try and add an additional scsi adapter, but I am not
sure that I would have a place for the drive, unless I went external.
Call Oracle support and ask for a document "Cracking Outlook Express", this
PDF will explain (thought not in complete details) how to implement this
interface. I am not sure if this file is available through Metalink
Libraries ... you can check though ...
Raj
_
If you do a snapshot refresh then the snapshot log should be empty(correct?).
Then I would think you could reorg the master table as long as you prohibit
users from updating the master until the reorg and the recreating of the log is
complete. Thus eliminating the need to do a complete refresh of
Can oracle do partition elimination when ysing bind variables?
Alex Hillman
-Original Message-
Sent: Thursday, May 31, 2001 1:16 PM
To: Multiple recipients of list ORACLE-L
Dave:
Oracle does do partition elimination in this case...check out he
partition_start and partition_stop column
I've been expirementing with MV for a couple of days. Interesting gotcha's for fast
refresh on
commit, but otherwise cool stuff. Now for the question.
If I have a base table of 1 millions rows of time series data and I want to produce
MVs for day,
month, and year aggregates, would it be bette
Actually, Oracle 'Applications" or a flavor there of has been around for many years.
10 + I believe.
What CD PACK are you looking for?
ROR mª¿ªm
>>> [EMAIL PROTECTED] 05/31/01 10:50AM >>>
Still no response from Oracle Canada, I left a message again - they didn't
know what to do when people orde
At 9:07 -0800 31/5/01, Mogens Nørgaard wrote:
>There is certainly something new called an index join around in 8i.
An index join is a hash join on 2 or more indexes which between them
contain all the columns required to fulfill the query. It is new to
8i, and is considered to be an access pathl b
Hi !
The simple thing is you can edit the datablocks using
BBED editor. It is shipped with Oracle and You need a
password to use that utility. You can browse and edit
the data blocks.
$BBED will give the required details. BUT IT IS
DANGEROUS
--- novicedba <[EMAIL PROTECTED]> wr
Yes it does.
The scan will be range of partitions and the execution plan will show
partition stop = key and partition start = key.
Regards,
Waleed
-Original Message-
Sent: Thursday, May 31, 2001 3:17 PM
To: Multiple recipients of list ORACLE-L
Can oracle do partition elimination when
they should be, unless you do nologging operations -- which can mess up your
standby database
>From: "The Oracle DBA" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Rebuilding indexes
>Date: Thu, 31 May 2001 10:05:57
Title: RE: select question
I believe you'll want to rpad your return value.
select rpad(26.5,5,0) from dual
returns
26.50
or format it in SQL*Plus.
HTH
Lisa Koivu
Oracle Database Administrator
954-935-4117
The information in the electronic mail message is Cendant confidential an
I guess this has already been answered, but to clarify:
I believe "Cartesian" refers to a *product* ("Cartesian product"), not a
join.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 1:41 PM
To: Multiple recipients of list ORACLE-L
Cartesian Join?
--
Pleas
Hi Folks,
I have just installed 8.1.7 on my HP-UX 11.00 box and have Apache running.
Now what? How can I test to make sure apache is talking to oracle and
vice-versa? The install documents don't really explain that part and I've
tried searching metalink but don't know what I'm looking for. Help
Take a look at /var/adm/messages for any reported errors
-Original Message-
Sent: Thursday, May 31, 2001 12:16 PM
To: Multiple recipients of list ORACLE-L
Has anybody come across the following error message in the listener.log, and
know what the resolution is.
TNS-12500: TNS:listener
Check optimizer_mode in v$parameter for your session. I don't think it will eliminate
partitions if it is RULE.
Here is an explain plan from a simple select on a partitioned table. An index exists:
SELECT STATEMENT Optimizer=CHOOSE (Cost=1.69535189333285 Card=32 Bytes=3488)
PARTITION RANGE
Title: RE: Auto Extend
We had
an issue here where we had the Sun box to except files over 2G but got bitten in
the ass quickly by it. We use HP OmniBack to backup all our Unix boxes and
the agent on the Sun box could not handle the file size. So there is more
then just "Can the OS handle i
You are out of space on that filesystem.
Check the size of your log files, as they are likely
responsible for consuming a lot of space.
Also check in the cdump directory for core files.
Jared
On Thursday 31 May 2001 09:16, zabair ahmed wrote:
> Has anybody come across the following error
Kev,
1. I have never heard of a cache directly on the hard drive (Which
certainly doesn't mean it doesn't exist). I have heard of a cache on the
controller for the HD!
2. I assume that you are looking at upgrading one of the Dell Workstations,
yes? If so, I highly recommend calling Dell and
Thanks
I just found it interesting that here in Canada no one has asked for the
trial CD kit... and that Oracle Canada doesn't know what to do when we wish
to order one.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Shreter, Hilary [S
Lisa,
This is what we did in my last project:
1. Developers had access to the application schema where they created and
modified procedures/functions/triggers as needed
2. After their unit testing is done, the QA team would test it using the
front-end application.
3. Once QA team approves the
18Gb with the cache all the way, I would recommend Seagate for this. The
cost difference is small between the 9Gb and 18Gb plus 18Gb will be
replaceable for longer time than 9Gb.
I would recommend more than 4 disks though. Specially if your implementing
raid of some sort.
If at all possible.
Rachel,
First, let me say that I just bought your book, so I definitely appreciate
any comments coming from you!! :) I'm simply trying to defrag the indexes
tablespace of the primary database, which I've done in the past as I
described below. Now that I have a standby database out there, I jus
Hi Anita,
Ironically that is just what I am trying to do. (ie implement a storage plan
which will address the issues discussed in the paper) To your other point, I
understand oracle's position, but if I can prohibit changes to the master
during the reorg/rebuild, is this still an issue?
Ditto
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L
I wouldn't mind a copy of that doc Mark?
-Original Message-
Sent: 31 May 2001 13:34
To: Multiple recipients of list ORACLE-L
Hi people,
A few we
Now that sounds like a fantastic idea, now all that I have to do is figure
out how you do that?:0 Kev
-Original Message-
McDonald
Sent: Thursday, May 31, 2001 1:47 PM
To: Multiple recipients of list ORACLE-L
if you get 18's then you can just use the outer 9G
portion of each drive to ge
This can be done using the Outlook object model. I have never done it with
express but have created lots of stuff with outlook. Check out
msdn.microsoft.com for information on the model and examples (look in the
MSDN Library).
- Ethan Post
-Original Message-
Sent: Thursday, May 31, 20
Title: RE: Listener problems
> -Original Message-
> From: zabair ahmed [mailto:[EMAIL PROTECTED]]
>
> Has anybody come across the following error message in the
> listener.log, and
> know what the resolution is.
>
> TNS-12500: TNS:listener failed to start a dedicated server process
I have heard rumors that OPS on 9i will allow you to use cooked files.
User group meeting next week, with a presentation on 9i new features.
I'll ask
Rachel
>From: "Adams, Matthew (GEA, 088130)" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[E
Oracle could be doing partition elimination but the tools that you are using
to see the execution plan is not showing you the details you're looking for.
I usually do:
Truncate table plan_table;
explain plan for ;
select * from plan_table;
There should be two columns that indicate the partitio
SET ORACLE-L NOMAIL
---
The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not copy,
I like lsof for this purpose. You can see which processes have which
filehandles and ports open to which hosts. It is an excellent utility.
ftp://vic.cc.purdue.edu/pub/tools/unix/lsof/README
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Thu, 31 May 2001, Mohan, Ross wrote:
> you c
Hi Ed,
Why do you say that OiD "is not cheap"? I haven't seen any associated
costs, other than servers to put it on. Can you explain?
The "complicated" part, though I definitely agree with! :)
Thx!
Rich Jesse System/Database Administrator
[EMAIL PROTECTED]
Hi all,
Does anybody knows how to autmotize the outlook express from a Form,
to open a new mail and atach a file to it, leaving the subject and
destiny in blank, to be filled by the user, or where can I find any
guidelines to do it.
I have searched it at metalink , oraclefaq and the OTN,
if you get 18's then you can just use the outer 9G
portion of each drive to get better performance.
The trick then is convincing management when more disk
is needed that you don't want to use the inner portion
hth
connor
--- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote: > Hi
all,
> Just thou
Hatzistavrou,
Thanks for you reply. It was about 4am when I ran into that and discovered
what I needed to do, however, I knew it would take a while so I just stopped
at that point. But, I was curious to find out if anyone had a BETTER way of
doing it. It seems like a waste if I have to go thro
Title: RE: Auto Extend
Hi Ron,
do you have large files enabled on your system? What unix are you running? if large files are not enabled you're going to get an error but I can't tell you what it will be.
Boy, autoextend reminds me of a monkey running around in your database. I'd never d
Title: RE: Auto Extend
See Note:62427.1, 2Gb or Not 2Gb - File limits in Oracle http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=62427.1
-Original Message-
From: Connor McDonald [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 9:56 AM
Title: Implementing Stored Procedures
Hi -
I'd like some advice on implementing stored procedures containing application logic (ie. written by developers). We have several applications where the developers use stored procedures for much of their coding. We let the developers create or repl
The general school of thought is joining a large table
to a small one. There is an article on Metalink thats
a little out of date now, but it describes the
good/the bad, and tuning of hash joins.
Look for doc 67134.1 and 41954.1
hth
connor
--- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote: >
What'
I need to find the article I had saved about Oracle 6.0 (as we were preparing to
upgrade from 5.1). It was something about how the 6.0 DBA would be bored and would now
be able to help appdev.
Cheers,
Earl
---
TheOracleDBA
[EMAIL PROTECTED]
On Fri, 25 May 2001 09:28:53
Vergara, Michael
Correct.
By the way: A good rule is to always keep the sequence "Table - Snapshot Log -
Snapshot", ie. don't break the sequence, for instance by dropping and
re-creating the snapshot log. If something happens to the snapshot log you
should drop the snapshot, create the snapshot log, then re-creat
Hi!
I have a SQL problem here, which I can't solve.
I have a B-tree structure in a table (parentID, childID).
If a parent has kids then select those kids. If not, select this parent.
How do I code this in SQL? I tried using "connect by" but this doesn't
include start point.
Any idea?
This is
Hi,
When i am trying to start my database form svrmgrl ..
i am getting error:
ORA-00205 error in identifying controlfile, check alert log for more info
there is nothing in alert.log...
i have 3 control files all r in proper directory..
i am using proper SID
i tryied with only i control
hi,
This may sound funny. I want to know
how to corrupt a block. I want to test the different methods of identifying
block corruption, but I don't have sample data blocks.
Please help me
novice
Dave:
Oracle does do partition elimination in this case...check out he
partition_start and partition_stop columns of you plan_table.
Kevin
-Original Message-
Sent: Thursday, May 31, 2001 12:01 PM
To: Multiple recipients of list ORACLE-L
Hi All,
Can anyone help me with this.
I have r
Cartesian Join?
Scott Shafer
San Antonio, TX
210-581-6217
"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup de Grâce via your Ninja
Death Touch, you step
However, if you rebuild all the indexes for schema SALES on PRIMARY, what happens on
STANDBY? Are they rebuilt?
Cheers,
Earl
---
TheOracleDBA
[EMAIL PROTECTED]
On Thu, 31 May 2001 08:16:06
Rachel Carmichael wrote:
>there IS no way to do that with a standby database. Once you open it f
It adds the datafile NAME only, not the file itself. And if the physical
file has not been moved before the archived log that has that redo in it is
applied, the recovery dies.
>From: Hatzistavrou Giannis <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACL
I have heard from iouga attendees that there was is something
called "Rack" from oracle/compaq on the horizon with 9i which
is the next replication solution. Can folks comment on this?
What is the architecture and how does this play with oracle?
Is this just an OPS on some alphastation? Our co
Thanks ! A very useful link !
-Original Message-
Sent: Thursday, May 31, 2001 7:07 AM
To: Multiple recipients of list ORACLE-L
Vikas Kawatra wrote:
>
> Anyone using this product as an alternative to Local Naming ? How about
LDAP
> ?
>
> Any info /suggestions/comments are welcome
>
>
We have a couple of independent applications running over the same instance
now (it's better to do it because our resources cant' support two instances
over the same machine), we think if we use parallel server, we can make
"partition" of this applications, one for each node or someting like that
And it will skip partitions that it can see will not match any other corresponding
partition.
PD Miller wrote:
At
0:16 -0800 31/5/01, Senthil Ganapathi wrote:
could tell me what's that hash-join
Straight from the concepts manual:
To perform a hash join, Oracle follows these steps:
1. Oracl
On unix you can look for the process running the listener. In our shop this
is done by :
$ ps -ef | grep tnslsnr
oracle 413 1 0 May 18 ?2:36
/u03/home/oracle/product/8.0.5/bin/tnslsnr listener.1526 -inherit
oracle 447 1 0 May 18 ?0:08
/u03/home/oracle/produc
Hi,
When using autoextend always set max size and monitor.
Turn off auto extend if a small possibility exists to do so.
Check if your OS has large file size enabled and there won't be any
problems.
jack
Out of space on the file system I believe.
-Original Message-
Sent: Thursday, May 31, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L
Has anybody come across the following error message in the listener.log, and
know what the resolution is.
TNS-12500: TNS:listener failed to sta
The only I know of way to see which process has a port open in Solaris is to
use lsof (there's a package on sunfreeware.com -- including source).
netstat and /proc aren't enough as far as I can see... It's not clear what
exactly you need to know, but hope this helps...
Steve
-Original Messa
I have a select statement that is pulling a field called total, which
represents a total value to charge a persons account. The total column in
the db has the parameters Number(10,2) but when I pull the data out of the
db the value for the total 26.50 looks like this 26.5. Is there away to
force t
I wouldn't mind a copy of that doc Mark?
-Original Message-
Sent: 31 May 2001 13:34
To: Multiple recipients of list ORACLE-L
Hi people,
A few weeks back somebody posted a message regarding an eval they are doing
comparing Oracle/DB2/SQLServer.
I came across a great document today for
"Depends" is the standard answer.
Oracle can handle files over 2g, some unixes can, some
unixes cannot, some say they can but cannot etc etc...
To compound things, in some versions, Oracle will let
the file go beyond 2g, only then to complain because
the unix won't let Oracle get to the bits aft
You seem to have lost your sig. Are you no longer a 'Wanton Kickboxing
Goddess'? ;-)
Todd Carlson
Oracle 8i Certified DBA
Bunge North America
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 F
Adding a datafile does not cancel recovery - you just
need to 'pause' it, transport the appropriate files to
the standby and resume standby operations.
hth
connor
--- Richard Huntley <[EMAIL PROTECTED]> wrote:
> For those of you that have implemented a standby
> database, what method do
> you us
I have always been told that using functions on fields would stop the
efficient use of indexes so . what if you said
WHERE it.transaction_date BETWEEN
to_date('May-19-2001.00.00.00', 'Mon-dd-.hh24.mi.ss') AND
to_date('May-28-2001.23.59.59', 'Mon-dd-')
This would at
Saurabh;
Have you looked at ALL of the packages involved ?? Does the SYS.UTL_TCP
exist and does the ID using SEND_MAIL have the correct access to it ?? (I
know these are basic questions, but its usually the basic ones that get us
first !)
Kevin
-Original Message-
Sent: Thursday, May
There is certainly something new called an index join around in 8i.
[EMAIL PROTECTED] wrote:
> I wonder if their thinking of the star join??
>
> Dick Goulet
>
> Reply Separator
> Author: =?iso-8859-1?q?Connor=20McDonald?= <[EMAIL PROTECTED]>
> Date:
Hi,
I'm on DIGEST, so I don't know if that's
been answered already, or not.
But anyhow, what about:
update (
select t.field1 f, t.field2 v, d.field1 g, d.field2 w from
testtable1 t, testtable2 d
where t.id = d.id)
set f = g, v = w
HTH
Dieter Buecherl
> From: "Eric D. Pierce" <[EMAIL PROTECTE
101 - 200 of 291 matches
Mail list logo
