Actually, there is a bug fix to 8.1.7.1. You don't really
need to go to 8.1.7.2 although I wouldn't necessarily say
not to.
-Original Message-
Sent: Tuesday, December 18, 2001 7:40 PM
To: Multiple recipients of list ORACLE-L
If you are running 8.1.7.1, it has memory leak problem.
Hello,
FYI, my understanding is that 8.1.7.2.0 has problems, and that 8.1.7.2.1 is
the way to go.
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 781-278-8341 (office)
email - [EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, December 18, 2001 10:40 PM
To:
I am still waiting for Oracle 8.1.7.3 final release for 8.1. Then start looking at
9.1, when it comes out.
[EMAIL PROTECTED] 12/19/01 10:35AM
Hello,
FYI, my understanding is that 8.1.7.2.0 has problems, and that 8.1.7.2.1 is
the way to go.
Thank you,
Paul Sherman
DBA
voice - 781-501-4143
Gene,
You may have a longer wait than January if you are non-Solaris.
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 781-278-8341 (office)
email - [EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, December 19, 2001 11:27 AM
To: [EMAIL PROTECTED]; [EMAIL
Paul - How does one get 8.1.7.2.1? We ordered 8.1.7 recently from Oracle,
but outside the CD just says 8.1.7. Do I need to download something? Sort of
a silly question, but maybe someone else is as dumb as I. Thanks.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
About a month ago, I upgraded from 8.1.7.1.0 to 8.1.7.2.1 (actually the
banner says 8.1.7.2.0). Everything is good so far.
Bing
-Original Message-
Sent: Wednesday, December 19, 2001 9:09 AM
To: Multiple recipients of list ORACLE-L
Gene,
You may have a longer wait than January if
Upgrade first to 8.1.7.2.1. Don't wait.
-Original Message-
Sent: Wednesday, December 19, 2001 9:09 AM
To: Multiple recipients of list ORACLE-L
Gene,
You may have a longer wait than January if you are non-Solaris.
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax-
oracle's banner rarely agrees with the actual revision that you are running.
I think that it just indicates the base rev, without the patches.
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 781-278-8341 (office)
email - [EMAIL PROTECTED]
-Original Message-
Sent:
Dennis,
Well, as far as I know, you download it from Oracle's download web-site.
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 781-278-8341 (office)
email - [EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, December 19, 2001 12:43 PM
To: Multiple recipients
PROTECTED]
TOUCH.COMcc:
Sent by: Subject: RE: Help
[EMAIL PROTECTED
The base release is 8.1.7[.0.0]
Applying patchsets change the 4th number, eg 8.1.7.1, or 8.1.7.2
The 5th number is reserved for port (ie OS) exceptions, fixes specific to each
platform.
On platforms like Unix, individual patches on top of the patchset can be applied
(relinked) without
I heard that! We got bit on 8.1.7.1 by a 'Cache Buffer Chains' latch
contention bug (bug 1967363) that is not fixed until 8.1.7.3 or 9.0.2. The
releases are supposed to be out in January, IIRC.
--Scott
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
HELP !!
-Original Message-
Sent: 17 December 2001 22:50
To: Multiple recipients of list ORACLE-L
You're kidding, right?
--- Boag, Merridy [SMTP:[EMAIL PROTECTED]]
[EMAIL PROTECTED] wrote:
Does this mean that I am no longer on the mailing list?
Thanks you for your help
Mer
Yeah, but you can be aged out.
-Original Message-
Sent: Monday, December 17, 2001 9:15 PM
To: Multiple recipients of list ORACLE-L
There is no escape. In the buffer pool, no one can hear you scream...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Are you an idiot?
Jared
;)
On Monday 17 December 2001 23:45, Robertson Lee - lerobe wrote:
HELP !!
-Original Message-
Sent: 17 December 2001 22:50
To: Multiple recipients of list ORACLE-L
You're kidding, right?
--- Boag, Merridy [SMTP:[EMAIL PROTECTED]]
[EMAIL PROTECTED]
HELP
-Original Message-
Sent: Monday, December 17, 2001 5:50 PM
To: Multiple recipients of list ORACLE-L
You're kidding, right?
--- Boag, Merridy [SMTP:[EMAIL PROTECTED]]
[EMAIL PROTECTED] wrote:
Does this mean that I am no longer on the mailing list?
Thanks you for your help
Mer
Mer,
The listserv is just like a mail redirector, it takes any message and send a
copy to everyone on its list.
If you are receiving the messages, you are on its list of recipients.
As long as you get the e-mails... you are on the listserv.
Otherwise you wouldn't get them anymore.
Don't
by: Subject: RE: help
[EMAIL PROTECTED]
om
Naw.
Just Ross.
and we'd all agree he needs help.
--
From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Tuesday, December 18, 2001 12:55 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: help
Another idiot
.
Mohan, Ross
MohanR@STARS- To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
SMI.com cc:
Sent by: Subject: RE: help
[EMAIL PROTECTED]
om
Your SGA has become fragmented. You would not per chance be running
8.1.7 would you? If so I would go and do some searching on Metalink.
I see an upgrade in your future. You could try flushing the SGA but
if its what I think it is it won't help. A restart will for a while.
-Original
Your SGA is too small.
'alter system flush shared_pool' will temporarily fix
this problem, while booting all of your carefully cached
sql out of the pool at the same time.
Consider:
making shared_pool_size larger
making reserved_pool_size larger and pinning
some objects in memory
RTFM, but i'm in a decent mood, so i cut paste the explanation from
oerr(if you're on windoze, move to unix, then you'll have oerr).
04031, 0, unable to allocate %s bytes of shared memory
(\%s\,\%s\,\%s\,\%s\)
// *Cause: More shared memory is needed than was allocated in the shared
//
If you are running 8.1.7.1, it has memory leak problem. Need to upgrade to
8.1.7.2.0.
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 12/18/01 5:50 PM
Your SGA has become fragmented. You would not per chance be running
8.1.7 would you? If so I would go and do
Title: help
Please
remove me from the mailing list,
Thank
you
Mer
-Original Message-From: Boag, Merridy
[SMTP:[EMAIL PROTECTED]]
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, 18 December 2001
10:11To: Multiple recipients of list ORACLE-LSubject:
help
HELP
**
:
RE: help
Please remove me from the mailing list,
Thank you
Mer
-Original Message-From: Boag, Merridy
[SMTP:[EMAIL PROTECTED]]
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, 18 December 2001
10:11To: Multiple recipients of list ORACLE-LSubject:
help
HELP
You're kidding, right?
--- Boag, Merridy [SMTP:[EMAIL PROTECTED]]
[EMAIL PROTECTED] wrote:
Does this mean that I am no longer on the mailing list?
Thanks you for your help
Mer
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 18 December 2001 10:26
To: Multiple
There is no escape. In the buffer pool, no one can hear you scream...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 17, 2001 4:50 PM
You're kidding, right?
--- Boag, Merridy [SMTP:[EMAIL PROTECTED]]
[EMAIL PROTECTED]
You may want to check support.microsoft.com.
There are some pages there that detail the use
of Oracle and ASP.
Jared
ARUN K C
sangeetha,
1) If a tablespace is deleted all of the tables, indexes or rollback
segments that reside in that tablespace will also be deleted. Users are not
stored in a tablespace, except in the SYSTEM tablespace - which you DON'T
want to delete as it is the tablespace that runs the Oracle
sangeetha,
1. When a tablespace is deleted, the users do not get dropped. Users would
still be present. However, the tables created on the tablespace would be
dropped. Users and their details are maintained in Oracle dictionary. If
you have DBA permissions on your database, check the view,
Title: RE: HELP : doubts regarding --- Tablespace ,Roll Segment , diff between oracle 8i and 9i, and between oracle 8i and previous versions - urgent
Hi sangeetha,
Well, hope that u want to know all in big things in one struch ;-).
Ok, here are my answers to you.
1
How is the job market in Austin?
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 4:00 PM
To: Multiple recipients of list ORACLE-L
Hey, the job market isn't any better (worse?) here in Austin-by-God, TX
than anywhere else. We've got a chance to hire a
Dave,
Straight from the Web (pointed to by Google):
http://www4.nationalacademies.org/ohr.nsf/b955c29d65d6677d8525676f00506905/7
18c743a7456d4f2852568ce007a0f74?OpenDocument
Qualifications: B.A./B.S. or equivalent, preferably in computer science,
information systems, or a related field; and at
save the key
then to set it back
alter user username idenfified by values 'HEX KEY HERE';
joe
[EMAIL PROTECTED] 10/24/01 10:10AM
Hi all,I've got a little question, which i can't find
simply on metalink.I've got one user with a not know password and i want to
temporary changeit;s
It's just
ALTER USER username IDENTIFIED BY VALUES 'hex-key-whatever';
Substituting the username and password value from dba_users as appropriate.
There are scripts that save it in a file with the commands to switch it back,
but it's easy enough to do manually.
Simon Anderson
Hi all,
The script below will generate a script that can be used to restore the
userid to its original state.
select 'alter user ' || username || ' identified by values ''' ||
password || || ' default tablespace '
|| default_tablespace ||' temporary tablespace ' || temporary_tablespace ||
' ;'
from
this is documented in Kevin Loney's 7.3 edition of the DBA Handbook
(look for become_another_user.sql)
--- [EMAIL PROTECTED] wrote:
Hi all,
I've got a little question, which i can't find simply on metalink.
I've got one user with a not know password and i want to temporary
change
it;s
Here is a script I use all the time to run jobs for other users. It saves the current
password, sets the password to temp, connects to user, and sets it back to original
setting. Now you are logged in as the new user but their password was only changed
for less than a second. The script
Title: RE: help with deleting duplicate records from very large table
Hi, Suhen
The following is a set of notes I have cut from various list messages on deleting duplicates. For the 60M rows you are talking about the first option looks the best (committing frequently). Can I suggest you
Suhen,
I have a similar problem at the moment although its 900 million rows of
which we want to delete approx. 200 million (they obviously never asked you
guys for help with their design!). Unfortunately we have just decided to
take the hit with downtime to correct the problem. We have
Hi Kevin and Suhen,
I believe that there are only two variants that
appropriate for such huge tables.
1. I remember a good tip from Steve Adams. He recommended
to use CTAS or INSERT AS SELECT for a similar case.
Of course, this method requires a lot of free space.
2. You may think about
Ed,
Thanks for that...I wasn't even aware of the 'exceptions into
exceptions_table' clause. Unfortunately for me it's not duplicated I'm
deleting, it's just a shed load of data :(
regards,
K.
hit any user to continue
__
Kevin Thomas
Technical Analyst
Deregulation Services
Have had problems before where anything over a db link was flaky explain
plan wise. If you can have the basic query as a view stored remotely on the
db you link too it should work more consistently.
Iain Nicoll
-Original Message-
Sent: 29 August 2001 17:01
To: Multiple recipients of
- Update the table by using either PL/SQL or 3gls.
If the LONG is always 32k or less you can do this in plsql.
If it may exceed 32k in size, plsql *cannot* manipulate it in
any way shape or form.
If the long is 32k or less, you simply declare a variable of
type LONG :
declare
my_var
EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: HELP - How can I limit what program users use to connect?
Date: Thu, 23 Aug 2001 09:42:34 -0800
I can't revoke connect permissions. I am simply looking for a way
to
preven
of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: HELP - How can I limit what program users use to connect?
Date: Wed, 22 Aug 2001 13:16:03 -0800
One thing you can try
TOAD includes a module name... so select from v$session where module =
'T.O.A.D.'
It will give you a list of users... and you
Hi Ken,
Try revoking the connect permssion from the users you want to restrict . But the user will not be able to connect to database using sqlplus also.
HTH.
Jyoti
From: "Fred Smith" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
[EMAIL PROTECTED]
Subject: Re: HELP - How can I limit what program users use to connect?
Date: Thu, 23 Aug 2001 09:20:15 -0800
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
Hi Ken,
Try revoking
PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: HELP - How can I limit what program users use to connect?
Date: Thu, 23 Aug 2001 09:20:15 -0800
_
Get your FREE download of MSN
I don't think you can do it in 8.0.6.
Starting with 8.1.5 you could use db logon triggers.
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 22, 2001 12:16 PM
You can use a password protected role which is only enabled
in the executable using a stored package that executes
dbms_session.set_role.
The package checks which program name invoked it be querying
v$session.program.
If the role is not enabled, users not granted the role do not have access
to
Hi Ken,
AFAIR you can limit connections via SQL*+ not sure though
it'll work for TOAD and other 3d party products.
Try to find pubbl.sql(?) (sorry don't remember the exact name).
It's one of the standart scripts you're supposed to run while
db creation. It creates a couple of profile tables and
Title: RE: HELP - How can I limit what program users use to connect?
One thing you can try
TOAD includes a module name... so select from v$session where module = 'T.O.A.D.'
It will give you a list of users... and you could probably create a DBMS_JOB to go around and kill any user
As someone said, probably that a lot of extents.
However the main deal here is that you could lock the
users with an ST lock. Therefore, you mustn't try it
where all the users are in. And also you could try
with a truncate tablereuse storage, and then
issuing several alter table deallocate of
lots of extents on the table, and a drop storage on the truncate will
cause the truncate to run very long -- Oracle needs to release the extents
to the FET$ -- which means taking each extent OFF the UET$ and adding it to
FET$ -- lots of recursive SQL
From: Troiano, Paul (CAP, GEFA) [EMAIL
Number of extents on this table is one of the reasons
MOHAMMAD RAFIQ
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Sat, 18 Aug 2001 21:45:25 -0800
I have a 12.5 million row table for which a truncate has been running for
2hrs. What can cause
Thanks. I rebuilt the tablespaces with larger extents sizes last night. Took
some time to drop though...
- Paul
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 8/19/01 10:25 AM
lots of extents on the table, and a drop storage on the truncate will
cause the
I have experienced the same problem on NT 4 next week.
When you do it from scheduler (not at command) , it is ok .
The problem is AT command. not your script .
Test what I say and see that I am right.
bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
]]
Sent: Thursday, August 16, 2001 4:19 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Help scheduling Hot Backup on NT...
I have experienced the same problem on NT 4 next week.
When you do it from scheduler (not at command) , it is ok
Miriam,
Looks like you missed a couple of things:
1). you do not need outer joins in the EXISTS clauses here - you just need
to know if
it EXISTS or NOT - it's ok for it to fail
2). looks like you are missing an additional AND clause in the EXISTS
clause - you did not
join it to
RTFM on auditing - this should provide all that you need. A good start would
be to read:
Oracle Concepts Guide - Chapter 28 - Auditing.
HTH
Mark
-Original Message-
Sent: Tuesday, August 07, 2001 09:00
To: Multiple recipients of list ORACLE-L
HI DBA Guru's
It has been a painful
Title: RE: Help needed
If on oracle 8i, you may also consider database triggers to prevent ddl stmts, userwise.
rgds
amar
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 2:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE
look up auditing it is your friend ;)
joe
Deewaker G.V. wrote:
HI DBA Guru's
It has been a painful process for me everytime when I change the
password of the user in ORACLE.. The reason is simple Some one is
trying to play with the tables and change the INDEXS... delete the
Deewaker,
you can run the listed srcipt to find the users that are connected to your server.
With a little modification you can get all of the information you need.
ROR mª¿ªm
+ user1.sql++
COLUMN SU FORMAT A8 HEADING 'ORACLE|USER ID' JUSTIFY LEFT
COLUMN OSU
From: [EMAIL PROTECTED]
Date: Wed, 1 Aug 2001 12:01:40 -0400
Subject: Help, processes won't die
I need some assistance ASAP. Our nightly batch process seems to have hung
up for some strange reason (ok no biggie my boss says kill it and start it
again). The problem is I have killed the
Hi,
This statement will get you the userid and the number of times it is
duplicated. Then it's just a case of inserting the value at the desired
location. Although this does mean that you are either going to have a column
with lots of null values or lots of repeated values...Doesn't really make
Title: Help, processes won't die
I
believe that I read somewhere that issuing a kill session will NOT free up the
memory from that session.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
[EMAIL PROTECTED]Sent: Wednesday, August 01, 2001
Title: Help, processes won't die
It
could be rolling back. If so, you really do have to
wait.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 01,
2001 10:02 AMTo: Multiple recipients of list
ORACLE-LSubject: Help, processes won't
Title: Help, processes won't die
Ivan:
The problem is that there is no way to "wake up"
PMON. PMON is cleaning up and rolling back all uncommitted transactions every 3
minutes and this isn't configurable. If this is 8i, you could have used alter
session ... kill session immediate, although
sometimes the only recourse is to bounce the instance.
joe
[EMAIL PROTECTED] 08/01/01 01:01PM
I need some assistance ASAP. Our nightly batch process
seems to have hung up for some strange reason (ok no biggie my boss says kill it
and start it again). The problem is I have killed the
It is smon who takes care of cleaning up after killed jobs. You can pay him
now or pay him later as the metaphor is mixed but you will have to let him
do his job. You can try a shutdown abort and startup but they smon will do
the cleanup in the background while your users scream.
So, Kim is
killed processes don't go away immediately, there is cleanup involved.
in fact -- does your batch job do updates/inserts without commits? if so,
those processes will stay around until the roll back has finished. And
bouncing the database won't eliminate the roll back
From: [EMAIL PROTECTED]
Ruth:
Just a couple of notes: first, PMON, not SMON, is responsible for process
cleanup--clean up of the components of failed transactions such as cache
entries, locks and other process resources. In instance recovery, PMON will
rollback any uncommitted transactions. On the other hand, SMON
Title: RE: Help, processes won't die
Thanks to all that have replied. I ended up having to bounce the db. I just did a startup force which I know does an abort, I probly should have tried an immediate first. I'll be tracking this process (batch) tonight and make sure that nothing else goes
Deewaker,
information you find with this select-stmt, perhaps you need to format the
output.
Depending on what you're looking for you should select either from the view:
user_indexes
all_indexes
dba_indexes
select
table_name,
index_name,
tablespace_name
from user_indexes
group by
Title: Help need
Hi deewakar,
hope this will help..
SELECT
TABLESPACE_NAME,TABLE_NAME,INDEX_NAME FROM DBA_INDEXESORDER BY 1,2,3/
Saurabh Sharma
Oracle DBA
[EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
- Original Message -
From:
Deewaker
G.V.
To:
this is an error code that must be reported to Oracle support along with
full description of error, procedure performed that caused this error and
also details about your database environment settings.
Saurabh Sharma
[EMAIL PROTECTED]
http://www.geocities.com/saurabh00pc/stride.html
-
Earlier it used to mean Goto Oracle Support
But now you have a choice.
http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html
And it works . most of the cases...
HTH,
Rajesh
-Original Message-
Sent: Thursday, July 26, 2001 10:31 AM
To: Multiple
I enclose a metalink document that I have because of
that error. Obsviously it is related with the PGA.
However I add sth in contradiction with the note, I've
seen a similar problem on 8.1.7. That I've resolved
setting the event 10262.
Doc ID: Note:131490.1
big for this port (o/s)
Type:
Thank you Rajesh,
Some of Oracle bugs are internal, you may not see all bugs. So, I've added
email feature to iOraBugFinder. Now, you can send the results and uploaded file
to Oracle support if iOraBugFinder doesn't return your bugs. Since trace files
are analyzed, response time from Oracle
That I've resolved
setting the event 10262.
Sorry ..I didn't understand that bit. Can you clarify please
John
-Original Message-
From: Christian Trassens [SMTP:[EMAIL PROTECTED]]
Sent: 26 July 2001 10:37
To: Multiple recipients of list ORACLE-L
Subject: Re: Help ! ORA
call support.
joe
John Dunn wrote:
Help !
What does this mean?
ORA-00600: internal error cod, arguments : [733], [33719116], [pga heap],
[], [], [], [], []
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Title: Help
Lots
of ways
CREATE
TABLE ouruser
AS
SELECT *
FROM myuser
UNION ALL
SELECT *
FROM uruser;
This
will create a table ouruser with 10,000 records.
Rick
-Original Message-From: Deewaker G.V.
[mailto:[EMAIL PROTECTED]]Sent: Thursday, July 26, 2001 7:47
AMTo:
read the fine manual, but i'm in a good mood
create table ouruser as select * from myuser;
insert into ouruser select * from uruser;
joe
Deewaker G.V. wrote:
Hi DBA Gurus
Suppose I have a Table myuser which has 5000 records and another table
uruser also 5000 records, and the structure
To: Multiple recipients of list ORACLE-L
Subject:Re: Help ! ORA-00600 : internal error
code
I enclose a metalink document that I have because
of
that error. Obsviously it is related with the PGA.
However I add sth in contradiction with the note,
I've
seen a similar problem
CREATE TABLE OURUSER
AS
SELECT *
FROM MYUSER
INSERT INTO OURUSER
SELECT *
FROM URUSER
-Original Message-
Sent: Thursday, July 26, 2001 7:47 AM
To: Multiple recipients of list ORACLE-L
Hi DBA Gurus
Suppose I have a Table myuser which has 5000 records and another table
uruser also
.Subject: Re: Help
com
John, You haven't indicated what version of Oracle you
are running or what application you where running when
you got this error message. These kinds of error messages
are best resolved by logging a tar with Oracle support.
I am no expert at 600 error messages, but I believe this
error is
Norrell, Brian wrote:
No one will be watching us,
Why don't we do it in the code?
i think we can code now...
--
Bill Shrek Thater Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the
RTFF (Read The Fine Footer)...
Edward W. Carr wrote:
HELP
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Edward W. Carr
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
no help for the weary.
-Original Message-
Sent: Monday, July 23, 2001 4:23 PM
To: Multiple recipients of list ORACLE-L
HELP
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Edward W. Carr
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Title: RE: HELP
Are you an idiot? I am.
-Original Message-
From: Edward W. Carr [SMTP:[EMAIL PROTECTED]]
Sent: Monday, July 23, 2001 4:23 PM
To: Multiple recipients of list ORACLE-L
Subject: HELP
HELP
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author
When I was younger then,
much younger than today,
I never needed anybody's help in anyway.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Page, Bruce
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
Will you still need me, will you still feed me when I'm 64 bits?
We all live in a yellow subroutine
-Original Message-
From: Page, Bruce [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 23, 2001 5:33 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: HELP
When I
Gogala, Mladen wrote:
Will you still need me, will you still feed me when I'm 64 bits?
We all live in a yellow subroutine
he's a real noop man, living in his noop plan
--
Bill Shrek Thater Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
No one will be watching us,
Why don't we do it in the code?
Brian Norrell
Manager, MPI Development
QuadraMed
511 E John Carpenter Frwy, Su 500
Irving, TX 75062
(972) 831-6600
-Original Message-
Sent: Monday, July 23, 2001 5:44 PM
To: Multiple recipients of list ORACLE-L
Gogala,
Malini,
Personal Oracle is not designed for production use,
but for development use. As such it doesn't allow
more than one session to connect via the listener (I
don't believe they've increased this limit with 8.x).
Olite will work with Personal Oracle, but it's not
very practical since you
If you're running Oracle8i,
you can do this:
SELECT *
FROM (SELECT * FROM my_table ORDER BY col_name_1
DESC)
WHERE ROWNUM 10;
Use this workaround with prior releases:
SELECT *
FROM my_table a
WHERE 10 = (SELECT COUNT(DISTINCT maxcol)
FROM my_table b
WHERE
Alexander,
Tuesday, July 10, 2001, 1:45:51 PM, you wrote:
AO Hi, gurus!!!
AO A need know how get n top row for any table somebody can help me!!
AO Thanks!!!
AO @lex
AO
AO Lic. Alexander Ordóñez Arroyo
AO Caja Costarricense del
301 - 400 of 485 matches
Mail list logo