date:20031216


Try milliseconds from the epoch - 1/1/1970

select to_date('01/01/1970','mm/dd/') + ( 1069716948959 / (24*60*60*1000) ) from dual

You really need to know how the timestamp column is defined by your app.

Jared








"Nguyen, David M" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 12/16/2003 02:09 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: Unreadable time_stamp format


Now I got.
 
USER_NAME             TIME STAMP
              --
eholley                       1069716948959
jmdavis                       1069715246467
jmdavis                       1069715324466
 
 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bobak, Mark
Sent: Tuesday, December 16, 2003 3:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Unreadable time_stamp format
 
Since it's a NUMBER datatype, try:
SQL>  column time_stamp format 
SQL>  select user_name, time_stamp from USER_ACTIVITY_LOG;
 
-Original Message-
From: Nguyen, David M [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 4:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Unreadable time_stamp format
I need to view time_stamp column in USER_ACTIVITY_LOG table but it displays unreadable format as shown below.  Is there a way to decode it to be readable?
SQL> desc USER_ACTIVITY_LOG
 Name                                      Null?    Type
 -  
 TIME_STAMP                              NOT NULL NUMBER(20)
 NODE_NAME                               NOT NULL VARCHAR2(20)
 USER_NAME                                NOT NULL VARCHAR2(20)
 CLIENT_IP                                    NOT NULL VARCHAR2(15)
 DESCRIPTION                              NOT NULL VARCHAR2(2048)
 
SQL>select user_name, time_stamp from USER_ACTIVITY_LOG;
edscott              1.0693E+12
edscott              1.0693E+12
edscott              1.0693E+12
edscott              1.0693E+12
jmdavis              1.0693E+12
edscott              1.0693E+12
edscott              1.0693E+12
Thanks,
David

Re: Unreadable time_stamp format

2003-12-16 Thread Rachel Carmichael

or in SQL*Plus:

set numwidth 20


--- [EMAIL PROTECTED] wrote:
> column time_stamp format 9 head 'TIME STAMP'
> 
> 
> 
> 
> 
> "Nguyen, David M" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  12/16/2003 01:39 PM
>  Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:Unreadable time_stamp format
> 
> 
> I need to view time_stamp column in USER_ACTIVITY_LOG table but it
> displays unreadable format as 
> shown below.  Is there a way to decode it to be readable?
> SQL> desc USER_ACTIVITY_LOG
>  Name  Null?Type
>  -  
> 
>  TIME_STAMP  NOT NULL NUMBER(20)
>  NODE_NAME   NOT NULL VARCHAR2(20)
>  USER_NAMENOT NULL VARCHAR2(20)
>  CLIENT_IPNOT NULL VARCHAR2(15)
>  DESCRIPTION  NOT NULL VARCHAR2(2048)
> 
> SQL>select user_name, time_stamp from USER_ACTIVITY_LOG;
> edscott  1.0693E+12
> edscott  1.0693E+12
> edscott  1.0693E+12
> edscott  1.0693E+12
> jmdavis  1.0693E+12
> edscott  1.0693E+12
> edscott  1.0693E+12
> Thanks,
> David
> 
> 


__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: SQL*Plus with readline

Daniel, there is gqlplus which does have readline. Look at the 
http://gqlplus.sourceforge.net/
On 2003.12.16 17:09, Daniel Hanks wrote:
> I know there's a lot of folks who grumble about the spartan-ness of SQL*Plus, but 
> the only real feature I wish it had was GNU readline capability for command history 
> and editing. I've looked at some wrappers (yasql, gasql), as well as replacements 
> (henplus, which is quite nice, actually), but today I found something that seems to 
> do exactly what I really want--SQL*Plus behavior, augmented with readline support 
> (So I can still do stuff like output formatting, spooling, etc., etc.,). Yes, I 
> actually dig SQL*Plus, just wish it had readline.
> 
> So today I found a little utility called uniread:
> 
> http://sourceforge.net/projects/uniread/
> 
> It's a Perl program that
> 
> "adds full readline support (command editing, history, etc.) to any existing 
> interactive command-line program. Common examples are Oracle's sqlplus or jython. 
> uniread will work on any POSIX platform with Perl."
> 
> I tried it out with SQL*plus, and so far seems to work beautifully. Just thought I'd 
> share.
> 
> -- Dan
> 
>Daniel Hanks - Systems/Database Administrator
>About Inc., Web Services Division
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Daniel Hanks
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

-- 
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-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: NT -> Win2K causes performance degradation..

Or just move to advanced server.

Murali_Pavuloori/[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 12/16/2003 02:04 PM
 Please respond to ORACLE-L

        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: NT -> Win2K causes performance degradation..

We run oracle 9.2.0.3 on Win 2000 and have observed that whenever the
memory on ora.exe process reaches around 1.4G, our application runs into
"Listener unable to start a dedicated server process" At this point no one
will be able to connect to the db and we are forced to restart.

We are exploring to migrate the db on to Win 2003.

Murali.

|-+>
|         |           "Boivin, Patrice |
|         |           J"               |
|         |           <[EMAIL PROTECTED]|
|         |           mpo.gc.ca>       |
|         |           Sent by:         |
|         |           [EMAIL PROTECTED]|
|         |           .com             |
|         |                            |
|         |                            |
|         |           12/16/2003 03:44 |
|         |           PM               |
|         |           Please respond to|
|         |           ORACLE-L         |
|         |                            |
|-+>
  >--|
  |                                                                                                              |
  |       To:       Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>                                  |
  |       cc:                                                                                                    |
  |       Subject:  RE: NT -> Win2K causes performance degradation..                                             |
  >--|

I'll throw gasoline on the fire here...

On Win2K you may hit resource limits when you get to 1.5G or so memory used
on a 4G server...

Because Windows allocates half the memory to the kernel processes, half to
the user processes.

Patrice.
      -Original Message-
      From: Yechiel Adar [mailto:[EMAIL PROTECTED]
      Sent: December 11, 2003 10:40 AM
      To: Multiple recipients of list ORACLE-L
      Subject: Re: NT -> Win2K causes performance degradation..

      The /3GB does not work for the simple reason that in W2K you have 3GB
      as max address space. At least that what my sysadmin tells me (after
      checking with MS).

      Yechiel Adar
      Mehish
       - Original Message -
       From: Paul Drake
       To: Multiple recipients of list ORACLE-L
       Sent: Wednesday, December 10, 2003 6:49 PM
       Subject: Re: NT -> Win2K causes performance degradation..

       Mark,

       My guess is, that the new OS re-instated the file system caching.
       By default, 41% (yes, it should have been 42%) of physical memory
       will be allocated to filesystem caching, as W2K thinks it a
       fileserver (and domain controller, web server, print server, etc)
       until you tell it otherwise.

       This is much improved in w2k3 server - where you tell it what you
       want it to be.

       A good sysadmin would have set the OS to "optimize throughput for
       network applications" which would have turned off the filesystem
       caching. Ok, its only one radio button to select, so an MSCE could
       set it also.

       Surprisingly enough, in W2K Server - changing this setting does not
       require a reboot, although I don't know if the changes take effect
       until after a system restart. That's not the sort of thing that I
       usually test, as NT4 had me trained to reboot afterwards.

       the other thing may be, that the boot.ini no longer supports the
       /3GB or /PAE switches as Jared mentioned - but that should not cause
       the symptoms you are reporting.

       hth.

       Paul

       Mark Leith <[EMAIL PROTECTED]> wrote:
        Hi All,

        We've been asked a question from one of our clients that I'm a
        little
        stumped on.

        They run an OLTP database (Oracle 8.1.7), and have recently
        upgraded their
        NT machine to Windows 2000, they were running with 2gb of memory,
        and
        upgraded that to 4gb in the process. As they increased physical
        memory, they
        also increased their SGA size & db_block_buffers.

        Since they've upgraded they have noticed a significant decrease in
        performance (the way it was described to me was "it was 7 out of
        10, and is
        now 3 out of 10"..).

        Has anybody else done a system upgrade of this nature that has
        caused less
        than desirable effects? Any pointers as to what to look at? We've
        requested
        s

RE: 9iAS - SSL certificate renewal and wallet manager

2003-12-16 Thread Ben

Hi

I answered my own question. The wallet manager allows you to import
the renewal certificate and then remove the old certificate and the
ssl connections just keep on working.

Ben
-Original Message-
Ben
Sent: December 16, 2003 9:19 AM
To: Multiple recipients of list ORACLE-L


Hi

My SSL certificate is going to expire and I need to renew it.
I am running 9iAS 9.0.3 on Solaris8. All the documentation
seems to be about setting up the original certificate and I
can't find anything on renewals. Has anyone done this?
I have requested a new certificate from Entrust using the
wallet manager. Do I just import the new certificate? Will
the wallet manager overwrite the old one or do I have to
remove it first? Thanks in advance,

Ben
Queen's University
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ben
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ben
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: SQL*Plus with readline

2003-12-16 Thread Daniel Hanks

On Tue, 16 Dec 2003, Carel-Jan Engel wrote:

> Don't know this particular one, but ran into a shell on HP-UX with similar 
> capabilities. I was a developer those days, and the feature I liked most 
> was its capability to  unveil sys/system passwords. Just get this shell 
> running and ask the DBA to do something from your terminal. After that, the 
> non-echoed password will be perfectly visible in command-line history 
> (after the DBA left the scene, of course). They never found out how we were 
> able to discover their passwords. I think it's now safe to spread the 
> knowledge around.
> 
Heh. Yeah, there's something on Linux called 'script' that would do that. Basically 
spawns a shell and sends all the output from that session to a file.

> Does this tool have the same 'functionality'? So, be carefull, or take 
> advantage of it ;-).

Nope, the only history it stores are the commands you type once the program it execs 
is fired up. Now, if you connect scott/tiger from within sqlplus, you're on thin ice, 
but I usually specify which user/db I'm connecting to on the command-line and let 
SQL*Plus ask me for my password.

-- Dan

   Daniel Hanks - Systems/Database Administrator
   About Inc., Web Services Division

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel Hanks
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: SQL*Plus with readline

2003-12-16 Thread Denny Koovakattu


  On HPUX the ied utility enables command history. Everything you type will be
logged to the HISTORY file unless you specify one.

-- 
Denny Koovakattu 


Quoting Carel-Jan Engel <[EMAIL PROTECTED]>:

> At 14:09 16-12-03 -0800, you wrote:
> >I know there's a lot of folks who grumble about the spartan-ness of 
> >SQL*Plus, but the only real feature I wish it had was GNU readline 
> >capability for command history and editing. I've looked at some wrappers 
> >(yasql, gasql), as well as replacements (henplus, which is quite nice, 
> >actually), but today I found something that seems to do exactly what I 
> >really want--SQL*Plus behavior, augmented with readline support (So I can 
> >still do stuff like output formatting, spooling, etc., etc.,). Yes, I 
> >actually dig SQL*Plus, just wish it had readline.
> >
> >So today I found a little utility called uniread:
> >
> >http://sourceforge.net/projects/uniread/
> >
> >It's a Perl program that
> >
> >"adds full readline support (command editing, history, etc.) to any 
> >existing interactive command-line program. Common examples are Oracle's 
> >sqlplus or jython. uniread will work on any POSIX platform with Perl."
> >
> >I tried it out with SQL*plus, and so far seems to work beautifully. Just 
> >thought I'd share.
> >
> >-- Dan
> >
> >Daniel Hanks - Systems/Database Administrator
> >About Inc., Web Services Division
> >
> 
> Don't know this particular one, but ran into a shell on HP-UX with similar 
> capabilities. I was a developer those days, and the feature I liked most 
> was its capability to  unveil sys/system passwords. Just get this shell 
> running and ask the DBA to do something from your terminal. After that, the
> 
> non-echoed password will be perfectly visible in command-line history 
> (after the DBA left the scene, of course). They never found out how we were
> 
> able to discover their passwords. I think it's now safe to spread the 
> knowledge around.
> 
> Does this tool have the same 'functionality'? So, be carefull, or take 
> advantage of it ;-).
> 
> 
> Regards, Carel-Jan
> 
> ===
> If you think education is expensive, try ignorance. (Derek Bok)
> === 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Carel-Jan Engel
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 


This message was sent using IMP, the Internet Messaging Program.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Denny Koovakattu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OffTopic : sed : Alternate (2,4,6..) replacement

2003-12-16 Thread Stephen.Lee


OK.  You got me going on this for a solution when GNU sed is not available.
(See what you did.)
Instead of the ksh example, here's a non-GNU sed one that works.  It works
on GNU sed too.

sed '
   $!N
   s/\(^.*\n.*:\)\(this\)\(.*$\)/\1that\3/
   p
   d
'

Here's an awk that is essentially the equivalent of the ksh thing.

awk -F':| ' '
   BEGIN{ x = 1 }
   (x = 0||(x-1)) == 1 {$2 = "that"}
   {print $1":"$2,$3,$4,$5,$6,$7,$8,$9}
'
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Unreadable time_stamp format

2003-12-16 Thread Stephen.Lee


Possibly a Boolean date?

-Original Message-

Which I assume means you have no idea how to get a readable date out of
that?
A thought, it could a be a julian date of some kind.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: SAN Comparison Question

2003-12-16 Thread Mogens Nørgaard

I would go for the one that promises to have a RAID-5 implementation
that doesn't suffer from the usual RAID-5 problems. Heh-heh.

Mogens

Jay Hostetter wrote:

One of our hardware guys is seeking an opinion on SANs. He is comparing the Hitachi "Thunder" 9500 to the HP EVA 5000. Does anybody have any pros or cons to offer for either one? Good or bad experiences?

Thank you,
Jay

**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of D&E except to the extent that it relates to their official business.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Re: SQL*Plus with readline

2003-12-16 Thread Carel-Jan Engel

At 14:09 16-12-03 -0800, you wrote:
I know there's a lot of folks who grumble about the spartan-ness of 
SQL*Plus, but the only real feature I wish it had was GNU readline 
capability for command history and editing. I've looked at some wrappers 
(yasql, gasql), as well as replacements (henplus, which is quite nice, 
actually), but today I found something that seems to do exactly what I 
really want--SQL*Plus behavior, augmented with readline support (So I can 
still do stuff like output formatting, spooling, etc., etc.,). Yes, I 
actually dig SQL*Plus, just wish it had readline.

So today I found a little utility called uniread:

http://sourceforge.net/projects/uniread/

It's a Perl program that

"adds full readline support (command editing, history, etc.) to any 
existing interactive command-line program. Common examples are Oracle's 
sqlplus or jython. uniread will work on any POSIX platform with Perl."

I tried it out with SQL*plus, and so far seems to work beautifully. Just 
thought I'd share.

-- Dan

   Daniel Hanks - Systems/Database Administrator
   About Inc., Web Services Division

Don't know this particular one, but ran into a shell on HP-UX with similar 
capabilities. I was a developer those days, and the feature I liked most 
was its capability to  unveil sys/system passwords. Just get this shell 
running and ask the DBA to do something from your terminal. After that, the 
non-echoed password will be perfectly visible in command-line history 
(after the DBA left the scene, of course). They never found out how we were 
able to discover their passwords. I think it's now safe to spread the 
knowledge around.

Does this tool have the same 'functionality'? So, be carefull, or take 
advantage of it ;-).

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok)
=== 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Carel-Jan Engel
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Unreadable time_stamp format

Title: Unreadable time_stamp format



Which 
I assume means you have no idea how to get a readable date out of that?  A 
thought, it could a be a julian date of some kind.
 
I 
tried several different guessesnone of which panned out.  These types 
of things usually work better when you have the specs and know what the format 
of the data was intended to be.  ;-)
 
There 
is a reason Oracle has DATE and TIMESTAMP datatypes.
 
-Mark
 
PS  I tried several julian date formats, expressed in days, seconds, 
hundredths of a second, but nothing really looked right.  Also 
tried microseconds, centiseconds, seconds and says since the epoch 
(01-JAN-1970), with nothing that looked reasonable.

  -Original Message-From: Nguyen, David M 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, December 16, 2003 5:09 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Unreadable time_stamp format
  
  Now I 
  got.
   
  USER_NAME 
  TIME STAMP
      
   
   --
  eholley   
  1069716948959
  jmdavis   
  1069715246467
  jmdavis   
  1069715324466
   
   
  -Original 
  Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bobak, MarkSent: Tuesday, December 
  16, 2003 3:54 
  PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: 
  Unreadable time_stamp format
   
  
  Since 
  it's a NUMBER datatype, try:
  
  SQL>  column 
  time_stamp format 
  
  SQL>  select 
  user_name, time_stamp from USER_ACTIVITY_LOG;
  
   
  
