Charlie,
I understand a transaction as a succession of SQL statements between two successive
COMMITs or ROLLBACKs - you will find inside V$SYSSTAT how many COMMITs and ROLLBACKs
were issued.
If you are interested, besides transactions proper, in the number of statements
executed, then have
Hi
All I know is that we used to completely different machines to set up a
windows test RAC.
The requirement seems to be that the OS must be the same.
Jack
-Original Message-
Sent: Wednesday, January 28, 2004 4:24 PM
To: Multiple recipients of list ORACLE-L
When running on a cluster
When running on a clustered environment, do all the servers have to be
identical?
Oracle says that the beauty of using blade servers is you buy what you need
now, then add later.
What if "later" is two years later? You might not be able to buy the same
machines, only more powerful ones.
Does th
t had disappeared and I had to (re)subscribe to
www.oraperf.com.
--
David Lord
> -Original Message-
> From: Anjo Kolk [mailto:[EMAIL PROTECTED]
> Sent: 27 January 2004 13:29
> To: Multiple recipients of list ORACLE-L
> Subject: RE: What to look for in STATSPACK report
>
>
yes!
--- Daniel Fink <[EMAIL PROTECTED]> wrote:
> Is there any interest in an Oracle-L gathering after the first
> day at RMOUG TD?
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Daniel Fink
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-5
one word ... CLOB field ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Messag
list ORACLE-LSubject:
RE: !!Please Read - Oracle-L is moving!!
Hi
List Manger-
Couldn't a immigration of our subscribed accounts been the most logical
and error free option ?
All
this fire would have been avaoided.
CSW
Simon.
-Original Message-From:
11:09 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: !!Please Read - Oracle-L is moving!!
One word -
exchange.
--David Lord
-Original Message-From: Hemant K
Chitale [mailto:[EMAIL PROTECTED] Sent: 23 January 2004
16:54To: Multiple recipients of
Title: Message
Thanks Mark Bobak
syed
- Original Message -
From:
Bobak, Mark
To: Multiple recipients of list ORACLE-L
Sent: Monday, January 26, 2004 6:39
PM
Subject: RE: consistent read gets
(I'm
sending the reply to the freelists.org list as well.
it is the same. '%TATA.COM' is not a variable.
sumant
--- Wolfgang Breitling <[EMAIL PROTECTED]> wrote:
> Is the sql really "the same query is run from a stored
> procedure" or is it
> perhaps using in place of the '%TATA.COM' a plsql variable
> (which is set
> to %TATA.COM)?
>
> At 04:44 AM
From: David Hau <[EMAIL PROTECTED]>
Date: 2004/01/27 Tue AM 11:54:26 EST
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: When does Oracle use 'Index Fast Scan'
This is where the access time of your disks (or SAN) makes a difference.
If your di
;
>
> [EMAIL PROTECTED] wrote:
>
> >ive found that index_ffs typically incur higher logical I/Os that index
range scans. so its not just access speeds.
> >
> >
> >>From: David Hau <[EMAIL PROTECTED]>
> >>Date: 2004/01/27 Tue AM 11:54:26 EST
> >
ive found that index_ffs typically incur higher logical I/Os that index range scans. so its not just access speeds.
From: David Hau <[EMAIL PROTECTED]>
Date: 2004/01/27 Tue AM 11:54:26 EST
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: When does Oracl
Q: What does "different results" mean?
Different row count?
Completely different data?
Partially different data?
Some columns have incorrect value?
What about doing it without the parallel hints? The tables aren't
so big that it would take a long time to find out.
Jared
"Pillai, Ra
cc:
Sent by: Subject: RE: How to find the last
execution time of a Procedure.
[EMA
Mauricio,
Check the Oracle version. We had similar problems with 8.1.7.2.
They got disappeared after we upgraded to 8.1.7.4
--
Thanks,
Krishna
~~
NOTICE: This email message is for the sole use of the intended
recipient(s) and may contain
forall should be used as follows:
forall index in lower_bound..upper_bound
;
Putting anything other than a sql statement (e.g. a pl/sql block) in a
forall statement defeats its purpose.
If you think about it, forall achieves its performance improvement by
binding arrays to the arguments of a
ive found that index_ffs typically incur higher logical I/Os that index range scans.
so its not just access speeds.
>
> From: David Hau <[EMAIL PROTECTED]>
> Date: 2004/01/27 Tue AM 11:54:26 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subjec
Sorry I did not make it clear that the number I used here (1, 9, 15,99) are
just examples, the actual element index is a varible and they are not
continuous. Yes, refTbl can be defined into a package. I guess what I am
asking is if there is a way in pl/sql to do something like
-- FORALL array el
If mypackage.function(i) is doing some DML operation on i, then the real
way to make it faster is to modify the signature of
mypackage.function(i) to take an array instead, and to do a "forall ...
" within mypackage.function(i).
forall is most useful when you want to minimize context switching
On 01/27/2004 02:09:25 PM, "Jesse, Rich" wrote:
Couldn't the declarations be put into a package? We've done this in
order
to maintain values for the life of the session.
Yes, they could, I didn't see it in this example.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mlad
Couldn't the declarations be put into a package? We've done this in order
to maintain values for the life of the session.
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Tu
Declare
type numTbl is table of number index by binary_integer;
refTbl numTbl;
i number;
str varchar2(30);
begin
refTbl (1) := 1;
refTbl (9) := 1;
refTbl(15) := 1;
refTbl(99) := 1;
forall i in refTbl.first..refTbllast
begin
dbms_output.put_line ('i=' || i)
--- David Hau <[EMAIL PROTECTED]> wrote:
> As long as you're not using any 9.2 feature, you
> should be fine. IIRC,
> according to Oracle's upgrade policy, the client and
> the server are
> compatible within one major version.
>
> Even if upgrading to the 92 client is not an
> emergency, you s
, 2004 11:14 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: ADMIN PLZ REPLY - FW: !!Please Read - Oracle-L moving!!
Yes, this is legitimate.
Jared and I have been talking recently about this. This list has
just outgrown what Fat City can handle. While I'd like to think
i normally go to the mount point (ie highest level dir for that disk) and issue:
du -k | sort -n
that way you see where the space is going in descending sequence
good luck,
steve
"Naveen, Nahata (IE10)" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/23/2004 03:44 AM
Please respond t
AIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/27/2004 08:54 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: When does Oracle use 'Index Fast Scan'
This is where t
ans' NOT index fast full
scans.
>
> any ideas? I rarely ever find this to be an optimal index access method
for anything.
> >
> > From: "Tanel Poder" <[EMAIL PROTECTED]>
> > Date: 2004/01/27 Tue AM 11:19:27 EST
> > To: Multiple recipients of lis
: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: When does Oracle use 'Index Fast Scan'
>
> Another situation where index full scans might be handy, would be where hash
> joins are disabled and sorted output can be used for "fast" sort-merg
From: David Hau <[EMAIL PROTECTED]>
> Date: 2004/01/27 Tue AM 11:14:27 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: When does Oracle use 'Index Fast Scan'
>
> This is where the access time of your disks (or SAN) makes a differ
it and hint your queries
From: David Hau <[EMAIL PROTECTED]>
Date: 2004/01/26 Mon PM 10:34:25 EST
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: When does Oracle use 'Index Fast Scan'
Correction: the Index Range Scan can be parallelized when it in
ts the full scan that does 1
I/O at a time. I rarely see oracle using it and when it does, it generally
means my table(s) aren't properly analyzed.
> >
> >
> >>From: David Hau <[EMAIL PROTECTED]>
> >>Date: 2004/01/26 Mon PM 10:34:25 EST
> >>To: Mult
I/Os.
test it and hint your queries
From: David Hau <[EMAIL PROTECTED]>
Date: 2004/01/26 Mon PM 10:34:25 EST
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: When does Oracle use 'Index Fast Scan'
Correction: the Index Range Scan can be par
, it generally means my table(s) aren't properly analyzed.
From: David Hau <[EMAIL PROTECTED]>
Date: 2004/01/26 Mon PM 10:34:25 EST
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: When does Oracle use 'Index Fast Scan'
Correction:
Have you checked DBA_JOBS for the last/next execution times?
Is the job broken?
Please check DBA_JOBS.
Jared
On Mon, 2004-01-26 at 06:04, Mauricio VÃlez wrote:
> Hi,
>
> This is the situation:
>
>
>
> I'm woriking on NT and there are two 8i databases on it
> One database can execute jobs n
parsed pieces.
-Original Message-From: Feighery Raymond
[mailto:[EMAIL PROTECTED]Sent: Tuesday, January 27,
2004 9:29 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: String manipulation
select
substr(subject,1,instr(subject,'~')-1) first,
substr(sub
Title: String manipulation
select
substr(subject,1,instr(subject,'~')-1) first,
substr(subject,instr(subject,'~')+1,
instr(subject,'~',1,2)-(instr(subject,'~'))-1) second,
substr(subject,instr(subject,'~',1,2)+1,length(subject))
third
from
test_table
where
test_column=1700455
/
Ray
Could you ask your Oracle rep. for a reference or two in your
industry? They're usually very quick to give those references.
You can contact the company in question and ask them for references.
HP-UX and terabyte sized oracle 9i database are rather frequent
combination, but you should contact their
Anjo
So what was the deal with oraperf.veritas.com if you don't mind my asking?
I subscribed to it sometime before Christmas, but when I went to use it a
week or so ago, it had disappeared and I had to (re)subscribe to
www.oraperf.com.
--
David Lord
> -Original Message-
>
On 01/26/2004 06:29:26 PM, Stefick Ronald S Contr ESC/HRIDA wrote:
I'm trying to separate a string into 3 values:
The string is:
mystr1~mystr2~mystr3
There is trivial, non-PL/SQL solution based on the split
function. To see more, type "perldoc -f split" and you should
see the light.
--
Please see
no, but you can buy one on Ebay that is 40% off for $8. A friend of mine did it and it
works.
>
> From: "Boivin, Patrice J" <[EMAIL PROTECTED]>
> Date: 2004/01/27 Tue AM 08:09:26 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Exam promo code
>
> Does the OTN promo
time. Less Logical and Physical I/Os.
test it and hint your queries
> From: David Hau <[EMAIL PROTECTED]>
> Date: 2004/01/26 Mon PM 10:34:25 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: When does Oracle use 'Index Fast Scan'
&
0kay, then the alcohol we were consuming fogged my brain :)
getting older is a pain in the butt... I do know I was getting emails
from Veritas about the oraperf site. That must be where the confusion
lies
--- Anjo Kolk <[EMAIL PROTECTED]> wrote:
> No, the server is in my basement.
>
> Anjo.
>
-> -Original Message-
-> From: Anjo Kolk [mailto:[EMAIL PROTECTED]
-> Sent: Tuesday, January 27, 2004 8:29 AM
-> To: Multiple recipients of list ORACLE-L
-> Subject: RE: What to look for in STATSPACK report
->
->
-> No, the server is in my basement.
why? w
No, the server is in my basement.
Anjo.
-Original Message-
Rachel Carmichael
Sent: Tuesday, January 27, 2004 11:44 AM
To: Multiple recipients of list ORACLE-L
that's pretty definitive. :)
I did say "retaining permanent ownership"
Is Veritas hosting it for you?
--- Anjo Kolk <[EMAIL
Title: Message
If you
have a way to work this out in shell then there is a simpler solution
...
$
export VAR='mystr1~mystr2~mystr3'$ echo $VARmystr1~mystr2~mystr3$
echo $VAR | tr '~'
'\012'mystr1mystr2mystr3$
HTH,
Nikhil
-Original Message-From: Stefick Ronald S Contr
ESC/HRIDA
5 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: When does Oracle use 'Index Fast Scan'
>
> Correction: the Index Range Scan can be parallelized when it involves
> multiple partitions.
>
> - Dave
>
>
> David Hau wrote:
&g
Is the sql really "the same query is run from a stored procedure" or is it
perhaps using in place of the '%TATA.COM' a plsql variable (which is set
to %TATA.COM)?
At 04:44 AM 1/27/2004, you wrote:
All,
i have this query:
SELECT count(1)
FROM ats.emktg_members t1
WHERE NOT EXISTS ( SELECT 'x'
It's a bad query that could probably be resolved throuh
an analytic function but I don't normally delve into things
like that before having finished my 2nd coffee. You can
use hints, in particular, there is a hint to force hash join.
On 01/27/2004 06:44:25 AM, S.Sarkar wrote:
All,
i have this quer
that's pretty definitive. :)
I did say "retaining permanent ownership"
Is Veritas hosting it for you?
--- Anjo Kolk <[EMAIL PROTECTED]> wrote:
> No,
>
> It is mine!
>
> Anjo.
>
> -Original Message-
> Rachel Carmichael
> Sent: Friday, January 23, 2004 11:49 AM
> To: Multiple recipien
No,
It is mine!
Anjo.
-Original Message-
Rachel Carmichael
Sent: Friday, January 23, 2004 11:49 AM
To: Multiple recipients of list ORACLE-L
well, I can't get to the site at the moment to test it.. if I remember
correctly, Anjo said he had "leased" it to Veritas for a couple of
years, w
This looks like the Novarg worm
What say people ?
If yes, then thank you Listguru for filtering out the binaries
[EMAIL PROTECTED] is a mass-mailing worm. The worm will arrive as an
attachment with a file extension of .bat, .cmd, .exe, .pif, .scr, or .zip.
When the machine gets infected, the wor
I'm new in the unix world, so get stuck in simple things like this.
I'm thankful to the list, since I didn't get rebuked for asking a non-oracle
question.
du (disk usage) worked easily for me, though Jared's idea of using find was
amusing, I'll get acquainted with that command as well.
Regards
May it rest in peace.
On 01/26/2004 11:19:27 PM, Jared Still wrote:
[EMAIL PROTECTED] is shutting down as of 1/31/2004
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-5
Correction: the Index Range Scan can be parallelized when it involves
multiple partitions.
- Dave
David Hau wrote:
I assume you're talking about the Fast Full Index Scan. This is used
when the index contains all the columns necessary to answer the query.
It's faster than a Full Table Scan b
I assume you're talking about the Fast Full Index Scan. This is used
when the index contains all the columns necessary to answer the query.
It's faster than a Full Table Scan because indexes are smaller than
entire rows, so a Fast Full Index Scan will scan fewer blocks than a
Full Table Scan.
sorry typo. I mean 'Index Full Scan'
- Original Message -
From:
Ryan
To: Multiple recipients of list ORACLE-L
Sent: Monday, January 26, 2004 9:24
PM
Subject: When does Oracle use 'Index Fast
Scan'
I have found that the vast majority of time that
Oracl
Here is an example for you.
You might want to spend some more time studying the instr() function in the SQL
manual to understand how this works. :)
define t = 'mystr1~mystr2~mystr3'
var t varchar2(30)
begin
select '&&t' into :t from dual;
end;
/
select
substr(:t,1,instr(:t,'~')-1) t1
Title: Message
Substr(''mystr1~mystr2~mystr3', 1, 20) => 1 is the position and 20 the
length (not the position). The "substring" functions return a portion of
string, beginning at character position, substring_length characters
long.
SELECT
substr('mystr1~mystr2~mystr3',1,instr('mystr1~myst
if i remember correctly(from a presentation i did like 3 years ago), its
a bug.
joe
Mauricio Vélez wrote:
Hello everybody
I normally have no problems with logminer.
The database es oracle 8.1.7.4.1 on Windows NT
but in this case the results show me the username and session_info
columns emp
As long as you're not using any 9.2 feature, you should be fine. IIRC,
according to Oracle's upgrade policy, the client and the server are
compatible within one major version.
Even if upgrading to the 92 client is not an emergency, you should at
least upgrade the 817 client to the latest patch
Thanks.
Gee, the Oracle sales folks keep telling our Lead Architect that RAC
requires zero code changes...guess this was not true for Statspack.
:)
-Original Message-
Sent: Monday, January 26, 2004 12:14 PM
To: Multiple recipients of list ORACLE-L
Ethan:
You can remove the order by
Actually, I found the actual link:
www.sun.com/bigadmin
scripts
under scripts there's one titled
haoracle substitute 'haora'
HTH!
Barb
--- oranew2004 <[EMAIL PROTECTED]> wrote:
>
> Hi All!
>
> I looking for commands which I could use to check
> Sun Cluster health ( like resources, groups..
Greg:
version 3.0 makes life extremely difficult.
The sudo commands we were able to use in the previous
version do not work in version 3
One of our SA's wrote a perl script that gives the
DBA's access to what we need. He submitted it to Sun
Solve. Take a look there and see if you find it
(rpetty
Mladen,
there you go again! LOL.
now go back and trade your Wang in for a new one.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Monday, January 26, 2004 2:04 PM
To: Multiple recipients of list ORACLE-L
On 01/26/2004 01:34:24 PM, "Mercadante, Thomas F" wrote:
On 01/26/2004 01:34:24 PM, "Mercadante, Thomas F" wrote:
Ashish,
Why do you think that the dates would be different on the two
machines
- is
one across the international date line? Shouldn't the dates be the
same?
Thomas, if we learned anything from Einstein, it is that the time is
relative t
: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]Sent: Monday, January
26, 2004 1:36 PMTo: '[EMAIL PROTECTED]'Cc:
'[EMAIL PROTECTED]'Subject: RE: Getting sysdate
across a DB link
Ashish,
Why
do you think that the dates would be different on the two machines -
Title: Getting sysdate across a DB link
Ashish,
Why do
you think that the dates would be different on the two machines - is one across
the international date line? Shouldn't the dates be the
same?
How
about getting the time from both servers - they *might be* different by a few
seconds
H on our 9204 instance this package is compiled with the order by ... our
compatible is set to 9.2.0.4
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
Ethan:
You can remove the order by if you are not using RAC. Basically it is
to avoid two identical SQLs inserted at the SAME time in RAC setup.
If you are using RAC just add another column in the order by
condition. (st1.hash_value,ss.text_subset,st1.piece)
I don't have the bug # handy. But
MAIL PROTECTED]>
cc:
Subject: Re: What to look for in STATSPACK report
Jared,
Thanks! I'd like to try perl, but I have to admit I am totally naive on
this subject. I am thinking to take a course. (free for me) How much
efforts in order to set this up?
ps, your graph
Create procedure get_date on the remote node and invoke it over the DB
link.
On 01/26/2004 11:14:26 AM, Ashish Sahasrabudhe wrote:
I'm trying to get the value of SYSDATE on a remote server. I have a
database link to the server, but I'm not sure how to force SYSDATE to
be evaluated on the remote
Title: Message
(I'm
sending the reply to the freelists.org list as well. Hope you all agree
that's a reasonable thing to do.)
no work - consistent read
gets - Oracle needs a block that's consistent w/
a particular SCN, goes to the buffer cache, finds it there. It's
done.cleanouts only
I'm trying to understand exactly what you are trying to do. Oracle thinks that you
are trying to get the next value for a sequence named SYSTEM_CHANGE_ID, but there is
no sequence by that name. If that is what you are trying to do, then either the
sequence doesn't exist and you need to create
Joshi, you'll have to use DBMS_SQL and return number instead of ref
cursor. DBMS_SQL has its own, internal table describing open cursors
by numbers. DBMS_SQL also contains a procedure called "describe" which,
I believe, does exactly what you want without XML or OCI.
On 01/26/2004 01:19:27 AM, A
any
sequence. How can I fix this ?
create or replace trigger oracle-l on owner.table
after mess-up
for each row
as
sci_next number;
begin
select system_change_id.nextva into sci_next from dual;
system_change values(sci_next);
raise NO_DATA_FOUND;
exit;
/
You'll have to re-arrange the trigger. O
Read the Oracle Documentation or http://otn.oracle.com or
http://metalink.oracle.com
on what a RowID is. It is actually a composite of
File_Number_in_Database + Block_Number_in_File + Row_Number_within_Block.
Since a Table is like a "heap" rows may be inserted by Oracle in any of the
available bl
Title: Message
If you
are using strongly typed ref cursors, I believe you can use the DBMS_DESCRIBE
package to get that information. You'll just have to parse the output from the
package.
Kevin
-Original Message-From: A Joshi
[mailto:[EMAIL PROTECTED] Sent: Monday, January
Title: RE: Nextval in trigger
Declare the sequence?
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
@>-->-->--
"Few people really enjoy the simple pleasure of flying a kite"
Adam Wells age 11
"Imagination is the highest kite one
That’s what XML is for :P
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of A
Joshi
Sent: Sunday, January 25, 2004
10:19 PM
To: Multiple recipients of list
ORACLE-L
Subject: ** field names of a ref
cursor
Hi,
I am calling a Oracle sto
AFAIK there are no PL/SQL functions to do what you want to do; they are available as
OCI functions, though, but PL/SQL only implements a very small subset of what is
available with OCI. An external C procedure might be an option, but only if not called
too often.
In my experience trying to write
Okey but how can I convert it
-Original Message-
Sent: Sunday, January 25, 2004 4:44 PM
To: Multiple recipients of list ORACLE-L
convert to a lob and use a substr. That might fix the problem.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent
Title: Message
One word -
exchange.
--David Lord
-Original Message-From: Hemant K Chitale
[mailto:[EMAIL PROTECTED] Sent: 23 January 2004
16:54To: Multiple recipients of list ORACLE-LSubject:
RE: !!Please Read - Oracle-L is moving!!Why not stop
using Outlook. I&#x
> > I have a book devoted to PostgresSQL at home. When I come home, I'll
> > post the information.
>
> O'Reilly has "Practical Postgresql", the full text of which is also available
> online: http://www.commandprompt.com/ppbook/
>
> I know there are a couple of others floating around as well.
>
Title: RE: alter table rename error
Yeah ... in 9i, rowid's in capital letters don't work correctly, they
only work on Windows ... which is case insensitive.
8:)
Raj
Rajendra dot Jamadagni at nosp
Title: RE: alter table rename error
Maybe the problem is with your capital
letters?!
Tanel.
- Original Message -
From:
Waleed
Haggagy
To: Multiple recipients of list ORACLE-L
Sent: Sunday, January 25, 2004 5:19
PM
Subject: ROWID PROBLEM
HI ALL..
I
Hi!
Expired backups are unusable since they were not found accessible during
last crosscheck or were set to expired state manually. This means that these
backups can't and won't be used for restore operation.
Obsolete backups can be deleted since there are enough redundant backups
according to cu
You need to understand that Oracle inserts data where
space is available in a table, and dependent on previous
DML in a table, that could be almost anywhere.
If you want to see the data in timestamp order, then
order it by that column.
And please don't use ALL CAPS. It is difficult to read.
Jar
You have to use dbms_sql ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Mess
Title: RE: alter table rename error
you need to read the documentation. Oracle is
supposed to workt his way.
otn.oracle.com
start with the concepts document. Skip the stuff on
java, xml, etc... read the first 10-12 chapters.
- Original Message -
From:
Waleed
Haggagy
convert to a lob and use a substr. That might fix the problem.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, January 25, 2004 10:24 AM
>
>
>
>
> Hi all ,
>I have a problem about fetching long variable in PL/SQL.
>I encountered wi
What amateur of Oracle support engineer are you working with?
Mladen is right. Your syntax is wrong. Read the documentation (and suggest
to the engineer he do the same):
SQL> create tablespace "INDEX1" logging datafile
'/u01/ORACLE/ora92/INDEX11.dbf' size 5m
2blocksize 16384
3
It is NOT true. I did put db_16k_cache_size on
init.ora file. I still work with ORACLE support
engineer tried to find problem.
--- Mladen Gogala <[EMAIL PROTECTED]> wrote:
> On 01/23/2004 12:19:26 PM, Kirtikumar Deshpande
> wrote:
> > Because, you left db_16k_cache_size parameter to
> the defa
Personal communication.
On 01/24/2004 06:44:24 AM, Ryan wrote:
where did you hear that oracle 10g was written almost entirely
outside
the
US?
what critical problems have you had with 9i?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, Ja
Experiment with dba_dependencies view.
- Kirti
--- Mauricio Vélez <[EMAIL PROTECTED]> wrote:
> Hi everybody
>
> I have the following question
>
> How can I query a table's views?
>
> For example I have the table students and I want to know the views related to this
> table.
>
> Than
where did you hear that oracle 10g was written almost entirely outside the
US?
what critical problems have you had with 9i?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 23, 2004 10:19 PM
>
> On 01/23/2004 07:54:25 PM, "Arnold,
What are you trying to get? Column values or (TABLE,COLUMN)
combination? You could probably use a function like this:
create or replace function trickery(T varchar2,C varchar2, V number)
return number deterministic
as
qry varchar2(2048);
cnt number:=0;
begin
qry='select count(*) from '||T||' where
Mark - Thanks for the correction. When I looked at what I said about the transaction
before a DDL command a second time, I myself wondered if I'd gotten it right. If
you've tested it, and the transaction is always committed, I'll take your word for it.
Arup - I don't normally use Oracle's buil
Perhaps I got it wrong, but, John - are you saying that the entries are part
of the rollback, i.e. if the transaction that caused the audit trail entries
to be created is rolled back, the audit trail enries are rolled back as
well?
The auditing entry is NOT part of the transaction, it's created vi
On 01/23/2004 07:54:25 PM, "Arnold, Sandra" wrote:
We still have an 8.1.5 database as well as two 8.1.7.4 and one 9.2.04
databases. We are planning on upgrading our 8i databases this year.
The
rate we are going it probably will be two years before we get to 10g.
Sandra
That would be a very coura
101 - 200 of 71998 matches
Mail list logo
