DB Monitoring

[VIVEK_SHARMA]

What Monitoring Activities Need to be Carried Out on Large Databases (
Excess of 100 GB ) ?

Any Experiences , best Practices , Documents , Links ?


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Clarification on External procedure in Oracle 8.1.6

[Ramesh_Kota]

Title: Clarification on External procedure in Oracle 8.1.6





Hi all...


    I believe any of u Would be of GREAT help... 


I have been trying Calling C functions from pl/sql using Oracle 8i's  External Routine. It works. But when I try to call the Pro*C function after precompiling it .. it is failing at connect itself. I have used 

EXEC SQL Connect username identified by passwd;


    The same Pro*c WORKS FINE when I try it from the command line. 


    Have any of u tried calling Pro*C from Pl/sql. If YES. could u .. Send me an example or some resource from wherein I can proceed with my work.


Thanx a lot in advance


Ramesh.

Re: Fwd: RE: !! *Very* important Oracle-L message !!

[Jan Pruner]

May be I'm a naive idiot (Forrest Gump :-)), but 
have somebody asked Oracle to sponzor this community of Oracle users?

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

insert into table .... values....

[Tatireddy, Shrinivas (MED, Keane)]

Hi lists

how to do the folloiwng inserts into a table?

table xyz has col1,col2, col3.

I need to populate the values to col1 from table dummy1 (cola)
 col2  table dummy2(colb)
 col3  table dummy3(colc).

there is no relation between dummy1 , dummy2, dummy3. We cannot join
these tables.

can I insert data into xyz in a single shot.

is there anything like 
  insert into xyz values((select cola from dummy1 where),
 (select colb from dummy2 where),
(select colc from dummy3 where )
);

srinivas.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tatireddy, Shrinivas (MED, Keane)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: alternative rows

[Sharmilan]

Hi Srini
SELECT * FROM Table
WHERE (rowid, 1)
IN ( select rowid , mod(rownum, 2) from Table )

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 9:05 PM


> Hi lists
> 
> can anybody post me to find alternative rows in a table.
> 
> 1,3,5 ...
> 
> or 2,4,6 
> 
> srinivas
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Tatireddy, Shrinivas (MED, Keane)
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Sharmilan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Fwd: RE: !! *Very* important Oracle-L message !!

[Viraj Luthra]

Jared,

Please suggest an Aussie rate for contributions. May be we from Australia could 
contribute $AUD30 or so( I could do may be more, when my next sal comes), what ever, 
"I Here by Pledge my Allegiance.." This list is good has helped me a lot in the 
past, and "I will endeavour... what ever I can do to help."

Please count me in...

Rgds,

raja


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viraj Luthra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: An OPS & tnsnames question

[Scott]

Andrey, The Oracle failover stuff is documented in the
net8 guide and I believe there are some examples as
well. The TNS syntax you are using is not failover but
more or less a load leveling across the listeners. If
you want to do TAF you will need to use this syntax.

ALIAS1.WORLD =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = NODE1)(PORT =
1521))
)
(CONNECT_DATA =
  (SID = OPS1)
  (server=dedicated)
 (failover_mode=
   (backup=ALIAS2.world)
   (type=select)
   (method=basic)))

ALIAS2.WORLD =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = NODE2)(PORT =
1521))
)
(CONNECT_DATA =
  (SID = OPS2)
  (server=dedicated)
 (failover_mode=
   (backup=ALIAS1.world)
   (type=select)
   (method=basic)))

I haven't used Oracle8 TAF syntax in a while so this
example may or may not work but it is close.

If you decide to use 8i or 9i this is the TNS you will
want to use.

# TNSNAMES.ORA Network Configuration File:
e:\stuff\tnsnames.ora
# Generated by Oracle configuration tools.

# Try each address, in order, until one succeeds

ALIAS1.WORLD =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = NODE##)(PORT
= 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = NODE##)(PORT
= 1521))
)
(CONNECT_DATA =
  (SERVICE_NAME = ops)
  (failover_mode=
(type=select) 
(method=basic)
(retries=20)
(delay=15))
)
  )

# Use each address in order until destination reached

ALIAS2.WORLD =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = NODE##)(PORT
= 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = NODE##)(PORT
= 1521))
)
(SOURCE_ROUTE = yes)
(CONNECT_DATA =
  (SERVICE_NAME = ops.us.oracle.com)
  (failover_mode=
(type=select) 
(method=basic)
(retries=20)
(delay=15))
)
  )

# Try each address, randomly, until one succeeds

ALIAS3.WORLD =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST =
git-opssun1)(PORT = 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST =
git-opssun2)(PORT = 1521))
  (LOAD_BALANCE = yes)
)
(CONNECT_DATA =
  (SERVICE_NAME = ops)
  (failover_mode=
(type=select) 
(method=basic)
(retries=20)
(delay=15))
)
  )

# Try one address selected at random

ALIAS4.WORLD =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = NODE##)(PORT
= 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = NODE##)(PORT
= 1521))
  (LOAD_BALANCE = yes)
  (FAILOVER = false)
)
(CONNECT_DATA =
  (SERVICE_NAME = ops)
  (failover_mode=
(type=select) 
(method=basic)
(retries=20)
(delay=15))
)
  )

# Use only the first address

ALIAS5.WORLD =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = NODE##)(PORT
= 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = NODE##)(PORT
= 1521))
  (FAILOVER = false)
)
(CONNECT_DATA =
  (SERVICE_NAME = ops)
  (failover_mode=
(type=select) 
(method=basic)
(retries=20)
(delay=15))
)
  )

#alias using backup syntax

ALIAS6.WORLD =
  (DESCRIPTION =
(failover=on)
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = NODE##)(PORT
= 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = NODE##)(PORT
= 1521))
)
(CONNECT_DATA =
  (SERVICE_NAME = OPS)
  (server=dedicated)
 (failover_mode=
   (backup=ALIAS1.world)
   (type=select)
   (method=basic)))

Scott

--- Andrey Bronfin <[EMAIL PROTECTED]> wrote:
> Dear list !
> I've got an OPS database named OPS with 2 instances
> OPS1 and OPS2 .
> I want the users to connect to OPS1 and ONLY if it
> is down , to connect to
> OPS2.
> It's Oracle 8.0.5.1 on NT4.
> 
> I put the following lines in clients' tnsnames.ora
> file :
> 
> OPS.world = (DESCRIPTION_LIST =
>   (DESCRIPTION = 
> (ADDRESS = (PROTOCOL = tcp) (HOST = DB1) (PORT =
> 1526))
> (CONNECT_DATA = (SID = OPS1))
>   )
>   (DESCRIPTION = 
> (ADDRESS = (PROTOCOL = tcp) (HOST = DB2) (PORT =
> 1526))
> (CONNECT_DATA = (SID = OPS2))
>   )
> )
> 
> This works perfectly fine except for the case when
> OPS1 instance is down ,
> but the listener is up.
> Then clients try to connect to OPS1 and fail -
> "Oracle not available" .
> When i bring the listener on OPS1 host down -
> everybody perfectly connect to
> OPS2.
> 
> Is there a solution ?
> Thanks a lot in advance !
> 
> 
> DBAndrey
> 
> * 03-9254520
> * 053-464562
> * mailto:[EMAIL PROTECTED]
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Andrey Bronfin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>
--

Re: Oracle VS. DB2

[Eric D. Pierce]

is that part of Larry's "reducing complexity" thangy?


[via: ORACLE-L Digest -- Volume 2001, Number 241]

> 
> --
> 
>  From: [EMAIL PROTECTED]
>  Date: Tue, 28 Aug 2001 13:41:03 -0400
>  Subject: Oracle VS. DB2
> 
> Any comment on the following:
> 
> IBM enlists ISVs in war against Oracle
> 
> Strategic alliances with independent software vendors have helped IBM gain
> new customers for its DB2 database software. IBM also appears to be
> getting help from an unlikely source: Oracle Corp.
> 
> http://computerworld.com/nlt/1%2C3590%2CNAV47_STO63350_NLTAM%2C00.html
> 
> Personally, I believe they've hit the nail straight on the head.


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: tab ascii value

[Jacques Kilchoer]

Title: RE: tab ascii value





>-Original Message-
>From: Bryan S [mailto:[EMAIL PROTECTED]]
>
>I'm not sure about the tab.
>I did the following ('tab' is between the ' '):
> ...



Well OK, for non-printing characters, just enter the word "Ascii chart" into a google search.
Here's one of the pages I found.
http://www.cdrummond.qc.ca/cegep/informat/Professeurs/Alain/files/ascii.htm

octal form

[Tatireddy, Shrinivas (MED, Keane)]

HI lists

when I do select 

select dump('k',1010) from dual  (decimal)

i get  107 as the ascii value 

to get an octal we substitute 1008 
in the place of 1010 and the result is 153 for 'k'.

andselect chr(107) from dual (decimal)
   value is ''k'  


if i use 
select chr(153) from dual, giving some wrong value... 

how do i convert this octal to decimal 


srinivas
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tatireddy, Shrinivas (MED, Keane)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Install oracle 7.3.4 in Solaris.

[Deshpande, Kirti]

Thanh-truc,
 Do you have the Installation Guide for 7.3.x Oracle for Sun Solaris
Platform? If you do, I suggest you refer to it first. If you still have
questions, we will be glad to address those. 

 If you do not have the Installation guide, please search for it at
http://technet.oracle.com. I believe there is one in the Archives for
Oracle7. 

 BTW - 7.3.4 is not supported by Oracle anymore, however, I am not sure when
the Extended Assistance Support for it ends (or if has already ended). 
 
HTH,
Regards,
 
- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Nguyen Thanh-truc [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 29, 2001 6:19 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Install oracle 7.3.4 in Solaris.
> 
> Hello listers,
> 
> I have to install a server Oracle (7.3.4) on Sun Solaris but i've never
> done
> that before. Could some one show me the steps to follow or give me some
> address where i can find the informations please ?
> 
> Thank you very much.
> 
> Thanh-truc Nguyen
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Nguyen Thanh-truc
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Burningman CD's

[Eric D. Pierce]

all miscreants will write "Mladen Gogala is a dba-god" 100 times in 
their event logs.

all miscreants will write "Mladen Gogala is a dba-god" 100 times in 
their event logs.

all miscreants will write "Mladen Gogala is a dba-god" 100 times in 
their event logs.

all miscreants will write "Mladen Gogala is a dba-god" 100 times in 
their event logs.

all miscreants will write "Mladen Gogala is a dba-god" 100 times in 
their event logs.

all miscreants will write "Mladen Gogala is a dba-god" 100 times in 
their event logs.

all miscreants will write "Mladen Gogala is a dba-god" 100 times in 
their event logs.

all miscreants will write "Mladen Gogala is a dba-god" 100 times in 
their event logs.

all miscreants will write "Mladen Gogala is a dba-god" 100 times in 
their event logs.


[via ORACLE-L Digest -- Volume 2001, Number 241]

> 
> --
> 
>  From: "Gogala, Mladen" <[EMAIL PROTECTED]>
>  Date: Tue, 28 Aug 2001 14:33:22 -0400
>  Subject: RE: Burning game CD's
> 
> Wow! I have fans! This will further inflate my already healthy ego


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

shutdown trigger

[Tatireddy, Shrinivas (MED, Keane)]

HI lists

can anybody throw this sql statement 

I need to create a trigger that will fire on shutdown (just before
shutdown) of the database.

It has to collect the flwng infm into a table called free_mem_prc 

1.   The time in minutes the system has been up( means my instance is
running since 200   minuts)
2.   Max no.of processes utilized by that instance 
(Can I get from V$resource_limit??)
3.   The free memory 
 (Can I get from v$sgastat??)

the table is 

free_mem_prc
   ( anumber- this stores 1
bnumber- this stores 2
cnumber )   - this stores 3


Are there any possible bugs with shutdown triggers... ?

thanx in advance
srinivas

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tatireddy, Shrinivas (MED, Keane)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Help using find for Perl...

[Denmark Weatherburne]

Hi Gurus,

I am trying to use Perl to find files with a particular extension (*.bat) on 
remote machines on our network.
I'm running Windows NT 4.0. I'm using ActivePerl v5.6.1 Build 626 May 
2,2001.
This is the script I got after running find2perl with the unix find 
specification and redirecting the output to a file:

#! D:\Perl\bin\perl.exe -w
eval 'exec D:\Perl\bin\perl.exe -S $0 ${1+"$@"}'
if 0; #$running_under_some_shell

use strict;
use File::Find ();

# Set the variable $File::Find::dont_use_nlink if you're using AFS,
# since AFS cheats.

# for the convenience of &wanted calls, including -eval statements:
use vars qw/*name *dir *prune/;
*name   = *File::Find::name;
*dir= *File::Find::dir;
*prune  = *File::Find::prune;


# Traverse desired filesystems
File::Find::find({wanted => \&wanted}, 'testdbmonitor/c$');
exit;


sub wanted {
/^.*\.bat\z/s;
}

When I executed it, no output resulted and after about 30 seconds the 
command prompt was returned. Definately the remote machine I was searching 
has lots of .bat files.

Please help!

Thanks in advance,

Denmark Weatherburne
"Knowledge is power, but it is only useful if it is shared!"



_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: tab ascii value

[Bryan S]

Title: RE: tab ascii value



I'm not sure about the tab.  I did the 
following ('tab' is between the ' '):
 
SQL> select dump(' ') from dual;
 
DUMP('')Typ=96 Len=1: 
32
 
SQL> select chr(32) from dual;
 
C-
It looks like a tab, but since it is a nonprinting 
character, it's hard to tell.
 
I'm pretty sure new line is 13 ( appears as ^M line 
ending char when viewed in vi).  I looked it up once online, and I did the 
following:
 
SQL> select chr(013) from dual;
 
C-
 
 
 
SQL>  select 'you' || chr(13) || 'me' || 
chr(13) || 'us'  2  from dual;
 
'YOU'||CH-youmeus
 
 
HTH,
Bryan
 

  - Original Message - 
  From: 
  Jacques Kilchoer 
  To: Multiple recipients of list ORACLE-L 
  Sent: Tuesday, August 28, 2001 2:21 
  PM
  Subject: RE: tab ascii value
  
  > -Original Message- > 
  From: Tatireddy, Shrinivas (MED, Keane) > [mailto:[EMAIL PROTECTED]] 
  > > how to find out the ascii 
  value of tab, new line > > for new line it is 10 > for tab it is 
  9 > > but how to get 
  from the following statement. > > select ascii(??) from dual; 
  I don't remember if this has been answered already, but read 
  the documentation on the DUMP and CHR functions. 
  SQL> select dump ('A') from dual ; 
  DUMP('A')  
  Typ=96 Len=1: 65 
  SQL> select chr (65) from dual ; 
  C - A 
  

Re: awk, sed, windoze, sql*loader, other fun stuff

[Jared . Still]

Lisa,

The cygwin package works well, it will even install perl for you.
http://sources.redhat.com/cygwin/

As for the script to gen sqlldr control files, get dump.sql from
www.cybcon.com/~jkstill/util
and just edit out the part that actually dumps the table.

Jared




   

"Koivu, Lisa"  


field.com>  cc:

Sent by:Subject: awk, sed, windoze, 
sql*loader, other fun stuff
[EMAIL PROTECTED]   

   

   

08/29/01 11:26 AM  

Please respond to  

ORACLE-L   

   

   





Hello all,


I'm working on sql*loader scripts and I realize that I'd probably be DONE
by now if I had awk and sed to use.  Of course, as unix-deficient as I am,
I don't have it.  Does anyone know of a windows version of these utilities?


Also I seem to remember someone had created a dynamic
create-control-file-based-on-a-table script in the past and shared it with
the list.  Does anyone remember where that was?


Gracias


Lisa Koivu
The Bootylicious DBA
Ft. Lauderdale, FL, USA







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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Oracle Discoverer 4i

[dgoulet]

To All,

I've seen a number of messages on Oracle's 9iAS and since we're evaluating
the product, is there anyone out there using the Discoverer 4i Plus WEB based
query tool?  If so, what is your opinion?

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: !! *Very* important Oracle-L message !!

[Sujatha Madan]

What about the Ozzie rate???...whatever it is, this list is great  even
though I've only been subscribed for a short time - I'm learning heaps ...
so I'm in for donating whatever the set fee is.

Cheers,

Sujatha



-Original Message-
Sent: Thursday, 30 August 2001 5:02 AM
To: Multiple recipients of list ORACLE-L


It is good start...I think we all should start sending min $20(for USA) and 
UKL 15 (for UK) to Jared/Bruce once we have address
Regards


MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 29 Aug 2001 08:50:55 -0800

Just publish the address where to send the money orders to
and my $20 will be on it's way tomorrow.

 > -Original Message-
 > From: Anjan Thakuria [mailto:[EMAIL PROTECTED]]
 > Sent: Wednesday, August 29, 2001 11:21 AM
 > To: Multiple recipients of list ORACLE-L
 > Subject: Re: !! *Very* important Oracle-L message !!
 >
 >
 > Can we just start pledging ..We have got to keep this form
 > going under. Ideas
 > .
 >
 > Anjan
 >
 > Jenner Mike wrote:
 >
 > > -Original Message-
 > > Sent: 28 August 2001 23:29
 > > To: Multiple recipients of list ORACLE-L
 > >
 > > Ok, now that I have your attention, please read the
 > following message from
 > > Bruce Bergman,
 > > owner of fatcity.com.  It concerns the future of this list.
 > >
 > > Please read the entire message before replying.
 > >
 > > Thank you.
 > >
 > > Jared Still  ( List Owner )
 > >
 > > ---
 > >
 > > Hello ORACLE-L list members --
 > >
 > > I would like to take a few minutes of your time for a
 > "State of the Union"
 > > address, if you can call it that.  This is a rather serious
 > message, and I
 > > request that you take the time to read this message
 > entirely.  I've got a
 > > problem that needs resolution this week, and I'm hoping you
 > folks can help
 > > me come to a conclusion.  This message turned out to be fairly
 > > long-winded, so please excuse me for that. :-)
 > >
 > > Fat City (fatcity.com) is my company, and I am the provider
 > of the list
 > > services that you receive ORACLE-L through.  I've been
 > hosting Internet
 > > mailing lists for over 10 years, and carry quite a few
 > lists, including a
 > > big selection of Oracle-related lists (14, in fact).  Fat
 > City has always
 > > been a labor of love for me.  Over the years it has rarely
 > generated any
 > > income at all, and it usually does not cover my expenses --
 > most of the
 > > time
 > > it is a monthly loss for me.  The vast majority of my 60+
 > mailing lists
 > > have
 > > been hosted for free, at my expense (as is the ORACLE-L
 > list, for example).
 > > Yet I have absorbed these costs because I enjoy hosting
 > discussion lists
 > > and I know a lot of lists can't afford to pay for quality service.
 > >
 > > I am soon to be one of the Rhythms Orphans.  Rhythms, my
 > DSL provider, has
 > > gone bankrupt and will be out of business by 10-Sep-2001.
 > I need to find
 > > another provider of high-speed Internet in order to
 > continue operations.  I
 > > am at the point of either folding shop completely and going
 > out of business
 > > myself, or trying to make Fat City a viable, money-making
 > endeavor.  I need
 > > to make this decision by this Friday (for financial and
 > planning reasons).
 > > After Friday, I am committed one way or the other.
 > >
 > > My upstream ISP and I are on very good terms, and in fact,
 > I've been a
 > > customer of theirs since 1985!  As a result, they have
 > graciously offered
 > > to help me out of this situation at considerable expense to
 > themselves.
 > > I'm not at liberty to discuss the terms of the contract I
 > would engage in
 > > with them, but suffice to say that is one of those
 > once-in-a-lifetime
 > > opportunities that I'd be a fool to pass up.  I have this
 > offer personally
 > > from the President of that company, if I want it.  Simply
 > said, my ability
 > > to take them up on their offer and switch Fat City over to
 > a dedicated T1
 > > or
 > > better solution revolves around being able to generate
 > quite a bit of
 > > additional
 > > income per month, and very soon.  In an effort to be open
 > and up-front with
 > > you folks about this, I basically need to generate an
 > additional $500 more
 > > per
 > > month. Right now that seems daunting, but I've been working
 > hard to line up
 > > that
 > > additional income, and I believe I can do it.  Just not
 > right away.  My
 > > estimates are that it will take me four or five months to
 > come up to that
 > > level.  I need to get out there and sell website hosting
 > and list hosting
 > > packages, and get new customers.  That takes time,
 > unfortunately.  I need a
 > > buffer to enable me to get past this startup phase.
 > >
 > > After some discussions with Jared (the list owner), and
 > some encouragement
 > > from him, I am coming to you to ask for you help in keeping Fat City
 > > fi

Re:RE: PeopleSoft8 Oddities

[dgoulet]

So am I, especially considering the "silence" on customer connection.

Dick Goulet

Reply Separator
Author: "MacGregor; Ian A." <[EMAIL PROTECTED]>
Date:   8/29/2001 3:30 PM

We'll be moving both human resources to Peoplesoft 8 before year's end.  I for
one am very interested.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Wednesday, August 29, 2001 2:46 PM
To: Multiple recipients of list ORACLE-L


OK, the subject is a bit redundant. We recently upgraded our HR system to
PeopleSoft8, and I have noticed some strange stuff with 2-tier connections.
Just thought I'ld toss this out and see if anyone else has seen the same
kind of stuff. 

In the past, when a user logged on 2-tier, an entry would be made to
v$session when the user logged on, and it would remain till the user logged
off. V$session.program would also show something like C:\...\ptools.exe and
v$session.osuser as the PC user. Now, however, sessions seem to pop in and
out. I have seen sessions come and go on v$session. I have also had a user
connect, be idle, shut down the listener, have them run something, and get a
Cannot  Connect error. Also, v$session.program now shows PSAPPSRV with an
osuser  of the osuser which spawned the application server. If I trace the
session back to v$process and look at the spid, the UNIX process points to a
dedicated shadow process as expected, not the appserver. The appserver,
however, must be touched or how would it know the osuser? (I haven't had a
chance to test this with the appserver shut down). Man that's confusing.

If anyone out there is interested in this stuff I will be glad to post more
if and when I find it.

Henry

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: PeopleSoft8 Oddities

[MacGregor, Ian A.]

We'll be moving both human resources to Peoplesoft 8 before year's end.  I for one am 
very interested.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Wednesday, August 29, 2001 2:46 PM
To: Multiple recipients of list ORACLE-L


OK, the subject is a bit redundant. We recently upgraded our HR system to
PeopleSoft8, and I have noticed some strange stuff with 2-tier connections.
Just thought I'ld toss this out and see if anyone else has seen the same
kind of stuff. 

In the past, when a user logged on 2-tier, an entry would be made to
v$session when the user logged on, and it would remain till the user logged
off. V$session.program would also show something like C:\...\ptools.exe and
v$session.osuser as the PC user. Now, however, sessions seem to pop in and
out. I have seen sessions come and go on v$session. I have also had a user
connect, be idle, shut down the listener, have them run something, and get a
Cannot  Connect error. Also, v$session.program now shows PSAPPSRV with an
osuser  of the osuser which spawned the application server. If I trace the
session back to v$process and look at the spid, the UNIX process points to a
dedicated shadow process as expected, not the appserver. The appserver,
however, must be touched or how would it know the osuser? (I haven't had a
chance to test this with the appserver shut down). Man that's confusing.

If anyone out there is interested in this stuff I will be glad to post more
if and when I find it.

Henry

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: User access within/outside of app

[Aponte, Tony]

Title: RE: User access within/outside of app






Here is a trigger that we use to change the optimizer goal at logon based on the operating system account.  You would be looking into the value of the v$session.program column instead of the OSUSER used below.  Instead of the 'alter session set optimizer...' code you would use any of the standard security recommendations that have already been posted for you.  I saw some recommending the use of a select-only role.  You can issue a 'set role selectonlyrole'.  I would use a password-restricted role and then use 'set role selectonlyrole identified by yoursecretpassword'.  This would prevent users from undoing your trigger changes post-logon.

HTH


= snippet begins here


CREATE OR REPLACE TRIGGER change_optimizer_on_startup

    AFTER LOGON ON DATABASE

DECLARE

    p_osuser_txt    V$SESSION_CONNECT_INFO.OSUSER%TYPE;

BEGIN

    BEGIN

    SELECT OSUSER

    INTO   p_osuser_txt

    FROM   V$SESSION

    WHERE  AUDSID = (SELECT USERENV('SESSIONID') FROM DUAL);

    EXCEPTION

    WHEN OTHERS THEN

 p_osuser_txt:=null;

    END;

    IF p_osuser_txt IN ('psoftfs','CompOps') THEN

     BEGIN

  EXECUTE IMMEDIATE 'alter session set optimizer_mode=rule';

   EXCEPTION

    WHEN OTHERS THEN

 SYS.DBMS_SYSTEM.KSDWRT(2,TO_CHAR(SYSDATE,'dd-mon-rr hh:mm:ss')||SQLERRM);

   END;

    END IF;

END;

/ 

== snippet ends here

-Original Message-

From: Larry Hahn [mailto:[EMAIL PROTECTED]]

Sent: Wednesday, August 22, 2001 6:07 PM

To: Multiple recipients of list ORACLE-L

Subject: RE: User access within/outside of app



Tony,


8.1.7 EE on Sun Solaris


Larry


--- "Aponte, Tony" <[EMAIL PROTECTED]> wrote:

> What version are you working with?

> 

> -Original Message-

> Sent: Tuesday, August 21, 2001 11:21 AM

> To: Multiple recipients of list ORACLE-L

> 

> 

> List,

> 

> We have purchased a system where users login through

> an ODBC connection using a generic Oracle userid.

> This

> userid has full rights to do insert, update, delete,

> select on any table in the schema. The app asks for

> another username and password which checks the

> application security table, which limits what areas

> of

> the apps they can access. 

> 

> Although this may work fine for the app, the users

> also have the ability to use Access and other ODBC

> compliant programs to look at the data. When doing

> so,

> they use the same ODBC DSN and, what do you know,

> they

> have capabilities beyond their wildest imagination. 

> 

> This is obviously not a situation I want to

> implement.

> I am looking for a way to allow a user into the app

> to

> do their normal work, but only allow read access for

> anything outside the app. 

> 

> Any suggestions or ideas would be more than welcome.

> 

> Thanks,

> 

> Larry Hahn

> Journal Sentinel, Inc. 

> 

> __

> Do You Yahoo!?

> Make international calls for as low as $.04/minute

> with Yahoo! Messenger

> http://phonecard.yahoo.com/

> -- 

> Please see the official ORACLE-L FAQ:

> http://www.orafaq.com

> -- 

> Author: Larry Hahn

>   INET: [EMAIL PROTECTED]

> 

> Fat City Network Services    -- (858) 538-5051  FAX:

> (858) 538-5051

> San Diego, California    -- Public Internet

> access / Mailing Lists

>



> 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).

> 



=

Larry Hahn

DBA

Journal Sentinel,Inc


__

Do You Yahoo!?

Make international calls for as low as $.04/minute with Yahoo! Messenger

http://phonecard.yahoo.com/

-- 

Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 

Author: Larry Hahn

  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

San Diego, California    -- Public Internet access / Mailing Lists



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: !! *Very* important Oracle-L message !!

[Rachel Carmichael]

amen! I know I work in NYC and that it's expensive here but trust me, $20 or 
even $10 is NOT barely the cost of lunch or dinner.

2 slices of pizza == $3.00throw in a soda and you're still under $5

>From: John Lewis <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: !! *Very* important Oracle-L message !!
>Date: Wed, 29 Aug 2001 14:58:27 -0800
>
> >we're throwing out figures
> >like $10, $20, $50 etc.  for us in the US, this is
> >barely the cost of lunch or dinner,
>
>Your lunches must be REAL nice. Is that with or without the wine?
>;-)
>
>(The place I usually eat has beans and rice with 4 corn tortillas for $3.
>And its in a downtown area)
>
>-Original Message-
>Sent: Wednesday, August 29, 2001 3:13 PM
>To: Multiple recipients of list ORACLE-L
>
>
>my 2 cents.  i think it was re-iterated that payment
>was not necessary so i don't think folks should feel
>guilty if they can't pay.  we're throwing out figures
>like $10, $20, $50 etc.  for us in the US, this is
>barely the cost of lunch or dinner, so no big deal.
>but some other folks in other parts of the world,
>$10-$20 bucks is a big chunk of money that they can
>ill-afforded.
>
>all i'm saying is that folks should not feel compelled
>to pay or feel guilty.  just re-read the original
>post. hopefully, most if not all the funds can be
>covered by US/Europe based DBAs' (and i hope this
>does'nt offend anyone).
>
>and everyone, whether they contribute or not, should
>feel more than welcome to use the list - no guilt
>trips please.
>
>mkb
>
>--- Jan Pruner <[EMAIL PROTECTED]> wrote:
> > There is no problem with subscription of today's
> > user.
> > I will pay too because I find this list excelent.
> >
> > But what about new users? If I find a new list
> > server with subscription,
> > I will never pay to try if is it valuable or not.
> >
> > I think that free subscription is better way 'cause
> > mail list is still free
> > (and open for new users)
> > and Bruce have no troubles with restriction (user's
> > rights) etc.
> >
> > Of course, we will pay and the others (nonpaying
> > users) have the List free,
> > I don't like it but 
> >
> > Jan Pruner
> >
> > Dne st 29. srpen 2001 19:22 jste napsal(a):
> > > I think a subscription is a decent suggestion. I
> > know Bruce wants to keep
> > > it free but it still sounds the most feasible to
> > me. After all the
> > > "electronic friends" I have made on the list, and
> > of course its primary aim
> > > as a second-to-none technical resource/forum, I
> > would hate to see it go.
> > >
> > > Regards
> > >
> > > Lee
> > >
> > > -Original Message-
> > > Sent: 29 August 2001 11:36
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >
> > >
> > > -Original Message-
> > > Sent: 28 August 2001 23:29
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >
> > > Ok, now that I have your attention, please read
> > the following message from
> > > Bruce Bergman,
> > > owner of fatcity.com.  It concerns the future of
> > this list.
> > >
> > > Please read the entire message before replying.
> > >
> > > Thank you.
> > >
> > > Jared Still  ( List Owner )
> > >
> > >
> > > ---
> > >
> > > Hello ORACLE-L list members --
> > >
> > > I would like to take a few minutes of your time
> > for a "State of the Union"
> > > address, if you can call it that.  This is a
> > rather serious message, and I
> > > request that you take the time to read this
> > message entirely.  I've got a
> > > problem that needs resolution this week, and I'm
> > hoping you folks can help
> > > me come to a conclusion.  This message turned out
> > to be fairly
> > > long-winded, so please excuse me for that. :-)
> > >
> > > Fat City (fatcity.com) is my company, and I am the
> > provider of the list
> > > services that you receive ORACLE-L through.  I've
> > been hosting Internet
> > > mailing lists for over 10 years, and carry quite a
> > few lists, including a
> > > big selection of Oracle-related lists (14, in
> > fact).  Fat City has always
> > > been a labor of love for me.  Over the years it
> > has rarely generated any
> > > income at all, and it usually does not cover my
> > expenses -- most of the
> > > time
> > > it is a monthly loss for me.  The vast majority of
> > my 60+ mailing lists
> > > have
> > > been hosted for free, at my expense (as is the
> > ORACLE-L list, for example).
> > > Yet I have absorbed these costs because I enjoy
> > hosting discussion lists
> > > and I know a lot of lists can't afford to pay for
> > quality service.
> > >
> > > I am soon to be one of the Rhythms Orphans.
> > Rhythms, my DSL provider, has
> > > gone bankrupt and will be out of business by
> > 10-Sep-2001.  I need to find
> > > another provider of high-speed Internet in order
> > to continue operations.  I
> > > am at the point of either folding shop completely
> > and going out of business
> >

Re:RE: !! Keeping the list alive

[dgoulet]

With me sitting here two hours after I should have left, you had better duck!!
:-)

Reply Separator
Author: [EMAIL PROTECTED]
Date:   8/29/2001 2:58 PM

You're surprised at those willing to pay?

You have to realize that most DBAs are over-payed and under-worked 
<>

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 29, 2001 1:43 PM
> To: Multiple recipients of list ORACLE-L
> Subject: !! Keeping the list alive
> 
> 
> 
> This list is apparently a more valuable resource to many of you than I
> realized.
> 
> I'm literally bowled over by the generosity.  I've received 
> so many emails
> about
> this that I really can't personally reply to them all right now.
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: OT: football fan-hood

[Joe Testa]

Paul, ask my wife, i hate sports, she's like college football fanatic.

joe

> > Paul Baumgartel wrote:
> >
> > Lisa,
> >
> > The stereotypical football fan is, of course, a male, whose
> > wife/significant other usually wants nothing to do with the sport.
> >  I've often wondered what might inspire a woman to follow
> > football--care to satisfy my curiosity?
> >
> >
> > Paul Baumgartel
> > MortgageSight Holdings, LLC
> > [EMAIL PROTECTED]
> >
> >  Lisa Koivu
> >  Vikings Fan and DBA
> >  Ft. Lauderdale, FL, USA
>
-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
IM: n8xcthome or joen8xct
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Install oracle 7.3.4 in Solaris.

[Nguyen Thanh-truc]

Hello listers,

I have to install a server Oracle (7.3.4) on Sun Solaris but i've never done
that before. Could some one show me the steps to follow or give me some
address where i can find the informations please ?

Thank you very much.

Thanh-truc Nguyen

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: OT: football fan-hood

[Kimberly Smith]

Tight pants on those nicely toned legs. Oh yeah, margaritas during the game
make it better as well.

-Original Message-
Sent: Wednesday, August 29, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L


Lisa's really a Dolphins phan in purple viking drag...

--Scott


> Paul Baumgartel wrote:
> 
> Lisa,
> 
> The stereotypical football fan is, of course, a male, whose
> wife/significant other usually wants nothing to do with the sport.
>  I've often wondered what might inspire a woman to follow
> football--care to satisfy my curiosity?
> 
> 
> Paul Baumgartel
> MortgageSight Holdings, LLC
> [EMAIL PROTECTED]
> 
>  Lisa Koivu
>  Vikings Fan and DBA
>  Ft. Lauderdale, FL, USA
> 
>   ).

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle 9i on NT beta

[Kevin Kostyszyn]

Hey Paul,
Great point, but don't be jealous I don't really have the time.
However, there are a lot of things that I dont understand about 9i (rollback
tablespace :?) so I figured I would have to read to get the basic
understanding of this thing.
However, you bring up a great point, I should probably continue to read
more about 8.1.7 because that is what we are using!!!  Even though I don't
know if you meant, thanks for the "hidden" advice:)
Sincerely,
Kevin
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 6:58 PM


> Kevin,
>
> I really admit that I am jealous.
> Where do you find the time to read the entire 9i - Concepts Manual,
> Administrators Guide, Installation Guide and Release Notes?
> I wish I had time to cover all of that. There's a few sections of those
for
> 8.1.6 (with updates for 8.1.7) that I haven't finished yet.
> For now, I'm trying to *know* as much about 8.1.7 as I can, since that is
> what my production boxes are running.
>
> have fun.
>
> Paul
>
>
>  Original Message 
> Date: Wed, 29 Aug 2001 14:12:56 -0800
> Reply-To: [EMAIL PROTECTED]
> Organization: Fat City Network Services, San Diego, California
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>
>
> Just wanted to say I loaded it today.  Wow, this thing sucks so far, now
it
> won't even start, where in the he__ is server manager!!!   Well, looks
like
> Barnes and Noble for me, I sure hope there is some good material out
there:)
>
> Sincerely,
> Kevin Kostyszyn
> DBA
> Dulcian, Inc
> www.dulcian.com
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Kostyszyn
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
> --
> Author: Paul Drake
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: OT: football fan-hood

[Gene Sais]

I know Lisa and she is no dolphin fan :)

Gene

*Fin Fan*

>>> [EMAIL PROTECTED] 08/29/01 06:35PM >>>
Lisa's really a Dolphins phan in purple viking drag...

--Scott


> Paul Baumgartel wrote:
> 
> Lisa,
> 
> The stereotypical football fan is, of course, a male, whose
> wife/significant other usually wants nothing to do with the sport.
>  I've often wondered what might inspire a woman to follow
> football--care to satisfy my curiosity?
> 
> 
> Paul Baumgartel
> MortgageSight Holdings, LLC
> [EMAIL PROTECTED] 
> 
>  Lisa Koivu
>  Vikings Fan and DBA
>  Ft. Lauderdale, FL, USA
> 
>   ).

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com 

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Gene Sais
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle 9i on NT beta (i know I know)

[Joe Testa]

Kevin:

sqlplus /nolog
connect / as sysdba;
startup;

joe
Kevin Kostyszyn wrote:
> 
> Just wanted to say I loaded it today.  Wow, this thing sucks so far, now it
> won't even start, where in the he__ is server manager!!!   Well, looks like
> Barnes and Noble for me, I sure hope there is some good material out there:)
> 
> Sincerely,
> Kevin Kostyszyn
> DBA
> Dulcian, Inc
> www.dulcian.com
> [EMAIL PROTECTED]
> 
>

-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
IM: n8xcthome or joen8xct
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: char vs. varchar2

[schmoldt]

Isn't CHAR a declining feature, which is why Oracle is forcing the
conversion to VARCHAR2 whenever possible?

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: !! Keeping the list alive

[schmoldt]

You're surprised at those willing to pay?

You have to realize that most DBAs are over-payed and under-worked 
<>

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 29, 2001 1:43 PM
> To: Multiple recipients of list ORACLE-L
> Subject: !! Keeping the list alive
> 
> 
> 
> This list is apparently a more valuable resource to many of you than I
> realized.
> 
> I'm literally bowled over by the generosity.  I've received 
> so many emails
> about
> this that I really can't personally reply to them all right now.
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Flat File vs. Database

[Jack C. Applewhite]

Dennis,

I'm stunned...

How about:
- Data Integrity (Referential Integrity and all the other constraints on
data)
- Concurrency (Readers don't block Writers and vice versa)
- Scalability
- Accessibility (no 3rd party tools could ever access your flat files for
analysis or reporting)
- Security

You're dang right it's an "no-brainer"!  ;-)

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, August 29, 2001 4:46 PM
To: Multiple recipients of list ORACLE-L


Hi all,
We are proposing a project to convert applications that use flat files to
Oracle databases. An essential piece of this proposal is to present to the
management the advantages of databases over flat files. Are there any
websites, whitepapers that talk about this? I know this probably is a
no-brainer for most of you but we just want to have all of our ducks in a
row so that we can make a strong case.
TIA

Dennis Meng
Database Administrator
Focal Communications
847-954-8328

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Flat File vs. Database

[Kevin Lange]

I have no web site for this but here is a begining list for you:

Pros:
  1. Relational in Nature.  
  2. You can access it from any location on your network with a multiple of
programs.  These can range from Excell, Word, SQL Plus, Toad, etc. etc. etc.
  3. Multiple people adding, deleting, changing, looking at at the same
time. (i.e. Locking).
  
Cons:
  1. Expensive
  2. Support needed to maintain.
  3. Expensive

And I am sure the rest on this site have more.

-Original Message-
Sent: Wednesday, August 29, 2001 4:46 PM
To: Multiple recipients of list ORACLE-L


Hi all,
We are proposing a project to convert applications that use flat files to
Oracle databases. An essential piece of this proposal is to present to the
management the advantages of databases over flat files. Are there any
websites, whitepapers that talk about this? I know this probably is a
no-brainer for most of you but we just want to have all of our ducks in a
row so that we can make a strong case.
TIA

Dennis Meng
Database Administrator
Focal Communications
847-954-8328

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Oracle 9i on NT beta (i know I know)

[Kevin Lange]

Kevin;
  I believe they did away with server manager.  Supposedly SQL Plus is now
allowed to do anything Servermanager did.

-Original Message-
Sent: Wednesday, August 29, 2001 5:13 PM
To: Multiple recipients of list ORACLE-L


Just wanted to say I loaded it today.  Wow, this thing sucks so far, now it
won't even start, where in the he__ is server manager!!!   Well, looks like
Barnes and Noble for me, I sure hope there is some good material out there:)

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: !! *Very* important Oracle-L message !!

[John Lewis]

>we're throwing out figures
>like $10, $20, $50 etc.  for us in the US, this is
>barely the cost of lunch or dinner,

Your lunches must be REAL nice. Is that with or without the wine?
;-)

(The place I usually eat has beans and rice with 4 corn tortillas for $3.
And its in a downtown area)

-Original Message-
Sent: Wednesday, August 29, 2001 3:13 PM
To: Multiple recipients of list ORACLE-L


my 2 cents.  i think it was re-iterated that payment
was not necessary so i don't think folks should feel
guilty if they can't pay.  we're throwing out figures
like $10, $20, $50 etc.  for us in the US, this is
barely the cost of lunch or dinner, so no big deal. 
but some other folks in other parts of the world,
$10-$20 bucks is a big chunk of money that they can
ill-afforded. 

all i'm saying is that folks should not feel compelled
to pay or feel guilty.  just re-read the original
post. hopefully, most if not all the funds can be
covered by US/Europe based DBAs' (and i hope this
does'nt offend anyone).

and everyone, whether they contribute or not, should
feel more than welcome to use the list - no guilt
trips please.

mkb

--- Jan Pruner <[EMAIL PROTECTED]> wrote:
> There is no problem with subscription of today's
> user.
> I will pay too because I find this list excelent.
> 
> But what about new users? If I find a new list
> server with subscription,
> I will never pay to try if is it valuable or not.
> 
> I think that free subscription is better way 'cause
> mail list is still free 
> (and open for new users)
> and Bruce have no troubles with restriction (user's
> rights) etc.
> 
> Of course, we will pay and the others (nonpaying
> users) have the List free,
> I don't like it but 
> 
> Jan Pruner
> 
> Dne st 29. srpen 2001 19:22 jste napsal(a):
> > I think a subscription is a decent suggestion. I
> know Bruce wants to keep
> > it free but it still sounds the most feasible to
> me. After all the
> > "electronic friends" I have made on the list, and
> of course its primary aim
> > as a second-to-none technical resource/forum, I
> would hate to see it go.
> >
> > Regards
> >
> > Lee
> >
> > -Original Message-
> > Sent: 29 August 2001 11:36
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> >
> > -Original Message-
> > Sent: 28 August 2001 23:29
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > Ok, now that I have your attention, please read
> the following message from
> > Bruce Bergman,
> > owner of fatcity.com.  It concerns the future of
> this list.
> >
> > Please read the entire message before replying.
> >
> > Thank you.
> >
> > Jared Still  ( List Owner )
> >
> >
> > ---
> >
> > Hello ORACLE-L list members --
> >
> > I would like to take a few minutes of your time
> for a "State of the Union"
> > address, if you can call it that.  This is a
> rather serious message, and I
> > request that you take the time to read this
> message entirely.  I've got a
> > problem that needs resolution this week, and I'm
> hoping you folks can help
> > me come to a conclusion.  This message turned out
> to be fairly
> > long-winded, so please excuse me for that. :-)
> >
> > Fat City (fatcity.com) is my company, and I am the
> provider of the list
> > services that you receive ORACLE-L through.  I've
> been hosting Internet
> > mailing lists for over 10 years, and carry quite a
> few lists, including a
> > big selection of Oracle-related lists (14, in
> fact).  Fat City has always
> > been a labor of love for me.  Over the years it
> has rarely generated any
> > income at all, and it usually does not cover my
> expenses -- most of the
> > time
> > it is a monthly loss for me.  The vast majority of
> my 60+ mailing lists
> > have
> > been hosted for free, at my expense (as is the
> ORACLE-L list, for example).
> > Yet I have absorbed these costs because I enjoy
> hosting discussion lists
> > and I know a lot of lists can't afford to pay for
> quality service.
> >
> > I am soon to be one of the Rhythms Orphans. 
> Rhythms, my DSL provider, has
> > gone bankrupt and will be out of business by
> 10-Sep-2001.  I need to find
> > another provider of high-speed Internet in order
> to continue operations.  I
> > am at the point of either folding shop completely
> and going out of business
> > myself, or trying to make Fat City a viable,
> money-making endeavor.  I need
> > to make this decision by this Friday (for
> financial and planning reasons).
> > After Friday, I am committed one way or the other.
> >
> > My upstream ISP and I are on very good terms, and
> in fact, I've been a
> > customer of theirs since 1985!  As a result, they
> have graciously offered
> > to help me out of this situation at considerable
> expense to themselves.
> > I'm not at liberty to discuss the terms of the
> contract I would engage in
> > with them, but suffice to say that is one of those
> once-in-a-lifetime
> > opportunities that I'd be a fool to pass up.  I
> have this 

Oracle 9i on NT beta

[Paul Drake]

Kevin,

I really admit that I am jealous.
Where do you find the time to read the entire 9i - Concepts Manual,
Administrators Guide, Installation Guide and Release Notes?
I wish I had time to cover all of that. There's a few sections of those for
8.1.6 (with updates for 8.1.7) that I haven't finished yet.
For now, I'm trying to *know* as much about 8.1.7 as I can, since that is
what my production boxes are running.

have fun.

Paul


 Original Message 
Date: Wed, 29 Aug 2001 14:12:56 -0800
Reply-To: [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego, California
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>


Just wanted to say I loaded it today.  Wow, this thing sucks so far, now it
won't even start, where in the he__ is server manager!!!   Well, looks like
Barnes and Noble for me, I sure hope there is some good material out there:)

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Paul Drake
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

listener supports no services

[Pat Hildebrand]

Has anyone run across this problem and come up with a way around it?

This morning we had a change of IP-addresses on a cluster of
machines. Our production server is now returning 
  The listener supports no services
whenever we try to start the listener. We have tried creating a new
listener (using a new name and new port) but we still get this
message. This is 8.1.6.2 on SunOS 5.7. The OS is 64 bit and Oracle is
32 bit.

The applications are all web based so if there is a work around for
OAS that in some way can access the database without going through the
listener (we can access the database via sqlplus as long as it is the
sqlplus on the same machine) it would help us out until we can solve
this. I have temporarily brought up one application on the test
instance since most of the data is via database links. However, we
don't have the space to move other apps that store their data locally.

A TAR has been opened with Oracle but at this point we looking for all
suggestions.

TIA

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: !! *Very* important Oracle-L message !!

[Joe Testa]

I also have a question, who besides myself have multiple(i think i use 4
a/o today) email accts to post from, how will we handle that concept,
would I need to pay 4 times(i'm thinking not, but how could we tell if
its the same person?).

joe

-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
IM: n8xcthome or joen8xct
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: OT: football fan-hood

[Scott Shafer]

Lisa's really a Dolphins phan in purple viking drag...

--Scott


> Paul Baumgartel wrote:
> 
> Lisa,
> 
> The stereotypical football fan is, of course, a male, whose
> wife/significant other usually wants nothing to do with the sport.
>  I've often wondered what might inspire a woman to follow
> football--care to satisfy my curiosity?
> 
> 
> Paul Baumgartel
> MortgageSight Holdings, LLC
> [EMAIL PROTECTED]
> 
>  Lisa Koivu
>  Vikings Fan and DBA
>  Ft. Lauderdale, FL, USA
> 
>   ).

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Oracle 9i on NT beta (i know I know)

[Kevin Kostyszyn]

Just wanted to say I loaded it today.  Wow, this thing sucks so far, now it
won't even start, where in the he__ is server manager!!!   Well, looks like
Barnes and Noble for me, I sure hope there is some good material out there:)

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: !! *Very* important Oracle-L message !!

[mohammed bhatti]

my 2 cents.  i think it was re-iterated that payment
was not necessary so i don't think folks should feel
guilty if they can't pay.  we're throwing out figures
like $10, $20, $50 etc.  for us in the US, this is
barely the cost of lunch or dinner, so no big deal. 
but some other folks in other parts of the world,
$10-$20 bucks is a big chunk of money that they can
ill-afforded. 

all i'm saying is that folks should not feel compelled
to pay or feel guilty.  just re-read the original
post. hopefully, most if not all the funds can be
covered by US/Europe based DBAs' (and i hope this
does'nt offend anyone).

and everyone, whether they contribute or not, should
feel more than welcome to use the list - no guilt
trips please.

mkb

--- Jan Pruner <[EMAIL PROTECTED]> wrote:
> There is no problem with subscription of today's
> user.
> I will pay too because I find this list excelent.
> 
> But what about new users? If I find a new list
> server with subscription,
> I will never pay to try if is it valuable or not.
> 
> I think that free subscription is better way 'cause
> mail list is still free 
> (and open for new users)
> and Bruce have no troubles with restriction (user's
> rights) etc.
> 
> Of course, we will pay and the others (nonpaying
> users) have the List free,
> I don't like it but 
> 
> Jan Pruner
> 
> Dne st 29. srpen 2001 19:22 jste napsal(a):
> > I think a subscription is a decent suggestion. I
> know Bruce wants to keep
> > it free but it still sounds the most feasible to
> me. After all the
> > "electronic friends" I have made on the list, and
> of course its primary aim
> > as a second-to-none technical resource/forum, I
> would hate to see it go.
> >
> > Regards
> >
> > Lee
> >
> > -Original Message-
> > Sent: 29 August 2001 11:36
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> >
> > -Original Message-
> > Sent: 28 August 2001 23:29
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > Ok, now that I have your attention, please read
> the following message from
> > Bruce Bergman,
> > owner of fatcity.com.  It concerns the future of
> this list.
> >
> > Please read the entire message before replying.
> >
> > Thank you.
> >
> > Jared Still  ( List Owner )
> >
> >
> > ---
> >
> > Hello ORACLE-L list members --
> >
> > I would like to take a few minutes of your time
> for a "State of the Union"
> > address, if you can call it that.  This is a
> rather serious message, and I
> > request that you take the time to read this
> message entirely.  I've got a
> > problem that needs resolution this week, and I'm
> hoping you folks can help
> > me come to a conclusion.  This message turned out
> to be fairly
> > long-winded, so please excuse me for that. :-)
> >
> > Fat City (fatcity.com) is my company, and I am the
> provider of the list
> > services that you receive ORACLE-L through.  I've
> been hosting Internet
> > mailing lists for over 10 years, and carry quite a
> few lists, including a
> > big selection of Oracle-related lists (14, in
> fact).  Fat City has always
> > been a labor of love for me.  Over the years it
> has rarely generated any
> > income at all, and it usually does not cover my
> expenses -- most of the
> > time
> > it is a monthly loss for me.  The vast majority of
> my 60+ mailing lists
> > have
> > been hosted for free, at my expense (as is the
> ORACLE-L list, for example).
> > Yet I have absorbed these costs because I enjoy
> hosting discussion lists
> > and I know a lot of lists can't afford to pay for
> quality service.
> >
> > I am soon to be one of the Rhythms Orphans. 
> Rhythms, my DSL provider, has
> > gone bankrupt and will be out of business by
> 10-Sep-2001.  I need to find
> > another provider of high-speed Internet in order
> to continue operations.  I
> > am at the point of either folding shop completely
> and going out of business
> > myself, or trying to make Fat City a viable,
> money-making endeavor.  I need
> > to make this decision by this Friday (for
> financial and planning reasons).
> > After Friday, I am committed one way or the other.
> >
> > My upstream ISP and I are on very good terms, and
> in fact, I've been a
> > customer of theirs since 1985!  As a result, they
> have graciously offered
> > to help me out of this situation at considerable
> expense to themselves.
> > I'm not at liberty to discuss the terms of the
> contract I would engage in
> > with them, but suffice to say that is one of those
> once-in-a-lifetime
> > opportunities that I'd be a fool to pass up.  I
> have this offer personally
> > from the President of that company, if I want it. 
> Simply said, my ability
> > to take them up on their offer and switch Fat City
> over to a dedicated T1
> > or
> > better solution revolves around being able to
> generate quite a bit of
> > additional
> > income per month, and very soon.  In an effort to
> be open and up-front with
> > you folks about this, I basically need to

RE: !! *Very* important Oracle-L message !!

[Kevin Hedger]

I think keeping the list free is the way to go.  My reasoning behind this is 
that newbees to the list, like myself, don't know the benefits they will 
reap from a list such as this until they use it.  They will just use another 
list that doesn't charge.  Some of you might think this is a good idea but 
if you look at the big picture, everyone started out as a newbee.  These 
newbees are the future ORACLE GURU'S and I really want those future guru's 
to be exchanging ideas and experiences with me in the future.

With new minds comes a new way of looking at things.

I will pledge $20 all I need is the paypal account #.

Kevin Hedger
Aspiring dba


>I think a subscription is a decent suggestion. I know Bruce wants to keep 
>it
>free but it still sounds the most feasible to me. After all the "electronic
>friends" I have made on the list, and of course its primary aim as a
>second-to-none technical resource/forum, I would hate to see it go.
>
>Regards
>
>Lee
>
>-Original Message-
>Sent: 29 August 2001 11:36
>To: Multiple recipients of list ORACLE-L
>
>
>
>
>-Original Message-
>Sent: 28 August 2001 23:29
>To: Multiple recipients of list ORACLE-L
>
>
>
>Ok, now that I have your attention, please read the following message from
>Bruce Bergman,
>owner of fatcity.com.  It concerns the future of this list.
>
>Please read the entire message before replying.
>
>Thank you.
>
>Jared Still  ( List Owner )
>
>
>---
>
>Hello ORACLE-L list members --
>
>I would like to take a few minutes of your time for a "State of the Union"
>address, if you can call it that.  This is a rather serious message, and I
>request that you take the time to read this message entirely.  I've got a
>problem that needs resolution this week, and I'm hoping you folks can help
>me come to a conclusion.  This message turned out to be fairly
>long-winded, so please excuse me for that. :-)
>
>Fat City (fatcity.com) is my company, and I am the provider of the list
>services that you receive ORACLE-L through.  I've been hosting Internet
>mailing lists for over 10 years, and carry quite a few lists, including a
>big selection of Oracle-related lists (14, in fact).  Fat City has always
>been a labor of love for me.  Over the years it has rarely generated any
>income at all, and it usually does not cover my expenses -- most of the
>time
>it is a monthly loss for me.  The vast majority of my 60+ mailing lists
>have
>been hosted for free, at my expense (as is the ORACLE-L list, for example).
>Yet I have absorbed these costs because I enjoy hosting discussion lists
>and I know a lot of lists can't afford to pay for quality service.
>
>I am soon to be one of the Rhythms Orphans.  Rhythms, my DSL provider, has
>gone bankrupt and will be out of business by 10-Sep-2001.  I need to find
>another provider of high-speed Internet in order to continue operations.  I
>am at the point of either folding shop completely and going out of business
>myself, or trying to make Fat City a viable, money-making endeavor.  I need
>to make this decision by this Friday (for financial and planning reasons).
>After Friday, I am committed one way or the other.
>
>My upstream ISP and I are on very good terms, and in fact, I've been a
>customer of theirs since 1985!  As a result, they have graciously offered
>to help me out of this situation at considerable expense to themselves.
>I'm not at liberty to discuss the terms of the contract I would engage in
>with them, but suffice to say that is one of those once-in-a-lifetime
>opportunities that I'd be a fool to pass up.  I have this offer personally
>from the President of that company, if I want it.  Simply said, my ability
>to take them up on their offer and switch Fat City over to a dedicated T1
>or
>better solution revolves around being able to generate quite a bit of
>additional
>income per month, and very soon.  In an effort to be open and up-front with
>you folks about this, I basically need to generate an additional $500 more
>per
>month. Right now that seems daunting, but I've been working hard to line up
>that
>additional income, and I believe I can do it.  Just not right away.  My
>estimates are that it will take me four or five months to come up to that
>level.  I need to get out there and sell website hosting and list hosting
>packages, and get new customers.  That takes time, unfortunately.  I need a
>buffer to enable me to get past this startup phase.
>
>After some discussions with Jared (the list owner), and some encouragement
>from him, I am coming to you to ask for you help in keeping Fat City
>financially afloat until I can be self sufficient.  I'm not asking for a
>specific dollar amount from anyone, nor am I *expecting* anything from you
>folks.  But if it is within your power to contribute some money towards
>this
>end (and yes, I know these are hard financial times for everyone), I am
>hoping you can help.  If I can get sufficient promise of funds that will
>see
>

RE: !! *Very* important Oracle-L message !!

[George Hofilena]

AMEN to that.

George

-Original Message-
Sent: Wednesday, August 29, 2001 1:06 PM
To: Multiple recipients of list ORACLE-L


I like Jeremiah's idea. 

All the "sermonizing" about the value of the list and how we should be
required to put something in the "offering basket" is just so much
"preaching to the choir."  :-)

I would gladly pay a subscription fee because I understand the value of the
list after having been on it a few years. HOWEVER, a newcomer may not
appreciate the value of the list without having seen any content over time
(as we all have). Requiring an up front entrance fee would probably scare
them off like "fire and brimstone sermon." If entrance to the list is free
then we can better "evangelize new believers" in the list. Broad
participation keeps the list healthy. In order to keep the list healthy we
need to be constantly adding new members and the best way to do this is to
make it free and easy. Another approach would be to make the first 6 months
free but this could be an administrative burden to enforce. So I think
voluntary contributions are the way to go... Do I have an "Amen?"

IMHO,
Steve Orr


-Original Message-
Sent: Wednesday, August 29, 2001 11:27 AM
To: Multiple recipients of list ORACLE-L


On my web page I maintain an Amazon.com payments paybox, which is for
collecting anonymous donations.  I think if Bruce sets up a paybox for
each list he hosts free of charge, and included a pledge request in
the list footers, there will be a steady stream of donations.

Amazon calls this the "Honor System," and it can be found at:

http://auctions.amazon.com/exec/varzea/subst/fx/home.html

It is basically like paypal, etc, but you can put the paybox inline
with any HTML, and it allows anonymous donations. The fee to Amazon is
15% of the total payment per transaction plus 15 cents.

I work for Amazon, so feel free to flame me for shamelessly promoting
my own product as a solution to this.  As an act of contrition, I
promise to pay US$50 into any form of collection that Bruce sets up,
Amazon or not.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Wed, 29 Aug 2001, Anjan Thakuria wrote:

> Can we just start pledging ..We have got to keep this form going under.
Ideas
>
> > -Original Message-
> > Sent: 28 August 2001 23:29
> > To: Multiple recipients of list ORACLE-L
> >
> > Ok, now that I have your attention, please read the following message
from
> > Bruce Bergman,
> > owner of fatcity.com.  It concerns the future of this list.
> >
> > Please read the entire message before replying.
> >
> > ---
> >
> > Hello ORACLE-L list members --
> >
> > I would like to take a few minutes of your time for a "State of the
Union"
> > address, if you can call it that.  This is a rather serious message, and
I
> > request that you take the time to read this message entirely.  I've got
a
> > problem that needs resolution this week, and I'm hoping you folks can
help
> > me come to a conclusion.  This message turned out to be fairly
> > long-winded, so please excuse me for that. :-)
> >
> > Fat City (fatcity.com) is my company, and I am the provider of the list
> > services that you receive ORACLE-L through.  I've been hosting Internet
> > mailing lists for over 10 years, and carry quite a few lists, including
a
> > big selection of Oracle-related lists (14, in fact).  Fat City has
always
> > been a labor of love for me.  Over the years it has rarely generated any
> > income at all, and it usually does not cover my expenses -- most of the
> > time
> > it is a monthly loss for me.  The vast majority of my 60+ mailing lists
> > have
> > been hosted for free, at my expense (as is the ORACLE-L list, for
example).
> > Yet I have absorbed these costs because I enjoy hosting discussion lists
> > and I know a lot of lists can't afford to pay for quality service.
> >
> > I am soon to be one of the Rhythms Orphans.  Rhythms, my DSL provider,
has
> > gone bankrupt and will be out of business by 10-Sep-2001.  I need to
find
> > another provider of high-speed Internet in order to continue operations.
I
> > am at the point of either folding shop completely and going out of
business
> > myself, or trying to make Fat City a viable, money-making endeavor.  I
need
> > to make this decision by this Friday (for financial and planning
reasons).
> > After Friday, I am committed one way or the other.
> >
> > My upstream ISP and I are on very good terms, and in fact, I've been a
> > customer of theirs since 1985!  As a result, they have graciously
offered
> > to help me out of this situation at considerable expense to themselves.
> > I'm not at liberty to discuss the terms of the contract I would engage
in
> > with them, but suffice to say that is one of those once-in-a-lifetime
> > opportunities that I'd be a fool to pass up.  I have this offer
personally
> > from the President of that company, if I want it.  Simply said, my
ability
> > to take them up on thei

RE: !! Keeping the list alive

[Kevin Lange]

And you are suprised at the response ??? Not from this end !!  There is
a lot of info out here that is just not available without a lot more
research than I have time for.



-Original Message-
Sent: Wednesday, August 29, 2001 1:43 PM
To: Multiple recipients of list ORACLE-L



This list is apparently a more valuable resource to many of you than I
realized.

I'm literally bowled over by the generosity.  I've received so many emails
about
this that I really can't personally reply to them all right now.

Many of you have asked some questions I would like to answer now.

Q.  How many members are there on this list.
A.  About 1500

Q. Why don't we just divide the amount needed by the number of
members and ask everyone for that amount?
A.  Not too practical.   This list is international.  It could present a
hardship for some.  Not everyone feels they get the same benefit
from the list.

Q.  Why not make this a fee based subscription?
A.  Charging a fee presents all kinds of additional complexity that
I don't care to introduce.

Q.  How much should I give?
A. That's up to you.  Don't make it a burden though.  Don't clean
out your savings, or anything like that. Many are pledging $10 or
$20 U.S.,  some more.  We don't want it to hurt.  :)

Q.  How can I send you some money?
A.  Details forthcoming.  You can send it to Bruce via PayPal.
Some want to send checks, what have you.  We'll post a PayPal
account and an address.


Thanks

Jared



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

PeopleSoft8 Oddities

[Henry Poras]

OK, the subject is a bit redundant. We recently upgraded our HR system to
PeopleSoft8, and I have noticed some strange stuff with 2-tier connections.
Just thought I'ld toss this out and see if anyone else has seen the same
kind of stuff. 

In the past, when a user logged on 2-tier, an entry would be made to
v$session when the user logged on, and it would remain till the user logged
off. V$session.program would also show something like C:\...\ptools.exe and
v$session.osuser as the PC user. Now, however, sessions seem to pop in and
out. I have seen sessions come and go on v$session. I have also had a user
connect, be idle, shut down the listener, have them run something, and get a
Cannot  Connect error. Also, v$session.program now shows PSAPPSRV with an
osuser  of the osuser which spawned the application server. If I trace the
session back to v$process and look at the spid, the UNIX process points to a
dedicated shadow process as expected, not the appserver. The appserver,
however, must be touched or how would it know the osuser? (I haven't had a
chance to test this with the appserver shut down). Man that's confusing.

If anyone out there is interested in this stuff I will be glad to post more
if and when I find it.

Henry

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: !! *Very* important Oracle-L message !!

[Chepuri Pramo (AP/QSW3, AB/QSW3)]

I'd be willing to pay a monthly/yearly subscription fee.

pramo


>> Original Message <<

On 8/29/01, 1:10:59 PM, Kathy Duret <[EMAIL PROTECTED]> wrote 
regarding RE: 
!! *Very* important Oracle-L message !!:


> IMHO

> How about a monthly and a yearly subscription fee.

> So newbies could join and pay a monthly subscription so if they don't 
like it they could bail.

> Other like me who would trade the list for anything could pay 
a yearly 
subscription fee.

> The yearly fee could be a bit lower than the monthly fee to encourage 
people to pay the whole year up front.  It would be less 
overhead for Bruce 
dealing with payments every month.

> In any case I am will either to do a subscription or voluntary 
contribution.  This list has save me so much time and money (and 
frustration not having to always learn the hard way!).  Not to 
mention made 
me a better DBA so I can command a better salary.

> If Bruce does start making money he can always revert the 
list back to 
being free.  Or he can wait a bit and recoup some of the money 
he has put 
into the list as that is only fair.  Bruce shouldn't feel guilty about 
anything!

> Kathy

> -Original Message-
> Sent: Wednesday, August 29, 2001 10:22 AM
> To: Multiple recipients of list ORACLE-L


> I think a subscription is a decent suggestion. I know Bruce 
wants to keep 
it
> free but it still sounds the most feasible to me. After all the 
"electronic
> friends" I have made on the list, and of course its primary aim as a
> second-to-none technical resource/forum, I would hate to see it go.

> Regards

> Lee

> -Original Message-
> Sent: 29 August 2001 11:36
> To: Multiple recipients of list ORACLE-L




> -Original Message-
> Sent: 28 August 2001 23:29
> To: Multiple recipients of list ORACLE-L



> Ok, now that I have your attention, please read the following message 
from
> Bruce Bergman,
> owner of fatcity.com.  It concerns the future of this list.

> Please read the entire message before replying.

> Thank you.

> Jared Still  ( List Owner )


> ---

> Hello ORACLE-L list members --

> I would like to take a few minutes of your time for a "State of the 
Union"
> address, if you can call it that.  This is a rather serious 
message, and 
I
> request that you take the time to read this message entirely. 
 I've got a
> problem that needs resolution this week, and I'm hoping you folks can 
help
> me come to a conclusion.  This message turned out to be fairly
> long-winded, so please excuse me for that. :-)

> Fat City (fatcity.com) is my company, and I am the provider 
of the list
> services that you receive ORACLE-L through.  I've been 
hosting Internet
> mailing lists for over 10 years, and carry quite a few lists, 
including a
> big selection of Oracle-related lists (14, in fact).  Fat 
City has always
> been a labor of love for me.  Over the years it has rarely 
generated any
> income at all, and it usually does not cover my expenses -- 
most of the
> time
> it is a monthly loss for me.  The vast majority of my 60+ 
mailing lists
> have
> been hosted for free, at my expense (as is the ORACLE-L list, for 
example).
> Yet I have absorbed these costs because I enjoy hosting 
discussion lists
> and I know a lot of lists can't afford to pay for quality service.

> I am soon to be one of the Rhythms Orphans.  Rhythms, my DSL 
provider, 
has
> gone bankrupt and will be out of business by 10-Sep-2001.  I 
need to find
> another provider of high-speed Internet in order to continue 
operations.  
I
> am at the point of either folding shop completely and going out of 
business
> myself, or trying to make Fat City a viable, money-making 
endeavor.  I 
need
> to make this decision by this Friday (for financial and planning 
reasons).
> After Friday, I am committed one way or the other.

> My upstream ISP and I are on very good terms, and in fact, I've been a
> customer of theirs since 1985!  As a result, they have 
graciously offered
> to help me out of this situation at considerable expense to 
themselves.
> I'm not at liberty to discuss the terms of the contract I 
would engage in
> with them, but suffice to say that is one of those once-in-a-lifetime
> opportunities that I'd be a fool to pass up.  I have this offer 
personally
> from the President of that company, if I want it.  Simply said, my 
ability
> to take them up on their offer and switch Fat City over to a 
dedicated T1
> or
> better solution revolves around being able to generate quite a bit of
> additional
> income per month, and very soon.  In an effort to be open and 
up-front 
with
> you folks about this, I basically need to generate an additional $500 
more
> per
> month. Right now that seems daunting, but I've been working 
hard to line 
up
> that
> additional income, and I believe I can do it.  Just not right 
away.  My
> estimates are that it will take me four or five months to 
come up to that
> l

Flat File vs. Database

[dmeng]

Hi all,
We are proposing a project to convert applications that use flat files to
Oracle databases. An essential piece of this proposal is to present to the
management the advantages of databases over flat files. Are there any
websites, whitepapers that talk about this? I know this probably is a
no-brainer for most of you but we just want to have all of our ducks in a
row so that we can make a strong case.
TIA

Dennis Meng
Database Administrator
Focal Communications
847-954-8328

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: !! Keeping the list alive

[Srinivas_Madala]

what man what else? are U leaving the office?
ekkada work vachi potundhi.
madala

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: "Drop & Recreate table" or "alter table drop column". Which

[Stephane Faroult]

> Jacques Kilchoer wrote:
> 
> > -Original Message-
> > From: William Rogge [mailto:[EMAIL PROTECTED]]
> >
> > Because of any synonyms (which are based off of object
> > numbers), Option 1
> > is the only way to go.  That is of course unless you want to
> > perform extra
> > work dealing with the synonyms.
> 
> I believe that your statment "synonyms are based on object numbers" is
> incorrect.

I fully agree with Jacques. Check sys.syn$, contrarily to most other
dictionary tables you have neither obj# nor user# but plain names. You
can see them as the equivalent of soft links under Unix - mere aliases,
which may point to nothing?
-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Lisa

[Kevin Kostyszyn]

Title: OT: Lisa



Nope, 
I don't think your wrong at all:)  I love the names!
KK

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
  Wednesday, August 29, 2001 4:28 PMTo: Multiple recipients of list 
  ORACLE-LSubject: OT: Lisa
  Nothing wrong with combining a 
  technical discussion with a bit of humor :)  Tell me if I'm wrong 
  ! 
  
-Original Message- From:   Kevin 
Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent:   Wednesday, 
August 29, 2001 4:12 PM To: Multiple recipients of list ORACLE-L Subject:    RE: Lisa 
I have been noticing this as well, 
Bootylicious?  hehheh 

  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Stephen AndertSent: Wednesday, August 29, 
  2001 3:16 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Lisa
  Lisa, do you have a file of "titles" 
  or do you keep coming up with new ones?  I read your messages just to 
  see things like:
  Dog Bone AdministratorThe 
  Bootylicious DBAand many more 
   
  StephenNo funny sig line 

OT: football fan-hood

[Paul Baumgartel]

Title: RE: How to loop call to SQL script in PL/SQL...



Lisa, 

 
The stereotypical 
football fan is, of course, a male, whose wife/significant other usually 
wants nothing to do with the sport.  I've often wondered what might inspire 
a woman to follow football--care to satisfy my curiosity?
 
Paul Baumgartel MortgageSight Holdings, 
LLC [EMAIL PROTECTED] 

  Lisa Koivu Vikings Fan and DBA Ft. Lauderdale, FL, USA 
  
). 

RE: LinuxFS for Oracle

[Gogala, Mladen]

Sorry for being unclear. ReiserFS has much, much, much faster fsck then
Ext2. 
With ReiserFS (a.k.a Ext3), fsck takes a second or two, not longer. With
ext2
it can go on forever, especially on /oracle, /mp3 or /usr/local filesystems.

-Original Message-
Sent: Wednesday, August 29, 2001 3:52 PM
To: Multiple recipients of list ORACLE-L



> -Original Message- 
> From: Gogala, Mladen [ mailto:[EMAIL PROTECTED]  ]

> 
> Oracle works on ReiserFS as well as on Ext2. My personal preference 
> was ReiserFS because of the abominable fsck times with my big 
> disks (32GB & 
> 20GB). 

I am confused - did you choose ReiserFS because you wanted abominable fsck
times, and that's what you got with ReiserFS, or because you wanted to avoid
abominable fsck times, and abominable fsck times are a feature of Ext2 but
not ReiserFS?

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: RMAN tuning

[Mercadante, Thomas F]

Ruth,

According to Michael:
>Tom:

>I haven't got a change to test it. I will try it sometime today. However,
>page 11-11 of Oracle8i Backup and Recovery Guide (8.1.5) states that Do not
>use this port-specific string if you have specified type disk.

>Thanks,

>Michael

I haven't tried it for disk, as I am backing up to tape and am happy about
it.  I mentioned that when I tested this param on NT/EDM, I experienced
marked improvements by setting this value from the default of 64k up to 2M.
There was no appreciable difference setting the parameter higher.


Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, August 29, 2001 11:36 AM
To: Multiple recipients of list ORACLE-L


Tom,
Does this only work for tape?

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 9:10 AM


> Michael,
>
> You might look at the BLKSIZE parameter.  I did some basic tests using NT
> and the EDM client, and found that setting the BLKSIZE to 2 Meg was the
> fastest for my installation.  I think the default is 64k.
>
> You set the parameter like:
>
> allocate channel d2 type 'SBT_TAPE' parms 'BLKSIZE=2097152';
>
> Hope this helps.
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -Original Message-
> Sent: Tuesday, August 28, 2001 9:26 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Hi All,
>
> I use RMAN to do a full backup of 120G database while the database is up
> running. It takes around 6 hours to finish. I have 61 data files and
> manually allocate 6 channels. For all the RMAN parameters such as
> FILESPERSET, I take the default.
>
> Does anybody there know how to maximize the throughput?
>
> Thanks,
>
> Michael
>
>
>
>

> This e-mail contains privileged attorney-client communications and/or
> confidential information, and is only for the use by the intended
recipient.
> Receipt by an unintended recipient does not constitute a waiver of any
> applicable privilege.
>
> Reading, disclosure, discussion, dissemination, distribution or copying of
> this information by anyone other than the intended recipient or his or her
> employees or agents is strictly prohibited.  If you have received this
> communication in error, please immediately notify us and delete the
original
> material from your computer.
>
> Sempra Energy Trading Corp. (SET) is not the same company as SDG&E or
> SoCalGas, the utilities owned by SET's parent company.  SET is not
regulated
> by the California Public Utilities Commission and you do not have to buy
> SET's products and services to continue to receive quality regulated
service
> from the utilities.
>

> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Xin \"Michael\" Wu
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
> --
> Author: Mercadante, Thomas F
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Ruth Gramolini
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Net

Re: OT: Lisa

[Scott Shafer]

You or J-Lo?  I'd give you the nod, Lisa.



--Scott


> "Koivu, Lisa" wrote:
> 
> Nothing wrong with combining a technical discussion with a bit of
> humor :)  Tell me if I'm wrong !
> 
>  -Original Message-
>  From:   Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
>  Sent:   Wednesday, August 29, 2001 4:12 PM
>  To: Multiple recipients of list ORACLE-L
>  Subject:RE: Lisa
> 
>  I have been noticing this as well, Bootylicious?  hehheh

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: !! *Very* important Oracle-L message !!

[Jeroen van Sluisdam]

Amen, I agree

-Oorspronkelijk bericht-
Van: Orr, Steve [mailto:[EMAIL PROTECTED]]
Verzonden: woensdag 29 augustus 2001 22:06
Aan: Multiple recipients of list ORACLE-L
Onderwerp: RE: !! *Very* important Oracle-L message !!


I like Jeremiah's idea. 

All the "sermonizing" about the value of the list and how we should be
required to put something in the "offering basket" is just so much
"preaching to the choir."  :-)

I would gladly pay a subscription fee because I understand the value of the
list after having been on it a few years. HOWEVER, a newcomer may not
appreciate the value of the list without having seen any content over time
(as we all have). Requiring an up front entrance fee would probably scare
them off like "fire and brimstone sermon." If entrance to the list is free
then we can better "evangelize new believers" in the list. Broad
participation keeps the list healthy. In order to keep the list healthy we
need to be constantly adding new members and the best way to do this is to
make it free and easy. Another approach would be to make the first 6 months
free but this could be an administrative burden to enforce. So I think
voluntary contributions are the way to go... Do I have an "Amen?"

IMHO,
Steve Orr


-Original Message-
Sent: Wednesday, August 29, 2001 11:27 AM
To: Multiple recipients of list ORACLE-L


On my web page I maintain an Amazon.com payments paybox, which is for
collecting anonymous donations.  I think if Bruce sets up a paybox for
each list he hosts free of charge, and included a pledge request in
the list footers, there will be a steady stream of donations.

Amazon calls this the "Honor System," and it can be found at:

http://auctions.amazon.com/exec/varzea/subst/fx/home.html

It is basically like paypal, etc, but you can put the paybox inline
with any HTML, and it allows anonymous donations. The fee to Amazon is
15% of the total payment per transaction plus 15 cents.

I work for Amazon, so feel free to flame me for shamelessly promoting
my own product as a solution to this.  As an act of contrition, I
promise to pay US$50 into any form of collection that Bruce sets up,
Amazon or not.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Wed, 29 Aug 2001, Anjan Thakuria wrote:

> Can we just start pledging ..We have got to keep this form going under.
Ideas
>
> > -Original Message-
> > Sent: 28 August 2001 23:29
> > To: Multiple recipients of list ORACLE-L
> >
> > Ok, now that I have your attention, please read the following message
from
> > Bruce Bergman,
> > owner of fatcity.com.  It concerns the future of this list.
> >
> > Please read the entire message before replying.
> >
> > ---
> >
> > Hello ORACLE-L list members --
> >
> > I would like to take a few minutes of your time for a "State of the
Union"
> > address, if you can call it that.  This is a rather serious message, and
I
> > request that you take the time to read this message entirely.  I've got
a
> > problem that needs resolution this week, and I'm hoping you folks can
help
> > me come to a conclusion.  This message turned out to be fairly
> > long-winded, so please excuse me for that. :-)
> >
> > Fat City (fatcity.com) is my company, and I am the provider of the list
> > services that you receive ORACLE-L through.  I've been hosting Internet
> > mailing lists for over 10 years, and carry quite a few lists, including
a
> > big selection of Oracle-related lists (14, in fact).  Fat City has
always
> > been a labor of love for me.  Over the years it has rarely generated any
> > income at all, and it usually does not cover my expenses -- most of the
> > time
> > it is a monthly loss for me.  The vast majority of my 60+ mailing lists
> > have
> > been hosted for free, at my expense (as is the ORACLE-L list, for
example).
> > Yet I have absorbed these costs because I enjoy hosting discussion lists
> > and I know a lot of lists can't afford to pay for quality service.
> >
> > I am soon to be one of the Rhythms Orphans.  Rhythms, my DSL provider,
has
> > gone bankrupt and will be out of business by 10-Sep-2001.  I need to
find
> > another provider of high-speed Internet in order to continue operations.
I
> > am at the point of either folding shop completely and going out of
business
> > myself, or trying to make Fat City a viable, money-making endeavor.  I
need
> > to make this decision by this Friday (for financial and planning
reasons).
> > After Friday, I am committed one way or the other.
> >
> > My upstream ISP and I are on very good terms, and in fact, I've been a
> > customer of theirs since 1985!  As a result, they have graciously
offered
> > to help me out of this situation at considerable expense to themselves.
> > I'm not at liberty to discuss the terms of the contract I would engage
in
> > with them, but suffice to say that is one of those once-in-a-lifetime
> > opportunities that I'd be a fool to pass up.  I have this offer
personally
> > fro

RE: financial problems with fatcity.com

[Anderson, Brian]

> Do we get a t-shirt, like for PBS? 
> 
> My 5-year old son got a great DragonTales t-shirt.
> 
> Now we have to think of a caption for the t-shirt.

Didn't we already cover the T-shirt question a while back?

Help!!!

Are You An Idiot?

;)

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: char vs. varchar2

[Richard Ji]

One thing you have to consider is the comparison semantic when using
CHAR vs VARCHAR.  You should consult the Oracle Doc on this.

>>> [EMAIL PROTECTED] 08/29/01 03:35PM >>>
I think that this subject comes up now and then, but I don't remember the
conclusions

We are creating a Data Warehouse and the subject of char vs varchar2 data types
came up.  I searched google and found a little bit on the subject (mainly there
is no space savings between char(1) and varchar2(1)).

Has anybody studied this?  For example:  If I know that all my data is 10
characters wide, should I not create the field as char(10)?  Any reason to make
it a varchar2(10)?  Would sql scripts (select and dml) be faster with one type
or the other?  Any space savings with one type or the other (still given 10
characters of fixed data)?

Thanks,
Tom

Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED] 
937-656-3844 

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: char vs. varchar2

[Terrian, Tom]

Thank you, I will check it out.

Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844 


-Original Message-
Sent: Wednesday, August 29, 2001 4:06 PM
To: Multiple recipients of list ORACLE-L


"Terrian, Tom" wrote:
> 
> I think that this subject comes up now and then, but I don't remember the
> conclusions
> 
> We are creating a Data Warehouse and the subject of char vs varchar2 data
types
> came up.  I searched google and found a little bit on the subject (mainly
there
> is no space savings between char(1) and varchar2(1)).
> 
> Has anybody studied this?  For example:  If I know that all my data is 10
> characters wide, should I not create the field as char(10)?  Any reason to
make
> it a varchar2(10)?  Would sql scripts (select and dml) be faster with one type
> or the other?  Any space savings with one type or the other (still given 10
> characters of fixed data)?
> 
> Thanks,
> Tom
> 
> Tom Terrian
> Oracle DBA
> WPAFB - DAASC
> [EMAIL PROTECTED]
> 937-656-3844

Tom,

  There is a somehow astonishingly little known - in spite of its having
been around for at least the 15 last years - SQL function named VSIZE()
which answers any question you may have about actual storage usage. For
the really inquisitive, you have DUMP() as well. 
-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Terrian, Tom
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Lisa

[Kevin Kostyszyn]

I have been noticing this as 
well, Bootylicious?  hehheh

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Stephen AndertSent: 
  Wednesday, August 29, 2001 3:16 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Lisa
  Lisa, do you have a file of "titles" or do 
  you keep coming up with new ones?  I read your messages just to see 
  things like:
  Dog Bone AdministratorThe Bootylicious DBA and many more
   
  StephenNo funny sig line

RE: !! *Very* important Oracle-L message !!

[MacGregor, Ian A.]

This definitely the best Oracle list.  Any chance of hacing the IOUG-A to sponsor it?  
I remember quite a few years back the IOUG was sponsoring a Compuserve list run by 
Chris Wooleridge.   Chris, one of the first Oracle employees, was  enjoying the 
financial benefits thereof, living the good life, until he was killed in an accident 
near Taos, New Mexico.

Chris for his services had been  made a member of the board.  I propose a similar 
position for Jared, should he want it.  Here's what I envision.  Ther IOUG-A pays the 
costs of the list; Jared for his work becomes a member  of the board receiving all 
benefits of the office.  At one time a perquisite of being a board member was free 
admission to IOUW.



Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]  

-Original Message-
Sent: Tuesday, August 28, 2001 3:29 PM
To: Multiple recipients of list ORACLE-L



Ok, now that I have your attention, please read the following message from
Bruce Bergman,
owner of fatcity.com.  It concerns the future of this list.

Please read the entire message before replying.

Thank you.

Jared Still  ( List Owner )


---

Hello ORACLE-L list members --

I would like to take a few minutes of your time for a "State of the Union"
address, if you can call it that.  This is a rather serious message, and I
request that you take the time to read this message entirely.  I've got a
problem that needs resolution this week, and I'm hoping you folks can help
me come to a conclusion.  This message turned out to be fairly
long-winded, so please excuse me for that. :-)

Fat City (fatcity.com) is my company, and I am the provider of the list
services that you receive ORACLE-L through.  I've been hosting Internet
mailing lists for over 10 years, and carry quite a few lists, including a
big selection of Oracle-related lists (14, in fact).  Fat City has always
been a labor of love for me.  Over the years it has rarely generated any
income at all, and it usually does not cover my expenses -- most of the
time
it is a monthly loss for me.  The vast majority of my 60+ mailing lists
have
been hosted for free, at my expense (as is the ORACLE-L list, for example).
Yet I have absorbed these costs because I enjoy hosting discussion lists
and I know a lot of lists can't afford to pay for quality service.

I am soon to be one of the Rhythms Orphans.  Rhythms, my DSL provider, has
gone bankrupt and will be out of business by 10-Sep-2001.  I need to find
another provider of high-speed Internet in order to continue operations.  I
am at the point of either folding shop completely and going out of business
myself, or trying to make Fat City a viable, money-making endeavor.  I need
to make this decision by this Friday (for financial and planning reasons).
After Friday, I am committed one way or the other.

My upstream ISP and I are on very good terms, and in fact, I've been a
customer of theirs since 1985!  As a result, they have graciously offered
to help me out of this situation at considerable expense to themselves.
I'm not at liberty to discuss the terms of the contract I would engage in
with them, but suffice to say that is one of those once-in-a-lifetime
opportunities that I'd be a fool to pass up.  I have this offer personally
from the President of that company, if I want it.  Simply said, my ability
to take them up on their offer and switch Fat City over to a dedicated T1
or
better solution revolves around being able to generate quite a bit of
additional
income per month, and very soon.  In an effort to be open and up-front with
you folks about this, I basically need to generate an additional $500 more
per
month. Right now that seems daunting, but I've been working hard to line up
that
additional income, and I believe I can do it.  Just not right away.  My
estimates are that it will take me four or five months to come up to that
level.  I need to get out there and sell website hosting and list hosting
packages, and get new customers.  That takes time, unfortunately.  I need a
buffer to enable me to get past this startup phase.

After some discussions with Jared (the list owner), and some encouragement
from him, I am coming to you to ask for you help in keeping Fat City
financially afloat until I can be self sufficient.  I'm not asking for a
specific dollar amount from anyone, nor am I *expecting* anything from you
folks.  But if it is within your power to contribute some money towards
this
end (and yes, I know these are hard financial times for everyone), I am
hoping you can help.  If I can get sufficient promise of funds that will
see
me through the next few months, I am willing to jump in with both feet and
make Fat City a viable business.  If it looks like the contributions are
not
sufficient to enable me to do that, I will cease operations within the next
45-60 days.

Let me be clear about a few things: If I *do* cease operations, I will give
all of my lists time to find new list

Re: awk, sed, windoze, sql*loader, other fun stuff

[Rocky Welch]

Hi Lisa,
MKS Toolkit or Unix Utilites for Windows (Microsoft). Both work very well.

-Rocky

--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
> Hello all, 
> 
> I'm working on sql*loader scripts and I realize that I'd probably be
> DONE by
> now if I had awk and sed to use.  Of course, as unix-deficient as I am,
> I
> don't have it.  Does anyone know of a windows version of these
> utilities?  
> 
> Also I seem to remember someone had created a dynamic
> create-control-file-based-on-a-table script in the past and shared it
> with
> the list.  Does anyone remember where that was?  
> 
> Gracias
> 
> Lisa Koivu
> The Bootylicious DBA
> Ft. Lauderdale, FL, USA
> 
> 


__
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: !! Keeping the list alive

[Tirumala, Surendra]

Waiting for the details

Suren

-Original Message-
Sent: Wednesday, August 29, 2001 2:43 PM
To: Multiple recipients of list ORACLE-L



This list is apparently a more valuable resource to many of you than I
realized.

I'm literally bowled over by the generosity.  I've received so many emails
about
this that I really can't personally reply to them all right now.

Many of you have asked some questions I would like to answer now.

Q.  How many members are there on this list.
A.  About 1500

Q. Why don't we just divide the amount needed by the number of
members and ask everyone for that amount?
A.  Not too practical.   This list is international.  It could present a
hardship for some.  Not everyone feels they get the same benefit
from the list.

Q.  Why not make this a fee based subscription?
A.  Charging a fee presents all kinds of additional complexity that
I don't care to introduce.

Q.  How much should I give?
A. That's up to you.  Don't make it a burden though.  Don't clean
out your savings, or anything like that. Many are pledging $10 or
$20 U.S.,  some more.  We don't want it to hurt.  :)

Q.  How can I send you some money?
A.  Details forthcoming.  You can send it to Bruce via PayPal.
Some want to send checks, what have you.  We'll post a PayPal
account and an address.


Thanks

Jared



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Tirumala, Surendra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: "Drop & Recreate table" or "alter table drop column". Which

[Jacques Kilchoer]

Title: RE: "Drop & Recreate table"  or  "alter table drop column". Which is 





> -Original Message-
> From: William Rogge [mailto:[EMAIL PROTECTED]]
> 
> Because of any synonyms (which are based off of object 
> numbers), Option 1 
> is the only way to go.  That is of course unless you want to 
> perform extra 
> work dealing with the synonyms.



I believe that your statment "synonyms are based on object numbers" is incorrect. I created a table, created a synonym to that table, then dropped the table, created another table with the same name, and the synonym "found" the new table.

SQL> create table t (n number) ;
Table created.
SQL> insert into t (n) values (1) ;
1 row created.
SQL> commit ;
Commit complete.


SQL> create synonym s for t ;
Synonym created.
SQL> select * from s ;


 N
--
 1


SQL> drop table t ;
Table dropped.
SQL> create table t (n number) ;
Table created.
SQL> insert into t (n) values (2) ;
1 row created.
SQL> commit ;
Commit complete.


SQL> select * from s ;
 N
--
 2


--
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

RE: !! *Very* important Oracle-L message !!

[Ramon Estevez]

Hola,

I think a subscription is the best solution. I have learned too much reading
the solutions to the posts that everyday show up, and mines too.

Can count on me !!!

Regards,


Ramon E. Estevez
[EMAIL PROTECTED]
Dominican Republic
809-565-3121



-Original Message-
Sent: 28 August 2001 23:29
To: Multiple recipients of list ORACLE-L



Ok, now that I have your attention, please read the following message from
Bruce Bergman,
owner of fatcity.com.  It concerns the future of this list.

Please read the entire message before replying.

Thank you.

Jared Still  ( List Owner )


---

Hello ORACLE-L list members --

I would like to take a few minutes of your time for a "State of the Union"
address, if you can call it that.  This is a rather serious message, and I
request that you take the time to read this message entirely.  I've got a
problem that needs resolution this week, and I'm hoping you folks can help
me come to a conclusion.  This message turned out to be fairly
long-winded, so please excuse me for that. :-)

Fat City (fatcity.com) is my company, and I am the provider of the list
services that you receive ORACLE-L through.  I've been hosting Internet
mailing lists for over 10 years, and carry quite a few lists, including a
big selection of Oracle-related lists (14, in fact).  Fat City has always
been a labor of love for me.  Over the years it has rarely generated any
income at all, and it usually does not cover my expenses -- most of the
time
it is a monthly loss for me.  The vast majority of my 60+ mailing lists
have
been hosted for free, at my expense (as is the ORACLE-L list, for example).
Yet I have absorbed these costs because I enjoy hosting discussion lists
and I know a lot of lists can't afford to pay for quality service.

I am soon to be one of the Rhythms Orphans.  Rhythms, my DSL provider, has
gone bankrupt and will be out of business by 10-Sep-2001.  I need to find
another provider of high-speed Internet in order to continue operations.  I
am at the point of either folding shop completely and going out of business
myself, or trying to make Fat City a viable, money-making endeavor.  I need
to make this decision by this Friday (for financial and planning reasons).
After Friday, I am committed one way or the other.

My upstream ISP and I are on very good terms, and in fact, I've been a
customer of theirs since 1985!  As a result, they have graciously offered
to help me out of this situation at considerable expense to themselves.
I'm not at liberty to discuss the terms of the contract I would engage in
with them, but suffice to say that is one of those once-in-a-lifetime
opportunities that I'd be a fool to pass up.  I have this offer personally
from the President of that company, if I want it.  Simply said, my ability
to take them up on their offer and switch Fat City over to a dedicated T1
or
better solution revolves around being able to generate quite a bit of
additional
income per month, and very soon.  In an effort to be open and up-front with
you folks about this, I basically need to generate an additional $500 more
per
month. Right now that seems daunting, but I've been working hard to line up
that
additional income, and I believe I can do it.  Just not right away.  My
estimates are that it will take me four or five months to come up to that
level.  I need to get out there and sell website hosting and list hosting
packages, and get new customers.  That takes time, unfortunately.  I need a
buffer to enable me to get past this startup phase.

After some discussions with Jared (the list owner), and some encouragement
from him, I am coming to you to ask for you help in keeping Fat City
financially afloat until I can be self sufficient.  I'm not asking for a
specific dollar amount from anyone, nor am I *expecting* anything from you
folks.  But if it is within your power to contribute some money towards
this
end (and yes, I know these are hard financial times for everyone), I am
hoping you can help.  If I can get sufficient promise of funds that will
see
me through the next few months, I am willing to jump in with both feet and
make Fat City a viable business.  If it looks like the contributions are
not
sufficient to enable me to do that, I will cease operations within the next
45-60 days.

Let me be clear about a few things: If I *do* cease operations, I will give
all of my lists time to find new list providers, and will make every effort
to aid the shift over to the new provider, provide list dumps, archives,
mail forwarding, etc.  Even though Rhythms goes out of business on
10-Sep-2001, I have secured service until at least 10-Oct-2001 to enable
this to happen.  So don't worry about having to rush into your conversion
if
things don't work out.  I would also like to clearly state that this is not
some attempt to blackmail or coerce anyone into coming up with money.  This
will either succeed or fail based on what you folks can comfortably and

Re: !! *Very* important Oracle-L message !!

[Jan Pruner]

There is no problem with subscription of today's user.
I will pay too because I find this list excelent.

But what about new users? If I find a new list server with subscription,
I will never pay to try if is it valuable or not.

I think that free subscription is better way 'cause mail list is still free 
(and open for new users)
and Bruce have no troubles with restriction (user's rights) etc.

Of course, we will pay and the others (nonpaying users) have the List free,
I don't like it but 

Jan Pruner

Dne st 29. srpen 2001 19:22 jste napsal(a):
> I think a subscription is a decent suggestion. I know Bruce wants to keep
> it free but it still sounds the most feasible to me. After all the
> "electronic friends" I have made on the list, and of course its primary aim
> as a second-to-none technical resource/forum, I would hate to see it go.
>
> Regards
>
> Lee
>
> -Original Message-
> Sent: 29 August 2001 11:36
> To: Multiple recipients of list ORACLE-L
>
>
>
>
> -Original Message-
> Sent: 28 August 2001 23:29
> To: Multiple recipients of list ORACLE-L
>
>
>
> Ok, now that I have your attention, please read the following message from
> Bruce Bergman,
> owner of fatcity.com.  It concerns the future of this list.
>
> Please read the entire message before replying.
>
> Thank you.
>
> Jared Still  ( List Owner )
>
>
> ---
>
> Hello ORACLE-L list members --
>
> I would like to take a few minutes of your time for a "State of the Union"
> address, if you can call it that.  This is a rather serious message, and I
> request that you take the time to read this message entirely.  I've got a
> problem that needs resolution this week, and I'm hoping you folks can help
> me come to a conclusion.  This message turned out to be fairly
> long-winded, so please excuse me for that. :-)
>
> Fat City (fatcity.com) is my company, and I am the provider of the list
> services that you receive ORACLE-L through.  I've been hosting Internet
> mailing lists for over 10 years, and carry quite a few lists, including a
> big selection of Oracle-related lists (14, in fact).  Fat City has always
> been a labor of love for me.  Over the years it has rarely generated any
> income at all, and it usually does not cover my expenses -- most of the
> time
> it is a monthly loss for me.  The vast majority of my 60+ mailing lists
> have
> been hosted for free, at my expense (as is the ORACLE-L list, for example).
> Yet I have absorbed these costs because I enjoy hosting discussion lists
> and I know a lot of lists can't afford to pay for quality service.
>
> I am soon to be one of the Rhythms Orphans.  Rhythms, my DSL provider, has
> gone bankrupt and will be out of business by 10-Sep-2001.  I need to find
> another provider of high-speed Internet in order to continue operations.  I
> am at the point of either folding shop completely and going out of business
> myself, or trying to make Fat City a viable, money-making endeavor.  I need
> to make this decision by this Friday (for financial and planning reasons).
> After Friday, I am committed one way or the other.
>
> My upstream ISP and I are on very good terms, and in fact, I've been a
> customer of theirs since 1985!  As a result, they have graciously offered
> to help me out of this situation at considerable expense to themselves.
> I'm not at liberty to discuss the terms of the contract I would engage in
> with them, but suffice to say that is one of those once-in-a-lifetime
> opportunities that I'd be a fool to pass up.  I have this offer personally
> from the President of that company, if I want it.  Simply said, my ability
> to take them up on their offer and switch Fat City over to a dedicated T1
> or
> better solution revolves around being able to generate quite a bit of
> additional
> income per month, and very soon.  In an effort to be open and up-front with
> you folks about this, I basically need to generate an additional $500 more
> per
> month. Right now that seems daunting, but I've been working hard to line up
> that
> additional income, and I believe I can do it.  Just not right away.  My
> estimates are that it will take me four or five months to come up to that
> level.  I need to get out there and sell website hosting and list hosting
> packages, and get new customers.  That takes time, unfortunately.  I need a
> buffer to enable me to get past this startup phase.
>
> After some discussions with Jared (the list owner), and some encouragement
> from him, I am coming to you to ask for you help in keeping Fat City
> financially afloat until I can be self sufficient.  I'm not asking for a
> specific dollar amount from anyone, nor am I *expecting* anything from you
> folks.  But if it is within your power to contribute some money towards
> this
> end (and yes, I know these are hard financial times for everyone), I am
> hoping you can help.  If I can get sufficient promise of funds that will
> see
> me through the next few mo

RE: LinuxFS for Oracle

[Jacques Kilchoer]

Title: RE: LinuxFS for Oracle





> -Original Message-
> From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]
> 
> Oracle works on ReiserFS as well as on Ext2. My personal preference 
> was ReiserFS because of the abominable fsck times with my big 
> disks (32GB & 
> 20GB).


I am confused - did you choose ReiserFS because you wanted abominable fsck times, and that's what you got with ReiserFS, or because you wanted to avoid abominable fsck times, and abominable fsck times are a feature of Ext2 but not ReiserFS?

Re: char vs. varchar2

[Stephane Faroult]

"Terrian, Tom" wrote:
> 
> I think that this subject comes up now and then, but I don't remember the
> conclusions
> 
> We are creating a Data Warehouse and the subject of char vs varchar2 data types
> came up.  I searched google and found a little bit on the subject (mainly there
> is no space savings between char(1) and varchar2(1)).
> 
> Has anybody studied this?  For example:  If I know that all my data is 10
> characters wide, should I not create the field as char(10)?  Any reason to make
> it a varchar2(10)?  Would sql scripts (select and dml) be faster with one type
> or the other?  Any space savings with one type or the other (still given 10
> characters of fixed data)?
> 
> Thanks,
> Tom
> 
> Tom Terrian
> Oracle DBA
> WPAFB - DAASC
> [EMAIL PROTECTED]
> 937-656-3844

Tom,

  There is a somehow astonishingly little known - in spite of its having
been around for at least the 15 last years - SQL function named VSIZE()
which answers any question you may have about actual storage usage. For
the really inquisitive, you have DUMP() as well. 
-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: financial problems with fatcity.com

[Hillman, Alex]

I dont think $12 is worth even speak to management. 

Alex Hillman

-Original Message-
Sent: Wednesday, August 29, 2001 2:54 PM
To: Multiple recipients of list ORACLE-L


The only problem with having my damagement pay for a subscription for this
list is that they may find out where I get all my answers to some very
difficult problems!!  ;o)

Dave

-Original Message-
Sent: Wednesday, August 29, 2001 11:43 AM
To: Multiple recipients of list ORACLE-L


Whats that first part of your domain address there Alex  :-)

Perhaps you could help the list out !! 

-Original Message-
Sent: 29 August 2001 16:16
To: Multiple recipients of list ORACLE-L


I think that much better than voluntary contributions will be some
s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I
am sure that
everybody working with Oracle and living in US or UK or other developed
country can afford such fees. We will not need to charge people from
developing countries - I am sure these subscription fees will generate more
than $500 per month.

Alex Hillman

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Hillman, Alex
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: !! *Very* important Oracle-L message !!

[Cornio, Georgette Ms USACFSC]

Count me IN ...

-Original Message-
Sent: Wednesday, August 29, 2001 15:22
To: Multiple recipients of list ORACLE-L


Yes. $25 one-shot, $25 a year or "my fair share"

-Original Message-
Sent: Tuesday, August 28, 2001 6:29 PM
To: Multiple recipients of list ORACLE-L



Ok, now that I have your attention, please read the following message from
Bruce Bergman,
owner of fatcity.com.  It concerns the future of this list.

Please read the entire message before replying.

Thank you.

Jared Still  ( List Owner )


---

Hello ORACLE-L list members --

I would like to take a few minutes of your time for a "State of the Union"
address, if you can call it that.  This is a rather serious message, and I
request that you take the time to read this message entirely.  I've got a
problem that needs resolution this week, and I'm hoping you folks can help
me come to a conclusion.  This message turned out to be fairly
long-winded, so please excuse me for that. :-)

Fat City (fatcity.com) is my company, and I am the provider of the list
services that you receive ORACLE-L through.  I've been hosting Internet
mailing lists for over 10 years, and carry quite a few lists, including a
big selection of Oracle-related lists (14, in fact).  Fat City has always
been a labor of love for me.  Over the years it has rarely generated any
income at all, and it usually does not cover my expenses -- most of the
time
it is a monthly loss for me.  The vast majority of my 60+ mailing lists
have
been hosted for free, at my expense (as is the ORACLE-L list, for example).
Yet I have absorbed these costs because I enjoy hosting discussion lists
and I know a lot of lists can't afford to pay for quality service.

I am soon to be one of the Rhythms Orphans.  Rhythms, my DSL provider, has
gone bankrupt and will be out of business by 10-Sep-2001.  I need to find
another provider of high-speed Internet in order to continue operations.  I
am at the point of either folding shop completely and going out of business
myself, or trying to make Fat City a viable, money-making endeavor.  I need
to make this decision by this Friday (for financial and planning reasons).
After Friday, I am committed one way or the other.

My upstream ISP and I are on very good terms, and in fact, I've been a
customer of theirs since 1985!  As a result, they have graciously offered
to help me out of this situation at considerable expense to themselves.
I'm not at liberty to discuss the terms of the contract I would engage in
with them, but suffice to say that is one of those once-in-a-lifetime
opportunities that I'd be a fool to pass up.  I have this offer personally
from the President of that company, if I want it.  Simply said, my ability
to take them up on their offer and switch Fat City over to a dedicated T1
or
better solution revolves around being able to generate quite a bit of
additional
income per month, and very soon.  In an effort to be open and up-front with
you folks about this, I basically need to generate an additional $500 more
per
month. Right now that seems daunting, but I've been working hard to line up
that
additional income, and I believe I can do it.  Just not right away.  My
estimates are that it will take me four or five months to come up to that
level.  I need to get out there and sell website hosting and list hosting
packages, and get new customers.  That takes time, unfortunately.  I need a
buffer to enable me to get past this startup phase.

After some discussions with Jared (the list owner), and some encouragement
from him, I am coming to you to ask for you help in keeping Fat City
financially afloat until I can be self sufficient.  I'm not asking for a
specific dollar amount from anyone, nor am I *expecting* anything from you
folks.  But if it is within your power to contribute some money towards
this
end (and yes, I know these are hard financial times for everyone), I am
hoping you can help.  If I can get sufficient promise of funds that will
see
me through the next few months, I am willing to jump in with both feet and
make Fat City a viable business.  If it looks like the contributions are
not
sufficient to enable me to do that, I will cease operations within the next
45-60 days.

Let me be clear about a few things: If I *do* cease operations, I will give
all of my lists time to find new list providers, and will make every effort
to aid the shift over to the new provider, provide list dumps, archives,
mail forwarding, etc.  Even though Rhythms goes out of business on
10-Sep-2001, I have secured service until at least 10-Oct-2001 to enable
this to happen.  So don't worry about having to rush into your conversion
if
things don't work out.  I would also like to clearly state that this is not
some attempt to blackmail or coerce anyone into coming up with money.  This
will either succeed or fail based on what you folks can comfortably and
willingly contribute.  If I had the ability to cover this start

RE: Novice Question

[Jacques Kilchoer]

Title: RE: Novice Question





> -Original Message-
> From: Kishore [mailto:[EMAIL PROTECTED]]
> 
> I am in a position to export a user and drop it then
> create again and import it. Why I am doing this is
> because I want to change the default tablespace of the
> user to a different one and also its tabel are out of
> extents. 
> 
> Now , my question ; may be very stupid though, Would
> it break anything like indexes and views depends on
> it. Once imported back everything would be same as it
> was before.
> 
> Is there a way I know how many views , indexes and
> every other objects depend on this user before even I
> export.


The views and source code will need to be recompiled after the import.
alter view view_name compile ;
alter procedure procedure_name compile ;
alter function function_name compile ;
alter package package_name compile body ;



Objects owned by the user:
select object_type, count (*)
from dba_objects
where owner = 'USER_NAME' ;


dependencies to objects owned by that user:
(this will show views and source code)
select owner, name, type
from dba_dependencies
where referenced_owner = 'USER_NAME'


synonyms to objects owned by that user:
select owner, synonym_name
from dba_synonyms
where table_owner = 'USER_NAME' ;


indexes on tables owned by that user:
select owner, index_name
from dba_indexes
where table_owner = 'USER_NAME' ;


Jacques R. Kilchoër
x8816> 

RE: How to loop call to SQL script in PL/SQL...

[Koivu, Lisa]

Title: RE: How to loop call to SQL script in PL/SQL...





Denmark, 


Every 5 seconds??  That's going to put an awful load on your database, dont'cha think?  That's also going to be a very large file.  We tried this a few months ago when jrun was acting suspect and we were getting a bunch of zombies.  We could barely make sense of the log files.  Lucky for me I had a sysadmin/perl hacker to write something that searched the log files appropriately.  I don't have that code. 

Are you looking for current/last executed sql statement?  That's what this will give you.  You may have to work it to exclude your current statement. 

You can schedule it to run on your host (unix or windoze) like this


sqlplus user/pw@sid < sessql.sql >> sessql.log


set linesize 2000
set pagesize 2000
column username format a15
column s.sid format 9
column s.serial# format 9
column client_program format a12
column sql_text format a85



select
    s.username,
    s.sid,
--  s.machine,
    t.sql_text
from v$session s, v$process p, v$sqltext t
where s.username is not null
    and p.addr = s.paddr
    and t.address = s.sql_address
order by 1,2,t.piece
/
EXIT
/





HTH
Lisa Koivu
Vikings Fan and DBA
Ft. Lauderdale, FL, USA




-Original Message-
From:   Denmark Weatherburne [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, August 29, 2001 3:27 PM
To: Multiple recipients of list ORACLE-L
Subject:    How to loop call to SQL script in PL/SQL...


Hi DBA's & Developers,


I first tried to call a batch file which calls SQL*Plus and executes an SQL 
script from within Perl, but I had no success.
Perhaps I'm taking the wrong approach.
I'm sure it can be done using PL/SQL.
I want to run an SQL script repeatedly every 5 seconds throughout the day to 
capture the SQL statements that are being parsed by the Oracle engine and 
spool the results to a disk file.
I would appreciate your help in sending me the PL/SQL code to accomplish 
this task.
I don't have mush experience using PL/SQL, but I am prepared to learn.


Thanks in advance for the help.


Regards,


Denmark Weatherburne
"Knowledge is power, but it is only usefule if it is shared!"



_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


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


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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: Lisa

[Koivu, Lisa]

Title: OT: Lisa





Nothing wrong with combining a technical discussion with a bit of humor :)  Tell me if I'm wrong !


-Original Message-
From:   Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, August 29, 2001 4:12 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: Lisa


I have been noticing this as well, Bootylicious?  hehheh


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Stephen Andert
Sent: Wednesday, August 29, 2001 3:16 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Lisa




Lisa, do you have a file of "titles" or do you keep coming up with new ones?  I read your messages just to see things like:

Dog Bone Administrator
The Bootylicious DBA
and many more


 


Stephen
No funny sig line

RE: !! Keeping the list alive - part deux

[George Hofilena]

Jared,

Count me in for $20 (for now).

George

-Original Message-
Sent: Wednesday, August 29, 2001 11:49 AM
To: Multiple recipients of list ORACLE-L



Forgot one question;


Q.  I would love to help, can I remain anonymous?
A. Certainly.  We have no intention of publishing contributors.



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: George Hofilena
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: financial problems with fatcity.com

[Boivin, Patrice J]

Do we get a t-shirt, like for PBS? 

My 5-year old son got a great DragonTales t-shirt.

Now we have to think of a caption for the t-shirt.

: )

I am willing to pledge some money as well, in US$ of course.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: !! *Very* important Oracle-L message !!

[Orr, Steve]

I like Jeremiah's idea. 

All the "sermonizing" about the value of the list and how we should be
required to put something in the "offering basket" is just so much
"preaching to the choir."  :-)

I would gladly pay a subscription fee because I understand the value of the
list after having been on it a few years. HOWEVER, a newcomer may not
appreciate the value of the list without having seen any content over time
(as we all have). Requiring an up front entrance fee would probably scare
them off like "fire and brimstone sermon." If entrance to the list is free
then we can better "evangelize new believers" in the list. Broad
participation keeps the list healthy. In order to keep the list healthy we
need to be constantly adding new members and the best way to do this is to
make it free and easy. Another approach would be to make the first 6 months
free but this could be an administrative burden to enforce. So I think
voluntary contributions are the way to go... Do I have an "Amen?"

IMHO,
Steve Orr


-Original Message-
Sent: Wednesday, August 29, 2001 11:27 AM
To: Multiple recipients of list ORACLE-L


On my web page I maintain an Amazon.com payments paybox, which is for
collecting anonymous donations.  I think if Bruce sets up a paybox for
each list he hosts free of charge, and included a pledge request in
the list footers, there will be a steady stream of donations.

Amazon calls this the "Honor System," and it can be found at:

http://auctions.amazon.com/exec/varzea/subst/fx/home.html

It is basically like paypal, etc, but you can put the paybox inline
with any HTML, and it allows anonymous donations. The fee to Amazon is
15% of the total payment per transaction plus 15 cents.

I work for Amazon, so feel free to flame me for shamelessly promoting
my own product as a solution to this.  As an act of contrition, I
promise to pay US$50 into any form of collection that Bruce sets up,
Amazon or not.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Wed, 29 Aug 2001, Anjan Thakuria wrote:

> Can we just start pledging ..We have got to keep this form going under.
Ideas
>
> > -Original Message-
> > Sent: 28 August 2001 23:29
> > To: Multiple recipients of list ORACLE-L
> >
> > Ok, now that I have your attention, please read the following message
from
> > Bruce Bergman,
> > owner of fatcity.com.  It concerns the future of this list.
> >
> > Please read the entire message before replying.
> >
> > ---
> >
> > Hello ORACLE-L list members --
> >
> > I would like to take a few minutes of your time for a "State of the
Union"
> > address, if you can call it that.  This is a rather serious message, and
I
> > request that you take the time to read this message entirely.  I've got
a
> > problem that needs resolution this week, and I'm hoping you folks can
help
> > me come to a conclusion.  This message turned out to be fairly
> > long-winded, so please excuse me for that. :-)
> >
> > Fat City (fatcity.com) is my company, and I am the provider of the list
> > services that you receive ORACLE-L through.  I've been hosting Internet
> > mailing lists for over 10 years, and carry quite a few lists, including
a
> > big selection of Oracle-related lists (14, in fact).  Fat City has
always
> > been a labor of love for me.  Over the years it has rarely generated any
> > income at all, and it usually does not cover my expenses -- most of the
> > time
> > it is a monthly loss for me.  The vast majority of my 60+ mailing lists
> > have
> > been hosted for free, at my expense (as is the ORACLE-L list, for
example).
> > Yet I have absorbed these costs because I enjoy hosting discussion lists
> > and I know a lot of lists can't afford to pay for quality service.
> >
> > I am soon to be one of the Rhythms Orphans.  Rhythms, my DSL provider,
has
> > gone bankrupt and will be out of business by 10-Sep-2001.  I need to
find
> > another provider of high-speed Internet in order to continue operations.
I
> > am at the point of either folding shop completely and going out of
business
> > myself, or trying to make Fat City a viable, money-making endeavor.  I
need
> > to make this decision by this Friday (for financial and planning
reasons).
> > After Friday, I am committed one way or the other.
> >
> > My upstream ISP and I are on very good terms, and in fact, I've been a
> > customer of theirs since 1985!  As a result, they have graciously
offered
> > to help me out of this situation at considerable expense to themselves.
> > I'm not at liberty to discuss the terms of the contract I would engage
in
> > with them, but suffice to say that is one of those once-in-a-lifetime
> > opportunities that I'd be a fool to pass up.  I have this offer
personally
> > from the President of that company, if I want it.  Simply said, my
ability
> > to take them up on their offer and switch Fat City over to a dedicated
T1
> > or
> > better solution revolves around being able to generate quite a bit of
> 

RE: results of analyze

[Jacques Kilchoer]

Title: RE: results of analyze





> -Original Message-
> From: Ruth Gramolini [mailto:[EMAIL PROTECTED]]
> 
> Someone asked me where the results of analying tables and 
> indexes goes.  Can
> anyone tell me what table(s) holds the statistics generated.


I think this is a complete answer. If I've forgotten anything, please let me know, since this is the list I give out to people.

Sys views:    Tables
dba_tables    sys.tab$
dba_tab_columns   sys.hist_head$
dba_tab_col_statistics


dba_tab_histograms    sys.hist_head$
  sys.histgrm$


dba_tab_partitions    sys.tabpart$
  sys.tabcompart$


dba_tab_subpartitions sys.tabsubpart$


dba_indexes   sys.ind$


dba_ind_partitions    sys.indpart$
  sys.indcompart$


dba_ind_subpartitions sys.indsubpart$


Jacques R. Kilchoër
x8816> 

Re: awk, sed, windoze, sql*loader, other fun stuff

[Randy Pace]

Title: awk, sed, windoze, sql*loader, other fun stuff



One site that has the main Unix tools is http://virtunix.itribe.net/.
 
I have them and use them all the time.
 
 
Randy Pace Phone 801 495 9300 9662 S 700 E 
  Fax 801 495 9301 Sandy, Utah 84070 
   email [EMAIL PROTECTED]

  - Original Message - 
  From: 
  Koivu, Lisa 
  To: Multiple recipients of list ORACLE-L 
  Sent: Wednesday, August 29, 2001 12:26 
  PM
  Subject: awk, sed, windoze, sql*loader, 
  other fun stuff
  
  Hello all, 
  I'm working on sql*loader scripts and I 
  realize that I'd probably be DONE by now if I had awk and sed to use.  Of 
  course, as unix-deficient as I am, I don't have it.  Does anyone know of 
  a windows version of these utilities?  
  Also I seem to remember someone had 
  created a dynamic create-control-file-based-on-a-table script in the past and 
  shared it with the list.  Does anyone remember where that was?  
  
  Gracias 
  Lisa Koivu The Bootylicious DBA Ft. Lauderdale, FL, USA 

!! Keeping the list alive - part deux

[Jared . Still]

Forgot one question;


Q.  I would love to help, can I remain anonymous?
A. Certainly.  We have no intention of publishing contributors.



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: 817 Intermedia on AIX

[Ron Rogers]

"The Bootylicious " "Gimme a PC and I'll Break It, Guaranteed" "The MONkey"
Boy ! arn't we busy today.
ROR mô¿ôm

>>> [EMAIL PROTECTED] 08/29/01 01:57PM >>>
Also - I ran into this problem on hp/ux:  you may have to create the library
hard coded with the oracle home path.  REferencing $ORACLE_HOME (in
user_libraries) did not work.

Lisa Koivu
The Bootylicious DBA
Ft. Lauderdale, FL, USA

> -Original Message-
> From: Mike J Kurth [SMTP:[EMAIL PROTECTED]] 
> Sent: Wednesday, August 29, 2001 11:21 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: 817 Intermedia on AIX
> 
> 
> You may want to connect as ctxsys and query the user_libraries view
> to make sure the library paths are pointing to your new 8.1.7 Oracle_home.
> Just a thought.
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: Mike J Kurth
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
--
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: !! *Very* important Oracle-L message !!

[Kirsch, Walter J, PERSCOM]

Yes. $25 one-shot, $25 a year or "my fair share"

-Original Message-
Sent: Tuesday, August 28, 2001 6:29 PM
To: Multiple recipients of list ORACLE-L



Ok, now that I have your attention, please read the following message from
Bruce Bergman,
owner of fatcity.com.  It concerns the future of this list.

Please read the entire message before replying.

Thank you.

Jared Still  ( List Owner )


---

Hello ORACLE-L list members --

I would like to take a few minutes of your time for a "State of the Union"
address, if you can call it that.  This is a rather serious message, and I
request that you take the time to read this message entirely.  I've got a
problem that needs resolution this week, and I'm hoping you folks can help
me come to a conclusion.  This message turned out to be fairly
long-winded, so please excuse me for that. :-)

Fat City (fatcity.com) is my company, and I am the provider of the list
services that you receive ORACLE-L through.  I've been hosting Internet
mailing lists for over 10 years, and carry quite a few lists, including a
big selection of Oracle-related lists (14, in fact).  Fat City has always
been a labor of love for me.  Over the years it has rarely generated any
income at all, and it usually does not cover my expenses -- most of the
time
it is a monthly loss for me.  The vast majority of my 60+ mailing lists
have
been hosted for free, at my expense (as is the ORACLE-L list, for example).
Yet I have absorbed these costs because I enjoy hosting discussion lists
and I know a lot of lists can't afford to pay for quality service.

I am soon to be one of the Rhythms Orphans.  Rhythms, my DSL provider, has
gone bankrupt and will be out of business by 10-Sep-2001.  I need to find
another provider of high-speed Internet in order to continue operations.  I
am at the point of either folding shop completely and going out of business
myself, or trying to make Fat City a viable, money-making endeavor.  I need
to make this decision by this Friday (for financial and planning reasons).
After Friday, I am committed one way or the other.

My upstream ISP and I are on very good terms, and in fact, I've been a
customer of theirs since 1985!  As a result, they have graciously offered
to help me out of this situation at considerable expense to themselves.
I'm not at liberty to discuss the terms of the contract I would engage in
with them, but suffice to say that is one of those once-in-a-lifetime
opportunities that I'd be a fool to pass up.  I have this offer personally
from the President of that company, if I want it.  Simply said, my ability
to take them up on their offer and switch Fat City over to a dedicated T1
or
better solution revolves around being able to generate quite a bit of
additional
income per month, and very soon.  In an effort to be open and up-front with
you folks about this, I basically need to generate an additional $500 more
per
month. Right now that seems daunting, but I've been working hard to line up
that
additional income, and I believe I can do it.  Just not right away.  My
estimates are that it will take me four or five months to come up to that
level.  I need to get out there and sell website hosting and list hosting
packages, and get new customers.  That takes time, unfortunately.  I need a
buffer to enable me to get past this startup phase.

After some discussions with Jared (the list owner), and some encouragement
from him, I am coming to you to ask for you help in keeping Fat City
financially afloat until I can be self sufficient.  I'm not asking for a
specific dollar amount from anyone, nor am I *expecting* anything from you
folks.  But if it is within your power to contribute some money towards
this
end (and yes, I know these are hard financial times for everyone), I am
hoping you can help.  If I can get sufficient promise of funds that will
see
me through the next few months, I am willing to jump in with both feet and
make Fat City a viable business.  If it looks like the contributions are
not
sufficient to enable me to do that, I will cease operations within the next
45-60 days.

Let me be clear about a few things: If I *do* cease operations, I will give
all of my lists time to find new list providers, and will make every effort
to aid the shift over to the new provider, provide list dumps, archives,
mail forwarding, etc.  Even though Rhythms goes out of business on
10-Sep-2001, I have secured service until at least 10-Oct-2001 to enable
this to happen.  So don't worry about having to rush into your conversion
if
things don't work out.  I would also like to clearly state that this is not
some attempt to blackmail or coerce anyone into coming up with money.  This
will either succeed or fail based on what you folks can comfortably and
willingly contribute.  If I had the ability to cover this startup period
myself,
I would definitely do so.  If Fat City ultimately goes under, it wil NOT be
your fault, and I hold no one to 

OT: RE: 817 Intermedia on AIX

[JOE TESTA]

I'd thought bootylicious would refer to Jennifer Lopez.
 
joe
>>> [EMAIL PROTECTED] 08/29/01 02:42PM 
>>>"The Bootylicious " "Gimme a PC and I'll Break It, Guaranteed" 
"The MONkey"Boy ! arn't we busy today.ROR mô¿ôm>>> 
[EMAIL PROTECTED] 08/29/01 01:57PM >>>Also - I ran into 
this problem on hp/ux:  you may have to create the libraryhard coded 
with the oracle home path.  REferencing $ORACLE_HOME (inuser_libraries) 
did not work.Lisa KoivuThe Bootylicious DBAFt. Lauderdale, FL, 
USA> -Original Message-> From:    Mike 
J Kurth [SMTP:[EMAIL PROTECTED]] > Sent:    Wednesday, 
August 29, 2001 11:21 AM> To:    Multiple recipients of 
list ORACLE-L> Subject:    Re: 817 Intermedia on 
AIX> > > You may want to connect as ctxsys and query the 
user_libraries view> to make sure the library paths are pointing to your 
new 8.1.7 Oracle_home.> Just a thought.> > > 
> -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > 
Author: Mike J Kurth>   INET: [EMAIL PROTECTED] > 
> Fat City Network Services    -- (858) 538-5051  
FAX: (858) 538-5051> San Diego, 
California    -- Public Internet access / 
Mailing Lists> 
> 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.com--Author: Ron 
Rogers  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
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).

OT: RE: financial problems with fatcity.com

[Jacques Kilchoer]

Title: OT: RE: financial problems with fatcity.com





-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]


>Alex, that is an excellent idea! I second that notion. 



"doh.state.fl.us"? Does that University count Homere Simpson amongst its proud alumni?



Please excuse the long e-mail, but since the suggestion has been made to make this a "subscription" list, I will share some of the issues that I am grappling with (along with others) as part of a volunteer moderator at an internet message board, where we are currently debating a fee-based message board instead of free membership.

My personal opinion (though of course this would be Mr. Still and Mr. Bergman's decision) is that having a "subscription" list would be very hard to manage. If someone who has provided valuable responses (e.g. a Steve Adams) doesn't pay his fee, do you immediately unsubscribe him from the list? Do you prevent him from posting an answer? What's the grace period for non-payment of fees? Would there be a trial period, or would you have to pay before you can even see what the list is like? Paying before you can see the content would diminish new membership, and new membership is essential to the survival of a list such as this one. If you have a free introductory period, I could sign up with a different "free" e-mail (e.g. hotmail) every month and never pay. Only the "honest" people would pay, which would end up being the same as asking for voluntary donations.

Another issue - how many people would go try out another "free" list? Charging a fee may mean the demise of this list. I think that the list is worth a modest fee, but what percentage of the membership will think so?

What if a person has paid for membership, but is posting messages disruptive to the list (e.g. spam or insults.) Do you refund their fee when you remove them from the list? Do they have more rights as a "paying customer"?

How about the archives? Would you have to pay to see them? What about people that always ask questions, but never answer any? Would they be charged more? Would some of our "experts" become resentful since they are paying Mr. Bergman and giving out more information than they are receiving? I can very well imagine a person thinking "why should I give out free answers when Mr. Bergman 'profits' from my expertise?" (Of course I realize that there is very little, if any, 'profit' involved, but some people may not be convinced of that.)

These are all difficult questions that would be faced by the person maintaining the list. Without charging enough to make the list profitable, it might not be worth the headache.

Re: !! *Very* important Oracle-L message !!

[Riyaj_Shamsudeen]

-->I am willing to donate up to $5 per month for up to 6 months paid either monthly or a lump sum depending on what he needs.
-->Just like in Public Television or Radio, I challenge everyone on the list to join me with an equal pledge.

Count me in...

Jarad/Bruce
        Please let us know how you want us to pay.. We will act accordingly.

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com






"John Carlson" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/29/01 12:51 PM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: !! *Very* important Oracle-L message !!


As I see it, he needs $500 per month for 4 or 5 months.  Lets just round that to 6 months times $500 or $3000.
 
I don't know how many people are on his 60+ mailing list but just guessing, I believe if only 1/4th the people contributed $1 per month for 6 months or just $6 that would cover it.
 
I am willing to donate up to $5 per month for up to 6 months paid either monthly or a lump sum depending on what he needs.
Just like in Public Television or Radio, I challenge everyone on the list to join me with an equal pledge.
 
Regards,
John Carlson
[EMAIL PROTECTED]
http://www.cj.com


>>> [EMAIL PROTECTED] 08/28/01 03:28PM >>>

Ok, now that I have your attention, please read the following message from
Bruce Bergman,
owner of fatcity.com.  It concerns the future of this list.

Please read the entire message before replying.

Thank you.

Jared Still  ( List Owner )


---

Hello ORACLE-L list members --

I would like to take a few minutes of your time for a "State of the Union"
address, if you can call it that.  This is a rather serious message, and I
request that you take the time to read this message entirely.  I've got a
problem that needs resolution this week, and I'm hoping you folks can help
me come to a conclusion.  This message turned out to be fairly
long-winded, so please excuse me for that. :-)

Fat City (fatcity.com) is my company, and I am the provider of the list
services that you receive ORACLE-L through.  I've been hosting Internet
mailing lists for over 10 years, and carry quite a few lists, including a
big selection of Oracle-related lists (14, in fact).  Fat City has always
been a labor of love for me.  Over the years it has rarely generated any
income at all, and it usually does not cover my expenses -- most of the
time
it is a monthly loss for me.  The vast majority of my 60+ mailing lists
have
been hosted for free, at my expense (as is the ORACLE-L list, for example).
Yet I have absorbed these costs because I enjoy hosting discussion lists
and I know a lot of lists can't afford to pay for quality service.

I am soon to be one of the Rhythms Orphans.  Rhythms, my DSL provider, has
gone bankrupt and will be out of business by 10-Sep-2001.  I need to find
another provider of high-speed Internet in order to continue operations.  I
am at the point of either folding shop completely and going out of business
myself, or trying to make Fat City a viable, money-making endeavor.  I need
to make this decision by this Friday (for financial and planning reasons).
After Friday, I am committed one way or the other.

My upstream ISP and I are on very good terms, and in fact, I've been a
customer of theirs since 1985!  As a result, they have graciously offered
to help me out of this situation at considerable expense to themselves.
I'm not at liberty to discuss the terms of the contract I would engage in
with them, but suffice to say that is one of those once-in-a-lifetime
opportunities that I'd be a fool to pass up.  I have this offer personally
from the President of that company, if I want it.  Simply said, my ability
to take them up on their offer and switch Fat City over to a dedicated T1
or
better solution revolves around being able to generate quite a bit of
additional
income per month, and very soon.  In an effort to be open and up-front with
you folks about this, I basically need to generate an additional $500 more
per
month. Right now that seems daunting, but I've been working hard to line up
that
additional income, and I believe I can do it.  Just not right away.  My
estimates are that it will take me four or five months to come up to that
level.  I need to get out there and sell website hosting and list hosting
packages, and get new customers.  That takes time, unfortunately.  I need a
buffer to enable me to get past this startup phase.

After some discussions with Jared (the list owner), and some encouragement
from him, I am coming to you to ask for you help in keeping Fat City
financially afloat until I can be self sufficient.  I'm not asking for a
specific dollar amount from anyone, nor am I *expecting* anything from you
folks.  But if it is within your power to contribute some money towards
this
end (and yes, I know these are hard financial times for eve

RE: !! Keeping the list alive - part deux

[TCarlson]

Dido.

Todd Carlson
Oracle 8i Certified DBA
Bunge North America


   

   

   GeorgeTo: Multiple recipients of list ORACLE-L  

Hofilena  <[EMAIL PROTECTED]>   

Subject: RE: !! Keeping the list alive - 
part 
Sent by:  deux 

[EMAIL PROTECTED] 

om 

   

   

   08/29/2001  

02:27 PM   

   Please  

respond to 

ORACLE-L   

   

   





Jared,

Count me in for $20 (for now).

George

-Original Message-
Sent: Wednesday, August 29, 2001 11:49 AM
To: Multiple recipients of list ORACLE-L



Forgot one question;


Q.  I would love to help, can I remain anonymous?
A. Certainly.  We have no intention of publishing contributors.



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: George Hofilena
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: financial problems with fatcity.com

[Gogala, Mladen]

I second that. The amount is more then reasonable and the value that 
this list provides is extremely high.

> -Original Message-
> From: Kevin Lange [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 29, 2001 12:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: financial problems with fatcity.com
> 
> 
> I for one would even agree to , say , a 25$ a year fee.   
> This is a very
> good site and there are a lot of good ideas bandied about 
> here every day.
> 
> Kevin
> 
> -Original Message-
> Sent: Wednesday, August 29, 2001 10:16 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I think that much better than voluntary contributions will be some
> s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better 
> $12 per year. I
> am sure that
> everybody working with Oracle and living in US or UK or other 
> developed
> country can afford such fees. We will not need to charge people from
> developing countries - I am sure these subscription fees will 
> generate more
> than $500 per month.
> 
> Alex Hillman
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Hillman, Alex
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
> -- 
> Author: Kevin Lange
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

char vs. varchar2

[Terrian, Tom]

I think that this subject comes up now and then, but I don't remember the
conclusions

We are creating a Data Warehouse and the subject of char vs varchar2 data types
came up.  I searched google and found a little bit on the subject (mainly there
is no space savings between char(1) and varchar2(1)).

Has anybody studied this?  For example:  If I know that all my data is 10
characters wide, should I not create the field as char(10)?  Any reason to make
it a varchar2(10)?  Would sql scripts (select and dml) be faster with one type
or the other?  Any space savings with one type or the other (still given 10
characters of fixed data)?

Thanks,
Tom

Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844 

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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 loop call to SQL script in PL/SQL...

[Denmark Weatherburne]

Hi DBA's & Developers,

I first tried to call a batch file which calls SQL*Plus and executes an SQL 
script from within Perl, but I had no success.
Perhaps I'm taking the wrong approach.
I'm sure it can be done using PL/SQL.
I want to run an SQL script repeatedly every 5 seconds throughout the day to 
capture the SQL statements that are being parsed by the Oracle engine and 
spool the results to a disk file.
I would appreciate your help in sending me the PL/SQL code to accomplish 
this task.
I don't have mush experience using PL/SQL, but I am prepared to learn.

Thanks in advance for the help.

Regards,

Denmark Weatherburne
"Knowledge is power, but it is only usefule if it is shared!"


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: financial problems with fatcity.com

[Mark Leith]

Just had a chat to the boss, and we would happily pay $10 per month for the
"service", provided that there was an easy way for us to pay for it such as
a credit card since we are based in England.

Regards

Mark

-Original Message-
Sent: Wednesday, August 29, 2001 16:48
To: Multiple recipients of list ORACLE-L


How about Corporate Sponsorship?




-Original Message-
Sent: Wednesday, August 29, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L


I think that much better than voluntary contributions will be some
s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I
am sure that
everybody working with Oracle and living in US or UK or other developed
country can afford such fees. We will not need to charge people from
developing countries - I am sure these subscription fees will generate more
than $500 per month.

Alex Hillman

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Haskins, Ed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Upgrade of database

[JOE TESTA]

its called the migration guide.
 
joe
>>> [EMAIL PROTECTED] 08/29/01 11:48AM 
>>>Can anyone point me towards the documentation for upgrading 
Oracle 8i, from8.1.6to 8.1.7.Thanks in advanceSteven 
H.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Steven 
Hovington  INET: [EMAIL PROTECTED]Fat City 
Network Services    -- (858) 538-5051  FAX: (858) 
538-5051San Diego, California    -- 
Public Internet access / Mailing 
ListsTo 
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).

RE: Lisa

[Stephen Andert]

Lisa, do you have a file of "titles" or do 
you keep coming up with new ones?  I read your messages just to see things 
like:
Dog Bone AdministratorThe Bootylicious DBA and many more
 
StephenNo funny sig line

RE: !! *Very* important Oracle-L message !!

[Mohammad Rafiq]

It is good start...I think we all should start sending min $20(for USA) and 
UKL 15 (for UK) to Jared/Bruce once we have address
Regards


MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 29 Aug 2001 08:50:55 -0800

Just publish the address where to send the money orders to
and my $20 will be on it's way tomorrow.

 > -Original Message-
 > From: Anjan Thakuria [mailto:[EMAIL PROTECTED]]
 > Sent: Wednesday, August 29, 2001 11:21 AM
 > To: Multiple recipients of list ORACLE-L
 > Subject: Re: !! *Very* important Oracle-L message !!
 >
 >
 > Can we just start pledging ..We have got to keep this form
 > going under. Ideas
 > .
 >
 > Anjan
 >
 > Jenner Mike wrote:
 >
 > > -Original Message-
 > > Sent: 28 August 2001 23:29
 > > To: Multiple recipients of list ORACLE-L
 > >
 > > Ok, now that I have your attention, please read the
 > following message from
 > > Bruce Bergman,
 > > owner of fatcity.com.  It concerns the future of this list.
 > >
 > > Please read the entire message before replying.
 > >
 > > Thank you.
 > >
 > > Jared Still  ( List Owner )
 > >
 > > ---
 > >
 > > Hello ORACLE-L list members --
 > >
 > > I would like to take a few minutes of your time for a
 > "State of the Union"
 > > address, if you can call it that.  This is a rather serious
 > message, and I
 > > request that you take the time to read this message
 > entirely.  I've got a
 > > problem that needs resolution this week, and I'm hoping you
 > folks can help
 > > me come to a conclusion.  This message turned out to be fairly
 > > long-winded, so please excuse me for that. :-)
 > >
 > > Fat City (fatcity.com) is my company, and I am the provider
 > of the list
 > > services that you receive ORACLE-L through.  I've been
 > hosting Internet
 > > mailing lists for over 10 years, and carry quite a few
 > lists, including a
 > > big selection of Oracle-related lists (14, in fact).  Fat
 > City has always
 > > been a labor of love for me.  Over the years it has rarely
 > generated any
 > > income at all, and it usually does not cover my expenses --
 > most of the
 > > time
 > > it is a monthly loss for me.  The vast majority of my 60+
 > mailing lists
 > > have
 > > been hosted for free, at my expense (as is the ORACLE-L
 > list, for example).
 > > Yet I have absorbed these costs because I enjoy hosting
 > discussion lists
 > > and I know a lot of lists can't afford to pay for quality service.
 > >
 > > I am soon to be one of the Rhythms Orphans.  Rhythms, my
 > DSL provider, has
 > > gone bankrupt and will be out of business by 10-Sep-2001.
 > I need to find
 > > another provider of high-speed Internet in order to
 > continue operations.  I
 > > am at the point of either folding shop completely and going
 > out of business
 > > myself, or trying to make Fat City a viable, money-making
 > endeavor.  I need
 > > to make this decision by this Friday (for financial and
 > planning reasons).
 > > After Friday, I am committed one way or the other.
 > >
 > > My upstream ISP and I are on very good terms, and in fact,
 > I've been a
 > > customer of theirs since 1985!  As a result, they have
 > graciously offered
 > > to help me out of this situation at considerable expense to
 > themselves.
 > > I'm not at liberty to discuss the terms of the contract I
 > would engage in
 > > with them, but suffice to say that is one of those
 > once-in-a-lifetime
 > > opportunities that I'd be a fool to pass up.  I have this
 > offer personally
 > > from the President of that company, if I want it.  Simply
 > said, my ability
 > > to take them up on their offer and switch Fat City over to
 > a dedicated T1
 > > or
 > > better solution revolves around being able to generate
 > quite a bit of
 > > additional
 > > income per month, and very soon.  In an effort to be open
 > and up-front with
 > > you folks about this, I basically need to generate an
 > additional $500 more
 > > per
 > > month. Right now that seems daunting, but I've been working
 > hard to line up
 > > that
 > > additional income, and I believe I can do it.  Just not
 > right away.  My
 > > estimates are that it will take me four or five months to
 > come up to that
 > > level.  I need to get out there and sell website hosting
 > and list hosting
 > > packages, and get new customers.  That takes time,
 > unfortunately.  I need a
 > > buffer to enable me to get past this startup phase.
 > >
 > > After some discussions with Jared (the list owner), and
 > some encouragement
 > > from him, I am coming to you to ask for you help in keeping Fat City
 > > financially afloat until I can be self sufficient.  I'm not
 > asking for a
 > > specific dollar amount from anyone, nor am I *expecting*
 > anything from you
 > > folks.  But if it is within your power to contribute some
 > money towards
 > > this
 > > end (and yes, I know these are hard financial times for
 > everyone), I am
 >

RE: financial problems with fatcity.com

[Ron Rogers]

I for one have learned a lot from this list. Heck ,I 've also learned how much I don't 
know. There is a lot of valuable information to be gleaned from this list and I has 
helped me with my learning curve. I do not have a budget item for open training here 
or I would apply it to the list to help. I'm the kind of guy that will pay for 
shareware if it fits a need and works as promised. I will be more than happy to donate 
to help keep the list solvent.
 I know that it is a nightmare to manage subscriptions and time based payments. If the 
route chosen is a subscription type, I suggest that the payment would be due on a 
yearly basis and the same due date for all (like IOUG-A).
I pledge the amount that the list and administrators feel is appropriate.
Ronald O. Rogers
ROR mô¿ôm



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: LinuxFS for Oracle

[Gogala, Mladen]

Oracle works on ReiserFS as well as on Ext2. My personal preference 
was ReiserFS because of the abominable fsck times with my big disks (32GB & 
20GB). I don't see much overhead. With UDMA3/66 enabled, my disks are
performing
extremely well. Having 384 MB RAM also helps a bit. On the other hand, I am
a DBA and I only have  oracle database to test & explore cool new features,
i.e.
I don't do any real work (which is a streak shared by all DBAs). 
If you put a real database with real users on such a box, please let me 
know how is it going.

> -Original Message-
> From: Bill Buchan [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 29, 2001 11:48 AM
> To: Multiple recipients of list ORACLE-L
> Subject: LinuxFS for Oracle
> 
> 
> 
> I am about to attempt an Oracle installation on SuSE Linux 
> 7.2.  I need to 
> pick a file-system: ext2 or reiserfs.
> Does anyone have any comments to share?
> 
> All I can see from the docs is:
> "Oracle8i Server must be able to verify that file writes have 
> been made to 
> disk. File
> systems that do not support this verification are not 
> supported for use 
> with Oracle
> databases, although Oracle software can be installed on them."
> 
> My knowledge of how the 2 filesystems is 0.  I'd be very 
> grateful for any 
> advice and/or interpretation.
> 
> Thanks
> - Bill.
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Bill Buchan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

awk, sed, windoze, sql*loader, other fun stuff

[Koivu, Lisa]

Title: awk, sed, windoze, sql*loader, other fun stuff





Hello all, 


I'm working on sql*loader scripts and I realize that I'd probably be DONE by now if I had awk and sed to use.  Of course, as unix-deficient as I am, I don't have it.  Does anyone know of a windows version of these utilities?  

Also I seem to remember someone had created a dynamic create-control-file-based-on-a-table script in the past and shared it with the list.  Does anyone remember where that was?  

Gracias


Lisa Koivu
The Bootylicious DBA
Ft. Lauderdale, FL, USA

!! *Very* important Oracle-L message !!

[James Howerton]

Jared,

I'm in for $12.





Jim Howerton
Senior Oracle DBA
University of Alabama at Birmingham
Health System Information Services
e: [EMAIL PROTECTED] 
v: 205-934-9111
f: 205-934-0632


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Spooling output of a select statement to a file through stored

[Mohammad Rafiq]

Do not forget 'grant execute on utl_file to apps_user' before running..

MOHAMMAD RAFIQ

Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 29 Aug 2001 08:21:20 -0800


Ranganath,

First you have to specify a place where Oracle may write the file.  You do
this by setting the UTL_DIR parameter in your init.ora file.  Make
sure that the Oracle user has write permission on the directory(ies) you
specify.  You'll need to bounce the DB to have this parameter take effect.

Your code will look something like this(this is for an NT Box):

CREATE or REPLACE .
AS
   CURSOR XXX IS..

 vocstu_report utl_file.file_type;

BEGIN

 vocstu_report:= utl_file.fopen('F:
\oracle\admin\reports','vocstu_report.txt','W');

(All your processing here)

utl_file.put_line(vocstu_report,
 RPAD(v_lastname,25,' ') ||
 RPAD(v_firstname,15,' ') ||
 RPAD(v_gender,6,' ') ||
 RPAD(v_grade,5,' ') ||
 RPAD(v_ethniccode,6,' ') ||
 RPAD(v_altid1,13,' ') ||
 RPAD(v_AGATInd,5,' ') ||
 RPAD(v_STXPInd,4,' '));


David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002



 "Ranganath K"
 
 group.com>  cc:
 Sent by:Subject: Spooling output of 
a select statement to a file through
 [EMAIL PROTECTED] stored procedure


 08/29/2001 06:00
 AM
 Please respond to
 ORACLE-L






Dear DBA Gurus,

How do I spool output of a select statement to a file through
stored
procedure.  The stored procedure should take the directory and path of the
file to be spooled to on the client machine.  I know we can do this using
UTL_FILE package.  But I don't want to write to a file in Oracle Database
server machine rather I want to write the output to a file in client
machine.  Please note that I want to do this through a Pl/Sql procedure or
a
pl/sql program so that the procedure can be called from the front end which
is Java/C++.   How do I do this?  Any help in this regard will be duly
appreciated.

Thanks and Regards,

Ranganath


DISCLAIMER: This correspondence is confidential and intended for the named
recipient(s) only. If you are not the named recipient and receive this
correspondence in error, you must not copy, distribute or take any action
in
reliance on it and you should delete it from your system and notify the
sender immediately. Unless otherwise stated, any views or opinions
expressed
are solely those of the author and do not represent those of Subex Systems
Limited.

www.subexgroup.com


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author:
   INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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 nam

RE: Auto log apply to standby db using Perl

[Jack C. Applewhite]

Rob 
(Jo?),
 
This 
is from the Oracle8i docs (Chapter 5 of "Oracle8i Standby Database Concepts and 
Administration"), but it's so basic that I believe it would apply to 
8.0
 
...
9.Write a script that you can periodically run to check 
the log files in the managed recovery directory and 
move  the log files 
that have a specified timestamp to the manual recovery directory. If new redo 
logs are being moved,  
start the manual recovery mode and apply the newly moved redo logs. 

 
  
The following PERL script performs what is outlined in this step: 

 
  
#!/usr/local/bin/perl
 
  
#How many hours the standby database should lag behind the primary 
database  $LAG_HOUR = 
4;
 
  
#The manual recovery 
directory  $DEST_DIR = 
'/fs2/oracle/stdby/';
 
  
#The flag for whether there are new logs to be 
applied.  $needApply = 
0;
 
  
#Check the managed recovery 
directory  while ( 
 ) 
{  
# Get the timestamp of the 
file  
$file_time = 
(stat($_))[9];  
# See if the file is "old 
enough"  
if ( time-$file_time > $LAG_HOUR*60*60 ) 
{  
print  "mv $_ 
$DEST_DIR\n";  
system "mv $_ 
$DEST_DIR";  
$needApply = 
1;   
}  
}  #If redo logs were 
moved in this round, apply 
them  if ( $needApply 
== 1 ) 
{  
system 
"/usr/Lagged_Standby/ApplyLog";  
}
 
  
The SHELL script (/usr/Lagged_Standby/ApplyLog) used to apply the redo logs 
consists of the following: 
 
  
sqlplus internal << EOF
 
  
recover automatic standby 
database;  
cancel  
exit
 
  
EOF
 
   10.Refer to 
your platform-specific documentation for information on how to create a job that 
is triggered at 
specific  times 
throughout the day. 
 
  
For example, in UNIX, you can write a CRON job file. Issue the man crontab 
command at the UNIX  
command shell to get help on how to write a CRON job file. 
...
 
Jack
Jack C. 
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, 
Inc.Austin, 
Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Jo KingSent: 
  Wednesday, August 29, 2001 1:23 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Auto log apply to standby db using 
  Perl
   
   
          Environment 
  is NT4 with Oracle 8.0.5.
   
          I wish to 
  automate the procedure for applying the archive logs to a
          standby 
  database. The logs are automatically transferred to standby 
          destination 
  'area'.
      I am 
  planning to use Perl (currently learning) to perform this. After  
      
  gaining connectivity to database via svrmgr30 and issuing command : -
          
           recover automatic standby 
  database; 
           I'm 
  NOT sure how to go about coding ( 
  'stacking') responses to .. 
          "Archive 
  file not found message..". when there are no 
  longer any more 
          archive 
  files to apply.
   
     I wish 
  to respond cancel to the standard message : -
          
      Enter 
  ...
     and 
  then exit out of svrmgr30.
   
          If anybody 
  has a Perl script for handling such a situation (or similar) or  
  
          could give 
  me an example on how to achieve, I'd be 
  very grateful.
   
  /Rob 
   

constraints in create table..

[Saurabh Sharma]

hi all,
 
do anybody explain me what is 
happening when i'm creating a table with the following 
constraints..
 
CREATE TABLE 
TAB1(
ENUM NUMBER PRIMARY KEY 
CHECK(ENUM IS NULL),
ENAME 
VARCHAR2(10)
);
 
why i'm being able to create 
table with such contradicting constraints.
both can't be true at the 
same time.
i can't have null in aprimary 
key.
 
what's the significance of 
this DDL.
 
thanks in 
advance..
 
Saurabh 
Sharma

RE: financial problems with fatcity.com

[Farnsworth, Dave]

The only problem with having my damagement pay for a subscription for this
list is that they may find out where I get all my answers to some very
difficult problems!!  ;o)

Dave

-Original Message-
Sent: Wednesday, August 29, 2001 11:43 AM
To: Multiple recipients of list ORACLE-L


Whats that first part of your domain address there Alex  :-)

Perhaps you could help the list out !! 

-Original Message-
Sent: 29 August 2001 16:16
To: Multiple recipients of list ORACLE-L


I think that much better than voluntary contributions will be some
s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I
am sure that
everybody working with Oracle and living in US or UK or other developed
country can afford such fees. We will not need to charge people from
developing countries - I am sure these subscription fees will generate more
than $500 per month.

Alex Hillman

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

WAS: !! *Very* important Oracle-L message !!

[Scott Shafer]

Just shoot me an email if you get to San Antonio.  We could even meet
for a long lunch in New Braunfels or sumthin', as I live an work in the
NE part of SA.  That goes for anyone in the area.  My schedule keeps me
hopping, but I can usually break free for a time.

Scott Shafer
San Antonio, TX
w: 210-581-6217


[EMAIL PROTECTED] wrote:
> 
> I didn't put OT in the header because I think this is very on topic.  I
> will be emailing Bruce to see what he needs, or feels is a fair
> contribution for my participation in this list through the years.  I have
> gained so much from the members of this list.  Without those who
> participate, both past and present, I would never have progressed as far
> along the DBA route as I have.  Ofttimes, I'll read about a problem someone
> has posted here and, although I can't help them, I do copious research to
> further my education and knowledge.  Many of these problems have
> subsequently cropped up within my DB's, and I am much better prepared to
> handle them as a result.  I also save, research, and test many of the
> scripts posted here.  Some work, some don't, some can afford to be tweaked,
> but playing with them has given me a deeper understanding of what goes into
> being a DBA (plus I've now got a great toolkit - just need to learn PERL!).
> 
> I pay for my subscription to the daily newspaper.  This forum is at least
> as valuable to me as the newspaper (I even get the comic section here).
> 
> There is a cost to the Internet - that's why many of us have jobs.  I urge
> the members of this community to search their conciouses and give what they
> can to help this forum prosper.
> 
> Someday I'd like to make it to OOW and meet some of you (heck, I've thought
> about driving down to San Antonio just to meet Scott.  Does Mladen ever
> leave his cave?)
> 
> Regards,
> 
> David A. Barbour
> Oracle DBA, OCP
> AISD
> 512-414-1002

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).