-Original 
Message-From: Nguyen, 
David M [mailto:[EMAIL PROTECTED]Sent: Tuesday, December 16, 2003 4:39 
PMTo: Multiple recipients 
of list ORACLE-LSubject: 
Unreadable time_stamp format
I 
need to view time_stamp 
column in USER_ACTIVITY_LOG 
table but it displays unreadable format as shown below.  Is there 
a way to decode it to be 
readable?
SQL> desc 
USER_ACTIVITY_LOG
 Name  
Null?    Type
 - 
 
 TIME_STAMP  
NOT NULL NUMBER(20)
 NODE_NAME   
NOT NULL VARCHAR2(20)
 USER_NAME    
NOT NULL VARCHAR2(20)
 CLIENT_IP 
   NOT NULL 
VARCHAR2(15)
 DESCRIPTION  
NOT NULL VARCHAR2(2048)
 
SQL>select user_name, time_stamp from 
USER_ACTIVITY_LOG;
edscott  1.0693E+12
edscott  1.0693E+12
edscott  1.0693E+12
edscott  1.0693E+12
jmdavis  1.0693E+12
edscott  1.0693E+12
edscott  1.0693E+12
Thanks,David

Re: Unreadable time_stamp format

Now that's great! Here is my contribution, pasted directly from
SQL Reference:
TIMESTAMP (fractional_seconds_precision)

Year, month, and day values of date, as well as hour, minute, and second values of 
time, where fractional_seconds_precision is the number of digits in the fractional 
part of the SECOND datetime field. Accepted values of fractional_seconds_precision are 
0 to 9. The default is 6.

Essentially, you know now how many microseconds have passed since 1.1.1970. and that 
is 
the information that not many human beings posses. It changes about 1 million times 
every
second.

On 12/16/2003 05:09:25 PM, "Nguyen, David M" wrote:
> Now I got.
> 
>  
> 
> USER_NAME TIME STAMP
> 
>   --
> 
> eholley   1069716948959
> 
> jmdavis   1069715246467
> 
> jmdavis   1069715324466
> 
>  
> 
>  
> 
> -Original Message-
> Bobak, Mark
> Sent: Tuesday, December 16, 2003 3:54 PM
> To: Multiple recipients of list ORACLE-L
> 
>  
> 
> Since it's a NUMBER datatype, try:
> 
> SQL>  column time_stamp format 
> 
> SQL>  select user_name, time_stamp from USER_ACTIVITY_LOG;
> 
>  
> 
>   -Original Message-
>   From: Nguyen, David M [mailto:[EMAIL PROTECTED]
>   Sent: Tuesday, December 16, 2003 4:39 PM
>   To: Multiple recipients of list ORACLE-L
>   Subject: Unreadable time_stamp format
> 
>   I need to view time_stamp column in USER_ACTIVITY_LOG table but
> it displays unreadable format as shown below.  Is there a way to decode
> it to be readable?
> 
>   SQL> desc USER_ACTIVITY_LOG
> 
>Name  Null?Type
> 
>- 
> 
> 
>TIME_STAMP  NOT NULL NUMBER(20)
> 
>NODE_NAME   NOT NULL VARCHAR2(20)
> 
>USER_NAMENOT NULL VARCHAR2(20)
> 
>CLIENT_IPNOT NULL
> VARCHAR2(15)
> 
>DESCRIPTION  NOT NULL
> VARCHAR2(2048)
> 
>
> 
>   SQL>select user_name, time_stamp from USER_ACTIVITY_LOG;
> 
>   edscott  1.0693E+12
> 
>   edscott  1.0693E+12
> 
>   edscott  1.0693E+12
> 
>   edscott  1.0693E+12
> 
>   jmdavis  1.0693E+12
> 
>   edscott  1.0693E+12
> 
>   edscott  1.0693E+12
> 
>   Thanks,
>   David
> 
> 

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-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: connection pooling from an application server to oracle

2003-12-16 Thread Bellow, Bambi

To extrapolate, then, do you think that Neanderthals(at a cranial capacity
of over 1700 cc) would have been using Oracle 11h, or do you think they
would have prefered OODBMSs?

-Original Message-
Sent: Tuesday, December 16, 2003 3:49 PM
To: Multiple recipients of list ORACLE-L


On 12/16/2003 04:09:34 PM, "Orr, Steve" wrote:
> Correction... Homo sapiens does not have the largest brain in the animal
> kingdom. Elephants have larger brains and sperm whale brains weigh in at
> a whopping 20 pounds. So this is not necessarily a case where size
> matters, it's the spirit within that makes the difference. Of course the
> size of the cerebral cortex may have something to do with it. ;-) There
> reason for larger brains in larger animals is the increased need for
> "connection pooling" because of the larger size of the nervous system.
> So you see, even nature recognizes the need for enhanced connectivity
> requirements. :-)
> 
> 
> 
> -Original Message-
> Mladen Gogala
> Sent: Monday, December 15, 2003 9:24 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> On 12/15/2003 10:54:27 AM, "Mercadante, Thomas F" wrote:
> > But Mladen, sooner or later, somebody is going to wise-up and catch 
> > you in your attempt at passing the blame.  When this happens to me, I 
> > quote to 80-20 rule.  80% gain in application thruput is brought thru 
> > Sql tuning (or rewrite).  If they say "The database is slow", I say 
> > "Show me the sql that is slow".  If they say "I can't because it is 
> > coming from the app", i say "Then I can't help you".
> 
> You're very optimistic about your fellow humans. I am not. Homo sapiens
> sapiens is a funny species. It is bestowed with the largest brain in the
> animal kingdom and usually very grateful when not forced to use it. As a
> matter of fact, any excuse is welcome to prevent the little grey cells
> (here I'm shamelessly 
> stealing from Poirot) from ever getting tired. 
> At any rate, it's politics. I'm trying to achieve something for the
> benefit of 
> my employer and I'm being obstructed by sleazy sales person aided and
> abetted by 
> damagement. Chances of them figuring me out are remote. I'm a DBA, I
> interpret 
> database statistics and it says what I say that it says. There are
> complications 
> when sleazy sales people bring in their own consultant DBA personnel.
> Then it is 
> a matter of discrediting the hostile DBA. 
> I have to say that this tactics has to be applied only there where there
> isn't 
> enough common sense to talk it through with the DBA and make him present
> the situation as it really is. Those are the places which distrust and
> fear their own DBAs. That is the first and foremost sign that the
> damagement has taken over. We, the DBAs hold 
> this truth to be self evident.
> 
> 
> 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-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name of
> mailing list you want to be removed from).  You may also send the HELP
> command for other information (like subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bellow, Bambi
  INET: [EMAIL PROTECTED]

Fat

RE: Unreadable time_stamp format

2003-12-16 Thread Nguyen, David M

Title: Unreadable time_stamp format









Now I got.

 

USER_NAME TIME STAMP

      --

eholley  
1069716948959

jmdavis  
1069715246467

jmdavis  
1069715324466

 

 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bobak,
Mark
Sent: Tuesday,
 December 16, 2003 3:54 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Unreadable time_stamp
format

 



Since it's a NUMBER
datatype, try:





SQL>  column
time_stamp format 





SQL>  select
user_name, time_stamp from USER_ACTIVITY_LOG;





 





-Original
Message-
From: Nguyen, David M
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003
4:39 PM
To: Multiple recipients of list
ORACLE-L
Subject: Unreadable time_stamp
format

I need to
view
time_stamp column in USER_ACTIVITY_LOG table but it displays unreadable
format as shown below.  Is there a way to decode it to be readable?

SQL> desc USER_ACTIVITY_LOG

 Name 
Null?    Type

 -
 

 TIME_STAMP 
NOT NULL NUMBER(20)

 NODE_NAME  
NOT NULL VARCHAR2(20)

 USER_NAME   
NOT NULL VARCHAR2(20)

 CLIENT_IP
  
NOT
NULL VARCHAR2(15)

 DESCRIPTION 
NOT NULL VARCHAR2(2048)

 

SQL>select user_name, time_stamp from USER_ACTIVITY_LOG;

edscott  1.0693E+12

edscott  1.0693E+12

edscott  1.0693E+12

edscott  1.0693E+12

jmdavis  1.0693E+12

edscott  1.0693E+12

edscott  1.0693E+12

Thanks,
David

SQL*Plus with readline

2003-12-16 Thread Daniel Hanks

I know there's a lot of folks who grumble about the spartan-ness of SQL*Plus, but the 
only real feature I wish it had was GNU readline capability for command history and 
editing. I've looked at some wrappers (yasql, gasql), as well as replacements 
(henplus, which is quite nice, actually), but today I found something that seems to do 
exactly what I really want--SQL*Plus behavior, augmented with readline support (So I 
can still do stuff like output formatting, spooling, etc., etc.,). Yes, I actually dig 
SQL*Plus, just wish it had readline.

So today I found a little utility called uniread:

http://sourceforge.net/projects/uniread/

It's a Perl program that

"adds full readline support (command editing, history, etc.) to any existing 
interactive command-line program. Common examples are Oracle's sqlplus or jython. 
uniread will work on any POSIX platform with Perl."

I tried it out with SQL*plus, and so far seems to work beautifully. Just thought I'd 
share.

-- Dan

   Daniel Hanks - Systems/Database Administrator
   About Inc., Web Services Division

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel Hanks
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: NT -> Win2K causes performance degradation..

2003-12-16 Thread Murali_Pavuloori/Claritas

We run oracle 9.2.0.3 on Win 2000 and have observed that whenever the
memory on ora.exe process reaches around 1.4G, our application runs into
"Listener unable to start a dedicated server process" At this point no one
will be able to connect to the db and we are forced to restart.

We are exploring to migrate the db on to Win 2003.

Murali.

|-+>
| |   "Boivin, Patrice |
| |   J"   |
| |   <[EMAIL PROTECTED]|
| |   mpo.gc.ca>   |
| |   Sent by: |
| |   [EMAIL PROTECTED]|
| |   .com |
| ||
| ||
| |   12/16/2003 03:44 |
| |   PM   |
| |   Please respond to|
| |   ORACLE-L |
| ||
|-+>

>--|
  |
  |
  |   To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>   
   |
  |   cc:  
  |
  |   Subject:  RE: NT -> Win2K causes performance degradation..   
  |

>--|

I'll throw gasoline on the fire here...

On Win2K you may hit resource limits when you get to 1.5G or so memory used
on a 4G server...

Because Windows allocates half the memory to the kernel processes, half to
the user processes.

Patrice.
  -Original Message-
  From: Yechiel Adar [mailto:[EMAIL PROTECTED]
  Sent: December 11, 2003 10:40 AM
  To: Multiple recipients of list ORACLE-L
  Subject: Re: NT -> Win2K causes performance degradation..

  The /3GB does not work for the simple reason that in W2K you have 3GB
  as max address space. At least that what my sysadmin tells me (after
  checking with MS).

  Yechiel Adar
  Mehish
   - Original Message -
   From: Paul Drake
   To: Multiple recipients of list ORACLE-L
   Sent: Wednesday, December 10, 2003 6:49 PM
   Subject: Re: NT -> Win2K causes performance degradation..

   Mark,

   My guess is, that the new OS re-instated the file system caching.
   By default, 41% (yes, it should have been 42%) of physical memory
   will be allocated to filesystem caching, as W2K thinks it a
   fileserver (and domain controller, web server, print server, etc)
   until you tell it otherwise.

   This is much improved in w2k3 server - where you tell it what you
   want it to be.

   A good sysadmin would have set the OS to "optimize throughput for
   network applications" which would have turned off the filesystem
   caching. Ok, its only one radio button to select, so an MSCE could
   set it also.

   Surprisingly enough, in W2K Server - changing this setting does not
   require a reboot, although I don't know if the changes take effect
   until after a system restart. That's not the sort of thing that I
   usually test, as NT4 had me trained to reboot afterwards.

   the other thing may be, that the boot.ini no longer supports the
   /3GB or /PAE switches as Jared mentioned - but that should not cause
   the symptoms you are reporting.

   hth.

   Paul

   Mark Leith <[EMAIL PROTECTED]> wrote:
Hi All,

We've been asked a question from one of our clients that I'm a
little
stumped on.

They run an OLTP database (Oracle 8.1.7), and have recently
upgraded their
NT machine to Windows 2000, they were running with 2gb of memory,
and
upgraded that to 4gb in the process. As they increased physical
memory, they
also increased their SGA size & db_block_buffers.

Since they've upgraded they have noticed a significant decrease in
performance (the way it was described to me was "it was 7 out of
10, and is
now 3 out of 10"..).

Has anybody else done a system upgrade of this nature that has
caused less
than desirable effects? Any pointers as to what to look at? We've
requested
some stats (top wait stats etc.) and I'll feed these back as and
when I get
them - but I thought I'd throw this out to you guys in the vague
hope thatsomeone has experienced some relatively similar
experiences.

Cheers!

Mark

=

RE: After 256 connections : ORA-12154

Jay - You have received some great suggestions on this and no doubt you are
researching them. I'll offer a slightly dumber long shot, but easy to check.
What is your PROCESSES set for this instance?

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, December 16, 2003 1:39 PM
To: Multiple recipients of list ORACLE-L


Dear Gurus,

We are getting the following error if we try to create more than 256
connections from the same client. The problem is easily reproducible bt
writing simple java program and keep creating connections(do not close it).

Did anyone encounter this kind of issue and how did you solve it?

Exception in thread "main" java.sql.SQLException: ORA-12154: TNS:could not
resolve service name
 
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.(Compiled Code)
at java.lang.Exception.(Compiled Code)
at java.sql.SQLException.(SQLException.java:43)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.oci8.OCIDBAccess.check_error(Compiled Code)
at oracle.jdbc.oci8.OCIDBAccess.logon(Compiled Code)
at oracle.jdbc.driver.OracleConnection.(Compiled Code)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(Compiled
Code)
at oracle.jdbc.driver.OracleDriver.connect(Compiled Code)
at java.sql.DriverManager.getConnection(Compiled Code)
at java.sql.DriverManager.getConnection(Compiled Code)
at j1.main(Compiled Code)

Thanks in advance

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Unreadable time_stamp format

Title: Unreadable time_stamp format



Since 
it's a NUMBER datatype, try:
SQL>  column time_stamp format 

SQL>  select user_name, time_stamp from 
USER_ACTIVITY_LOG;
 

  -Original Message-From: Nguyen, David M 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, December 16, 2003 4:39 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Unreadable time_stamp format
  I need 
  to view time_stamp column in USER_ACTIVITY_LOG table but it displays unreadable 
  format as shown below.  Is there a way to decode it 
  to be readable?
  SQL> desc 
  USER_ACTIVITY_LOG
   Name  
  Null?    Type
   -  
  
   TIME_STAMP  
  NOT NULL NUMBER(20)
   NODE_NAME   
  NOT NULL VARCHAR2(20)
   USER_NAME    
  NOT NULL VARCHAR2(20)
   CLIENT_IP    
  NOT NULL VARCHAR2(15)
   DESCRIPTION  
  NOT NULL VARCHAR2(2048)
  SQL>select 
  user_name, time_stamp from 
  USER_ACTIVITY_LOG;
  edscott  1.0693E+12
  edscott  1.0693E+12
  edscott  1.0693E+12
  edscott  1.0693E+12
  jmdavis  1.0693E+12
  edscott  1.0693E+12
  edscott  1.0693E+12
  Thanks,David

Re: connection pooling from an application server to oracle

Steve, you're a genuine cornucopia of almost useful information.
I stand corrected. Sperm whales have larger brain then humans,
which makes them smart enough to forgo Java. Legend has it that
they are using a whale version of perl, based on whistling. 
(This is the place to insert "I'm a believer" by Monkees).

On 12/16/2003 04:09:34 PM, "Orr, Steve" wrote:
> Correction... Homo sapiens does not have the largest brain in the animal
> kingdom. Elephants have larger brains and sperm whale brains weigh in at
> a whopping 20 pounds. So this is not necessarily a case where size
> matters, it's the spirit within that makes the difference. Of course the
> size of the cerebral cortex may have something to do with it. ;-) There
> reason for larger brains in larger animals is the increased need for
> "connection pooling" because of the larger size of the nervous system.
> So you see, even nature recognizes the need for enhanced connectivity
> requirements. :-)
> 
> 
> 
> -Original Message-
> Mladen Gogala
> Sent: Monday, December 15, 2003 9:24 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> On 12/15/2003 10:54:27 AM, "Mercadante, Thomas F" wrote:
> > But Mladen, sooner or later, somebody is going to wise-up and catch 
> > you in your attempt at passing the blame.  When this happens to me, I 
> > quote to 80-20 rule.  80% gain in application thruput is brought thru 
> > Sql tuning (or rewrite).  If they say "The database is slow", I say 
> > "Show me the sql that is slow".  If they say "I can't because it is 
> > coming from the app", i say "Then I can't help you".
> 
> You're very optimistic about your fellow humans. I am not. Homo sapiens
> sapiens is a funny species. It is bestowed with the largest brain in the
> animal kingdom and usually very grateful when not forced to use it. As a
> matter of fact, any excuse is welcome to prevent the little grey cells
> (here I'm shamelessly 
> stealing from Poirot) from ever getting tired. 
> At any rate, it's politics. I'm trying to achieve something for the
> benefit of 
> my employer and I'm being obstructed by sleazy sales person aided and
> abetted by 
> damagement. Chances of them figuring me out are remote. I'm a DBA, I
> interpret 
> database statistics and it says what I say that it says. There are
> complications 
> when sleazy sales people bring in their own consultant DBA personnel.
> Then it is 
> a matter of discrediting the hostile DBA. 
> I have to say that this tactics has to be applied only there where there
> isn't 
> enough common sense to talk it through with the DBA and make him present
> the situation as it really is. Those are the places which distrust and
> fear their own DBAs. That is the first and foremost sign that the
> damagement has taken over. We, the DBAs hold 
> this truth to be self evident.
> 
> 
> 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-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name of
> mailing list you want to be removed from).  You may also send the HELP
> command for other information (like subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Orr, Steve
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Unreadable time_stamp format


column time_stamp format 9 head 'TIME STAMP'







"Nguyen, David M" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 12/16/2003 01:39 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Unreadable time_stamp format


I need to view time_stamp column in USER_ACTIVITY_LOG table but it displays unreadable format as shown below.  Is there a way to decode it to be readable?
SQL> desc USER_ACTIVITY_LOG
 Name                                      Null?    Type
 -  
 TIME_STAMP                              NOT NULL NUMBER(20)
 NODE_NAME                               NOT NULL VARCHAR2(20)
 USER_NAME                                NOT NULL VARCHAR2(20)
 CLIENT_IP                                    NOT NULL VARCHAR2(15)
 DESCRIPTION                              NOT NULL VARCHAR2(2048)

SQL>select user_name, time_stamp from USER_ACTIVITY_LOG;
edscott              1.0693E+12
edscott              1.0693E+12
edscott              1.0693E+12
edscott              1.0693E+12
jmdavis              1.0693E+12
edscott              1.0693E+12
edscott              1.0693E+12
Thanks,
David

Unreadable time_stamp format

2003-12-16 Thread Nguyen, David M

Title: Unreadable time_stamp format






I need to view time_stamp column in USER_ACTIVITY_LOG table but it displays unreadable format as shown below.  Is there a way to decode it to be readable?

SQL> desc USER_ACTIVITY_LOG

 Name  Null?    Type

 -  

 TIME_STAMP  NOT NULL NUMBER(20)

 NODE_NAME   NOT NULL VARCHAR2(20)

 USER_NAME    NOT NULL VARCHAR2(20)

 CLIENT_IP    NOT NULL VARCHAR2(15)

 DESCRIPTION  NOT NULL VARCHAR2(2048)


SQL>select user_name, time_stamp from USER_ACTIVITY_LOG;

edscott  1.0693E+12

edscott  1.0693E+12

edscott  1.0693E+12

edscott  1.0693E+12

jmdavis  1.0693E+12

edscott  1.0693E+12

edscott  1.0693E+12

Thanks,
David

RE: table partitions

2003-12-16 Thread raju pa

And make sure all your indexes are local."M.Godlewski" <[EMAIL PROTECTED]> wrote:

Alternatively you could create the table based on a time_key and map that to the time table. Then the partitions key could change meaning as the years go by.
i.e. time_key 1 = January of 2004
time_key 2 = Februrary of 2004
...
truncate the partitions as needed and reuse by changing the date in the time table.
time_key 1 = January of 2005
time_key 2 = Feburary of 2005
DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
Rick - Well, a simple way to do it might be to create 5 years of partitions,based on date as described. Then map all the Jan partitions to the sametablespace, Feb partitions to the same tablespace, etc. Instead oftruncating a partition, just drop it to reclaim the space. Crude, but mightmeet your needs without adding a new column. If you are still working therein 5 years, then congratulate yourself and create another 5 years ofpartitions.Dennis WilliamsDBALifetouch, Inc.[EMAIL PROTECTED] -Original Message-Sent: Tuesday, December 16, 2003 11:39 AMTo: Multiple recipients of list ORACLE-LYes, this is what I was looking for. I don't care about the year, and don'twant to worry about adding new partitions for every new month that comesalong each year. This table will only needs to contain !
! six
months worth ofdata. I will not be archiving it at all. I wanted to truncate thedata/partition after it was 6 months old.Thanks,Rick Stephenson-Original Message-Sent: Tuesday, December 16, 2003 6:49 AMTo: Multiple recipients of list ORACLE-LFrom what I understood, he's asking how to put all January records in onepartition, all Feb in another etc.So you end up with 12 partitions for as many years as you wish. I could notthink of any other solution then the one he does not want to.rw> Your high value for each partition can just be the beginning of every> month. For example: > > CREATE TABLE ACCOUNTS> (> STATEMENT_DATE DATE NOT NULL,> ACCOUNT_NUMBER VARCHAR2(8) NOT NULL,> BILLING_CYCLE VARCHAR2(2) NOT NULL,-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Wartiak RastislavINET: [EMAIL PROTECTED]Fat
City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).This email and any files transmitted with it are confidential and intendedsolely for the use of the individual or entity to which they are addressed.This message contains confidential information and is intended only for theindividual named. If you are not the named addressee you should notdisseminate, distribute or copy this e-mail. Please notify the senderimmediately by e-mail if you have received this e-ma!
! il by
mistake and deletethis e-mail from your system. If you are not the intended recipient you arenotified that disclosing, copying, forwarding or otherwise distributing ortaking any action in reliance on the contents of this information isstrictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Rick StephensonINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please !
! see the
official ORACLE-L FAQ: http://www.orafaq.net-- Author: DENNIS WILLIAMSINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).

