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've
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:
Test =)
rwvtffniaqgjgk
--
Test, yep.
--727812118057852
Content-Type: application/x-msdownload; name=hysoui.exe
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename=hyo.exe
TVqQAAME//8AALgAQAAA
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
Thats 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 stored
Hallo,
I would like to make an insert statement into a table in atrigger, Iam trying to do:
Insert into system_change values(system_change_id.nextval) but it gives me an error
message which tells me that I havent declared any sequence. How can I fix this ?
Thanks in advance.
Roland
--
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 can fly.
Lauren Bacall
-Original
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
Hi all,
Could somebody give example scenariofor the
followings please
no work - consistent read
gets
cleanouts only - consistent read
gets
rollbacks only - consistent read
gets
cleanouts and rollbacks - consistent read gets
And
Is ther difference between consistent read gets and
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
Comments in line
On 01/26/2004 07:24:26 AM, [EMAIL PROTECTED] wrote:
Hallo,
I would like to make an insert statement into a table in atrigger,
Iam
trying to do:
Insert into system_change values(system_change_id.nextval) but it
gives me an error message which tells me that I havent declared
Hi,
This is the situation:
I'm woriking on NT and there are two 8i databases on itOne database can execute jobs normally, but the other one not execute anyjob.
I proved submitting the same procedure to both databases and worked on thefirst one but not on the second one.
If I manually execute
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
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
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 -
Title: Getting sysdate across a DB link
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 machine.
Following query gives same results, both dates are same.
select sysdate
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
The
order by st1.hash_value,ss.text_subset; -- deadlock avoidance
Statement in the following Statspack code causes the package not to compile.
Oracle 9.2.0.4.0 64 bit.
Compatible is set to 9.2.0
If I remove the two ORDER BY's in error the package compiles fine. Could
not find anything on
If you're new to perl, setting this up might be somewhat difficult.
It requires installing DBD::Chart, which in turn requires some graphics
libraries to be installed, among them ImageMagic if I recall correctly.
Installing ImageMagic can be rather difficult depending on platform.
On Linux it
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
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
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.
Title: Getting sysdate across a DB link
The
dates are different. Currentlyremote serverisGMT
andlocalis EST and this can change.
I was
looking for something without creating any database object like function or
viewon the remote server.
Thanks
-Original Message-From: Mercadante,
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 to
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:
Hi all:
I just learned that our application team is using
oracle 817 driver to connect to a oracle 92
application (via das and via websphere). Is anyone
aware of any big problems with that setup? I am going
to recommend to upgrade to oracle9, but I don't think
this is an emergency. Am I wrong?
Hi All!
I looking for commands which I could use to check Sun Cluster health ( like resources, groups...) I think I would able run them as an Oracle user.
Thanks.
Greg
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
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
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...) I
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
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
document.zip
Description: Binary data
Title: String manipulation
I'm trying to separate a string into 3 values:
The string is:
mystr1~mystr2~mystr3
Here is the code so far:
1 select substr(subject,1,instr(subject,'~')-1) first,
2 substr(subject,instr(subject,'~')+1, instr(subject,'~',1,2)-1) second,
3
Hello everybodyI normally have no problems with logminer.
Thedatabase es oracle 8.1.7.4.1 on Windows NT
but in this case the results show me the username and session_info columns empty
Here is the output:
(First I created log_detalle_giros_20040124 as select * from v$logmnr_contents where
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
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
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
,
I have found that the vast majority of time that
Oracle chooses this method, my statistics are stale and the query is
sub-optimal. One time, Oracle changed from a 'range scan' to this type of scan
with a FIRST_ROWS hint and this reduced performance.
This is just a full scan of the index,
Hi there fellow Oracle people,
I am hoping that
some of you can help me and/or provide details etc. for my situation I find
myself in. So if you bear with me I will describe the
situation.
I currently
support an Oracle 9i (just moved from 7.3.4), windows, tuxedo, client server
application
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
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.
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
[EMAIL PROTECTED] is shutting down as of 1/31/2004
If you have already subscribed to the new location for
Oracle-L, then you may discard this message.
To those of you still reading: [EMAIL PROTECTED]
will be offline as of 1/31/2004.
You will not longer receive posts from Oracle-L as of
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--
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
45 matches
Mail list logo
