and I don't need a Hummer or Land
Rover.
Offroad in Montana,
Steve
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]Sent: Monday, January 19, 2004 6:42
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Oracle vs
It is defined as below in the Reference Guide:
The session is waiting on an empty OLTP queue (Advanced Queuing) for a message to
arrive so that
the session can dequeue that message.
I would treat it as an Idle Wait, similar to, SQL*Net message from client.
- Kirti
--- Ehresmann, David
I've got my GX21-9129-9 right here in front of me. It should be in a
museum...
I'll take Obscure Geek References for $800, Alex.
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
I do indeed. Rumor was that rpt/rpf was written by Larry himself.
On 01/20/2004 09:39:34 AM, Goulet, Dick wrote:
Careful Mladen, your revealing your age!! Bet you remember RPT
RPF
as well!!
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday,
On 01/20/2004 08:04:33 AM, Thater, William wrote:
Mladen Gogala scribbled on the wall in glitter crayon:
oh damn, have we been at this too long?;-)
Yes, we probably have. I must say that the spirit of Oracle Corp.
has changed significantly since the days of Geoff Squire, Chris Ellis,
Richard
Probably because they were dropping RPT RPF SQR smells a lot like it, YUCK!
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, January 20, 2004 10:09 AM
To: Multiple recipients of list ORACLE-L
The RPT RPF Oracle class was what made me go
[snip]
120 col. punch cards?
You had a high-density model. Mine only had 80 cols, of which 72 were usable for my
goto-happy Fortran statements.
SF
No hard drives?
My $0.02 worth,
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Oracle vs Mysql
Sounds like the old Oracle vs. Ingress battles. Oracle won because it was
better at marketing. All detailed in the book The Difference Between God
and Larry Ellison. I can see
Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!!
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, January 20, 2004 2:04 AM
To: Multiple recipients of list ORACLE-L
On 2004.01.19 23:39, Jonathan Gennick wrote:
I
On 01/20/2004 10:09:34 AM, KENNETH JANUSZ wrote:
Do you remember IBM System 3/10? RPGII flat files? 120 col. punch
cards?
No hard drives?
My $0.02 worth,
Ken Janusz, CPIM
I've never done anything with System/3. My first IBM was 3084
with MVS and IMS, running on 8M RAM. After an upgrade, it was
a
Tuesday, January 20, 2004, 9:19:44 AM, Goulet, Dick ([EMAIL PROTECTED]) wrote:
GD Well, PostGreSql has all of those features, but handling 100GB? Not sure not
sure I'd trust
GD it that far.
You know, I talked to someone at last year's MySQL
conference who was using MySQL to manage three
Hello,
On Tuesday 20 January 2004 11:01 am, Mercadante, Thomas F wrote:
Reuben,
If the normal connection is throwing an error, then it stands to reason
that the seond one would not connect either. You need to get a connection
working first before you try something else.
I can confirm that
Abandon hope, all ye who enter here
(Dante Alighieri)
On 01/20/2004 10:24:27 AM, Bill Gentry wrote:
help
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos
Mail!
http://login.mail.lycos.com/r/referral?aid=27005
--
RPT was great stuff. In addition to SELECT statements it could do full
DML, DDL, and DCL (I think.) Like Unix it was just particular on who it
was friendly with. :-) Then there was RPT2C. Now there's perl.
Eschewing the pointy-clicky stuff.
-Original Message-
Sent: Tuesday, January
Tuesday, January 20, 2004, 9:34:25 AM, Jesse, Rich ([EMAIL PROTECTED]) wrote:
JR Then here's a rare treat for you! I *loved* SQL mods in RDB. I could make
JR a program in MACRO, BASIC, FORTRAN, BLISS, Ada, DIBOL, or Mladen's favorite
JR COBOL, and could effortlessly have them do DB work.
Yep!
Reuben,
If the normal connection is throwing an error, then it stands to reason that
the seond one would not connect either. You need to get a connection
working first before you try something else.
The Oracle error you are getting is complaining about the service_name
entry. Is this the same
Are you using Oracle Services? I've seen this happen before and we
change SERVICE_NAME to SID and everything works fine.
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
Life is like a sewer, what you get out of it depends on what you put
into it. - Tom Lehrer.
-Original Message-
Reuben
On 01/20/2004 09:19:44 AM, Goulet, Dick wrote:
Well, PostGreSql has all of those features, but handling 100GB? Not
sure not sure I'd trust it that far.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
Given the price, I believe that some testing would be warranted, don't
you think?
--
However...
do not blindly treat SQL*Net messages as Idle waits. They can be
important indicators of networking issues.
Stephen
[EMAIL PROTECTED] 01/20/04 08:24AM
It is defined as below in the Reference Guide:
The session is waiting on an empty OLTP queue (Advanced Queuing) for a
message
If you have a line like this on your sqlnet.ora
names.default_domain = world
Then try putting an entry like this in tnsnames.ora
dbname.world=(etc. etc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City
Inprocess actually.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, January 20, 2004 10:54 AM
To: Multiple recipients of list ORACLE-L
On 01/20/2004 09:19:44 AM, Goulet, Dick wrote:
Well, PostGreSql has all of those features, but handling 100GB?
YES!
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, January 20, 2004 10:10 AM
To: Multiple recipients of list ORACLE-L
Do you remember IBM System 3/10? RPGII flat files? 120 col. punch cards?
No hard drives?
My $0.02 worth,
Ken Janusz, CPIM
There's a new-ish RAC/Linux install guide on OTN:
http://otn.oracle.com/tech/linux/pdf/RAC_1030.pdf Interestingly enough the
guide specifically shows *not* to alias localhost at all (page 9).
Hmmm...
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED]
On Tuesday 20 January 2004 11:20 am, Scott Canaan wrote:
Are you using Oracle Services? I've seen this happen before and we
change SERVICE_NAME to SID and everything works fine.
That does not work for me either.
RDB
-Original Message-
Reuben D. Budiardja
Sent: Tuesday, January 20,
To: Multiple recipients of list ORACLE-L
Subject: Re: FW: Disk capacity planning
Cary,
Good answer. The problem is most people concentrate on bytes
because it's
relatively easy and everyone understands it. IOs per sec is
much harder to
calculate for a new system and hence it's
so what's the solution?
-Original Message-
Sent: Tuesday, January 20, 2004 4:10 AM
To: Multiple recipients of list ORACLE-L
Someone is messing with standard package ... so it would seem.
Raj
Rajendra dot
On Wed, 14 Jan 2004, eric king wrote:
I think he is talking about 100GB database. Can PostgreSQL and MySQL handle
that size? We used MySQL in some of the web projects, but it just stores
small set of operational data and later on those data are moved to Oracle as
a permenant store. For small
Chris,
Thanks.
When people do what you say, it's kind of like what would have happened
if NASA had used the following assumption throughout the Apollo project:
Assume adequate quantities of breathable air...
It would have made the planning phase much simpler, but it would have
been a touch more
If you're keen on Perl, the Spreadsheet-WriteExcel module is very handy:
http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-0.42/
With that you could slurp data out via DBI, and then build a customized spreadsheet
based on the data.
But I'd agree with what others have said. Dumping to
Either that or someone ran dbmspool.sql out of ORACLE_HOME/rdbms/admin.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, January 20, 2004 12:45 PM
To: Multiple recipients of list ORACLE-L
so what's the solution?
-Original Message-
Sent:
what is the listener status??
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
The old IBM System3 machines used 120 col. punch cards. And initially they
had no HD's. Everything was done with cards and a reader/sorter. To
compile a program you took the code you wrote, punched it into cards and
then put it behind a stack of cards that was the compiler. The machine read
Tuesday, January 20, 2004, 12:44:43 PM, Daniel Hanks ([EMAIL PROTECTED]) wrote:
DH nd to be fair, MySQL _does_ offer foreign key constraints (it used to not,
though), but only
DH (iirc) if you use the 'Innodb' table type.
My experience recently was just the opposite. I could create
foreign key
Back to MySQL and whether Postgres is the way to go,
I can recall editorials debating whether Unix/Oracle would ever be
industrial strength enough to support critical applications.
The point the book The Difference Between God and Larry Ellison tries to
make is that the technically superior
encoded content removed -- binaries not allowed by ListGuru
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender
[EMAIL PROTECTED]
c.com cc:
Sent by: Subject: Re: Spool to Excel File
Please, let's not turn this into a bulletin board.
Spontaneous humor in a conversation (thread) is one
thing, cutting and pasting completely non-relevant articles
is another.
For those of you that are non-native English speakers, the
one thing... another thing phrase means don't do this.
Jared
Huh???!?? What did you search for? I get many hits searching for
postgresql.
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Tuesday, January 20, 2004 12:29 PM
To:
On 01/20/2004 01:29:25 PM, DENNIS WILLIAMS wrote:
Back to MySQL and whether Postgres is the way to go,
I can recall editorials debating whether Unix/Oracle would ever be
industrial strength enough to support critical applications.
The point the book The Difference Between God and Larry Ellison
I found myself working with some larger databases in the 500-800 GB range that also
spawn into multiple test databases.
I take a df -k or bdf and bring that into excel. Then I take a query on all
autoextend and break that out by disk.
then I put that all together and tell what's left on disks.
--- Niall Litchfield [EMAIL PROTECTED]
wrote:
Hi
The bad news is that I don't believe that
calculating IO/Sec *can* be done
for a *new* system. At least I'd like to see how it
is done. I'm willing to
bet that any formula for doing it will include (x%)
for 'overhead', which
actually means
Tuesday, January 20, 2004, 1:29:25 PM, DENNIS WILLIAMS ([EMAIL PROTECTED]) wrote:
DW I can recall editorials debating whether Unix/Oracle would ever be
DW industrial strength enough to support critical applications.
I admit to not being involved in databases that far back,
but I've read enough to
]
c.com cc:
Sent by: Subject: Re: Spool to
Excel File
[EMAIL PROTECTED]
.com
01/20/2004
Hi!
Note that when you set an event with alter system, it will only apply for
new sessions created, not for any existing ones.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 4:19 PM
Oradebug is the right way to
[EMAIL PROTECTED] wrote:
One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3
instance due to a possible memory leak. The only note on memory leaks and
pga_aggregate_target I can find on metalink is: 334427.995
doesnt seem to apply to pga_aggregate_target. We
On Tue, 20 Jan 2004, Mladen Gogala wrote:
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
Hi!
I think what Kirti meant here, is that from only database's point of view
(scope), the SQL*Net message from client waits do not indicate any
database bottlenecks.
Anyway, when you have network bottleneck, from my experience you usually see
other SQL*Net message waits, like more data to/from
What RPT and RPF exactly are? Are they some sort of reporting tool?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 11:19 AM
RPT was great stuff. In addition to SELECT statements it could do full
DML, DDL, and DCL (I
On 01/20/2004 02:59:35 PM, Tanel Poder wrote:
Hi!
Note that when you set an event with alter system, it will only apply
for
new sessions created, not for any existing ones.
And that, exactly is the problem. First, when you set event using
alter system, the setting is system wide. Second, if you
On 01/20/2004 02:34:45 PM, Ana Choto wrote:
I have set up a profile where the passwords expire in 30 days, 6
characters
minimum, grace period before the account locks to 6 days. It works
as
expected when the user logs in to our web site and tries to change
the
password. Users receive
Hence why Sql*Server is out there.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, January 20, 2004 1:29 PM
To: Multiple recipients of list ORACLE-L
Back to MySQL and whether Postgres is the way to go,
I can recall editorials debating whether
Gene,
This is the problem with high-level aggregate reports like
BSTAT/ESTAT and STATSPACK. A possible problem is
highlighted, but there is no detail on the possible cause.
One way to get more info is monitor V$SESSION_EVENT view
searching for sessions with lots of waits on enqueue
wait-event:
Jonathan,
The only reason MySql is known better is that big mouth equal to Bill Gates
in Finland. Otherwise PostGreSql is the much better product.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, January 20, 2004 1:49 PM
To: Multiple
Yupp. RPF=report formatter or some such.
-Original Message-
eric king
Sent: Tuesday, January 20, 2004 1:19 PM
To: Multiple recipients of list ORACLE-L
What RPT and RPF exactly are? Are they some sort of reporting tool?
- Original Message -
To: Multiple recipients of list
Eric,
They were the precusors to Oracle reports. RPT was the report extraction
tool, and RPF was the report formatter.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, January 20, 2004 3:19 PM
To: Multiple recipients of list ORACLE-L
You can also use DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION and
DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION, in lieu of oradebug.
-Mark
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him
Strange, no one has mentioned OWA_SYLK.
Do a search on SYLK at asktom.oracle.com
There are 2 versions, one for web output and one for excel output.
SYLK allows cell references, etc, if needed, which you won't get with CSV.
Jared
Mudhalvan, Moovarkku [EMAIL PROTECTED]
Sent by: [EMAIL
But, unless you have old diskettes... you'll never see them. They died with
the demise of v5.
-Original Message-
Sent: Tuesday, January 20, 2004 2:29 PM
To: Multiple recipients of list ORACLE-L
Yupp. RPF=report formatter or some such.
-Original Message-
eric king
Sent:
cc
Subject
01/20/2004 03:24 Re: Password management using
PM
But you can't set events with it :(
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 10:39 PM
You can also use DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION and
DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION, in lieu of oradebug.
On 01/20/2004 03:29:33 PM, Goulet, Dick wrote:
Jonathan,
The only reason MySql is known better is that big mouth
equal to Bill Gates in Finland. Otherwise PostGreSql is the much
better product.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
Dick, when you are talking about big
ofessional
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Tuesday, January 20, 2004
3:44 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: Spool to Excel FileStrange, no one has mentioned OWA_SYLK. Do a search on SYLK at asktom.oracle.com
There are
I know I used to set up RPT and do all sorts of complex updating things. At the State
and with things coming from mainframes, the data organization seemed to lend itself
well to RPT.
Since the organization was like of loops within loops, I could take the high order
update and then loop through
If you are using Linux, you can use NBD's (network block devices) that will
allow you to use a third PC as a storage device. You can download the
drivers at http://nbd.sourceforge.net/
There's a pretty good paper out there as well, at
http://www.fi.muni.cz/~kripac/orac-nbd/ that will walk you
For that, there is DBMS_SYSTEM.SET_EV. ;-)
-Mark
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him for what he is. --Unknown
-Original Message-
Sent: Tuesday,
One thing I've been looking for is a way to set a string parameter in
another session, The two you mention handle INTEGER and BOOLEAN. I want
a way to set TRACEFILE_IDENTIFIER to a string in another session to make
it easier to identify trace files.
Any ideas?
Stephen
[EMAIL PROTECTED]
Dick, when you are talking about big mouth from Finland, you probably
don't refer to Pamela Anderson, also from Finland? The other person
from Finland, whom I will not mention except by the first name (Linus)
should be given credit for a wonderful OS that is successfully breaking
the MS
If Mr Torvalds needs a security blanket, I'd be happy to send him several. Yes he
crafted a wonderful OS I sincerely hope he knocks Billy Gates down to size. Seems
to be doing one heck of a job at it, even with SCO on MicroSlop's side. MS Anderson
appears headed for the twilight, thank GOD.
Have you tried $ORACLE_HOME/rdbms/admin/utlrp.sql yet? This will usually
recompile all invalid objects. Note that you have to run this script from
SQL*Plus and have to be connected as SYS i.e. connect / as sysdba.
HTH,
Faan
- Original Message -
To: Multiple recipients of list ORACLE-L
Ok, yeap I confused this with READ_EV, which can't read event from other
sessions...
Great job ;)
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 11:19 PM
For that, there is DBMS_SYSTEM.SET_EV. ;-)
-Mark
Mark
yes. they are listed on fatcity. the jdeveloper one is not active. ask your
questions on the dev2k list. Its very active.
Also, Ive been told the forums on otn are pretty active too.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 20,
Mark - Maybe a good place to start is:
http://groups.google.com/groups?hl=enlr=ie=UTF-8group=comp.databases.orac
le.tools
(usenet newslist comp.databases.oracle.tools)
If that doesn't suit you, post your request there.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
If you are looking for Oracle Development Tools, then check out the Oracle Development
Tools User Group (ODTUG) at www.odtug.com
On the home page you can go to the list serve page where you can sign up for any or
all of about a dozen list serves devoted to Oracle tools. They are free so
For further testing but will try do do so and report some more.
Regards,
Jeroen
-Oorspronkelijk bericht-
Van: Stephane Faroult [mailto:[EMAIL PROTECTED]
Verzonden: dinsdag 20 januari 2004 20:59
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: pga_aggregate_target and a memory leak
Rich
Amazon - Enter MySQL - 412 hits. The first screen of books are nearly all
devoted to MySQL.
Enter Postgres - 94 hits. None of the books on the first screen seem to
be devoted to Postgres, but just mention it incidentally.
Google - Enter MySQL - 15.6 million hits. Postgres -
Any experience with ENBD (Extended NBD), also from SourceForge?
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Tuesday, January 20, 2004 3:20 PM
To: Multiple recipients of
Ahh. Re-read my post. The proper name of the product is postgresql and
not postgres. You should find 112 hits on books...
HTH! :)
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message
So what's the recommendation, how can I recompile all the SYS packages?
-Original Message-
Sent: Tuesday, January 20, 2004 10:10 AM
To: Multiple recipients of list ORACLE-L
Either that or someone ran dbmspool.sql out of ORACLE_HOME/rdbms/admin.
Dick Goulet
Senior Oracle DBA
Oracle
You may want to look at the Oracle Migration workbench.
http://otn.oracle.com/tech/migration/workbench/index.html
http://otn.oracle.com/tech/migration/workbench/index.html
I don't know if the slides are still available but there was a presentation
at IOUG Live! 2002 titled Migrating a Microsoft
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, 20 January 2004 23:59
To: Multiple recipients of list ORACLE-L
Subject: Re: Re: Oracle vs Mysql
if Oracle is offshoring its develeoping of its database,
everyone
Tim,
Thanks a lot. This does help. The data that I have are
a result from a test run, so I can't do anything right
now, but this does give me something to look at if I
see the enqueue timeouts increasing in the database in
the future.
thank you
Gene
--- Tim Gorman [EMAIL PROTECTED] wrote:
At 03:29 PM 1/20/2004, you wrote:
I do indeed. Rumor was that rpt/rpf
was written by Larry himself.
Now I understand! I once applied for a job at Oracle, and got asked: What
do you think about RPT/RPF. My answer: Probably som hobby-project of one
or another developer, which, after demonstration
Hi,
There is a newsgroup comp.databases.oracle.tools that covers Oracle
development.
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for
:
[EMAIL PROTECTED] Subject: Re: Password management using
profiles
ity.com
Hi Maryann,
I can do this easily when creating a new table using:
create table new_table as
select emp_id,
row_number() over (partition by emp_id order by rec_id) as rec_id
from original_table;
Translating this into an update statement is probably a bit awkward for me
- I'd just
Not personally. The testing that I did last year just used regular NBDs.
I'm not sure what the difference is. Basically, the NBDs allow you to use
container files as raw devices -- it's nice because you don't need to mess
around with the disks, just create some files and serve them up through
There is no other list similar to this one.
Mark Burgess [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/20/2004 01:29 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:OT: Developer Mailing List
Hi Folks,
Maryann
You can use the new windowing function, here is test select working
on emp :-)
select deptno, row_number() over (PARTITION BY DEPTNO order by deptno)
from emp
/
DEPTNO ROW_NUMBER()OVER(PARTITIONBYDEPTNOORDERBYDEPTNO)
--
Mercadante, Thomas F [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/20/2004 12:59 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Spool to Excel File
SYLK allows cell references, etc, if needed, which you
select deptno, row_number() over (PARTITION BY DEPTNO order by deptno)
from emp
/
Hm... but thats not available in 8i, is it?
and besides, I want to update the table, not just select from it...
...
thx
maa
At 06:19 PM 1/20/2004, you wrote:
Maryann
You can use the new windowing function,
Not pretty but it should work:
SQL create or replace procedure emprec
2 is
3cursor empcursor is
4 select empno, recno from emptest order by empno for update of
recno;
5v_empno number := 9;
6v_count number := 0;
7 begin
8for x in empcursor loop
9
Maryann Atkinson wrote:
I have a 1-rows table with 2 columns, Emp_ID and Req_ID.
There are about 150 different emp_ids in these 1+ records.
What I want to do is the following:
For every different Emp_id, I need the Rec_ids that corresponds to it
to be updated/renumbered
No other replies yet, so here goes.
First of all, what does it really mean when you say:
users are complaining that Precise is showing a whole lot of time in Parallel Sync Wait.
Are these end users, or developers? Seems rather curious that users would be mentioning this.
Second, what % of
Yes it's fix all the invalid objects.
Thanks all
-Original Message-
Sent: Tuesday, January 20, 2004 1:29 PM
To: Multiple recipients of list ORACLE-L
Have you tried $ORACLE_HOME/rdbms/admin/utlrp.sql yet? This will usually
recompile all invalid objects. Note that you have to run this
At 06:49 PM 1/20/2004, you wrote:
Not pretty but it should work:
It does, thanks!
maa
SQL create or replace procedure emprec
2 is
3cursor empcursor is
4 select empno, recno from emptest order by empno for update of
recno;
5v_empno number := 9;
6v_count number
:
Sent by: Subject: Re: Renumber a set of grupped
rows?
[EMAIL PROTECTED
] [mailto:[EMAIL PROTECTED] Sent:
Wednesday, January 21, 2004 8:29 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Spool to Excel
File If you
use tab separated columns, you can also generate formula's that look like
text, but work just fine in the spreadsheet! Didn't realize
Maryann
The select workes on 8i, but the update part I have to think som time
over :-)
[EMAIL PROTECTED] oracle]$ sqlplus scott/tiger
SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jan 21 01:43:33 2004
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i
--- Mauricio VĂ©lez [EMAIL PROTECTED] wrote:
Hello everybody
I'm trying to recover a full database from a hot
backup.
When I execute the following instruction:
SQL recover database using backup controlfile
until cancel;
Then I obtain the error ora-00331,
This is the output:
Open the sqlnet.ora. What is NAMES.DEFAULT_DOMAIN set to. Add that as a
suffix to the DEV_DB entry.
If there is no sqlnet.ora or it has no NAMES.DEFAULT_DOMAIN entry try
adding .world:
DEV_DB.{whatever_names.default_domain_is | world} =
..
At 11:09 AM 1/20/2004, you wrote:
what is the listener
501 - 600 of 67344 matches
Mail list logo