Do you Yahoo!?New Yahoo! Photos - easier uploading and sharing
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard

RE: connection pooling from an application server to oracle

2003-12-16 Thread Orr, Steve

Correction... Homo sapiens does not have the largest brain in the animal
kingdom. Elephants have larger brains and sperm whale brains weigh in at
a whopping 20 pounds. So this is not necessarily a case where size
matters, it's the spirit within that makes the difference. Of course the
size of the cerebral cortex may have something to do with it. ;-) There
reason for larger brains in larger animals is the increased need for
"connection pooling" because of the larger size of the nervous system.
So you see, even nature recognizes the need for enhanced connectivity
requirements. :-)

-Original Message-
Mladen Gogala
Sent: Monday, December 15, 2003 9:24 AM
To: Multiple recipients of list ORACLE-L

On 12/15/2003 10:54:27 AM, "Mercadante, Thomas F" wrote:
> But Mladen, sooner or later, somebody is going to wise-up and catch 
> you in your attempt at passing the blame.  When this happens to me, I 
> quote to 80-20 rule.  80% gain in application thruput is brought thru 
> Sql tuning (or rewrite).  If they say "The database is slow", I say 
> "Show me the sql that is slow".  If they say "I can't because it is 
> coming from the app", i say "Then I can't help you".

You're very optimistic about your fellow humans. I am not. Homo sapiens
sapiens is a funny species. It is bestowed with the largest brain in the
animal kingdom and usually very grateful when not forced to use it. As a
matter of fact, any excuse is welcome to prevent the little grey cells
(here I'm shamelessly 
stealing from Poirot) from ever getting tired. 
At any rate, it's politics. I'm trying to achieve something for the
benefit of 
my employer and I'm being obstructed by sleazy sales person aided and
abetted by 
damagement. Chances of them figuring me out are remote. I'm a DBA, I
interpret 
database statistics and it says what I say that it says. There are
complications 
when sleazy sales people bring in their own consultant DBA personnel.
Then it is 
a matter of discrediting the hostile DBA. 
I have to say that this tactics has to be applied only there where there
isn't 
enough common sense to talk it through with the DBA and make him present
the situation as it really is. Those are the places which distrust and
fear their own DBAs. That is the first and foremost sign that the
damagement has taken over. We, the DBAs hold 
this truth to be self evident.

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-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Linux install for Oracle - Details reqd


On 12/16/2003 03:29:25 PM, quriyat  wrote:
> 
> Hello all
> 
> I am planning to install Linux; the idea is to install Oracle RAC.
> I have two questions:
> 
> Q1. Which Linux is best suited for it(RH?/SUSE?/Mandrake?).
> I know i can get Oracle download from OTN but it should be 
> installable on the particular flavor of Linux. Also, i would
> like to know which Linux will have comparitively lesser efforts
> to go thru the install and get me started at the earliest.

RH AS 3.0

> 
> Q2. Has anyone tried Oracle RAC on any of the above. If so what
> are the experience/problems encountered.

return (sub { "www.puschitz.com"; })

> 
> TIA
> 
> Quriyat DBA
> 
> 
> ___
> No banners. No pop-ups. No kidding.
> Introducing My Way - http://www.myway.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: quriyat 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: NT -> Win2K causes performance degradation..

2003-12-16 Thread Boivin, Patrice J

Title: Message



I'll 
throw gasoline on the fire here... 
 
On 
Win2K you may hit resource limits when you get to 1.5G or so memory used on a 4G 
server... 
 
Because Windows allocates half the memory to the kernel processes, half 
to the user processes.
 
Patrice.

  
  -Original Message-From: Yechiel Adar 
  [mailto:[EMAIL PROTECTED] Sent: December 11, 2003 10:40 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  NT -> Win2K causes performance degradation..
  The /3GB does not work for the simple reason that in W2K 
  you have 3GB as max address space. At least that what my sysadmin tells me 
  (after checking with MS).
   
  Yechiel AdarMehish
  
- Original Message - 
From: 
Paul 
Drake 
To: Multiple recipients of list ORACLE-L 

Sent: Wednesday, December 10, 2003 6:49 
PM
Subject: Re: NT -> Win2K causes 
performance degradation..

Mark,
 
My guess is, that the new OS re-instated the file system caching.
By default, 41% (yes, it should have been 42%) of physical memory will 
be allocated to filesystem caching, as W2K thinks it a fileserver (and 
domain controller, web server, print server, etc) until you tell it 
otherwise.
 
This is much improved in w2k3 server - where you tell it what you want 
it to be.
 
A good sysadmin would have set the OS to "optimize throughput for 
network applications" which would have turned off the filesystem caching. 
Ok, its only one radio button to select, so an MSCE could set it also.
 
Surprisingly enough, in W2K Server - changing this setting does not 
require a reboot, although I don't know if the changes take effect until 
after a system restart. That's not the sort of thing that I usually test, as 
NT4 had me trained to reboot afterwards.
 
the other thing may be, that the boot.ini no longer supports the /3GB 
or /PAE switches as Jared mentioned - but that should not cause the 
symptoms you are reporting.
 
hth.
 
PaulMark Leith <[EMAIL PROTECTED]> 
wrote:
Hi 
  All,We've been asked a question from one of our clients that I'm a 
  littlestumped on.They run an OLTP database (Oracle 8.1.7), and 
  have recently upgraded theirNT machine to Windows 2000, they were 
  running with 2gb of memory, andupgraded that to 4gb in the process. As 
  they increased physical memory, theyalso increased their SGA size 
  & db_block_buffers.Since they've upgraded they have noticed a 
  significant decrease inperformance (the way it was described to me was 
  "it was 7 out of 10, and isnow 3 out of 10"..).Has anybody 
  else done a system upgrade of this nature that has caused lessthan 
  desirable effects? Any pointers as to what to look at? We've 
  requestedsome stats (top wait stats etc.) and I'll feed these back as 
  and when I getthem - but I thought I'd throw this out to you guys in 
  the vague hope thatsomeone has experienced some relatively similar 
  experiences.Cheers!Mark===Mark 
  Leith | T: +44 (0)1905 330 281Sales & Marketing | F: +44 (0)870 
  127 5283Cool Tools UK Ltd | E: 
  [EMAIL PROTECTED]===http://www.cool-tools.co.ukMaximising 
  throughput & performance---Outgoing mail is certified Virus 
  Free.Checked by AVG anti-virus system 
  (http://www.grisoft.com).Version: 6.0.547 / Virus Database: 340 - 
  Release Date: 02/12/2003-- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.net-- Author: Mark LeithINET: 
  [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 
  http://www.fatcity.comSan Diego, California -- Mailing list and web 
  hosting 
  services-To 
  REMOVE yourself from this mailing list, send an E-Ma! il messageto: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe 
  message BODY, include a line containing: UNSUB ORACLE-L(or the name of 
  mailing list you want to be removed from). You mayalso send the HELP 
  command for other information (like subscribing).


Do you Yahoo!?New 
Yahoo! Photos - easier uploading and 
sharing

Linux install for Oracle - Details reqd

2003-12-16 Thread quriyat


Hello all

I am planning to install Linux; the idea is to install Oracle RAC.
I have two questions:

Q1. Which Linux is best suited for it(RH?/SUSE?/Mandrake?).
I know i can get Oracle download from OTN but it should be 
installable on the particular flavor of Linux. Also, i would
like to know which Linux will have comparitively lesser efforts
to go thru the install and get me started at the earliest.

Q2. Has anyone tried Oracle RAC on any of the above. If so what
are the experience/problems encountered.

TIA

Quriyat DBA


___
No banners. No pop-ups. No kidding.
Introducing My Way - http://www.myway.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: quriyat 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: After 256 connections : ORA-12154

My first thought is that JDBC has an array of connections indexed by 
a byte-sized index. Let me paraphrase Marie Antoinette, lady famous
for her shrewd dietary advice.
   
Let them use DBI.

Marie Antoinette's dietary advice came back to haunt her and gave
her a huge albeit very short pain in the neck. Hopefully, I will be
better off.

On 12/16/2003 02:59:33 PM, "Bobak, Mark" wrote:
> Hmm...my first thought is that this could be an OS/network configuration limitation 
> on the client side?  Though it does seem odd to raise an ORA-12154, after many 
> successful connections
> 
> What OS is the client?
> 
> -Original Message-
> Sent: Tuesday, December 16, 2003 2:39 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Dear Gurus,
> 
> We are getting the following error if we try to create more than 256 connections 
> from the same client. The problem is easily reproducible bt writing simple java 
> program and keep creating connections(do not close it).
> 
> Did anyone encounter this kind of issue and how did you solve it?
> 
> Exception in thread "main" java.sql.SQLException: ORA-12154: TNS:could not resolve 
> service name
>  
> at java.lang.Throwable.fillInStackTrace(Native Method)
> at java.lang.Throwable.fillInStackTrace(Compiled Code)
> at java.lang.Throwable.(Compiled Code)
> at java.lang.Exception.(Compiled Code)
> at java.sql.SQLException.(SQLException.java:43)
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
> at oracle.jdbc.oci8.OCIDBAccess.check_error(Compiled Code)
> at oracle.jdbc.oci8.OCIDBAccess.logon(Compiled Code)
> at oracle.jdbc.driver.OracleConnection.(Compiled Code)
> at oracle.jdbc.driver.OracleDriver.getConnectionInstance(Compiled Code)
> at oracle.jdbc.driver.OracleDriver.connect(Compiled Code)
> at java.sql.DriverManager.getConnection(Compiled Code)
> at java.sql.DriverManager.getConnection(Compiled Code)
> at j1.main(Compiled Code)
> 
> Thanks in advance
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Bobak, Mark
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: alter tablespace offline

2003-12-16 Thread Hand, Michael T

Jeroen,

The errors look like its from the database open not the mount.  As
Rachel has already mentioned the file rename has to take place after
the mount but before you open the database.

Mike

-Original Message-
Sent: Tuesday, December 16, 2003 8:04 AM
To: Multiple recipients of list ORACLE-L

did you also rename the datafile within the database?  the error
message on the line starting with ORA-01110 tells you that the database
thinks the file should be at /migratie_deca/DECA/DATA. If that is the
original location, that should tell you that as far as Oracle is
concerned the datafile is in the original location. You have to tell
Oracle where you moved the file, the database is smart but not
omniscient.

in addition to the "alter tablespace offline" (and no, I've NEVER had
to do this with the "normal" clause) you need to do an

alter database rename file '' to '' before you do the mount

--- Jeroen van Sluisdam <[EMAIL PROTECTED]> wrote:
> Hi Sinardy,
>  
> Instance was terminated when opening
>  
> Errors in file
> /opt/oracle/product/admin/DECA/udump/deca_ora_28080.trc:
> ORA-00376: file 6 cannot be read at this time
> ORA-01110: data file 6: '/migratie_deca/DECA/DATA/tools01.dbf'
> Error 376 happened during db open, shutting down database
> USER: terminating instance due to error 376
> Instance terminated by USER, pid = 28080
> ORA-1092 signalled during: ALTER DATABASE OPEN...
>  
> Regards,
>  
> Jeroen
> -Oorspronkelijk bericht-
> Van: Sinardy Xing [mailto:[EMAIL PROTECTED] 
> Verzonden: Tuesday, December 16, 2003 11:44
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp: RE: alter tablespace offline
>  
> Hi Jeroen,
>  
> What is problem? Error msg or something?
>  
> Sinardy
> -Original Message-
> Sent: 16 December 2003 18:12
> To: Multiple recipients of list ORACLE-L
>  
> Hi,
>  
> This weekend I was migrating an oracle 7.3.4 environment to oracle
> 9.2.0.4
> and we encountered
> a strange problem in issueing alter tablespace name offline.
> I had to reorganize tablespace and when testing this I did this
> manually and
> no problem at all.
> I put the statements in a script.
>  
> Executing the script put the tablespace offlline
> with exactly : alter tablespace name offline
> Moving the file with os and then starting up the database in mount
> phase
> lead to the problem it would not do this.
>  
> Backtracking this to a test environment and rereading the docs lead
> me to
> that I should have used
> alter tablespace name offline normal
>  
> I cannot remember whether I did this ok in the first tests but I
> might have
> copied it wrong into my script.
> What is the problem in issueing a alter tablespace name offline so
> without
> the normal clause?
>  
> Details: HP-UX11.11, Oracle 9.2.0.4
>  
> Regards,
>  
> Jeroen
> 

__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
This transmission is intended only for use by the addressee(s) named herein and may 
contain information that is proprietary, confidential and/or legally privileged. If 
you are not the intended recipient, you are hereby notified that any disclosure, 
copying, distribution, or use of the information contained herein (including any 
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, 
please immediately contact the sender and destroy the material in its entirety, 
whether in electronic or hard copy format. Thank you.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hand, Michael T
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: FW: Sun sets Solaris x86 free

2003-12-16 Thread Boivin, Patrice J

Linux is just not an option in some environments.

: )

Patrice

-Original Message-
Sent: December 15, 2003 9:24 AM
To: Multiple recipients of list ORACLE-L


That's right, it is just another crap. I would rather use Linux instead of
Solarix for x86.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, December 15, 2003 07:29


>
> On 2003.12.15 07:09, "Boivin, Patrice J" wrote:
> > Now if Oracle could release a version of its products for Solaris x86.
>
> Why would you use it? So that SUN can, at Scott McNealy's whim, start
charging for it?
> What is needed is not yet another Unix for x86, support for already
existing public domain
> Unix like system. SUN will have to accept Linux, not compete against it,
just like IBM did.
>
> >
> > Patrice.
> >
> > >  -Original Message-
> > > http://www.theregister.co.uk/content/61/34450.html
> > > 
> > >
> > > Sun sets Solaris x86 free
> > > By Ashlee Vance in Chicago  > >  >
> > > Posted: 10/12/2003 at 23:01 GMT
> > >
> > > Almost two years after it went on hiatus, Sun Microsystems' Solaris
x86
> > > has come back in full form with free downloads of the operating system
> > > becoming available once again, The Register has discovered.
> > >
> > > Some users call Sun's decision to give Solaris x86 away again a small
> > > step, but without doubt the move does bring some degree of closure to
part
> > > of a messy affair. Starting this week, Sun has removed the $20
price-tag
> > > for the OS - versions 8 and 9, replacing it with a red FREE sign
> > >  > >  > instead. A
fair
> > > number of Sun users have kept a close eye on this saga and will
remember
> > > that it was way back in Jan. of 2002 when Sun first said it would halt
> > > development on Solaris x86 only to buckle and bring the OS back at
cost.
> > >
> > > Big Solaris x86 fan Bruce Riddle wrote
> > >  > >  >,
> > > "This is really great news and shows that Sun is committed to Solaris
> > > x86," on a message board dedicated to the subject.
> > >
> > > And why not pat Sun on the back?
> > >
> > > Since giving Solaris x86 users the finger two year ago, Sun has worked
> > > rather hard to put the OS for Intel and AMD processors on equal
footing
> > > with Solaris/Sparc and Linux. Sun has vowed to have its entire
enterprise
> > > software stack - known as the Java Enterprise System - run on Solaris
x86.
> > > In addition, Sun now has Athlon, Xeon and, yes, Opteron hardware to
run
> > > its OS. The Opteron bit is a particular point of interest, as Sun is
> > > quickly establishing itself as the premier enterprise Unix supplier
for
> > > the new chip.
> > >
> > > Guns blazing, right?
> > >
> > > Well, a rather feisty chap from Penn State University named John
Groenveld
> > > doesn't think so.
> > >
> > > Groenveld owns the title of the most disgruntled Solaris x86 user on
the
> > > planet and relishes this role. When Sun was trying to back away from
the
> > > OS, it was Groenveld that gathered funds to place ads in major dailies
> > > blasting Sun CEO Scott McNealy for abandoning a very loyal portion of
the
> > > company's user base. One point of interest there is that some Sun
> > > engineers actually helped fund the ads.
> > >
> > > Now Groenveld is ready to strike again for what he is calling a
"customer
> > > service failure at Sun." He is threating to launch another ad
campaign.
> > >
> > > "The January 8 anniversary (of Sun nixing Solaris x86) is an important
> > > date for the community to make this failure clear," he said.
> > >
> > > Groenveld is an associate research engineer at Penn State - a
university
> > > that has been running Solaris x86 in production since the early 1990s.
> > > When Sun seemed to waver on the OS, "they left the university in the
> > > lurch." And so resentment was born.
> > >
> > > What Groenveld wants is direct and consistent answers from what he
sees as
> > > sparring divisions within Sun - the Solaris stalwarts and the Linux
> > > upstarts.
> > >
> > > In particular, Groenveld wants to know
> > >  > >  > where copies of
> > > StarOffice 7.0 for Solaris x86 are hiding. Over at StarOffice central,
> > > you'll
> > > notice
> > > Solaris x86 seems to be missing from the supported OS list.
> > >
> > > It took Sun a few months, but they have promised Groenveld a copy of
the
> > > office suite for Solaris x86 is coming. He would just like Sun to make
> > > this clear in a public fashion to convince those u

RE: FW: Sun sets Solaris x86 free

2003-12-16 Thread Boivin, Patrice J

Mladen,

I notice that the linux vendors are charging for their distributions...

The "free linux" argument doesn't hold true anymore, in my opinion.

Patrice.

-Original Message-
Sent: December 15, 2003 8:29 AM
To: Multiple recipients of list ORACLE-L



On 2003.12.15 07:09, "Boivin, Patrice J" wrote:
> Now if Oracle could release a version of its products for Solaris x86.

Why would you use it? So that SUN can, at Scott McNealy's whim, start
charging for it?
What is needed is not yet another Unix for x86, support for already existing
public domain
Unix like system. SUN will have to accept Linux, not compete against it,
just like IBM did.

> 
> Patrice.
> 
> >  -Original Message-
> > http://www.theregister.co.uk/content/61/34450.html
> >  
> > 
> > Sun sets Solaris x86 free
> > By Ashlee Vance in Chicago  >  >
> > Posted: 10/12/2003 at 23:01 GMT
> > 
> > Almost two years after it went on hiatus, Sun Microsystems' Solaris x86
> > has come back in full form with free downloads of the operating system
> > becoming available once again, The Register has discovered. 
> > 
> > Some users call Sun's decision to give Solaris x86 away again a small
> > step, but without doubt the move does bring some degree of closure to
part
> > of a messy affair. Starting this week, Sun has removed the $20 price-tag
> > for the OS - versions 8 and 9, replacing it with a red FREE sign
> >  >  > instead. A
fair
> > number of Sun users have kept a close eye on this saga and will remember
> > that it was way back in Jan. of 2002 when Sun first said it would halt
> > development on Solaris x86 only to buckle and bring the OS back at cost.

> > 
> > Big Solaris x86 fan Bruce Riddle wrote
> >  >  >,
> > "This is really great news and shows that Sun is committed to Solaris
> > x86," on a message board dedicated to the subject. 
> > 
> > And why not pat Sun on the back? 
> > 
> > Since giving Solaris x86 users the finger two year ago, Sun has worked
> > rather hard to put the OS for Intel and AMD processors on equal footing
> > with Solaris/Sparc and Linux. Sun has vowed to have its entire
enterprise
> > software stack - known as the Java Enterprise System - run on Solaris
x86.
> > In addition, Sun now has Athlon, Xeon and, yes, Opteron hardware to run
> > its OS. The Opteron bit is a particular point of interest, as Sun is
> > quickly establishing itself as the premier enterprise Unix supplier for
> > the new chip. 
> > 
> > Guns blazing, right? 
> > 
> > Well, a rather feisty chap from Penn State University named John
Groenveld
> > doesn't think so. 
> > 
> > Groenveld owns the title of the most disgruntled Solaris x86 user on the
> > planet and relishes this role. When Sun was trying to back away from the
> > OS, it was Groenveld that gathered funds to place ads in major dailies
> > blasting Sun CEO Scott McNealy for abandoning a very loyal portion of
the
> > company's user base. One point of interest there is that some Sun
> > engineers actually helped fund the ads. 
> > 
> > Now Groenveld is ready to strike again for what he is calling a
"customer
> > service failure at Sun." He is threating to launch another ad campaign. 
> > 
> > "The January 8 anniversary (of Sun nixing Solaris x86) is an important
> > date for the community to make this failure clear," he said. 
> > 
> > Groenveld is an associate research engineer at Penn State - a university
> > that has been running Solaris x86 in production since the early 1990s.
> > When Sun seemed to waver on the OS, "they left the university in the
> > lurch." And so resentment was born. 
> > 
> > What Groenveld wants is direct and consistent answers from what he sees
as
> > sparring divisions within Sun - the Solaris stalwarts and the Linux
> > upstarts. 
> > 
> > In particular, Groenveld wants to know
> >  >  > where copies of
> > StarOffice 7.0 for Solaris x86 are hiding. Over at StarOffice central,
> > you'll
> > notice
> > Solaris x86 seems to be missing from the supported OS list. 
> > 
> > It took Sun a few months, but they have promised Groenveld a copy of the
> > office suite for Solaris x86 is coming. He would just like Sun to make
> > this clear in a public fashion to convince those users nervous about
Sun's
> > intentions that the product is most certainly on its way. 
> > 
> > "Just put it up on the product page so at least people know it will be
> > there eventually," Groenveld said. 
> > 
> > Now, there are certain workers within Sun that think Groe

RE: After 256 connections : ORA-12154

Hmm...my first thought is that this could be an OS/network configuration limitation on 
the client side?  Though it does seem odd to raise an ORA-12154, after many successful 
connections

What OS is the client?

-Original Message-
Sent: Tuesday, December 16, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L


Dear Gurus,

We are getting the following error if we try to create more than 256 connections from 
the same client. The problem is easily reproducible bt writing simple java program and 
keep creating connections(do not close it).

Did anyone encounter this kind of issue and how did you solve it?

Exception in thread "main" java.sql.SQLException: ORA-12154: TNS:could not resolve 
service name
 
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.(Compiled Code)
at java.lang.Exception.(Compiled Code)
at java.sql.SQLException.(SQLException.java:43)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.oci8.OCIDBAccess.check_error(Compiled Code)
at oracle.jdbc.oci8.OCIDBAccess.logon(Compiled Code)
at oracle.jdbc.driver.OracleConnection.(Compiled Code)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(Compiled Code)
at oracle.jdbc.driver.OracleDriver.connect(Compiled Code)
at java.sql.DriverManager.getConnection(Compiled Code)
at java.sql.DriverManager.getConnection(Compiled Code)
at j1.main(Compiled Code)

Thanks in advance

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bobak, Mark
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: After 256 connections : ORA-12154

2003-12-16 Thread Odland, Brad

Anytime you see a number like 256 it is likely you are hitting some limit.

My guess is you are running out of memory in your application on that
client.

If you are trying to open that many connections from a single client you
should start to look at connection manager to pool these connections of at
least recode your app to share connections.

Brad 

-Original Message-
Sent: Tuesday, December 16, 2003 1:39 PM
To: Multiple recipients of list ORACLE-L


Dear Gurus,

We are getting the following error if we try to create more than 256
connections from the same client. The problem is easily reproducible bt
writing simple java program and keep creating connections(do not close it).

Did anyone encounter this kind of issue and how did you solve it?

Exception in thread "main" java.sql.SQLException: ORA-12154: TNS:could not
resolve service name
 
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.(Compiled Code)
at java.lang.Exception.(Compiled Code)
at java.sql.SQLException.(SQLException.java:43)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.oci8.OCIDBAccess.check_error(Compiled Code)
at oracle.jdbc.oci8.OCIDBAccess.logon(Compiled Code)
at oracle.jdbc.driver.OracleConnection.(Compiled Code)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(Compiled
Code)
at oracle.jdbc.driver.OracleDriver.connect(Compiled Code)
at java.sql.DriverManager.getConnection(Compiled Code)
at java.sql.DriverManager.getConnection(Compiled Code)
at j1.main(Compiled Code)

Thanks in advance

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Odland, Brad
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Exclusive Password file, multiple databases

Id the file name $ORACLE_HOME/dbs/orapw$ORACLE_SID?  The file MUST BE properly named
in order for oracle to recognize it.
On 12/16/2003 01:54:24 PM, M.Godlewski wrote:
> April,
>  
> Look for a syntax error.
> 
> April Wells <[EMAIL PROTECTED]> wrote:
> 
> Okay, I have been trying Google and Tahiti for 2 days, and I can't for the life of 
> me figure out how to clue in my database.  
> 
> 9.2.0.2 on AIX 5l 
> 
> I am running multiple databases and am trying to get all of the instances running 
> with remote_login_passwordfile=exclusive.  Most of the databases are running fine, 
> but one insists on looking for the default file name, despite my having provided 
> filename= parameter to orapwd.  I can't find anything that is supposed to 
> clue it in in this circumstance, and recreating the password file doesn't really so 
> any good either.  Every time I try to start the database using the pfile, it 
> complains about wanting the orapwd file... 
> 
> All of the other databases are happy enough with what I did.  What am I doing wrong 
> with this one... where do I start looking?  
> 
> 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 
> 
> The information contained in this communication, including attachments, is strictly 
> confidential and for the intended use of the addressee only; it may also contain 
> proprietary, price sensitive, or legally privileged information. Notice is hereby 
> given that any disclosure, distribution, dissemination, use, or copying of the 
> information by anyone other than the intended recipient is strictly prohibited and 
> may be illegal. If you have received this communication in error, please notify the 
> sender immediately by reply e-mail, delete this communication, and destroy all 
> copies.Corporate Systems, Inc. has taken reasonable precautions to ensure that any 
> attachment to this e-mail has been swept for viruses. We specifically disclaim all 
> liability and will accept no responsibility for damage sustained as a result of 
> software viruses and advise you to carry out your own virus checks before opening 
> any attachment.
> 
> 
> -
> Do you Yahoo!?
> New Yahoo! Photos - easier uploading and sharing

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-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: After 256 connections : ORA-12154

What is the setting for processes in the database? What is your per-process-file 
descriptor limit?

If you are on Solaris following may apply to you ...



Problem Description 
--- 
You have a JDBC program connecting to the database. This program may run standalone 
or on a webserver. This program opens many simultaneous connections to the database. 
The following error occurs on or near the 257th connection: 
java.sql.SQLException: ORA-12154: TNS:could not resolve service name 
All of the following symptoms apply: 
- Solaris OS 
- Oracle JDBC/OCI driver 
- ORA-12154 Error 
- Failure occurs on 257th connection between JDBC client and Oracle server. 
- Same program works on a non-Solaris OS, exceeding the 257th connection. 
Solution Description 
 
This is a known Solaris bug (1084772). Contact Sun for further information and/or 
possible patch. As a workaround, you can hardcode the full tns description in the 
JDBC/OCI connection string. This avoids the need to read the tnsnames.ora file. 
This will not eliminate the problem, but should free up more file descriptors for 
your use, thus deferring failure until later. 
jdbc:oracle:oci8:@(description=(address=(host=pepper)(protocol=tcp)(port=1521))(connect_data=(sid=ORCL)))
 
Explanation 
--- 
The OS file descriptor limit is being reached. Thus, the tnsnames.ora file cannot 
be read to resolve the tns alias suppled to the connection string. 
References 
-- 
http://sunsolve.sun.com 
bug (1084772) Summary: Although the limit for file descriptors is 1024, you  cannot 
open more than 256 fd's using stdio.h. (This is not an Oracle bug.) 
note:94091.1 Example: Identifying Connection String Problems in JDBC 
bug:777647 When Opening > 253 File Descriptors and Then Connection 
bug:2060739 ORA-12154 After Creating 220+ Connections Using Thick (OCI8) JDBC Driver 



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 Message-
Sent: Tuesday, December 16, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L


Dear Gurus,

We are getting the following error if we try to create more than 256 connections from 
the same client. The problem is easily reproducible bt writing simple java program and 
keep creating connections(do not close it).

Did anyone encounter this kind of issue and how did you solve it?

Exception in thread "main" java.sql.SQLException: ORA-12154: TNS:could not resolve 
service name
 
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.(Compiled Code)
at java.lang.Exception.(Compiled Code)
at java.sql.SQLException.(SQLException.java:43)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.oci8.OCIDBAccess.check_error(Compiled Code)
at oracle.jdbc.oci8.OCIDBAccess.logon(Compiled Code)
at oracle.jdbc.driver.OracleConnection.(Compiled Code)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(Compiled Code)
at oracle.jdbc.driver.OracleDriver.connect(Compiled Code)
at java.sql.DriverManager.getConnection(Compiled Code)
at java.sql.DriverManager.getConnection(Compiled Code)
at j1.main(Compiled Code)

Thanks in advance

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**5
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-

After 256 connections : ORA-12154

2003-12-16 Thread jaysingh1

Dear Gurus,

We are getting the following error if we try to create more than 256 connections from 
the same client. The problem is easily reproducible bt writing simple java program and 
keep creating connections(do not close it).

Did anyone encounter this kind of issue and how did you solve it?

Exception in thread "main" java.sql.SQLException: ORA-12154: TNS:could not resolve 
service name
 
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.(Compiled Code)
at java.lang.Exception.(Compiled Code)
at java.sql.SQLException.(SQLException.java:43)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.oci8.OCIDBAccess.check_error(Compiled Code)
at oracle.jdbc.oci8.OCIDBAccess.logon(Compiled Code)
at oracle.jdbc.driver.OracleConnection.(Compiled Code)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(Compiled Code)
at oracle.jdbc.driver.OracleDriver.connect(Compiled Code)
at java.sql.DriverManager.getConnection(Compiled Code)
at java.sql.DriverManager.getConnection(Compiled Code)
at j1.main(Compiled Code)

Thanks in advance

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Good news from Oracle

2003-12-16 Thread Thater, William

[EMAIL PROTECTED]  scribbled on the wall in glitter crayon:

> Or perhaps
> 
> ora-600 [x] "I didn't expect the Spanish Inquisition !"

NOBODY expects the Spanish Inquisition!;-)

--
Bill "Shrek" Thater ORACLE DBA  
"I'm going to work my ticket if I can..." -- Gilwell song
[EMAIL PROTECTED]

The release of atom power has changed everything except our way of
thinking...the solution to this problem lies in the heart of mankind. If
only I had known, I should have become a watchmaker. - Albert Einstein
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Exclusive Password file, multiple databases

2003-12-16 Thread M.Godlewski

April,
 
Look for a syntax error.April Wells <[EMAIL PROTECTED]> wrote:


Okay, I have been trying Google and Tahiti for 2 days, and I can't for the life of me figure out how to clue in my database.  
9.2.0.2 on AIX 5l 
I am running multiple databases and am trying to get all of the instances running with remote_login_passwordfile=exclusive.  Most of the databases are running fine, but one insists on looking for the default file name, despite my having provided filename= parameter to orapwd.  I can't find anything that is supposed to clue it in in this circumstance, and recreating the password file doesn't really so any good either.  Every time I try to start the database using the pfile, it complains about wanting the orapwd file... 
All of the other databases are happy enough with what I did.  What am I doing wrong with this one... where do I start looking?  
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 



The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.

Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing

RE: Good news from Oracle

2003-12-16 Thread Pete Sharman

Well, that Irish Cream stuff usually includes whiskey anyway, though of
the Irish variety of course.  I have fond memories of my university days
when a friend used to make his own Baileys by the 5 gallon bucket.  Same
great taste, only creamier.  Ah, those were the days!  :)

Pete

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA


-Original Message-
Mladen Gogala
Sent: Wednesday, December 17, 2003 5:29 AM
To: Multiple recipients of list ORACLE-L

Pete, I wholeheartedly agree with you. That is why I took two weeks off
as of this Friday. Unfortunately, as far as Scotch  is concerned, I'm
more
of an Irish Cream guy. Bailey's, Feeney Irish Cream and St Bredans Irish
Cream
are my favorite poisons. Connor, I hope that you're not disappointed.


On 12/16/2003 12:24:25 PM, Pete Sharman wrote:
> Mladen, you seem to be getting more warped, bitter and twisted each
day!
> :)
> 
> I think you need a holiday, or at least a good bottle of whiskey.  If
> you contact Connor McDonald, he has a list of VERY nice scotches (up
to
> 11,000 pounds IIRC) that you might like to pass on to someone to
choose
> a nice pressy to put under your Christmas tree.  :)
> 
> Pete
> 
> "Controlling developers is like herding cats."
> 
> Kevin Loney, Oracle DBA Handbook
> 
> "Oh no, it's not.  It's much harder than that!"
> 
> Bruce Pihlamae, long-term Oracle DBA
> 
> 
> -Original Message-
> Mladen Gogala
> Sent: Wednesday, December 17, 2003 3:19 AM
> To: Multiple recipients of list ORACLE-L
> 
> Raj, you proven once again that you're an invaluable source of
> good information. Let me share it with the others. The note 
> that Raj is talking about has the tfollowing title:
> 
>   ORA-600 [12235] "Oracle process has no purpose in life !"
> 
> I guess it will be accompanied by "ora-600 [x] "Look at the bright
> side of life!"
> rather soon.
> 
> On 12/16/2003 09:54:38 AM, "Jamadagni, Rajendra" wrote:
> > check the subject heading for tech note 33174.1
> > 
> > Type:  REFERENCE 
> > Status:  PUBLISHED 
> > 
> > Howzzat?
> > 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 Message-
> > Sent: Tuesday, December 16, 2003 9:44 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Of course they are. Support and development cost them much less now
> that they've
> > outsourced it to Elbonia. The quality of the code is another matter.
> Fortunately,
> > they have broad and wide open beta testing program so that we all
know
> what we can
> > expect. If the first relase of 10g is usable, I'll change my name to
> ora-600.
> > 
> >
>

> **
> > This e-mail message is confidential, intended only for the named
> recipient(s) above and may contain information that is privileged,
> attorney work product or exempt from disclosure under applicable law.
If
> you have received this message in error, or are not the named
> recipient(s), please immediately notify corporate MIS at (860)
766-2000
> and delete this e-mail message from your computer, Thank you.
> >
>

> **4
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Jamadagni, Rajendra
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
services
> >
-
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> > 
> 
> 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-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> -- 
> Please see the offici

RE: table partitions

2003-12-16 Thread M.Godlewski

Alternatively you could create the table based on a time_key and map that to the time table. Then the partitions key could change meaning as the years go by.
i.e. time_key 1 = January of 2004
time_key 2 = Februrary of 2004
...
truncate the partitions as needed and reuse by changing the date in the time table.
time_key 1 = January of 2005
time_key 2 = Feburary of 2005
DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
Rick - Well, a simple way to do it might be to create 5 years of partitions,based on date as described. Then map all the Jan partitions to the sametablespace, Feb partitions to the same tablespace, etc. Instead oftruncating a partition, just drop it to reclaim the space. Crude, but mightmeet your needs without adding a new column. If you are still working therein 5 years, then congratulate yourself and create another 5 years ofpartitions.Dennis WilliamsDBALifetouch, Inc.[EMAIL PROTECTED] -Original Message-Sent: Tuesday, December 16, 2003 11:39 AMTo: Multiple recipients of list ORACLE-LYes, this is what I was looking for. I don't care about the year, and don'twant to worry about adding new partitions for every new month that comesalong each year. This table will only needs to contain !
six
months worth ofdata. I will not be archiving it at all. I wanted to truncate thedata/partition after it was 6 months old.Thanks,Rick Stephenson-Original Message-Sent: Tuesday, December 16, 2003 6:49 AMTo: Multiple recipients of list ORACLE-LFrom what I understood, he's asking how to put all January records in onepartition, all Feb in another etc.So you end up with 12 partitions for as many years as you wish. I could notthink of any other solution then the one he does not want to.rw> Your high value for each partition can just be the beginning of every> month. For example: > > CREATE TABLE ACCOUNTS> (> STATEMENT_DATE DATE NOT NULL,> ACCOUNT_NUMBER VARCHAR2(8) NOT NULL,> BILLING_CYCLE VARCHAR2(2) NOT NULL,-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Wartiak RastislavINET: [EMAIL PROTECTED]Fat
City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).This email and any files transmitted with it are confidential and intendedsolely for the use of the individual or entity to which they are addressed.This message contains confidential information and is intended only for theindividual named. If you are not the named addressee you should notdisseminate, distribute or copy this e-mail. Please notify the senderimmediately by e-mail if you have received this e-ma!
il by
mistake and deletethis e-mail from your system. If you are not the intended recipient you arenotified that disclosing, copying, forwarding or otherwise distributing ortaking any action in reliance on the contents of this information isstrictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Rick StephensonINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please !
see the
official ORACLE-L FAQ: http://www.orafaq.net-- Author: DENNIS WILLIAMSINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing

Re: Good news from Oracle

Pete, I wholeheartedly agree with you. That is why I took two weeks off
as of this Friday. Unfortunately, as far as Scotch  is concerned, I'm more
of an Irish Cream guy. Bailey's, Feeney Irish Cream and St Bredans Irish Cream
are my favorite poisons. Connor, I hope that you're not disappointed.


On 12/16/2003 12:24:25 PM, Pete Sharman wrote:
> Mladen, you seem to be getting more warped, bitter and twisted each day!
> :)
> 
> I think you need a holiday, or at least a good bottle of whiskey.  If
> you contact Connor McDonald, he has a list of VERY nice scotches (up to
> 11,000 pounds IIRC) that you might like to pass on to someone to choose
> a nice pressy to put under your Christmas tree.  :)
> 
> Pete
> 
> "Controlling developers is like herding cats."
> 
> Kevin Loney, Oracle DBA Handbook
> 
> "Oh no, it's not.  It's much harder than that!"
> 
> Bruce Pihlamae, long-term Oracle DBA
> 
> 
> -Original Message-
> Mladen Gogala
> Sent: Wednesday, December 17, 2003 3:19 AM
> To: Multiple recipients of list ORACLE-L
> 
> Raj, you proven once again that you're an invaluable source of
> good information. Let me share it with the others. The note 
> that Raj is talking about has the tfollowing title:
> 
>   ORA-600 [12235] "Oracle process has no purpose in life !"
> 
> I guess it will be accompanied by "ora-600 [x] "Look at the bright
> side of life!"
> rather soon.
> 
> On 12/16/2003 09:54:38 AM, "Jamadagni, Rajendra" wrote:
> > check the subject heading for tech note 33174.1
> > 
> > Type:  REFERENCE 
> > Status:  PUBLISHED 
> > 
> > Howzzat?
> > 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 Message-
> > Sent: Tuesday, December 16, 2003 9:44 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Of course they are. Support and development cost them much less now
> that they've
> > outsourced it to Elbonia. The quality of the code is another matter.
> Fortunately,
> > they have broad and wide open beta testing program so that we all know
> what we can
> > expect. If the first relase of 10g is usable, I'll change my name to
> ora-600.
> > 
> >
> 
> **
> > This e-mail message is confidential, intended only for the named
> recipient(s) above and may contain information that is privileged,
> attorney work product or exempt from disclosure under applicable law. If
> you have received this message in error, or are not the named
> recipient(s), please immediately notify corporate MIS at (860) 766-2000
> and delete this e-mail message from your computer, Thank you.
> >
> 
> **4
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Jamadagni, Rajendra
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> > 
> 
> 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-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Pete Sharman
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may

Re: Good news from Oracle

2003-12-16 Thread Rachel Carmichael

Before Jared sends you all to my list

nope. hated LOTR (the books and part 1) and never saw Babylon 5


--- Thomas Day <[EMAIL PROTECTED]> wrote:
> 
> Everybody loves Monty Python, don't they?  I liked Red Dwarf well
> enough to
> make the effort to see it.
> 
> Are we all big LOTR and B5 fans as well?
> 
> 
> 
>  
>  
>   Mladen Gogala  
>  
>recipients of list ORACLE-L <[EMAIL PROTECTED]>   
> 
>   @wangtrading.com cc:   
>  
>   >Subject: Re: Good news
> from Oracle  
>   Sent by:   
>  
>   ml-errors  
>  
>  
>  
>  
>  
>   12/16/2003 12:29   
>  
>   PM 
>  
>   Please respond 
>  
>   to ORACLE-L
>  
>  
>  
>  
>  
> 
> 
> 
> 
> Nobody expects the Spanish Inquisition! Why is that there are so
> many Monty Python lovers among us oraclites? The other day, Bambi
> has used the "velocity of a laden swallow" thing from the Holy Grail,
> almost everybody knows Brian and some other sketches. Do we have
> any lovers of the Red Dwarf and Ace Rimmer here?
> 
> On 12/16/2003 12:14:25 PM, [EMAIL PROTECTED] wrote:
> > Or perhaps
> >
> > ora-600 [x] "I didn't expect the Spanish Inquisition !"
> >
> > mvg/regards
> >
> > Jo
> >
> >
> >
> >
> >
> >
> > Mladen Gogala <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 12/16/2003 17:19
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> > cc:
> > Subject:Re: Good news from Oracle
> >
> >
> > Raj, you proven once again that you're an invaluable source of
> > good information. Let me share it with the others. The note
> > that Raj is talking about has the tfollowing title:
> >
> >  ORA-600 [12235] "Oracle process has no purpose in
> life
> !"
> >
> > I guess it will be accompanied by "ora-600 [x] "Look at the
> bright
> > side of life!"
> > rather soon.
> >
> > On 12/16/2003 09:54:38 AM, "Jamadagni, Rajendra" wrote:
> > > check the subject heading for tech note 33174.1
> > >
> > > Type:  REFERENCE
> > > Status:  PUBLISHED
> > >
> > > Howzzat?
> > > 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 Message-
> > > Sent: Tuesday, December 16, 2003 9:44 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Of course they are. Support and development cost them much less
> now
> that
> > they've
> > > outsourced it to Elbonia. The quality of the code is another
> matter.
> > Fortunately,
> > > they have broad and wide open beta testing program so that we all
> know
> > what we can
> > > expect. If the first relase of 10g is usable, I'll change my name
> to
> > ora-600.
> > >
> > >
> >
>
**
> 
> > > This e-mail message is confidential, intended only for the named
> > recipient(s) above and may contain information that is privileged,
> > attorney work product or exempt from disclosure under applicable
> law. If
> > you have received this message in error, or are not the named
> > recipient(s),

RE: table partitions

Rick - Well, a simple way to do it might be to create 5 years of partitions,
based on date as described. Then map all the Jan partitions to the same
tablespace, Feb partitions to the same tablespace, etc. Instead of
truncating a partition, just drop it to reclaim the space. Crude, but might
meet your needs without adding a new column. If you are still working there
in 5 years, then congratulate yourself and create another 5 years of
partitions.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, December 16, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L


Yes, this is what I was looking for.  I don't care about the year, and don't
want to worry about adding new partitions for every new month that comes
along each year.  This table will only needs to contain six months worth of
data.  I will not be archiving it at all.  I wanted to truncate the
data/partition after it was 6 months old.

Thanks,

Rick Stephenson


-Original Message-
Sent: Tuesday, December 16, 2003 6:49 AM
To: Multiple recipients of list ORACLE-L

>From what I understood, he's asking how to put all January records in one
partition, all Feb in another etc.
So you end up with 12 partitions for as many years as you wish. I could not
think of any other solution then the one he does not want to.

rw

> Your high value for each partition can just be the beginning of every
> month.  For example: 
> 
> CREATE TABLE ACCOUNTS
> (
>   STATEMENT_DATE DATE   NOT NULL,
>   ACCOUNT_NUMBER VARCHAR2(8)NOT NULL,
>   BILLING_CYCLE  VARCHAR2(2)NOT NULL,
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wartiak Rastislav
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to which they are addressed.
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system. If you are not the intended recipient you are
notified that disclosing, copying, forwarding or otherwise distributing or
taking any action in reliance on the contents of this information is
strictly prohibited. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rick Stephenson
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

(OT !!!!!!!) Re: Good news from Oracle

2003-12-16 Thread jo_holvoet

Most definitely ! "Smoke me a kipper" and all that.
I'm heavily biased in favour of anything British as far as comedy goes : 
Blackadder (absolute no. 1), AbFab, ...

mvg/regards

Jo






Mladen Gogala <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/16/2003 18:29
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: Good news from Oracle


Nobody expects the Spanish Inquisition! Why is that there are so
many Monty Python lovers among us oraclites? The other day, Bambi
has used the "velocity of a laden swallow" thing from the Holy Grail,
almost everybody knows Brian and some other sketches. Do we have
any lovers of the Red Dwarf and Ace Rimmer here?

On 12/16/2003 12:14:25 PM, [EMAIL PROTECTED] wrote:
> Or perhaps
> 
> ora-600 [x] "I didn't expect the Spanish Inquisition !"
> 
> mvg/regards
> 
> Jo
> 
> 
> 
> 
> 
> 
> Mladen Gogala <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 12/16/2003 17:19
> Please respond to ORACLE-L
> 
> 
> To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
> cc: 
> Subject:Re: Good news from Oracle
> 
> 
> Raj, you proven once again that you're an invaluable source of
> good information. Let me share it with the others. The note 
> that Raj is talking about has the tfollowing title:
> 
>  ORA-600 [12235] "Oracle process has no purpose in life 
!"
> 
> I guess it will be accompanied by "ora-600 [x] "Look at the bright 
> side of life!"
> rather soon.
> 
> On 12/16/2003 09:54:38 AM, "Jamadagni, Rajendra" wrote:
> > check the subject heading for tech note 33174.1
> > 
> > Type:  REFERENCE 
> > Status:  PUBLISHED 
> > 
> > Howzzat?
> > 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 Message-
> > Sent: Tuesday, December 16, 2003 9:44 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Of course they are. Support and development cost them much less now 
that 
> they've
> > outsourced it to Elbonia. The quality of the code is another matter. 
> Fortunately,
> > they have broad and wide open beta testing program so that we all know 

> what we can
> > expect. If the first relase of 10g is usable, I'll change my name to 
> ora-600.
> > 
> > 
> 
**
> > This e-mail message is confidential, intended only for the named 
> recipient(s) above and may contain information that is privileged, 
> attorney work product or exempt from disclosure under applicable law. If 

> you have received this message in error, or are not the named 
> recipient(s), please immediately notify corporate MIS at (860) 766-2000 
> and delete this e-mail message from your computer, Thank you.
> > 
> 
**4
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Jamadagni, Rajendra
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> > 
> 
> 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-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note

RE: Good news from Oracle

2003-12-16 Thread Thater, William

Mladen Gogala  scribbled on the wall in glitter crayon:

> Nobody expects the Spanish Inquisition! Why is that there are so
> many Monty Python lovers among us oraclites? The other day, Bambi
> has used the "velocity of a laden swallow" thing from the Holy Grail,
> almost everybody knows Brian and some other sketches. Do we have
> any lovers of the Red Dwarf and Ace Rimmer here?

i'm more a Dr. Who type meself.;-)  but it is interesting that almost all
techies are Monty Python lovers.  go to a party and say a MP line, and most
likely anybody who answers correctly will be somebody you can talk shop
with.  [my wife hates when i do that.;-)]

--
Bill "Shrek" Thater ORACLE DBA  
"I'm going to work my ticket if I can..." -- Gilwell song
[EMAIL PROTECTED]

DYNAMIC LINKING ERROR: Your mistake is now everywhere.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thater, William
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Good news from Oracle

2003-12-16 Thread Thomas Day


Everybody loves Monty Python, don't they?  I liked Red Dwarf well enough to
make the effort to see it.

Are we all big LOTR and B5 fans as well?



   

  Mladen Gogala

  
  @wangtrading.com cc: 

  >Subject: Re: Good news from Oracle  

  Sent by: 

  ml-errors

   

   

  12/16/2003 12:29 

  PM   

  Please respond   

  to ORACLE-L  

   

   





Nobody expects the Spanish Inquisition! Why is that there are so
many Monty Python lovers among us oraclites? The other day, Bambi
has used the "velocity of a laden swallow" thing from the Holy Grail,
almost everybody knows Brian and some other sketches. Do we have
any lovers of the Red Dwarf and Ace Rimmer here?

On 12/16/2003 12:14:25 PM, [EMAIL PROTECTED] wrote:
> Or perhaps
>
> ora-600 [x] "I didn't expect the Spanish Inquisition !"
>
> mvg/regards
>
> Jo
>
>
>
>
>
>
> Mladen Gogala <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 12/16/2003 17:19
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:Re: Good news from Oracle
>
>
> Raj, you proven once again that you're an invaluable source of
> good information. Let me share it with the others. The note
> that Raj is talking about has the tfollowing title:
>
>  ORA-600 [12235] "Oracle process has no purpose in life
!"
>
> I guess it will be accompanied by "ora-600 [x] "Look at the bright
> side of life!"
> rather soon.
>
> On 12/16/2003 09:54:38 AM, "Jamadagni, Rajendra" wrote:
> > check the subject heading for tech note 33174.1
> >
> > Type:  REFERENCE
> > Status:  PUBLISHED
> >
> > Howzzat?
> > 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 Message-
> > Sent: Tuesday, December 16, 2003 9:44 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Of course they are. Support and development cost them much less now
that
> they've
> > outsourced it to Elbonia. The quality of the code is another matter.
> Fortunately,
> > they have broad and wide open beta testing program so that we all know
> what we can
> > expect. If the first relase of 10g is usable, I'll change my name to
> ora-600.
> >
> >
>
**

> > This e-mail message is confidential, intended only for the named
> recipient(s) above and may contain information that is privileged,
> attorney work product or exempt from disclosure under applicable law. If
> you have received this message in error, or are not the named
> recipient(s), please immediately notify corporate MIS at (860) 766-2000
> and delete this e-mail message from your computer, Thank you.
> >
>
**4

> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Jamadagni, Rajendra
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, Cali

RE: Good news from Oracle

2003-12-16 Thread Bellow, Bambi


$ oerr tns 0
0, 0, "Not An Error"
// *Cause:  Everything is working as it should.
// *Action: Don't worry: Be happy.

Different song... less Pythonesque...


-Original Message-
Sent: Tuesday, December 16, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L


Raj, you proven once again that you're an invaluable source of
good information. Let me share it with the others. The note 
that Raj is talking about has the tfollowing title:

ORA-600 [12235] "Oracle process has no purpose in life !"

I guess it will be accompanied by "ora-600 [x] "Look at the bright side
of life!"
rather soon.

On 12/16/2003 09:54:38 AM, "Jamadagni, Rajendra" wrote:
> check the subject heading for tech note 33174.1
> 
> Type:  REFERENCE 
> Status:  PUBLISHED 
> 
> Howzzat?
> 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 Message-
> Sent: Tuesday, December 16, 2003 9:44 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Of course they are. Support and development cost them much less now that
they've
> outsourced it to Elbonia. The quality of the code is another matter.
Fortunately,
> they have broad and wide open beta testing program so that we all know
what we can
> expect. If the first relase of 10g is usable, I'll change my name to
ora-600.
> 
>

**
> This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged, attorney
work product or exempt from disclosure under applicable law. If you have
received this message in error, or are not the named recipient(s), please
immediately notify corporate MIS at (860) 766-2000 and delete this e-mail
message from your computer, Thank you.
>

**4
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jamadagni, Rajendra
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bellow, Bambi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OT: Christmas present for the Oracle DBA

2003-12-16 Thread Jesse, Rich

Maybe some of our stories made it?

http://www.computerworld.com/2004sharktankcalendar

Happy Holidays!

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Good news from Oracle

2003-12-16 Thread Odland, Brad

Smeg! Love a hologram...forget that pompus self rightous illusion...
 


-Original Message-
Sent: Tuesday, December 16, 2003 11:29 AM
To: Multiple recipients of list ORACLE-L


Nobody expects the Spanish Inquisition! Why is that there are so
many Monty Python lovers among us oraclites? The other day, Bambi
has used the "velocity of a laden swallow" thing from the Holy Grail,
almost everybody knows Brian and some other sketches. Do we have
any lovers of the Red Dwarf and Ace Rimmer here?

On 12/16/2003 12:14:25 PM, [EMAIL PROTECTED] wrote:
> Or perhaps
> 
> ora-600 [x] "I didn't expect the Spanish Inquisition !"
> 
> mvg/regards
> 
> Jo
> 
> 
> 
> 
> 
> 
> Mladen Gogala <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 12/16/2003 17:19
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc: 
> Subject:Re: Good news from Oracle
> 
> 
> Raj, you proven once again that you're an invaluable source of
> good information. Let me share it with the others. The note 
> that Raj is talking about has the tfollowing title:
> 
>  ORA-600 [12235] "Oracle process has no purpose in life !"
> 
> I guess it will be accompanied by "ora-600 [x] "Look at the bright 
> side of life!"
> rather soon.
> 
> On 12/16/2003 09:54:38 AM, "Jamadagni, Rajendra" wrote:
> > check the subject heading for tech note 33174.1
> > 
> > Type:  REFERENCE 
> > Status:  PUBLISHED 
> > 
> > Howzzat?
> > 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 Message-
> > Sent: Tuesday, December 16, 2003 9:44 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Of course they are. Support and development cost them much less now that

> they've
> > outsourced it to Elbonia. The quality of the code is another matter. 
> Fortunately,
> > they have broad and wide open beta testing program so that we all know 
> what we can
> > expect. If the first relase of 10g is usable, I'll change my name to 
> ora-600.
> > 
> > 
>

**
> > This e-mail message is confidential, intended only for the named 
> recipient(s) above and may contain information that is privileged, 
> attorney work product or exempt from disclosure under applicable law. If 
> you have received this message in error, or are not the named 
> recipient(s), please immediately notify corporate MIS at (860) 766-2000 
> and delete this e-mail message from your computer, Thank you.
> > 
>

**4
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Jamadagni, Rajendra
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> > 
> 
> 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-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

Mladen Go

RE: table partitions

2003-12-16 Thread Rick Stephenson

Yes, this is what I was looking for.  I don't care about the year, and don't
want to worry about adding new partitions for every new month that comes
along each year.  This table will only needs to contain six months worth of
data.  I will not be archiving it at all.  I wanted to truncate the
data/partition after it was 6 months old.

Thanks,

Rick Stephenson


-Original Message-
Sent: Tuesday, December 16, 2003 6:49 AM
To: Multiple recipients of list ORACLE-L

>From what I understood, he's asking how to put all January records in one
partition, all Feb in another etc.
So you end up with 12 partitions for as many years as you wish. I could not
think of any other solution then the one he does not want to.

rw

> Your high value for each partition can just be the beginning of every
> month.  For example: 
> 
> CREATE TABLE ACCOUNTS
> (
>   STATEMENT_DATE DATE   NOT NULL,
>   ACCOUNT_NUMBER VARCHAR2(8)NOT NULL,
>   BILLING_CYCLE  VARCHAR2(2)NOT NULL,
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wartiak Rastislav
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to which they are addressed.
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system. If you are not the intended recipient you are
notified that disclosing, copying, forwarding or otherwise distributing or
taking any action in reliance on the contents of this information is
strictly prohibited. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rick Stephenson
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Good news from Oracle

2003-12-16 Thread Boyle, Christopher J.

Oh, smeg

-Original Message-
Sent: Tuesday, December 16, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L

Nobody expects the Spanish Inquisition! Why is that there are so
many Monty Python lovers among us oraclites? The other day, Bambi
has used the "velocity of a laden swallow" thing from the Holy Grail,
almost everybody knows Brian and some other sketches. Do we have
any lovers of the Red Dwarf and Ace Rimmer here?

On 12/16/2003 12:14:25 PM, [EMAIL PROTECTED] wrote:
> Or perhaps
>
> ora-600 [x] "I didn't expect the Spanish Inquisition !"
>
> mvg/regards
>
> Jo
>
>
>
>
>
>
> Mladen Gogala <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 12/16/2003 17:19
> Please respond to ORACLE-L
>
> 
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:
> Subject:Re: Good news from Oracle
>
>
> Raj, you proven once again that you're an invaluable source of
> good information. Let me share it with the others. The note
> that Raj is talking about has the tfollowing title:
>
>  ORA-600 [12235] "Oracle process has no purpose in life !"
>
> I guess it will be accompanied by "ora-600 [x] "Look at the bright
> side of life!"
> rather soon.
>
> On 12/16/2003 09:54:38 AM, "Jamadagni, Rajendra" wrote:
> > check the subject heading for tech note 33174.1
> >
> > Type:  REFERENCE
> > Status:  PUBLISHED
> >
> > Howzzat?
> > 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 Message-
> > Sent: Tuesday, December 16, 2003 9:44 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Of course they are. Support and development cost them much less now that
> they've
> > outsourced it to Elbonia. The quality of the code is another matter.
> Fortunately,
> > they have broad and wide open beta testing program so that we all know
> what we can
> > expect. If the first relase of 10g is usable, I'll change my name to
> ora-600.
> >
> >
> **
> > This e-mail message is confidential, intended only for the named
> recipient(s) above and may contain information that is privileged,
> attorney work product or exempt from disclosure under applicable law. If
> you have received this message in error, or are not the named
> recipient(s), please immediately notify corporate MIS at (860) 766-2000
> and delete this e-mail message from your computer, Thank you.
> >
> **4
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Jamadagni, Rajendra
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
> 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-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
  INET: [EMAIL PROT

RE: How to refresh

2003-12-16 Thread John Flack

The methodology we developed for one client goes like this:
There are three databases - dev, test, and prod.
dev starts as a clone of prod, and fixes, changes and enhancements are developed and 
unit tested there.  One of the REQUIRED products of development is a script that will 
upgrade prod to the new version.
When we are ready for complete testing of a new version of the entire application, 
test is recreated as a clone of prod.
We run the upgrade script against test.  If there are any problems, errors, missing 
stored procedures, or other missing or incorrect versions of database objects after 
running this script, the script must be corrected, and we start over with a fresh 
clone of prod.  By the way, VERY IMPORTANT: Data changes, such as new, updated or 
deleted rows in code or control tables are part of the upgrade, not just DDL changes.
Once the upgrade script has been run, test is a version beyond prod, and can be tested 
thoroughly.  If errors are found they are corrected and unit tested in DEV, not test, 
and then put into a corrected upgrade script, we may then correct test from the 
script, but testing is NOT complete until test is recreated as a clone of prod yet one 
more time, and upgraded with the script, and run through a battery of tests again.
By the time we finish testing, all we should have to do is run the upgrade script 
against prod and bring prod live in the new version.  Then we'll often recreate dev as 
a clone of prod.

-Original Message-
Sent: Tuesday, December 16, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L


I need to do a refresh of a test database using production data.  We use
import for this.  In the past we have always dropped the schemas (4 or
5), recreated the schemas, and then did a full import with ignore=n.
This time the user does not want to lose any of the new functions and
procedures that are in test, but not in prod.  Instead, they would like
to just refresh the table data.  Last time we tried this we had all
kinds of trouble with functions, triggers, constraints, etc... and ended
up doing a full import.

Is there a tried and true way to just refresh the table data without
losing anything else and without having all the problems with triggers
and constraints?

Thanks!
Ron 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Flack
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Good news from Oracle

Nobody expects the Spanish Inquisition! Why is that there are so
many Monty Python lovers among us oraclites? The other day, Bambi
has used the "velocity of a laden swallow" thing from the Holy Grail,
almost everybody knows Brian and some other sketches. Do we have
any lovers of the Red Dwarf and Ace Rimmer here?

On 12/16/2003 12:14:25 PM, [EMAIL PROTECTED] wrote:
> Or perhaps
> 
> ora-600 [x] "I didn't expect the Spanish Inquisition !"
> 
> mvg/regards
> 
> Jo
> 
> 
> 
> 
> 
> 
> Mladen Gogala <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 12/16/2003 17:19
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc: 
> Subject:Re: Good news from Oracle
> 
> 
> Raj, you proven once again that you're an invaluable source of
> good information. Let me share it with the others. The note 
> that Raj is talking about has the tfollowing title:
> 
>  ORA-600 [12235] "Oracle process has no purpose in life !"
> 
> I guess it will be accompanied by "ora-600 [x] "Look at the bright 
> side of life!"
> rather soon.
> 
> On 12/16/2003 09:54:38 AM, "Jamadagni, Rajendra" wrote:
> > check the subject heading for tech note 33174.1
> > 
> > Type:  REFERENCE 
> > Status:  PUBLISHED 
> > 
> > Howzzat?
> > 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 Message-
> > Sent: Tuesday, December 16, 2003 9:44 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Of course they are. Support and development cost them much less now that 
> they've
> > outsourced it to Elbonia. The quality of the code is another matter. 
> Fortunately,
> > they have broad and wide open beta testing program so that we all know 
> what we can
> > expect. If the first relase of 10g is usable, I'll change my name to 
> ora-600.
> > 
> > 
> **
> > This e-mail message is confidential, intended only for the named 
> recipient(s) above and may contain information that is privileged, 
> attorney work product or exempt from disclosure under applicable law. If 
> you have received this message in error, or are not the named 
> recipient(s), please immediately notify corporate MIS at (860) 766-2000 
> and delete this e-mail message from your computer, Thank you.
> > 
> **4
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Jamadagni, Rajendra
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> > 
> 
> 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-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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-538-5051 http://www

RE: Good news from Oracle

2003-12-16 Thread Whittle Jerome Contr NCI

Title: RE: Good news from Oracle







More like 

 ora-600 [x] "Spam spam spam spam. Lovely spam! Wonderful spam!"

I'm sure Jared will soon agree.

Jerry Whittle

ASIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145

-Original Message-

From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]

Or perhaps

ora-600 [x] "I didn't expect the Spanish Inquisition !"

mvg/regards

Jo


Mladen Gogala <[EMAIL PROTECTED]>

 

    To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

    cc: 

    Subject:    Re: Good news from Oracle


Raj, you proven once again that you're an invaluable source of

good information. Let me share it with the others. The note 

that Raj is talking about has the tfollowing title:

 ORA-600 [12235] "Oracle process has no purpose in life !"

I guess it will be accompanied by "ora-600 [x] "Look at the bright 

side of life!"

rather soon.

RE: Good news from Oracle

2003-12-16 Thread Pete Sharman

Mladen, you seem to be getting more warped, bitter and twisted each day!
:)

I think you need a holiday, or at least a good bottle of whiskey.  If
you contact Connor McDonald, he has a list of VERY nice scotches (up to
11,000 pounds IIRC) that you might like to pass on to someone to choose
a nice pressy to put under your Christmas tree.  :)

Pete

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA

-Original Message-
Mladen Gogala
Sent: Wednesday, December 17, 2003 3:19 AM
To: Multiple recipients of list ORACLE-L

Raj, you proven once again that you're an invaluable source of
good information. Let me share it with the others. The note 
that Raj is talking about has the tfollowing title:

ORA-600 [12235] "Oracle process has no purpose in life !"

I guess it will be accompanied by "ora-600 [x] "Look at the bright
side of life!"
rather soon.

On 12/16/2003 09:54:38 AM, "Jamadagni, Rajendra" wrote:
> check the subject heading for tech note 33174.1
> 
> Type:  REFERENCE 
> Status:  PUBLISHED 
> 
> Howzzat?
> 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 Message-
> Sent: Tuesday, December 16, 2003 9:44 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Of course they are. Support and development cost them much less now
that they've
> outsourced it to Elbonia. The quality of the code is another matter.
Fortunately,
> they have broad and wide open beta testing program so that we all know
what we can
> expect. If the first relase of 10g is usable, I'll change my name to
ora-600.
> 
>

**
> This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged,
attorney work product or exempt from disclosure under applicable law. If
you have received this message in error, or are not the named
recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank you.
>

**4
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jamadagni, Rajendra
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Sharman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Good news from Oracle

2003-12-16 Thread jo_holvoet

Or perhaps

ora-600 [x] "I didn't expect the Spanish Inquisition !"

mvg/regards

Jo

Mladen Gogala <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/16/2003 17:19
Please respond to ORACLE-L

To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: Good news from Oracle

Raj, you proven once again that you're an invaluable source of
good information. Let me share it with the others. The note 
that Raj is talking about has the tfollowing title:

 ORA-600 [12235] "Oracle process has no purpose in life !"

I guess it will be accompanied by "ora-600 [x] "Look at the bright 
side of life!"
rather soon.

On 12/16/2003 09:54:38 AM, "Jamadagni, Rajendra" wrote:
> check the subject heading for tech note 33174.1
> 
> Type:  REFERENCE 
> Status:  PUBLISHED 
> 
> Howzzat?
> 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 Message-
> Sent: Tuesday, December 16, 2003 9:44 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Of course they are. Support and development cost them much less now that 
they've
> outsourced it to Elbonia. The quality of the code is another matter. 
Fortunately,
> they have broad and wide open beta testing program so that we all know 
what we can
> expect. If the first relase of 10g is usable, I'll change my name to 
ora-600.
> 
> 
**
> This e-mail message is confidential, intended only for the named 
recipient(s) above and may contain information that is privileged, 
attorney work product or exempt from disclosure under applicable law. If 
you have received this message in error, or are not the named 
recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
> 
**4
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jamadagni, Rajendra
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

817 for aix5l

2003-12-16 Thread zhu chao

Re: RedHat Advanced Server v3.0, anyone?


No, no lawsuit.

Just receiving threatening correspondence from an attorney was enough to ruin my day.

Jared








"Eric King" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 12/15/2003 03:49 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: RedHat Advanced Server v3.0, anyone?


Do you mean Oracle attorney actually sued you before???
- Original Message - 
From: [EMAIL PROTECTED] 
To: Multiple recipients of list ORACLE-L 
Sent: Monday, December 15, 2003 18:34
Subject: RE: RedHat Advanced Server v3.0, anyone?


MetaLink is an official Oracle support mechanism for paid subscribers. 

Please be careful about cutting and pasting documentation from MetaLink 
into a mailing list.  Quoting parts of a MetaLink document may be OK. 

Please do not quote entire articles, and *especially* do not cut and paste 
forum articles, partiularly with the names of the of posters. 

I haven't been contacted by an Oracle attorney in a while now, and am 
looking forward to mantaining the status quo. 


Jared ( List Owner) 






"Juan Miranda" <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED] 
 12/15/2003 01:44 AM 
 Please respond to ORACLE-L 
        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
        cc:         
        Subject:        RE: RedHat Advanced Server v3.0, anyone?



  
I have a system with RH AS 2.1 in production and is very very fast and reliable. 
The server is a Proliant with 8GB RAM and 2x Intel Xeon. 
Oracle installation was easy, only take care if you have big memory. 
Also remenber to update the kernel. The predetermined don´t let start database. 
  
I tried RH AS 3 and Oracle installation and there are a lot of problems. 
It´s nearly almost essential to read this http://www.puschitz.com/InstallingOracle9i.shtml. 
  
Anyway I think RH is a good S.O. 
  
Look at Metalink: 
  
Unix Installation/OS: RDBMS Technical Forum 







Displayed below are the messages of the selected thread. 
Thread Status: Active 
From: ..

RDBMS Version: 9.2.0.1.0
Operating System and Version: Red Hat Enterprise Linux 3.0 ES
Error Number (if applicable): 
Product (i.e. SQL*Loader, Import, etc.): 
Product Version: 

. 



De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Paul Drake
Enviado el: viernes, 12 de diciembre de 2003 23:24
Para: Multiple recipients of list ORACLE-L
Asunto: RedHat Advanced Server v3.0, anyone?
Has anyone kicked the tires on RH AS 3.0? 
There is a strong possibility that in a migration early next year, that a client wants to move off of MS w2k adv svr and onto either RH AS or SLES (they are an HP (compaq) shop). 
It seems like a bad idea to start them off on RH AS 2.1 now, when they likely won't take the system into production until after close of the first quarter. 
thanks, 
Paul 

Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing

RE: How to refresh

2003-12-16 Thread Odland, Brad

If the developers have code in dev they should have DDLs that generate the
triggers and changes. I hate it whenDevelopers think they can get away with
telling some else to own thier code...Database CODE in my mind always
includes the scripts to generate the object in addition to the funtioning
body of the code. If they don't then crack the whip and whip those fellows
into shape. They shouldn't be just generating changes without code to effect
the changesheesh...

If they refuse to do thier job correctly then why not run OEM's change
management db compare bewteen prod and dev to generate the  object changes
in a script that you can run after the produciton import.


THough you are opening yourself up to being reponsible for code you didn't
write.

Brad

-Original Message-
Sent: Tuesday, December 16, 2003 8:55 AM
To: Multiple recipients of list ORACLE-L


I need to do a refresh of a test database using production data.  We use
import for this.  In the past we have always dropped the schemas (4 or
5), recreated the schemas, and then did a full import with ignore=n.
This time the user does not want to lose any of the new functions and
procedures that are in test, but not in prod.  Instead, they would like
to just refresh the table data.  Last time we tried this we had all
kinds of trouble with functions, triggers, constraints, etc... and ended
up doing a full import.

Is there a tried and true way to just refresh the table data without
losing anything else and without having all the problems with triggers
and constraints?

Thanks!
Ron 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Odland, Brad
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to refresh

2003-12-16 Thread Ramón Estevez

I do that every night, but I drop the user to be refresh in the test db, 
is not a big DB.

Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994

-Original Message-
Sent: Tuesday, December 16, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L

Hi Ron,

For just testdata you might take a look at http://www.databee.com/main.htm, 
this can help you.
Dennis' method will work, but doesn't answer your question, because a 
production copy will overwrite all new functionality as well. However, his 
suggestion isn't as bad as it might seem on a first sight. How is the 
user/developer gonig to install all new functionality/triggers/functions 
etc? He might wan't to test his installation procedures as well,  and 
otherwise you might want him to.

So, wrap up all the new functionality in neat installations scripts, take a 
copy of the production database and start testing the installation scripts. 
It's the only way to be sure that what's tested in your test databaes will 
actually get installed in your production database.

At 06:54 16-12-03 -0800, you wrote:
>I need to do a refresh of a test database using production data.  We 
>use import for this.  In the past we have always dropped the schemas (4 
>or 5), recreated the schemas, and then did a full import with ignore=n. 
>This time the user does not want to lose any of the new functions and 
>procedures that are in test, but not in prod.  Instead, they would like 
>to just refresh the table data.  Last time we tried this we had all 
>kinds of trouble with functions, triggers, constraints, etc... and 
>ended up doing a full import.
>
>Is there a tried and true way to just refresh the table data without 
>losing anything else and without having all the problems with triggers 
>and constraints?

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok) ===  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Carel-Jan Engel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 
include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 
removed from).  You may also send the HELP command for other information (like 
subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?Q?Ram=F3n_Estevez?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: OffTopic : sed : Alternate (2,4,6..) replacement

It will replace colons with blank and display "$A:that Junk" on
even number of iterations.
which is used to evaluate the if condition.
On 12/16/2003 11:04:31 AM, [EMAIL PROTECTED] wrote:
> 
> Will this work?
> 
> --
> #!/usr/bin/ksh
> THINGY=0
> cat swt | sed 's/:/ /' | while read A B JUNK; do
> 
>if [ $THINGY -eq 1 ]; then
>   B="that"
>   THINGY=0
>else
>   THINGY=1
>fi
>echo "$A:$B $JUNK"
> 
> done
> --
> 
> You can set up a similar loop in awk too.
> The sed 's/:/ /' changes the colon to a space so that the read A B JUNK will
> work.
> 
> > -Original Message-
> > 
> > Hi List
> > I need some help on this;
> > How do i replace the 2nd,4th,6th occurances of a column 
> > (vertical) in a
> > file.
> > I know sed does it within a row
> > 
> > $ cat swt
> > 01:this is a file1 this
> > 02:this is a file1 this
> > 03:this is line3 
> > 04:this is line4
> > 
> > $ sed 's/this/that/2' swt
> > 01:this is a file1 that
> > 02:this is a file1 that
> > 03:this is line3 
> > 04:this is line4
> > $ sed 's/this/that/1' swt
> > 01:that is a file1 this
> > 02:that is a file1 this
> > 03:that is line3 
> > 04:that is line4
> > 
> > But i want 
> > 01:this is a file1 this
> > 02:that is a file1 this
> > 03:this is line3 
> > 04:that is line4
> > 
> > I tried awk but awk seems to be going one line at a time.
> > 
> > Thanks in Advance.
> > 
> > GovindanK
> > 
> > -- 
> > http://www.fastmail.fm - The professional email service
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: GovindanK
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> > 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: <[EMAIL PROTECTED]
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Good news from Oracle

Whoops  somehow one line got snipped by listguru ...

S_u_b_j_e_c_t:  ORA-600 [12235] "Oracle process has no purpose in life !" ... really?

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 Message-
Sent: Tuesday, December 16, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L


check the subject heading for tech note 33174.1

Type:  REFERENCE 
Status:  PUBLISHED 

Howzzat?
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 !


**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**5
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Good news from Oracle

Raj, you proven once again that you're an invaluable source of
good information. Let me share it with the others. The note 
that Raj is talking about has the tfollowing title:

ORA-600 [12235] "Oracle process has no purpose in life !"

I guess it will be accompanied by "ora-600 [x] "Look at the bright side of life!"
rather soon.

On 12/16/2003 09:54:38 AM, "Jamadagni, Rajendra" wrote:
> check the subject heading for tech note 33174.1
> 
> Type:  REFERENCE 
> Status:  PUBLISHED 
> 
> Howzzat?
> 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 Message-
> Sent: Tuesday, December 16, 2003 9:44 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Of course they are. Support and development cost them much less now that they've
> outsourced it to Elbonia. The quality of the code is another matter. Fortunately,
> they have broad and wide open beta testing program so that we all know what we can
> expect. If the first relase of 10g is usable, I'll change my name to ora-600.
> 
> **
> This e-mail message is confidential, intended only for the named recipient(s) above 
> and may contain information that is privileged, attorney work product or exempt from 
> disclosure under applicable law. If you have received this message in error, or are 
> not the named recipient(s), please immediately notify corporate MIS at (860) 
> 766-2000 and delete this e-mail message from your computer, Thank you.
> **4
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jamadagni, Rajendra
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to refresh

Thanks!  I'll try it.

Ron

-Original Message-
Sent: Tuesday, December 16, 2003 9:44 AM
To: Multiple recipients of list ORACLE-L


Here is a sample of the script I run to disable FK constraints:

declare lTables DBMS_SQL.VARCHAR2_TABLE;
lConstraints DBMS_SQL.VARCHAR2_TABLE;
nJ BINARY_INTEGER;
BEGIN
SELECT table_name, constraint_name
  BULK COLLECT INTO lTables, lConstraints
  FROM user_constraints
  WHERE owner = 'IPN_DBA'
AND constraint_type = 'R';
FOR nJ IN 1..lTables.COUNT LOOP
DBMS_OUTPUT.PUT_LINE(lTables(nJ) || ': ' || lConstraints(nJ)); --
just for logging
EXECUTE IMMEDIATE 'ALTER TABLE ' || lTables(nJ) || ' MODIFY
CONSTRAINT ' || lConstraints(nJ) || ' DISABLE'; END LOOP; END; /

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Smith, Ron L.
Sent: Tuesday, December 16, 2003 10:25 AM
To: Multiple recipients of list ORACLE-L

Seems like last time I tried to disable constraints Oracle complained
and wouldn't let me due to dependant objects or something.

Ron

-Original Message-
Sent: Tuesday, December 16, 2003 9:15 AM
To: Multiple recipients of list ORACLE-L


You can always disable triggers and constraints in existing schema
before running import (and then, enable them after import is done).
Also, specify "CONSTRAINTS=N" and "TRIGGERS=N" when exporting.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Smith, Ron L.
Sent: Tuesday, December 16, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L

I need to do a refresh of a test database using production data.  We use
import for this.  In the past we have always dropped the schemas (4 or
5), recreated the schemas, and then did a full import with ignore=n.
This time the user does not want to lose any of the new functions and
procedures that are in test, but not in prod.  Instead, they would like
to just refresh the table data.  Last time we tried this we had all
kinds of trouble with functions, triggers, constraints, etc... and ended
up doing a full import.

Is there a tried and true way to just refresh the table data without
losing anything else and without having all the problems with triggers
and constraints?

Thanks!
Ron 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, Calif

RE: OffTopic : sed : Alternate (2,4,6..) replacement

2003-12-16 Thread Stephen.Lee


Will this work?

--
#!/usr/bin/ksh
THINGY=0
cat swt | sed 's/:/ /' | while read A B JUNK; do

   if [ $THINGY -eq 1 ]; then
  B="that"
  THINGY=0
   else
  THINGY=1
   fi
   echo "$A:$B $JUNK"

done
--

You can set up a similar loop in awk too.
The sed 's/:/ /' changes the colon to a space so that the read A B JUNK will
work.

> -Original Message-
> 
> Hi List
> I need some help on this;
> How do i replace the 2nd,4th,6th occurances of a column 
> (vertical) in a
> file.
> I know sed does it within a row
> 
> $ cat swt
> 01:this is a file1 this
> 02:this is a file1 this
> 03:this is line3 
> 04:this is line4
> 
> $ sed 's/this/that/2' swt
> 01:this is a file1 that
> 02:this is a file1 that
> 03:this is line3 
> 04:this is line4
> $ sed 's/this/that/1' swt
> 01:that is a file1 this
> 02:that is a file1 this
> 03:that is line3 
> 04:that is line4
> 
> But i want 
> 01:this is a file1 this
> 02:that is a file1 this
> 03:this is line3 
> 04:that is line4
> 
> I tried awk but awk seems to be going one line at a time.
> 
> Thanks in Advance.
> 
> GovindanK
> 
> -- 
> http://www.fastmail.fm - The professional email service
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: GovindanK
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 8i pl/sql question

2003-12-16 Thread Guang Mei

Below is the code for myfunction1 in the package, It calls a bunch of other
functions, such as getBlastMatches, escapeGene, genes.gene2protein and
addItem.

Guang

---

type blastMatch is record (
  geneName  gene.name%type,
  percent   number
);

function myfunction1 (seqid in number,
   sid in number,
   secondsid in number default -1) return varchar2 is
  tbl   blastMatches;
  cnt   number;
  item  varchar2(256);
  str   varchar2(256);
begin
  cnt := getBlastMatches(seqid, sid, tbl, secondsid);
  if cnt<1 then return null; end if;

  for i in 1..cnt loop
item := escapeGene(sid, tbl(i).geneName,
   genes.gene2protein(tbl(i).geneName, sid)) || ' ('
  || tbl(i).percent || '%)';
if not addItem(str, item, '; ', 80) then exit; end if;
  end loop;
  return str;
exception
  when others then return null;
end myfunction1;

--
function getBlastMatches (seqid in number,
  spid in number,
  matchTable out blastMatches,
  secondspid in number default -1) return number is
  cursor bcur is
select  queryid, subjid, 100.0*identity/matchlen pct
  from  blastresults
 where  ((subjspid in (spid,secondspid) and queryid = seqid) or
(queryspid in (spid,secondspid) and subjid = seqid)) and
(identity/matchlen >= .200 or positive/matchlen >= .400)
 order  by blast.pvalToNumber(pval) asc, score desc;
  match number;
  cnt   number := 0;
  gname gene.name%type;

begin

  for bmatch in bcur loop
if bmatch.queryid=seqid then match := bmatch.subjid;
else match := bmatch.queryid; end if;

BEGIN
  select name into gname from gene,seqtable
where geneid=gene.id and aaseqid = match and
gene.use = 'Y' and seqtable.use='Y';
EXCEPTION
  when no_data_Found then gname := NULL;
END;

if gname is not null then
  cnt := cnt + 1;

  matchTable(cnt).geneName := gname;
  matchTable(cnt).percent := round(bmatch.pct, 0);

  if cnt = maxMatches then return cnt; end if;
end if;

  end loop;

  return cnt;
exception
  when others then return 0;
end getBlastMatches;


-Original Message-
Jamadagni, Rajendra
Sent: Tuesday, December 16, 2003 10:45 AM
To: Multiple recipients of list ORACLE-L


what does myfunction1() do?

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 Message-
Sent: Tuesday, December 16, 2003 10:24 AM
To: Multiple recipients of list ORACLE-L


The first argumant (myID) is a variable that is different every time the
function gets called. The second argument is a hard code number (just as in
my orginal message). So I guess I could not use DETERMINISTIC here. I have
not heard of DETERMINISTIC before but I will take a look of this becuase it
probably can be used at a couple of places if it works as you described.
Thanks.

Guang

-Original Message-
John Flack
Sent: Tuesday, December 16, 2003 8:44 AM
To: Multiple recipients of list ORACLE-L


Does myFunction1 often get called with the same arguments?  In your example,
the second argument is never repeated, but in the real thing, would the same
second argument be likely to repeat?  If myFunction1 gets the same
arguments, will it always return the same value?  If so, then it is a
deterministic function, and you can declare it as one by putting the keyword
DETERMINISTIC before the IS/AS in its header.  This way the optimiser will
know not to recalculate the function if it is called again with the same
arguments, but will reuse the value it calculated before.

-Original Message-
Sent: Monday, December 15, 2003 7:54 PM
To: Multiple recipients of list ORACLE-L


can you return multiple values from a modified version of myfunction(1) ??
If so, then you can replace multiple calls by only one. And no, bulk binds
is only within dml/select statements.

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 Message-
Sent: Monday, December 15, 2003 4:34 PM
To: Multiple recipients of list ORACLE-L


Hi:

Oracle 8173 DB.

I have a package funtion, part of it is doing something like this:

  utl_file.put_line(fpn,  myFunction1(myID, 1));
  utl_file.put_line(fpn,  myFunction1(myID, 8));
  utl_file.put_line(fpn,  myFunction1(myID, 6));
  utl_file.put_line(fpn,  myFunction1(myID, 35));
  utl_file.put_line(fpn,  myFunction1(myID, 33));
  utl_file.put_line(fpn,  myFunction1(myID, 7));
  utl_file.put_line(fpn,  myFunction1(myID, 102));
  utl_file.put_line(fpn,

Re: How to refresh

2003-12-16 Thread Carel-Jan Engel

Hi Ron,

For just testdata you might take a look at http://www.databee.com/main.htm, 
this can help you.
Dennis' method will work, but doesn't answer your question, because a 
production copy will overwrite all new functionality as well. However, his 
suggestion isn't as bad as it might seem on a first sight. How is the 
user/developer gonig to install all new functionality/triggers/functions 
etc? He might wan't to test his installation procedures as well,  and 
otherwise you might want him to.

So, wrap up all the new functionality in neat installations scripts, take a 
copy of the production database and start testing the installation scripts. 
It's the only way to be sure that what's tested in your test databaes will 
actually get installed in your production database.

At 06:54 16-12-03 -0800, you wrote:
I need to do a refresh of a test database using production data.  We use
import for this.  In the past we have always dropped the schemas (4 or
5), recreated the schemas, and then did a full import with ignore=n.
This time the user does not want to lose any of the new functions and
procedures that are in test, but not in prod.  Instead, they would like
to just refresh the table data.  Last time we tried this we had all
kinds of trouble with functions, triggers, constraints, etc... and ended
up doing a full import.
Is there a tried and true way to just refresh the table data without
losing anything else and without having all the problems with triggers
and constraints?
Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok)
===  

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Carel-Jan Engel
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: rebuilding indexes - sure to cause a ruckus

2003-12-16 Thread Adams, Matthew (GECP, MABG, 088130)

Title: RE: rebuilding indexes - sure to cause a ruckus





My brother (the NASA rocket scientist) usually 
says something like 


' "Hey, this is all quite easy, it sure ain't raising kids"


Matt



Matt Adams - GE Appliances - [EMAIL PROTECTED]
Their fundamental design flaws are completely
hidden by their superficial design flaws.
  - Douglas Adams


-Original Message-
From: Richard Foote [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 10, 2003 5:40 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: rebuilding indexes - sure to cause a ruckus



Hi Yong,


One thing I should have mentioned when I posted my "epic" is that it not
only attempts to correct the numerous technical errors in the article but
also attempts to answer the various questions the article raises but totally
fails to address. What I find most astonishing about the article is that the
author confesses at the conclusion he has no idea when and why an index
rebuild is beneficial. And as the author doesn't know, then surely it must
all be so difficult, a "scientific-less phenomenon".


If I can convince anyone who makes it through my email that this isn't
rocket science, then it's been worth the bandwidth.


BTW, does anyone know what a rocket scientist refers to when they say "Hey,
this is all quite easy, it sure ain't ?" ?


Cheers ;)


Richard


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 10, 2003 5:44 AM



> Thanks, Richard. I'll read your long message more carefully later. I like
your
> statement that rebuilding an index or not is not rocket science. One needs
to
> measure the performance before and after the rebuild and make a conclusion
> himself. Many times we discuss performance issues and get very technical
and
> sophisticated, without showing experimental results! Having been a science
> researcher before, I'd like to emphasize that facts speak louder than
theories.
> There may be 10,000 24x7 databases in the world that don't easily allow
even
> testing an index rebuild. But there may be 100 times more production
databases
> in the world that are not 24x7. The individual DBA needs to do his control
> study and conclude, using experts' opinions as reference.
>
> Yong Huang
>
>
>
> __
> Do you Yahoo!?
> New Yahoo! Photos - easier uploading and sharing.
> http://photos.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Yong Huang
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California    -- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Foote
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 8i pl/sql question

what does myfunction1() do?

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 Message-
Sent: Tuesday, December 16, 2003 10:24 AM
To: Multiple recipients of list ORACLE-L


The first argumant (myID) is a variable that is different every time the
function gets called. The second argument is a hard code number (just as in
my orginal message). So I guess I could not use DETERMINISTIC here. I have
not heard of DETERMINISTIC before but I will take a look of this becuase it
probably can be used at a couple of places if it works as you described.
Thanks.

Guang

-Original Message-
John Flack
Sent: Tuesday, December 16, 2003 8:44 AM
To: Multiple recipients of list ORACLE-L


Does myFunction1 often get called with the same arguments?  In your example,
the second argument is never repeated, but in the real thing, would the same
second argument be likely to repeat?  If myFunction1 gets the same
arguments, will it always return the same value?  If so, then it is a
deterministic function, and you can declare it as one by putting the keyword
DETERMINISTIC before the IS/AS in its header.  This way the optimiser will
know not to recalculate the function if it is called again with the same
arguments, but will reuse the value it calculated before.

-Original Message-
Sent: Monday, December 15, 2003 7:54 PM
To: Multiple recipients of list ORACLE-L


can you return multiple values from a modified version of myfunction(1) ??
If so, then you can replace multiple calls by only one. And no, bulk binds
is only within dml/select statements.

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 Message-
Sent: Monday, December 15, 2003 4:34 PM
To: Multiple recipients of list ORACLE-L


Hi:

Oracle 8173 DB.

I have a package funtion, part of it is doing something like this:

  utl_file.put_line(fpn,  myFunction1(myID, 1));
  utl_file.put_line(fpn,  myFunction1(myID, 8));
  utl_file.put_line(fpn,  myFunction1(myID, 6));
  utl_file.put_line(fpn,  myFunction1(myID, 35));
  utl_file.put_line(fpn,  myFunction1(myID, 33));
  utl_file.put_line(fpn,  myFunction1(myID, 7));
  utl_file.put_line(fpn,  myFunction1(myID, 102));
  utl_file.put_line(fpn,  myFunction1(myID, 10));
  utl_file.put_line(fpn,  myFunction1(myID, 9));
  utl_file.put_line(fpn,  myFunction1(myID, 15));
  utl_file.put_line(fpn,  myFunction1(myID, 2));

myFunction1 (returns a varchar2 string) here is another function in the same
package and
it calls a bunch of other functions.

Is there a way to speed up the performance of the above lines by using "bulk
bind"?
I am brain-dead now and can not seem to find if it can be done and/or how it
can be done.

TIA.

Guang

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**5
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to refresh

2003-12-16 Thread Igor Neyman

Here is a sample of the script I run to disable FK constraints:

declare lTables DBMS_SQL.VARCHAR2_TABLE;
lConstraints DBMS_SQL.VARCHAR2_TABLE;
nJ BINARY_INTEGER;
BEGIN
SELECT table_name, constraint_name
  BULK COLLECT INTO lTables, lConstraints
  FROM user_constraints
  WHERE owner = 'IPN_DBA'
AND constraint_type = 'R';
FOR nJ IN 1..lTables.COUNT LOOP
DBMS_OUTPUT.PUT_LINE(lTables(nJ) || ': ' || lConstraints(nJ)); --
just for logging
EXECUTE IMMEDIATE 'ALTER TABLE ' || lTables(nJ) || ' MODIFY
CONSTRAINT ' || lConstraints(nJ) || ' DISABLE';
END LOOP;
END;
/

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Smith, Ron L.
Sent: Tuesday, December 16, 2003 10:25 AM
To: Multiple recipients of list ORACLE-L

Seems like last time I tried to disable constraints Oracle complained
and wouldn't let me due to dependant objects or something.

Ron

-Original Message-
Sent: Tuesday, December 16, 2003 9:15 AM
To: Multiple recipients of list ORACLE-L


You can always disable triggers and constraints in existing schema
before running import (and then, enable them after import is done).
Also, specify "CONSTRAINTS=N" and "TRIGGERS=N" when exporting.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Smith, Ron L.
Sent: Tuesday, December 16, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L

I need to do a refresh of a test database using production data.  We use
import for this.  In the past we have always dropped the schemas (4 or
5), recreated the schemas, and then did a full import with ignore=n.
This time the user does not want to lose any of the new functions and
procedures that are in test, but not in prod.  Instead, they would like
to just refresh the table data.  Last time we tried this we had all
kinds of trouble with functions, triggers, constraints, etc... and ended
up doing a full import.

Is there a tried and true way to just refresh the table data without
losing anything else and without having all the problems with triggers
and constraints?

Thanks!
Ron 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to refresh

2003-12-16 Thread Mercadante, Thomas F

Ron,

here's an ugly way to do this:

Empty your TEST database of data.  Drop constraints & Indexes.
Perform and export of the TEST database with ROWS=N - this will export all
Functions, packages and procedures.
Import data from production.
Import the stuff from step 2 above.  This should overlay all functions,
packages and procedures from production.

Like I said, this is uuugggly.  I like Dennis's suggestions - force them to
keep scripts of their functions and have them reload them once your refresh
the database.

One other option is to empty your database, drop indexes and constraints,
and bring data one table at a time using insert into table as select * from
[EMAIL PROTECTED]  Then apply constraints and indexes.  I would attempt
this approach before the ugly approach above.

good Luck


Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, December 16, 2003 10:14 AM
To: Multiple recipients of list ORACLE-L


Like I said.  There are new packages, procedures, functions, etc... in
TEST that we do not want to lose.

Ron

-Original Message-
Sent: Tuesday, December 16, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L


Ron - You should consider refreshing the instance by cloning your
production database. This way you get an exact replica in all respects,
and you can test your backup as a bonus. If you are interested in this
method, tell us how you backup your production database.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, December 16, 2003 8:55 AM
To: Multiple recipients of list ORACLE-L


I need to do a refresh of a test database using production data.  We use
import for this.  In the past we have always dropped the schemas (4 or
5), recreated the schemas, and then did a full import with ignore=n.
This time the user does not want to lose any of the new functions and
procedures that are in test, but not in prod.  Instead, they would like
to just refresh the table data.  Last time we tried this we had all
kinds of trouble with functions, triggers, constraints, etc... and ended
up doing a full import.

Is there a tried and true way to just refresh the table data without
losing anything else and without having all the problems with triggers
and constraints?

Thanks!
Ron 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How to refresh

2003-12-16 Thread Carel-Jan Engel

Hi Ron,

For just testdata you might take a look at http://www.databee.com/main.htm, 
this can help you.
Dennis' method will work, but doesn't answer your question, because a 
production copy will overwrite all new functionality as well. However, his 
suggestion isn't as bad as it might seem on a first sight. How is the 
user/developer gonig to install all new functionality/triggers/functions 
etc? He might wan't to test his installation procedures as well,  and 
otherwise you might want him to.

So, wrap up all the new functionality in neat installations scripts, take a 
copy of the production database and start testing the installation scripts. 
It's the only way to be sure that what's tested in your test databaes will 
actually get installed in your production database.

At 06:54 16-12-03 -0800, you wrote:
I need to do a refresh of a test database using production data.  We use
import for this.  In the past we have always dropped the schemas (4 or
5), recreated the schemas, and then did a full import with ignore=n.
This time the user does not want to lose any of the new functions and
procedures that are in test, but not in prod.  Instead, they would like
to just refresh the table data.  Last time we tried this we had all
kinds of trouble with functions, triggers, constraints, etc... and ended
up doing a full import.
Is there a tried and true way to just refresh the table data without
losing anything else and without having all the problems with triggers
and constraints?
Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok)
=== 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Carel-Jan Engel
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How to refresh

What are "all the problems with triggers and constraints"? If you're talking
about unique/primary/foreign keys, disable constraints and those pesky things
that protect the integrity of your data will no longer be in your way. Of course,
you will not know whether your data is inconsistent or not, but what we don't know
doesn't hurt us. Isn't that an old platitude?
If you want to move some data from one database to another, it helps if you have
some mechanisms to help, like "DATE_CREATED" and "USER_CREATED" columns in each of
your database tables. What you're really talking about is called "snapshot based
replication". You will, however, need some programming to load the data back into 
the base tables. Let me recommend excellent works of Randall Schwartz, Tom 
Christiansen,
Larry Wall,Sriram Srinivasan, Damian Conway, Tim Bunce and Aligator Descartes. They
have written books that can show The Only Right Way (TM) of programming.

On 12/16/2003 09:54:48 AM, "Smith, Ron L." wrote:
> I need to do a refresh of a test database using production data.  We use
> import for this.  In the past we have always dropped the schemas (4 or
> 5), recreated the schemas, and then did a full import with ignore=n.
> This time the user does not want to lose any of the new functions and
> procedures that are in test, but not in prod.  Instead, they would like
> to just refresh the table data.  Last time we tried this we had all
> kinds of trouble with functions, triggers, constraints, etc... and ended
> up doing a full import.
> 
> Is there a tried and true way to just refresh the table data without
> losing anything else and without having all the problems with triggers
> and constraints?
> 
> Thanks!
> Ron 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to refresh

Seems like last time I tried to disable constraints Oracle complained
and wouldn't let me due to dependant objects or something.

Ron

-Original Message-
Sent: Tuesday, December 16, 2003 9:15 AM
To: Multiple recipients of list ORACLE-L


You can always disable triggers and constraints in existing schema
before running import (and then, enable them after import is done).
Also, specify "CONSTRAINTS=N" and "TRIGGERS=N" when exporting.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Smith, Ron L.
Sent: Tuesday, December 16, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L

I need to do a refresh of a test database using production data.  We use
import for this.  In the past we have always dropped the schemas (4 or
5), recreated the schemas, and then did a full import with ignore=n.
This time the user does not want to lose any of the new functions and
procedures that are in test, but not in prod.  Instead, they would like
to just refresh the table data.  Last time we tried this we had all
kinds of trouble with functions, triggers, constraints, etc... and ended
up doing a full import.

Is there a tried and true way to just refresh the table data without
losing anything else and without having all the problems with triggers
and constraints?

Thanks!
Ron 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 8i pl/sql question

2003-12-16 Thread Guang Mei

The first argumant (myID) is a variable that is different every time the
function gets called. The second argument is a hard code number (just as in
my orginal message). So I guess I could not use DETERMINISTIC here. I have
not heard of DETERMINISTIC before but I will take a look of this becuase it
probably can be used at a couple of places if it works as you described.
Thanks.

Guang

-Original Message-
John Flack
Sent: Tuesday, December 16, 2003 8:44 AM
To: Multiple recipients of list ORACLE-L


Does myFunction1 often get called with the same arguments?  In your example,
the second argument is never repeated, but in the real thing, would the same
second argument be likely to repeat?  If myFunction1 gets the same
arguments, will it always return the same value?  If so, then it is a
deterministic function, and you can declare it as one by putting the keyword
DETERMINISTIC before the IS/AS in its header.  This way the optimiser will
know not to recalculate the function if it is called again with the same
arguments, but will reuse the value it calculated before.

-Original Message-
Sent: Monday, December 15, 2003 7:54 PM
To: Multiple recipients of list ORACLE-L


can you return multiple values from a modified version of myfunction(1) ??
If so, then you can replace multiple calls by only one. And no, bulk binds
is only within dml/select statements.

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 Message-
Sent: Monday, December 15, 2003 4:34 PM
To: Multiple recipients of list ORACLE-L


Hi:

Oracle 8173 DB.

I have a package funtion, part of it is doing something like this:

  utl_file.put_line(fpn,  myFunction1(myID, 1));
  utl_file.put_line(fpn,  myFunction1(myID, 8));
  utl_file.put_line(fpn,  myFunction1(myID, 6));
  utl_file.put_line(fpn,  myFunction1(myID, 35));
  utl_file.put_line(fpn,  myFunction1(myID, 33));
  utl_file.put_line(fpn,  myFunction1(myID, 7));
  utl_file.put_line(fpn,  myFunction1(myID, 102));
  utl_file.put_line(fpn,  myFunction1(myID, 10));
  utl_file.put_line(fpn,  myFunction1(myID, 9));
  utl_file.put_line(fpn,  myFunction1(myID, 15));
  utl_file.put_line(fpn,  myFunction1(myID, 2));

myFunction1 (returns a varchar2 string) here is another function in the same
package and
it calls a bunch of other functions.

Is there a way to speed up the performance of the above lines by using "bulk
bind"?
I am brain-dead now and can not seem to find if it can be done and/or how it
can be done.

TIA.

Guang

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to refresh

2003-12-16 Thread Igor Neyman

You can always disable triggers and constraints in existing schema
before running import (and then, enable them after import is done).
Also, specify "CONSTRAINTS=N" and "TRIGGERS=N" when exporting.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Smith, Ron L.
Sent: Tuesday, December 16, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L

I need to do a refresh of a test database using production data.  We use
import for this.  In the past we have always dropped the schemas (4 or
5), recreated the schemas, and then did a full import with ignore=n.
This time the user does not want to lose any of the new functions and
procedures that are in test, but not in prod.  Instead, they would like
to just refresh the table data.  Last time we tried this we had all
kinds of trouble with functions, triggers, constraints, etc... and ended
up doing a full import.

Is there a tried and true way to just refresh the table data without
losing anything else and without having all the problems with triggers
and constraints?

Thanks!
Ron 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to refresh

2003-12-16 Thread Pandian, Thiru

For this kind of situation I do normally like this 
Store all table names in single file. 

Exp constraints=n triggers=n indexes=n tables=`cat tables.lst`
file=table_data.dmp grants=n 

Import the full file or by  fromuser, touser option. 


-Original Message-
Sent: Tuesday, December 16, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L


I need to do a refresh of a test database using production data.  We use
import for this.  In the past we have always dropped the schemas (4 or
5), recreated the schemas, and then did a full import with ignore=n.
This time the user does not want to lose any of the new functions and
procedures that are in test, but not in prod.  Instead, they would like
to just refresh the table data.  Last time we tried this we had all
kinds of trouble with functions, triggers, constraints, etc... and ended
up doing a full import.

Is there a tried and true way to just refresh the table data without
losing anything else and without having all the problems with triggers
and constraints?

Thanks!
Ron 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pandian, Thiru
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to refresh

Like I said.  There are new packages, procedures, functions, etc... in
TEST that we do not want to lose.

Ron

-Original Message-
Sent: Tuesday, December 16, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L


Ron - You should consider refreshing the instance by cloning your
production database. This way you get an exact replica in all respects,
and you can test your backup as a bonus. If you are interested in this
method, tell us how you backup your production database.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, December 16, 2003 8:55 AM
To: Multiple recipients of list ORACLE-L


I need to do a refresh of a test database using production data.  We use
import for this.  In the past we have always dropped the schemas (4 or
5), recreated the schemas, and then did a full import with ignore=n.
This time the user does not want to lose any of the new functions and
procedures that are in test, but not in prod.  Instead, they would like
to just refresh the table data.  Last time we tried this we had all
kinds of trouble with functions, triggers, constraints, etc... and ended
up doing a full import.

Is there a tried and true way to just refresh the table data without
losing anything else and without having all the problems with triggers
and constraints?

Thanks!
Ron 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to refresh

Ron,

Of course, your milage may vary, but this is what I do:

1.)  exp [EMAIL PROTECTED] file=prod_data_exp.dmp 
owner=list,of,comma,separated,schemas direct=y
2.)  connect to test_db.
3.)  Disable all constraints.  When you script this, make sure you order it so that 
referential constraints 
get disabled before PK/UK.
4.)  truncate all tables.
5.)  imp [EMAIL PROTECTED] file=prod_data_exp.dmp direct=y full=y ignore=y
 (Optionally, you could use fromuser/touser if the usernames change between 
instances.)

Hope that helps,

-Mark

-Original Message-
Sent: Tuesday, December 16, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L


I need to do a refresh of a test database using production data.  We use
import for this.  In the past we have always dropped the schemas (4 or
5), recreated the schemas, and then did a full import with ignore=n.
This time the user does not want to lose any of the new functions and
procedures that are in test, but not in prod.  Instead, they would like
to just refresh the table data.  Last time we tried this we had all
kinds of trouble with functions, triggers, constraints, etc... and ended
up doing a full import.

Is there a tried and true way to just refresh the table data without
losing anything else and without having all the problems with triggers
and constraints?

Thanks!
Ron 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bobak, Mark
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to refresh

Ron - As far as losing the new functions, this is one reason we've moved to
a 3-instance layout. Production, staging, and test. This takes off a lot of
the pressure for overwriting test as you describe. Other than that, it
becomes a matter of negotiation. Describe what your options are, and let
them decide which option they choose. Also suggest that everything in test
(except maybe data changes users have made) should be based on scripts. If
they've created functions, they should have scripts to recreate those
because that is what they are eventually going to have to do in production
(or in staging, if you implement that).

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, December 16, 2003 8:59 AM
To: '[EMAIL PROTECTED]'


Ron - You should consider refreshing the instance by cloning your production
database. This way you get an exact replica in all respects, and you can
test your backup as a bonus. If you are interested in this method, tell us
how you backup your production database.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, December 16, 2003 8:55 AM
To: Multiple recipients of list ORACLE-L


I need to do a refresh of a test database using production data.  We use
import for this.  In the past we have always dropped the schemas (4 or
5), recreated the schemas, and then did a full import with ignore=n.
This time the user does not want to lose any of the new functions and
procedures that are in test, but not in prod.  Instead, they would like
to just refresh the table data.  Last time we tried this we had all
kinds of trouble with functions, triggers, constraints, etc... and ended
up doing a full import.

Is there a tried and true way to just refresh the table data without
losing anything else and without having all the problems with triggers
and constraints?

Thanks!
Ron 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to refresh

Ron - You should consider refreshing the instance by cloning your production
database. This way you get an exact replica in all respects, and you can
test your backup as a bonus. If you are interested in this method, tell us
how you backup your production database.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, December 16, 2003 8:55 AM
To: Multiple recipients of list ORACLE-L


I need to do a refresh of a test database using production data.  We use
import for this.  In the past we have always dropped the schemas (4 or
5), recreated the schemas, and then did a full import with ignore=n.
This time the user does not want to lose any of the new functions and
procedures that are in test, but not in prod.  Instead, they would like
to just refresh the table data.  Last time we tried this we had all
kinds of trouble with functions, triggers, constraints, etc... and ended
up doing a full import.

Is there a tried and true way to just refresh the table data without
losing anything else and without having all the problems with triggers
and constraints?

Thanks!
Ron 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

How to refresh

I need to do a refresh of a test database using production data.  We use
import for this.  In the past we have always dropped the schemas (4 or
5), recreated the schemas, and then did a full import with ignore=n.
This time the user does not want to lose any of the new functions and
procedures that are in test, but not in prod.  Instead, they would like
to just refresh the table data.  Last time we tried this we had all
kinds of trouble with functions, triggers, constraints, etc... and ended
up doing a full import.

Is there a tried and true way to just refresh the table data without
losing anything else and without having all the problems with triggers
and constraints?

Thanks!
Ron 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Good news from Oracle

2003-12-16 Thread KENNETH JANUSZ

If you are an owner of Oracle stock as I am, I don't care where the sales
are.  They all help make the stock price rise.  However, I do prefer that
the sales be in the USA.

My $0.02,

Ken Janusz, CPIM


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, December 16, 2003 8:34 AM


> the question for technical people is where the sales are located. are they
in the US? or somewhere else
> >
> > From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> > Date: 2003/12/16 Tue AM 08:59:26 EST
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: Good news from Oracle
> >
> > Oracle is posting healthy profits.
> >
> >
http://www.informationweek.com/story/showArticle.jhtml?articleID=16700686
> >
> >
> > Dennis Williams
> > DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: DENNIS WILLIAMS
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <[EMAIL PROTECTED]
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: KENNETH JANUSZ
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Good news from Oracle

check the subject heading for tech note 33174.1

Type:  REFERENCE 
Status:  PUBLISHED 

Howzzat?
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 Message-
Sent: Tuesday, December 16, 2003 9:44 AM
To: Multiple recipients of list ORACLE-L


Of course they are. Support and development cost them much less now that they've
outsourced it to Elbonia. The quality of the code is another matter. Fortunately,
they have broad and wide open beta testing program so that we all know what we can
expect. If the first relase of 10g is usable, I'll change my name to ora-600.

**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Good news from Oracle

Of course they are. Support and development cost them much less now that they've
outsourced it to Elbonia. The quality of the code is another matter. Fortunately,
they have broad and wide open beta testing program so that we all know what we can
expect. If the first relase of 10g is usable, I'll change my name to ora-600.

On 12/16/2003 08:59:26 AM, DENNIS WILLIAMS wrote:
> Oracle is posting healthy profits.
> 
> http://www.informationweek.com/story/showArticle.jhtml?articleID=16700686
> 
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

SAN Comparison Question

2003-12-16 Thread Jay Hostetter

One of our hardware guys is seeking an opinion on SANs.  He is comparing the Hitachi 
"Thunder" 9500 to the HP EVA 5000.  Does anybody have any pros or cons to offer for 
either one?  Good or bad experiences?

Thank you,
Jay



**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use of the 
individual or entity to which they are addressed and may contain information that is 
privileged, proprietary and confidential. If you are not the intended recipient, you 
may not use, copy or disclose to anyone the message or any information contained in 
the message. If you have received this communication in error, please notify the 
sender and delete this e-mail message. The contents do not represent the opinion of 
D&E except to the extent that it relates to their official business.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jay Hostetter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: New TPC benchmarks

In good, old times when I was much younger then today, things 
that were benchmarked were called MIPS, which was short for
"Marketing Invention for Pushing Sales". Today they have 
"TPC transactions" which are equally relevant to the real
world, but have no good translation. Whoever chooses hardware
vendor or the database vendor based on TPC results should be 
decapitated in public as a warning to the others.

On 12/16/2003 03:19:26 AM, Jonathan Lewis wrote:
> 
> 
> Not just hash clusters, single-table hash clusters
> with user-defined, and very carefully designed hash
> key.  Not something you can usually get away with
> in a dynamic table of 19 billion rows.
> 
> 
> Regards
> 
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
> 
>   The educated person is not the person
>   who can answer the questions, but the
>   person who can question the answers -- T. Schick Jr
> 
> 
> One-day tutorials:
> http://www.jlcomp.demon.co.uk/tutorial.html
> 
> 
> Three-day seminar:
> see http://www.jlcomp.demon.co.uk/seminar.html
> UK___November
> 
> 
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> 
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, December 16, 2003 6:49 AM
> 
> 
> Yes, both DB2, SQL Server and Oracle arrive in special editions for
> these benchmarks. Note also that no indexes are used - Oracle uses hash
> clusters, for instance. No indexes in sight.
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jonathan Lewis
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Good news from Oracle

2003-12-16 Thread ryan_oracle

the question for technical people is where the sales are located. are they in the US? 
or somewhere else 
> 
> From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> Date: 2003/12/16 Tue AM 08:59:26 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Good news from Oracle
> 
> Oracle is posting healthy profits.
> 
> http://www.informationweek.com/story/showArticle.jhtml?articleID=16700686
> 
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Free Memory in v$sgastat

Sinardy, where does oracle say anything like that about free memory? Please,
quote me an article or URL. Second, if you are not using MTS, your PGA is a 
part of your dedicated server address space, not SGA. It does exist, though. 
Similarly, UGA goes to shared pool instead. Buy yourself The Book (Practical
Oracle 8i) and read all about the architecture. I'll get rich from all commissions
I receive. 

of large pool. 
On 12/16/2003 12:24:25 AM, Sinardy Xing wrote:
> Hi Mladen,
> 
> I try to understand 8i, and I am not using MTS, my current understanding is UGA and 
> PGA only exists (I mean in use or in the picture) when you are using MTS.
> 
> Oracle themselves said "'free memory' are more properly thought of as wasted space"
> 
> I just wondering why this million dollar RDBMS can't make use of this space? 
> everything are in terms of Oracle Block, you can release and reuse the blocks.
> Well maybe quite difficult to get long continuous blocks, but it still free space, I 
> am so blur now
> 
> 
> Sinardy
> 
> -Original Message-
> Sent: 16 December 2003 12:54
> To: Multiple recipients of list ORACLE-L
> 
> 
> Sinardy, you've attended wrong database tuning course. You need free memory in your 
> shared pool.
> There is no such thing as "sga fragmentation" unless there is not enough free memory 
> to satisfy average
> request. While  oracle is not monitoring the size of an average shared pool request. 
> you have things
> like session_uga_memory and session_pga_memory in v$mystat. In v9 there is also 
> "session_stored_procedure_space".
> If the instance doesn't have enough room to load the next thing to execute (SQL, 
> PL/SQL, Java), it will have 
> to make room. Generally speaking, making room hurts.  You want to have enough room 
> to load your
> stuff into the shared pool and then some.  That "room" is also known as "free 
> space".  Look into the tuning manual on the 
> OTN and make sure that your buffer cache hit ratio is high enough (sorry folks, I 
> couldn't resist).
> 
> 
> 
> On 2003.12.15 23:19, Sinardy Xing wrote:
> > Hi all,
> >  
> > Why free memory in v$sgastat is a symptom of the fragmentation?
> >  
> > Why these "free memory" are more properly thought of as wasted space?
> >  
> >  
> >  
> > Thanks
> >  
> > Sinardy
> > 
> 
> -- 
> 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-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Sinardy Xing
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

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-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

9iAS - SSL certificate renewal and wallet manager

2003-12-16 Thread Ben

Hi

My SSL certificate is going to expire and I need to renew it.
I am running 9iAS 9.0.3 on Solaris8. All the documentation
seems to be about setting up the original certificate and I
can't find anything on renewals. Has anyone done this?
I have requested a new certificate from Entrust using the
wallet manager. Do I just import the new certificate? Will
the wallet manager overwrite the old one or do I have to
remove it first? Thanks in advance,

Ben
Queen's University
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ben
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OFS and MSCS

2003-12-16 Thread O'Neill, Sean

To implement OFS, Oracle 9i Database, on W2K do you need to implement MSCS
too?

-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode] 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: O'Neill, Sean
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Good news from Oracle