2 Databases Problem

[Bambang Setiawan]

Dear Listers ,

yesterday , I've created 2nd database for Test using Database Assistant on NT.
and I also shutdown my Test Server later.

this morning , when I tried to Startup both of My DB , I found ORA-01102 error :can 
not mount database exclusively.

My 1st database is able to be started in OPEN mode , but I can not startup my 2nd 
database .

please help me , how to solve it...

 
Thanks a lot in advance : )


=bambang=


<> Bambang Setiawan <>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bambang Setiawan
  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).

Not abble to connect to the serer.

[mentor]

HI,
  I can not connet to server , when I run  Oracle Application BIS Runtime Repository 
wizard, after I install the BIS.
  After I typical install the BIS , I run the wizard.  In the APPS schema form
no mater how I feed the user and pwd, the wizard tell me :
"Not able to connect to the server .please verify the given sever infromation."
How can I do???
Thanks  James




===
ΪÄã¶ø½¨£¬ÎªÄã¶øÉ裬ÈÃÄã´«µÝÕæÐÄÕæÒâ 

 163.netºØ¿¨Õ¾£¨http://ecard.163.net£©

163µç×ÓÓʾÖȫзîÏ×£¬¾«²ÊÎÞÏ޵ĵç×Ӻؿ¨Õ¾¡£
===

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

[C.S.Venkata Subramanian]

Yes def RMAN will recognise and execute the same. After u have backed up the database, 
We need to backup the Archivelog and then the controlfiles. This is the sequence in 
which the backup is done. We need to issue the SQL stmt to archive the current redo 
log so that we don't loose the transactions. This will help u to restore the database. 

Hope this helps you.

--

On Tue, 27 Mar 2001 18:25:44  
 Yustiono wrote:
>Dear DBAs,
>
>I found this RMAN command on Oracle8i Backup Recovery documentation. This is
>used to backup all data files and controlfiles.
>
>run {
>allocate channel ch1 type disk;
>backup database;
>sql 'ALTER SYSTEM ARCHIVE LOG CURRENT'; # archives current redo log
>sql 'ALTER SYSTEM ARCHIVE LOG ALL'; # archives all un-archived redo logs
>}
>
>My question is, why they put sql commands to archives current redo log and
>unarchived redo logs, after the "backup database" command? Why not before
>the "backup database" command? Will RMAN execute it as a transaction for all
>commands in curly bracket?
>
>TIA
>
>Yustiono
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Yustiono
>  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 250 color business cards for FREE! at Lycos Mail
http://mail.lycos.com/freemail/vistaprint_index.html
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  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).

Import comma-delimited text file into Oracle

[Helmut Daiminger]

Hi!

Is SQL*Loader the only way to move the contents of a comma-delimited ASCII
file into Oracle? UTL_FILE would be another option, right?

Or are there any other ways to do this?

This is 8.1.6 on Win2k.

Thanks,
Helmut

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Helmut Daiminger
  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: changing db_block_size

[Rachel Carmichael]

no flame supposedly in 9i you will be able to change the block size 
while the db is up and will also be able to have different blocksizes  -- I 
think it's by tablespace



>From: "Joseph S. Testa" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: changing db_block_size
>Date: Tue, 27 Mar 2001 16:50:56 -0800
>
>last i checked that was your only choice, anyone like to flame me for
>that statement :)
>
>joe
>Roy Ferguson wrote:
> >
> > all,
> >
> > I would like to change the db_block_size (currently 2048) of our 
>production
> > database and would be interested in hearing from those that have done 
>this on a
> > not so small database.  This is our oracle financials/manufacturing 
>server and
> > is about 30GB in size.  Did you recreate the database using imp/exp or 
>another
> > method?
> >
> > Running Oracle 8.0.5 on Sun Solaris 7.
> >
> > thanks in advance...roy
>
>--
>Joe Testa  http://www.oracle-dba.com
>Performing Remote DBA Services, need some backup DBA support?
>For Sale: Oracle-dba.com domain, its not going cheap but feel free to
>ask :)
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Joseph S. 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).

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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).

RMAN

[Yustiono]

Dear DBAs,

I found this RMAN command on Oracle8i Backup Recovery documentation. This is
used to backup all data files and controlfiles.

run {
allocate channel ch1 type disk;
backup database;
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT'; # archives current redo log
sql 'ALTER SYSTEM ARCHIVE LOG ALL'; # archives all un-archived redo logs
}

My question is, why they put sql commands to archives current redo log and
unarchived redo logs, after the "backup database" command? Why not before
the "backup database" command? Will RMAN execute it as a transaction for all
commands in curly bracket?

TIA

Yustiono

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yustiono
  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: New born DBA.....

[Joseph S. Testa]

start by reading the administrators guide and welcome to the world(Dr
DBA slaps the bottom side of the newborn) :)

joe
Sinardy Xing wrote:
> 
> Hi guys,
> 
> I am a new DBA, can you please tell me what are the common task list as DBA
> for Oracle8i on Solaris 7. I mean things that I should do and check
> regularly.
> I know backup is one of them.
> 
> Thank you
> 
> Sinardy
> Soon be OCP certified
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sinardy Xing
>   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).

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. 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: changing db_block_size

[Suhen Pather]

Roy,

You will have to recreate the database to change db_block_size.
Possibly the only way to do this is through export/import.

-full export
-remove old database
-recreate database with new block size.
-full import

30Gb database will take approximately 12 hours to complete the job on a
medium
sized machine.

HTH
Suhen


all,

I would like to change the db_block_size (currently 2048) of our production 
database and would be interested in hearing from those that have done this
on a 
not so small database.  This is our oracle financials/manufacturing server
and 
is about 30GB in size.  Did you recreate the database using imp/exp or
another 
method?

Running Oracle 8.0.5 on Sun Solaris 7.

thanks in advance...roy

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Roy Ferguson
  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: Suhen Pather
  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: changing db_block_size

[Joseph S. Testa]

last i checked that was your only choice, anyone like to flame me for
that statement :)

joe
Roy Ferguson wrote:
> 
> all,
> 
> I would like to change the db_block_size (currently 2048) of our production
> database and would be interested in hearing from those that have done this on a
> not so small database.  This is our oracle financials/manufacturing server and
> is about 30GB in size.  Did you recreate the database using imp/exp or another
> method?
> 
> Running Oracle 8.0.5 on Sun Solaris 7.
> 
> thanks in advance...roy

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. 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: changing db_block_size

[Winnie_Liu]

export and import is your only solution to recreate the database in
different db_block_size

Winnie





Roy Ferguson <[EMAIL PROTECTED]>@fatcity.com on 03/27/2001 04:40:22 PM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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



all,

I would like to change the db_block_size (currently 2048) of our production
database and would be interested in hearing from those that have done this
on a
not so small database.  This is our oracle financials/manufacturing server
and
is about 30GB in size.  Did you recreate the database using imp/exp or
another
method?

Running Oracle 8.0.5 on Sun Solaris 7.

thanks in advance...roy

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Roy Ferguson
  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: Cleaning up before upgrades / migrations; avoiding upgrade pr

[Alexander . Feinstein]

Title: RE: Cleaning up before upgrades / migrations; avoiding upgrade problems





Patrice,


That is what I did:


1. Install 8.1.7.
2. Create new DB.
3. Migrate old DB from 7.3.4 to 8.1.7.
4. Create new LMTs for tables and indexes.
5. Move all tables to new tablespaces (adjust PCTFREE and PCTUSED) according the size.
6. Rebuild all indexes to new tablespaces (adjust PCTFREE and PCTUSED) according the size.
7. Additional cleaning.
8. Export new tablespaces as transportable.
9. Import new tablespaces as transportable into new DB.


There are more details if you need.


Alex.



-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 5:16 AM
To: Multiple recipients of list ORACLE-L
Subject: Cleaning up before upgrades / migrations; avoiding upgrade
proble ms



Hi,


We are preparing to upgrade our databases here from 7.3.4. to 8.1.6..


Do you have any suggestions re. re-organization, "cleaning up" before the
migration is done, or just after it is done, and before I release the
servers to the developers and end users?  If you have done this type of
upgrade before, any problems encountered?


e.g. separating indexes and tables, right now they are all lumped in the
same tablespace.  Ensuring that extent sizes are appropriate.


I intend to use export / import to do the transition instead of the
migration utility.  I am testing that today with a few schemas on NT, will
test it again later with full exports / imports on Tru64 when we receive our
new Digital servers.


TIA
Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada

New born DBA.....

[Sinardy Xing]

Hi guys,


I am a new DBA, can you please tell me what are the common task list as DBA
for Oracle8i on Solaris 7. I mean things that I should do and check
regularly.
I know backup is one of them.




Thank you


Sinardy
Soon be OCP certified

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinardy Xing
  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).

changing db_block_size

[Roy Ferguson]

all,

I would like to change the db_block_size (currently 2048) of our production 
database and would be interested in hearing from those that have done this on a 
not so small database.  This is our oracle financials/manufacturing server and 
is about 30GB in size.  Did you recreate the database using imp/exp or another 
method?

Running Oracle 8.0.5 on Sun Solaris 7.

thanks in advance...roy

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Roy Ferguson
  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: A Basic PL/SQL Question

[Jack C. Applewhite]

Bill,

Try pushing the output directly to a file using calls to the
Utl_File supplied package.  That would allow you unlimited
spooling capacity.

If you really want to use DBMS_Output, you might try (but I
don't know if it would work) to call DBMS_Output.Disable
then DBMS_Output.Enable(100) every once in a while in a
loop in your procedure.  That would close the buffer, then
open it with a new million character capacity (I think).

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]


-Original Message-
Carle,
William T (Bill), NLCIO
Sent: Tuesday, March 27, 2001 3:09 PM
To: Multiple recipients of list ORACLE-L


Hi,

This is my first attempt at writing a PL/SQL procedure.
Everything works
fine, except I have a firly large table I am running
against. I am trying to
display my output with DBMS_OUTPUT.PUT_LINE. I have set the
buffer size to
100, apparently the maximum value, but it still isn't
enough to print
output for my entire table. Is there another way to display
data? Or is
there some way to increase the maximum?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
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: A Basic PL/SQL Question

[Morton, Ronald D]

Bill,

The version 8 PL/SQL manual states:

Messages sent using the DBMS_OUTPUT are not actually sent until the sending
subprogram or trigger completes.  There is no mechanism to flush output
during the execution of a procedure.

You may want to try using the file i/o facility provided by the UTL_FILE
package - not as convenient, but should handle all of your table.  Maybe use
DBMS_OUTPUT to indicate when file has been written?

Ron Morton
Union Switch & Signal Inc
[EMAIL PROTECTED]

> -Original Message-
> From: Carle, William T (Bill), NLCIO [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, March 27, 2001 4:09 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  A Basic PL/SQL Question
> 
> Hi,
> 
> This is my first attempt at writing a PL/SQL procedure. Everything
> works
> fine, except I have a firly large table I am running against. I am trying
> to
> display my output with DBMS_OUTPUT.PUT_LINE. I have set the buffer size to
> 100, apparently the maximum value, but it still isn't enough to print
> output for my entire table. Is there another way to display data? Or is
> there some way to increase the maximum?
> 
> 
> Bill Carle
> AT&T
> Database Administrator
> 816-995-3922
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Carle, William T (Bill), NLCIO
>   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: Morton, Ronald D
  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: Issues with Oracle on a Compaq Tru64 5.1 Cluster

[Murali Vallath]

We use COMPAQ tru64 5.1 with Oracle 8.1.7. we had noticed corruption in some 
all files and had to apply some O/S level patches.
We followed the instructions in the following TAR#  13320267.600. You may 
want to do a dbv on certain files to ensure there is not corruption.

Again we did not notice these problems until RMAN complained of corruption. 
And we noticed corruption in the redo logs.


Murali Vallath


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 27 Mar 2001 08:47:20 -0800

   We are running Oracle 8.1.6.2.0 on a new Compaq Tru64 cluster running 5.1 
patchkit 1.  We have had Oracle running for almost 2 months.  For the last 
several days, we have been experiencing severe I/O issues.  The databases 
will freeze-up and claim that they can't access certain files.  
Occassionally even 'ls' commands will lock up to, but only when accessing 
certain sub-directories of file systems.
   Naturally, we are trying to figure out what has changed in the last few 
days.  We know that the Legatto Networker client was installed, and we also 
had a UPS failure.  In an attempt to isolate the problem, we have removed 
the Legatto Networker client.  Our sysadmins are not seeing any problems at 
the hardware level.  We have completed powered the cluster down and brought 
it back up.  When the databases begin locking up, we do see error messages 
related to various file systems come across the console.  For a few days, we 
thought it might be RMAN, but I haven't used it in the last 2 days and the 
problems are still occurring.
   So, my question is - are any of you folks on a Tru64 5.1 cluster and if 
so, have you seen similar problems?  The systems include 3 GS80s, an ES40, 
and a Storage Area Network for the disks.  We are not running OPS and we are 
not using raw devices.

Thank you,
Jay Hostetter

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jay Hostetter
   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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Murali Vallath
  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: A Basic PL/SQL Question

[Chesebro, Eric]

Use the UTL_FILE package and write the results to a temporary file.

Eric

-Original Message-
Sent: Tuesday, March 27, 2001 4:09 PM
To: Multiple recipients of list ORACLE-L


Hi,

This is my first attempt at writing a PL/SQL procedure. Everything works
fine, except I have a firly large table I am running against. I am trying to
display my output with DBMS_OUTPUT.PUT_LINE. I have set the buffer size to
100, apparently the maximum value, but it still isn't enough to print
output for my entire table. Is there another way to display data? Or is
there some way to increase the maximum?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  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: Chesebro, Eric
  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: Trying to find a book...

[Chesebro, Eric]

http://www.amazon.com/exec/obidos/ASIN/1562058916/qid%3D/107-6190632-5933351

-Original Message-
Sent: Tuesday, March 27, 2001 4:16 PM
To: Multiple recipients of list ORACLE-L


Hi Gang,
Anyone know of a book by Willard Baird? I'd like to like to know the title
and any thoughts you may have.

TIA,

Rocky

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/?.refer=text
-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Chesebro, Eric
  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: LOB ?

[Winnie_Liu]

I am not quite sure that you can reference a LOB in a remote database
through a database link. You are very likely to get the ORA-22992 error
when you attempt to do so.

22992, 0, "cannot use LOB locators selected from remote tables"
// *Cause:  A remote LOB column cannot be referenced.
// *Action:  Remove references to LOBs in remote tables.

Winnie





"Gene Sais" <[EMAIL PROTECTED]>@fatcity.com on 03/27/2001 12:52:13
PM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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



LOB question?

Can you have db A have a view w/ db link reference to db B blob data type?

I think so, but not 100% sure.  The reason I ask is I have a 3rd party
app that wants to move 500gb worth of images to a remote db, but have the
current db
reference it as if it was in the same db through a view.  Thanks for any
blob insight the list can offer.

Gene Sais


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



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

Trying to find a book...

[Rocky Welch]

Hi Gang,
Anyone know of a book by Willard Baird? I'd like to like to know the title
and any thoughts you may have.

TIA,

Rocky

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/?.refer=text
-- 
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).

library cache load lock latch

[Pablo ksksksk]

I've some waits on this latch.
I've read that a sesion has to get this latch for a
database object (always in exclusive mode) in order to
LOAD this object (to the LC I assume).
And when this latch is busy the session has to wait on
the "library cache loda lock event"

Does anybody know what can be done to eliminate this
wait?

thanks


___
Do You Yahoo!?
Envía mensajes instantáneos y recibe alertas de correo con 
Yahoo! Messenger - http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20ksksksk?=
  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).

A Basic PL/SQL Question

[Carle, William T (Bill), NLCIO]

Hi,

This is my first attempt at writing a PL/SQL procedure. Everything works
fine, except I have a firly large table I am running against. I am trying to
display my output with DBMS_OUTPUT.PUT_LINE. I have set the buffer size to
100, apparently the maximum value, but it still isn't enough to print
output for my entire table. Is there another way to display data? Or is
there some way to increase the maximum?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  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).

Log writer waits

[Kevin Kostyszyn]

Hi all,
Someone had answered this already last week, but being the bone head that I
am I forgot to save it.  It was something to the effect of seeing how many
processes were waiting to write to the log buffer or something like that.
And it was a good indicator that your log files are too small?  Any help?

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: OFFTOPIC - RE: Which is faster, Metalink or...

[Richard Ji]

Me going upstream against Naigara fall.

-Original Message-
Beilstein
Sent: Tuesday, March 27, 2001 3:19 PM
To: Multiple recipients of list ORACLE-L


Water flowing uphill (that never works either)

>>> [EMAIL PROTECTED] 03/27/01 02:52PM >>>
Turtles walking through peanut butter in January?

-Original Message-
Sent: Tuesday, March 27, 2001 2:32 PM
To: Multiple recipients of list ORACLE-L



A snail going uphill through jungle vegetation? Molasses in the northernmost
region of the Siberian tundra?




  _

Do You Yahoo!?
Yahoo! Mail Personal  
Address - Get email at your own domain with Yahoo! Mail.


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  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: OFFTOPIC - RE: Which is faster, Metalink or...

[Kevin Kostyszyn]

Metalink, hands down.

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: 
  Tuesday, March 27, 2001 2:52 PMTo: Multiple recipients of list 
  ORACLE-LSubject: OFFTOPIC - RE: Which is faster, Metalink 
  or...
  Turtles walking through peanut butter in January?
  
-Original Message-From: Chuck Hamilton 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 27, 2001 
2:32 PMTo: Multiple recipients of list 
ORACLE-LSubject: Which is faster, Metalink 
or...
A snail going uphill through jungle vegetation? Molasses in 
the northernmost region of the Siberian tundra?


Do You Yahoo!?Yahoo! Mail 
Personal Address - Get email at your own domain with Yahoo! 
  Mail.

OFFTOPIC - RE: Which is faster, Metalink or...

[William Beilstein]

Water flowing uphill (that never works either)

>>> [EMAIL PROTECTED] 03/27/01 02:52PM >>>
Turtles walking through peanut butter in January?

-Original Message-
Sent: Tuesday, March 27, 2001 2:32 PM
To: Multiple recipients of list ORACLE-L



A snail going uphill through jungle vegetation? Molasses in the northernmost
region of the Siberian tundra?




  _  

Do You Yahoo!?
Yahoo! Mail Personal  
Address - Get email at your own domain with Yahoo! Mail.


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  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: Which is faster, Metalink or...

[gregory . t . norris]

Especially when it's a stampeding herd of turtles!!!

-Original Message-
Sent: Tuesday, March 27, 2001 1:52 PM
To: ORACLE-L
Cc: MohanR




Turtles walking through peanut butter in January?

-Original Message-
Sent: Tuesday, March 27, 2001 2:32 PM
To: Multiple recipients of list ORACLE-L



A snail going uphill through jungle vegetation? Molasses in the 
northernmost region of the Siberian tundra?

 

RE: IOUG university

[Jack C. Applewhite]

Just don't let the room temperature get below about 80 deg.
F, or Gaja's teeth will start chattering and he won't be
able to speak!  He likes it hot!   ;-)

It really is worth sweating for an hour or so to hear his
stuff - he's good!  I had the privilege of working with him
for a while a couple of years ago and learned a lot, though
he was smarter to move on early - I hung around long enough
to get laid off.   8^(

All the best, Gaja!

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]


-Original Message-
Rachel
Carmichael
Sent: Monday, March 26, 2001 7:30 PM
To: Multiple recipients of list ORACLE-L


I saw Cary present in Copenhagen VERY smart man.. father
of OFA :)

Gaja we all know from this list -- and I know very few (if
any) people who
know more about performance tuning than he does

Dave Ensor also -- yes a stand-up comic, but he also is one
of the most
knowledgeable men about oracle that I have met.

ALL these presentations will be wonderful


-- 
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: Execute priv to an isolated procedure inside a package

[Jack C. Applewhite]

Ian,

You are 100% correct.

A procedure, function, cursor, etc. not declared in the
package spec, but only in the package body is considered
private to the package and cannot be executed by any
external call, only by calls from other procedures,
functions, etc. within the package.

That way you can only expose the items that you truly want
to be public.  IMHO, it is not a limitation at all, but a
very valuable mechanism for enforcing selective security.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]


-Original Message-
MacGregor,
Ian A.
Sent: Tuesday, March 27, 2001 7:45 AM
To: Multiple recipients of list ORACLE-L
package


I have not tested this.  I believe ,with about a 60% level
of confidence,  you can place a function/procedure in the
body of a package without placing its definition in the
package's specification.  If so, the function/procedure
should not be available when exectute is granted on the
package.

Ian MacGregor
Stanford Linear Accelerator Center
ian@slac,stanford.edu

-Original Message-
Sent: Monday, March 26, 2001 5:40 PM
To: Multiple recipients of list ORACLE-L


Hi friends,

One cannot grant execute privilege to a specific
procedure/function inside a
package, but only for all or nothing that is in that
package.

Anybody has an idea how this limitation can be overcomed.
One idea is to
create a separate stand-alone procedure that will just be a
wrapper around
the packaged procedure and call it.  Any other ideas.

Thanks.

Djordje

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

Issues with Oracle on a Compaq Tru64 5.1 Cluster

[plomax]

> Checking this up with a colleague who works at another operator.
> Get back to you on this
> Peter
> --
> email: [EMAIL PROTECTED]
> Oriole Corporation (http://www.oriole.com/)
> Oracle Performance Tools and Free Scripts
> Tel: +44 (0)20 7872 5480
> Faxes: UK +44(0)705 066 8661 / US +1 240 526 5946
>
> - Original Message -
> From: "Jay Hostetter" <[EMAIL PROTECTED]>
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, March 27, 2001 5:47 PM
> Subject: Issues with Oracle on a Compaq Tru64 5.1 Cluster
>
>
>   We are running Oracle 8.1.6.2.0 on a new Compaq Tru64 cluster running
5.1
> patchkit 1.  We have had Oracle running for almost 2 months.  For the last
> several days, we have been experiencing severe I/O issues.  The databases
> will freeze-up and claim that they can't access certain files.
> Occassionally even 'ls' commands will lock up to, but only when accessing
> certain sub-directories of file systems.
>   Naturally, we are trying to figure out what has changed in the last few
> days.  We know that the Legatto Networker client was installed, and we
also
> had a UPS failure.  In an attempt to isolate the problem, we have removed
> the Legatto Networker client.  Our sysadmins are not seeing any problems
at
> the hardware level.  We have completed powered the cluster down and
brought
> it back up.  When the databases begin locking up, we do see error messages
> related to various file systems come across the console.  For a few days,
we
> thought it might be RMAN, but I haven't used it in the last 2 days and the
> problems are still occurring.
>   So, my question is - are any of you folks on a Tru64 5.1 cluster and if
> so, have you seen similar problems?  The systems include 3 GS80s, an ES40,
> and a Storage Area Network for the disks.  We are not running OPS and we
are
> not using raw devices.
>
> Thank you,
> Jay Hostetter
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jay Hostetter
>   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).

OFFTOPIC - RE: Which is faster, Metalink or...

[Mohan, Ross]

Turtles walking through peanut butter in January?

  -Original Message-From: Chuck Hamilton 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 27, 2001 2:32 
  PMTo: Multiple recipients of list ORACLE-LSubject: Which 
  is faster, Metalink or...
  A snail going uphill through jungle vegetation? Molasses in 
  the northernmost region of the Siberian tundra?
  
  
  Do You Yahoo!?Yahoo! Mail Personal 
  Address - Get email at your own domain with Yahoo! 
Mail.

Using Profiles to Force Users off After Inactivity

[MacGregor, Ian A.]

Has this been improved in 8i.  When the time has expired does it still issue

alter system kill session ',serial#';

or does it now  issue

alter system kill session ',serial#' immediate;


Ian MacGregor
Stanford Linear Acclerator Center
[EMAIL PROTECTED]

-- 
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: Exp Imp Overwirte posiible or not?

[Scott . Shafer]

Thanks for the correction.  I'm away from the doc CD at the moment as we are
moving offices...

Scott Shafer
San Antonio, TX
210-581-6217

> -Original Message-
> From: William Beilstein [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, March 27, 2001 1:19 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Exp Imp  Overwirte posiible or not?
> 
> The DESTROY option on an import indicates whether the CREATE TABLESPACE
> commands only found in a full export should be executed. Setting DESTROY=Y
> destroys the data files of the database being imported into. This is only
> used when you want to rebuild an entire database, not to overwrite data in
> tables. If you really need the empty all the tables in a schema, disable
> the constraints on the tables, truncate them, and reenable the
> constraints. This will only work if the schema is self contained, and it's
> tables are not used as a foreign key for a table in a different schema.
> >>> [EMAIL PROTECTED] 03/27/01 01:50PM >>>
> IIRC, there is a flag for import "destroy=y" to do what you want.  This is
> very dangerous and you should research all the implications before trying
> it.  If you don't have the docs, try http://technet.oracle.com and read up
> on the import options.
> 
> Scott Shafer
> San Antonio, TX
> 210-581-6217
> 
> > -Original Message-
> > From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] 
> > Sent:   Tuesday, March 27, 2001 1:46 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:Exp Imp  Overwirte posiible or not?
> > 
> > Hi All,
> >  I want to import data from a user dump file but when i import data, i
> > want
> > to overwrite the existing data . Normally imp utility append data to
> > existing rows. Requirement of application is such  that we need to
> > overwrite existing data  without  dropping objects and its dependent
> > objects. Is it possible with exp , imp utilities or  i have to delete
> data
> > first and then import  using imp utility.
> > Is there any other possibility...
> > Environment Oracle8i, Windows NT4
> > TIA
> > 
> > Azhar Siddiq
> > 
> -- 
> 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: William Beilstein
>   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).

LOB ?

[Gene Sais]

LOB question?  

Can you have db A have a view w/ db link reference to db B blob data type?  

I think so, but not 100% sure.  The reason I ask is I have a 3rd party
app that wants to move 500gb worth of images to a remote db, but have the current db
reference it as if it was in the same db through a view.  Thanks for any blob insight 
the list can offer.

Gene Sais


--
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: Exp Imp Overwirte posiible or not?

[Seema Singh]

You can use truncate command to delete all data from that tables and then 
IMP.Hope this will help u .
-Seema


>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Exp Imp  Overwirte posiible or not?
>Date: Tue, 27 Mar 2001 10:50:43 -0800
>
>IIRC, there is a flag for import "destroy=y" to do what you want.  This is
>very dangerous and you should research all the implications before trying
>it.  If you don't have the docs, try http://technet.oracle.com and read up
>on the import options.
>
>Scott Shafer
>San Antonio, TX
>210-581-6217
>
> > -Original Message-
> > From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> > Sent:   Tuesday, March 27, 2001 1:46 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:Exp Imp  Overwirte posiible or not?
> >
> > Hi All,
> >  I want to import data from a user dump file but when i import data, i
> > want
> > to overwrite the existing data . Normally imp utility append data to
> > existing rows. Requirement of application is such  that we need to
> > overwrite existing data  without  dropping objects and its dependent
> > objects. Is it possible with exp , imp utilities or  i have to delete 
>data
> > first and then import  using imp utility.
> > Is there any other possibility...
> > Environment Oracle8i, Windows NT4
> > TIA
> >
> > Azhar Siddiq
> >
>--
>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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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).

Which is faster, Metalink or...

[Chuck Hamilton]

A snail going uphill through jungle vegetation? Molasses in the northernmost region of the Siberian tundra?Do You Yahoo!?
Yahoo! Mail Personal Address - 
Get email at your own domain with Yahoo! Mail.

RE: Exp Imp Overwirte posiible or not?

[William Beilstein]

The DESTROY option on an import indicates whether the CREATE TABLESPACE commands only 
found in a full export should be executed. Setting DESTROY=Y destroys the data files 
of the database being imported into. This is only used when you want to rebuild an 
entire database, not to overwrite data in tables. If you really need the empty all the 
tables in a schema, disable the constraints on the tables, truncate them, and reenable 
the constraints. This will only work if the schema is self contained, and it's tables 
are not used as a foreign key for a table in a different schema.
>>> [EMAIL PROTECTED] 03/27/01 01:50PM >>>
IIRC, there is a flag for import "destroy=y" to do what you want.  This is
very dangerous and you should research all the implications before trying
it.  If you don't have the docs, try http://technet.oracle.com and read up
on the import options.

Scott Shafer
San Antonio, TX
210-581-6217

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] 
> Sent: Tuesday, March 27, 2001 1:46 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Exp Imp  Overwirte posiible or not?
> 
> Hi All,
>  I want to import data from a user dump file but when i import data, i
> want
> to overwrite the existing data . Normally imp utility append data to
> existing rows. Requirement of application is such  that we need to
> overwrite existing data  without  dropping objects and its dependent
> objects. Is it possible with exp , imp utilities or  i have to delete data
> first and then import  using imp utility.
> Is there any other possibility...
> Environment Oracle8i, Windows NT4
> TIA
> 
> Azhar Siddiq
> 
-- 
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: William Beilstein
  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: Off Topic Unix question

[David Miller]

Hi Rick,

x86 refers to the Solaris for Intel version.  There are slightly different
patches for this version.  Assuming you are running on SPARC, you want
the non-x86 version.

Dave Miller
Sun Microsystems, Inc.

>Date: Tue, 27 Mar 2001 10:05:26 -0800
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>X-Comment: Oracle RDBMS Community Forum
>X-Sender: "Cale, Rick T (Richard)" <[EMAIL PROTECTED]>
>From: "Cale, Rick T (Richard)" <[EMAIL PROTECTED]>
>Subject: Off Topic Unix question
>X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman
>Mime-Version: 1.0
>Content-Transfer-Encoding: 7bit
>
>One of co-workers is going to upgrade from Solaris 2.6 to 2.7(version 7).
>The question they had is what 
>patch cluster to apply the below web site has
>7 x86(21.7m) and  7 (39.8m). Which one to apply? 
>
>
>"Rick
>I was looking at
>http://sunsolve.sun.com/pub-cgi/show.pl?target=patches/patch-access
>and wondering what the x86 is referring to.  I am interested in the patches
>for Solaris 7 and wanted to be sure that I am looking at the correct patch
>cluster.
>Steve"
>
>Thanks
>Rick Cale, Science Applications International Corp.
>Phone:865-481-2198, fax:865-481-8555
>e-mail: [EMAIL PROTECTED]
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Cale, Rick T (Richard)
>  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: David Miller
  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: Off Topic Unix question

[William Beilstein]

x87 is the version of Solaris that runs on an Intel based (PC) machine. For sun 
hardware, you don't want x86

>>> [EMAIL PROTECTED] 03/27/01 01:05PM >>>
One of co-workers is going to upgrade from Solaris 2.6 to 2.7(version 7).
The question they had is what 
patch cluster to apply the below web site has
7 x86(21.7m) and  7 (39.8m). Which one to apply? 


"Rick
I was looking at
http://sunsolve.sun.com/pub-cgi/show.pl?target=patches/patch-access 
and wondering what the x86 is referring to.  I am interested in the patches
for Solaris 7 and wanted to be sure that I am looking at the correct patch
cluster.
Steve"

Thanks
Rick Cale, Science Applications International Corp.
Phone:865-481-2198, fax:865-481-8555
e-mail: [EMAIL PROTECTED] 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Cale, Rick T (Richard)
  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: William Beilstein
  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: Off Topic Unix question

[Ed . Haskins]

Rick,

x86 stands for the Intel (processor) version of Solaris...as opposed to the
Spark (processor) version of Solaris.

Ed Haskins
Oracle DBA
Verizon Wireless


-Original Message-
Sent: Tuesday, March 27, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L


One of co-workers is going to upgrade from Solaris 2.6 to 2.7(version 7).
The question they had is what 
patch cluster to apply the below web site has
7 x86(21.7m) and  7 (39.8m). Which one to apply? 


"Rick
I was looking at
http://sunsolve.sun.com/pub-cgi/show.pl?target=patches/patch-access
and wondering what the x86 is referring to.  I am interested in the patches
for Solaris 7 and wanted to be sure that I am looking at the correct patch
cluster.
Steve"

Thanks
Rick Cale, Science Applications International Corp.
Phone:865-481-2198, fax:865-481-8555
e-mail: [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  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: Exp Imp Overwirte posiible or not?

[Scott . Shafer]

IIRC, there is a flag for import "destroy=y" to do what you want.  This is
very dangerous and you should research all the implications before trying
it.  If you don't have the docs, try http://technet.oracle.com and read up
on the import options.

Scott Shafer
San Antonio, TX
210-581-6217

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, March 27, 2001 1:46 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Exp Imp  Overwirte posiible or not?
> 
> Hi All,
>  I want to import data from a user dump file but when i import data, i
> want
> to overwrite the existing data . Normally imp utility append data to
> existing rows. Requirement of application is such  that we need to
> overwrite existing data  without  dropping objects and its dependent
> objects. Is it possible with exp , imp utilities or  i have to delete data
> first and then import  using imp utility.
> Is there any other possibility...
> Environment Oracle8i, Windows NT4
> TIA
> 
> Azhar Siddiq
> 
-- 
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: Solaris security ?

[Rao, Maheswara]

UID 0 means root user.  Root user by definition can access any file in the
system.

Rao

-Original Message-
Sent: Tuesday, March 27, 2001 10:41 AM
To: Multiple recipients of list ORACLE-L


Just make sure that the non-owner performing backup has the UID 0.

-Original Message-
Sent: Monday, March 26, 2001 8:00 PM
To: Multiple recipients of list ORACLE-L


Hi guys,

(With - Solaris 2.7)

Do you have any solution how to allow "non owner" to perform backup ? with
"tar command"

For example:
myfile.txt rw---

can you solve this puzzled ?
If you think I need to write a unix script would you please teaching me and
showing me the steps ?



Thank you,



Sinardy

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinardy Xing
  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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rao, Maheswara
  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).

Off Topic Unix question

[Cale, Rick T (Richard)]

One of co-workers is going to upgrade from Solaris 2.6 to 2.7(version 7).
The question they had is what 
patch cluster to apply the below web site has
7 x86(21.7m) and  7 (39.8m). Which one to apply? 


"Rick
I was looking at
http://sunsolve.sun.com/pub-cgi/show.pl?target=patches/patch-access
and wondering what the x86 is referring to.  I am interested in the patches
for Solaris 7 and wanted to be sure that I am looking at the correct patch
cluster.
Steve"

Thanks
Rick Cale, Science Applications International Corp.
Phone:865-481-2198, fax:865-481-8555
e-mail: [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  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:What is best practice - differenet schema/different dbs

[dgoulet]

Rao,

I'm going to differ from a previous return post.  I think that you should
use different schema's with separate tablespaces.  Why?  Because your all on one
machine therefore all of your background Oracle processes are competing for the
same CPU, memory, and IO resources which can and does slow matters down
significantly.  The best bet in my experience is one large DB instance with a
very large SGA, particularly in the DB_BLOCK_BUFFERS area.  We've tried both
approaches with our PeopleSoft development environments and this works much
better than multiple instances.  Way too much background CPU & Memory burn not
to mention all of the wasted disk space for multiple system, temp, rbs, and
other tablespaces.  It really dings the IO too.  BTW: with each schema in it's
own tablespace(s) you can still take one offline without crashing the others,
unless you need to take system or rbs offline.

Dick Goulet

Reply Separator
Author: "Rao; Maheswara" <[EMAIL PROTECTED]>
Date:   3/27/2001 8:15 AM

List,

I would like to have your opinion on the following scenario.

We are having an application which is used by different customers (around 15
customers).  On an average each customer will have around 1,000 transactions
per 5 minutes.  Now, is it better to have a separate database for each
customer on the same machine or to create all the customers as different
schema in one single database?  

What are the pros and cons.  I am specifically looking at performance and
security issues.  

Environment:

This application is a 24x7 environment, OLTP application. Sun 6500 Solaris 7
with 4 CPUS. Raid 10.  Memory 4 GB (memory can be increased if required).
Oracle 816.

Thanks,

Rao
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rao, Maheswara
  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:

[Toepke, Kevin M]

You have a forward reference. Move the function declaration to the top of
the package body and it should work.

Kevin Toepke

-
The information in this electronic mail message is Cendant Confidential
and may be legally privileged. It is intended solely for the
addressee(s). Access to this Internet electronic mail message by anyone
else is unauthorized. If you are not the intended recipient, any
disclosure, copying, distribution or action taken or omitted to be taken
in reliance on it is prohibited and may be unlawful.
-
The sender believes that this E-mail and any attachments were free of
any virus, worm, Trojan horse, and/or malicious code when sent. This
message and its attachments could have been infected during
transmission. By reading the message and opening any attachments, the
recipient accepts full responsibility for taking protective and remedial
action about viruses and other defects. Cendant Corporation is not
liable for any loss or damage arising in any way from this message or
its attachments.
-


-Original Message-
Sent: Tuesday, March 27, 2001 11:47 AM
To: Multiple recipients of list ORACLE-L


When I create a function in a package and declare it in the specification
section it works fine.  When I try and make it private by removing the
declaration in the spec section I get the following error trying to compile:

PLS-00306: Wrong number or types of arguments in the call to
functionxxx

What am I doing wrong.  Are there additional steps (beside not putting a
declaration in the specs) needed to make a function private?



Thanks,
Eric
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Chesebro, Eric
  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: Toepke, Kevin M
  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: What is best practice - differenet schema/different dbs

[Richard Ji]

Having separate databases gives you some flexibility.  You can manage them
separatly, for instance you can upgrade the database to a newer version in
phase.  Also, if you lose a database only one customer is affected.  Do all
the customers always use the same application (same version)?  If one
customer wants to use the latest version of the application (perhaps for a
feature they have long been waiting for) when it become available and
requires the latest version of Oracle and the rest of the customers want to
stick with the old version, then you have to put them into separate
databases.

On the other hand, separate databases means more database to manage.

So the answer is depends on your situtaion.

Richard

--- "Rao, Maheswara" <[EMAIL PROTECTED]> wrote:
> List,
>
> I would like to have your opinion on the following scenario.
>
> We are having an application which is used by different customers
> (around 15
> customers).  On an average each customer will have around 1,000
> transactions
> per 5 minutes.  Now, is it better to have a separate database for each
> customer on the same machine or to create all the customers as different
> schema in one single database?
>
> What are the pros and cons.  I am specifically looking at performance
> and
> security issues.
>
> Environment:
>
> This application is a 24x7 environment, OLTP application. Sun 6500
> Solaris 7
> with 4 CPUS. Raid 10.  Memory 4 GB (memory can be increased if
> required).
> Oracle 816.
>
> Thanks,
>
> Rao
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rao, Maheswara
>   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).


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/?.refer=text
--
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).

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

[Ed . Haskins]

FYI: They must also be on Raw Partitions!!

Ed Haskins
Oracle DBA
Verizon Wireless

-Original Message-
Sent: Tuesday, March 27, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L


For an OPS configuration, disks have to be shared among the nodes, 
which usually means some kind of common IO bus (SCSI, FCAL, SSA).
That means that the nodes must be within cca. 2 miles (3 km). 

-Original Message-
Sent: Tuesday, March 27, 2001 6:45 AM
To: Multiple recipients of list ORACLE-L


Hi all!
Does anyone know is it possible to configure OPS between two remote sites?

TIA,
Sonja
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?=
  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).
-- 
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: help!!! data migration

[Bala, Prakash]

Nihar, assuming both the db versions are on 8i, how about the export with
the direct option and then import it.

Prakash

-Original Message-
Sent: Tuesday, March 27, 2001 1:06 AM
To: Multiple recipients of list ORACLE-L


hi ppl,

 i want to migrate oracle database from solaris to NT and vise versa..
can anybody tell me the best way to do it. my database sixe is around 25GB.


thanks

   
- NIHAR SANGHVI

NetMagic Solutions Pvt. Ltd.
22,Nirlon Complex,Western Express Highway,
Goregaon (E), Mumabai 400 063

Phone: 8723003 extn: 144
www.netmagicsolutions.com



 
  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nihar
  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: Bala, Prakash
  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).

Issues with Oracle on a Compaq Tru64 5.1 Cluster

[Jay Hostetter]

  We are running Oracle 8.1.6.2.0 on a new Compaq Tru64 cluster running 5.1 patchkit 
1.  We have had Oracle running for almost 2 months.  For the last several days, we 
have been experiencing severe I/O issues.  The databases will freeze-up and claim that 
they can't access certain files.  Occassionally even 'ls' commands will lock up to, 
but only when accessing certain sub-directories of file systems. 
  Naturally, we are trying to figure out what has changed in the last few days.  We 
know that the Legatto Networker client was installed, and we also had a UPS failure.  
In an attempt to isolate the problem, we have removed the Legatto Networker client.  
Our sysadmins are not seeing any problems at the hardware level.  We have completed 
powered the cluster down and brought it back up.  When the databases begin locking up, 
we do see error messages related to various file systems come across the console.  For 
a few days, we thought it might be RMAN, but I haven't used it in the last 2 days and 
the problems are still occurring.
  So, my question is - are any of you folks on a Tru64 5.1 cluster and if so, have you 
seen similar problems?  The systems include 3 GS80s, an ES40, and a Storage Area 
Network for the disks.  We are not running OPS and we are not using raw devices.

Thank you,
Jay Hostetter

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jay Hostetter
  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: OFF TOPIC: java servlet service provider

[Haskins, Ed]

Check out http://portalstudio.oracle.com

This may (or may not) be helpful!

Ed Haskins
Oracle DBA
Verizon Wireless

-Original Message-
Sent: Tuesday, March 27, 2001 10:57 AM
To: Multiple recipients of list ORACLE-L


Hi,

I developed a java servlet based application. I need
an  ASP. do you know java service provider company ?

thanks in advance...

=
---
Danisment Gazi Unal
Web: http://www.geocities.com/danisment
---

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/?.refer=text
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal
  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).

CLOB code question

[Koivu, Lisa]

Hello everyone 
-

I'm 
fiddling with CLOB code for the first time.  I have to write a function 
that will accept a long string of characters from an external application and 
store it in a CLOB field.  
Seems 
to me that since the character data is coming from an outside application, the 
only format I can declare the function to accept is VARCHAR2, in 32K 
chunks.  For example, if it was another PL/SQL module calling this function 
then I could format and pass in a CLOB.  But since it isn't, my only 
choice is VARCHAR2. 
If 
someone could either validate my train of thought here or set me straight I 
would sure appreciate it. 
Thanks

  
  

  
  
  Lisa 
  Rutland KoivuOracle Database 
  Administrator[EMAIL PROTECTED]4850 N. 
  State Rd. 7, #G104
  Ft. 
  Lauderdale, FL 33319
  Phone: 
  954.484.3191
  Fax: 
  954.484.2933
  www.neom.comwww.paperclick.comwww.qode.com
  

  

   
  
  
  

  

   
   
 
 

Re:RE: Execute priv to an isolated procedure inside a packag

[dgoulet]

Dan,

In my experience your statements are absolutely true.

Dick Goulet

Reply Separator
Author: "Dasko; Dan" <[EMAIL PROTECTED]>
Date:   3/27/2001 7:51 AM

I'm coming late to this thread, but then couldn't you set things up in an OO
paradigm and have the accesssible functions(methods) check the userid and
control access that way?  So if the package is a ccessible by anyone, and
function A is the one with no external access, build in functions B, C, & D
that access the functionality of function A like public methods in OO.  Then
include in B,C,&D a check against the userid for access to function A.
Maybe I'm missing something, and it does seem like a bit of work, but it
makes sense to me.

Dan

-Original Message-
Sent: Tuesday, March 27, 2001 9:22 AM
To: Multiple recipients of list ORACLE-L


Ian,

You are 100% correct, but then that program unit becomes internal to the
package and can only be accessed by other program units in that package.

HTH
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art !

*

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

*

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  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).

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  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: What is best practice - differenet schema/different dbs

[Rocky Welch]

Hi Maheswara,
I would think seperate databases would be the way to go, if for no other
reason, you can bring one customer offline without affecting the others.

-Rocky

--- "Rao, Maheswara" <[EMAIL PROTECTED]> wrote:
> List,
> 
> I would like to have your opinion on the following scenario.
> 
> We are having an application which is used by different customers
> (around 15
> customers).  On an average each customer will have around 1,000
> transactions
> per 5 minutes.  Now, is it better to have a separate database for each
> customer on the same machine or to create all the customers as different
> schema in one single database?  
> 
> What are the pros and cons.  I am specifically looking at performance
> and
> security issues.  
> 
> Environment:
> 
> This application is a 24x7 environment, OLTP application. Sun 6500
> Solaris 7
> with 4 CPUS. Raid 10.  Memory 4 GB (memory can be increased if
> required).
> Oracle 816.
> 
> Thanks,
> 
> Rao
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rao, Maheswara
>   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).


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/?.refer=text
-- 
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).

No Subject

[Chesebro, Eric]

When I create a function in a package and declare it in the specification
section it works fine.  When I try and make it private by removing the
declaration in the spec section I get the following error trying to compile:

PLS-00306: Wrong number or types of arguments in the call to
functionxxx

What am I doing wrong.  Are there additional steps (beside not putting a
declaration in the specs) needed to make a function private?



Thanks,
Eric
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Chesebro, Eric
  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:Request Tracker Call for Assistance

[dgoulet]

Dave,

What would probably be a much better solution is:

select , , etc...
from 
group by , , etc...

I've a funny feeling that blob/clob's can't be included in the group by clause
so they'll have to specify the column names.  Other wise do a parent/child table
relation and have the blob/clob in the child table.

Dick Goulet

Reply Separator
Author: Dave Morgan <[EMAIL PROTECTED]>
Date:   3/27/2001 6:31 AM

Hi All,
I have been involved with a perl/DBI trouble
ticketing system called Request Tracker. I have done a small 
piece of the work required to port the system to Oracle. 
The creators are almost finished but with my new
job I cannot devote the time necessary now that 
they are pushing to a beta release.

Jesse needs Oracle testers and both Oracle and perl
assistance.  

The current problem is the use of "DISTINCT" in a 
select clause from a table that has BLOB/CLOB etc
columns. 

This is an industrial strength web and email ticketing
system ala Remedy, but it is under an open source license.

http://www.fsck.com/projects/rt/
mailto:[EMAIL PROTECTED]
TIA
Dave

Tobias Brox wrote:
> 
> > Anyone have a helpful
> > suggestion for how to make oracle happy with this:
> >
> > SELECT DISTINCT * from Tablename;
> >
> > Thanks,
> > Jesse
> 
> I've never tried Oracle, but I'd suggest trying this:
> 
> SELECT UNIQUE(*) from Tablename;
> 
> ___
> Rt-devel mailing list
> [EMAIL PROTECTED]
> http://lists.fsck.com/mailman/listinfo/rt-devel
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dave Morgan
  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).

What is best practice - differenet schema/different dbs

[Rao, Maheswara]

List,

I would like to have your opinion on the following scenario.

We are having an application which is used by different customers (around 15
customers).  On an average each customer will have around 1,000 transactions
per 5 minutes.  Now, is it better to have a separate database for each
customer on the same machine or to create all the customers as different
schema in one single database?  

What are the pros and cons.  I am specifically looking at performance and
security issues.  

Environment:

This application is a 24x7 environment, OLTP application. Sun 6500 Solaris 7
with 4 CPUS. Raid 10.  Memory 4 GB (memory can be increased if required).
Oracle 816.

Thanks,

Rao
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rao, Maheswara
  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: Curious /etc/system settings in Solaris

[David Miller]

Hi Louis,

There is a Solaris Tunable Parameters Reference Manual available at:
http://docs.sun.com:80/ab2/coll.707.1/SOLTUNEPARAMREF/@Ab2TocView?Ab2Lang=C&Ab2E
nc=iso-8859-1
It will describe what these mean.  All of these are valid Solaris variables.

Basically the msgsys values refer to the msg IPC layer.  The semsys values
refer to the semaphore IPC layer. The pln, soc, socal and fcaw variables refer 
to settings in various device drivers.  The tune_t variables are solaris tuning 
variables.

See the above manual for more information.

Dave Miller
Sun Microsystems, Inc.

>Date: Mon, 26 Mar 2001 21:10:28 -0800
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>X-Comment: Oracle RDBMS Community Forum
>X-Sender: Louis Avrami <[EMAIL PROTECTED]>
>From: Louis Avrami <[EMAIL PROTECTED]>
>Subject: Curious /etc/system settings in Solaris
>X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman
>Mime-Version: 1.0
>Content-Transfer-Encoding: 7bit
>
>Hello all,
>
>One of the database servers that I am currently working on is
>a Sun 6500, running Solaris 2.7.  It's a fairly large machine,
>with 20 gig of memory.  It's being used for development and testing
>for multiple applications.
>
>When I began installing our particular versions of Oracle (7.3.4.5
>and 8.1.7) on the box, I noticed that there were several tunables
>settings in /etc/system that I had not seen on Solaris boxes
>previously.  Is anyone familiar with the settings that I have
>listed below?  I have placed an < to the right of the tunables
>in question.  Could they perhaps be applicable to an HP-UX server?
> So far I've only worked on Sun, AIX and Linux servers.  The
>shop where this server is located has been primarily HP-UX in
>the past, so I thought that these might be legacy settings.
>
>On Solaris, I've heard that it isn't a good idea to fool around
>too much with tunables if it isn't necessary.  Portions of the
>kernel are "dynamic", and unneeded settings could limit OS operations.
>
>Some of the typical Oracle settings don't look optimal either,
> for example semmns=15000!!, but that is an issue for another
>time.
>
>Any info would be greatly appreciated,
>
>Lou Avrami
>
>
>
>* Following paraameters added under change # 144754 for Oracle
>install.
>set tune_t_gpgslo=250   <-
>set tune_t_minarmem=100 <-
>set tune_t_minasmem=250 <-
>set msgsys:msginfo_msgmap=200   <-
>set msgsys:msginfo_msgmni=100   <-
>set msgsys:msginfo_msgtql=80<-
>set msgsys:msginfo_msgseg=2048  <-
>set semsys:seminfo_semmap=100   <-
>set semsys:seminfo_semmnu=800   <-
>set semsys:seminfo_semume=100   <-
>set pln:pln_enable_detach_suspend=1 <-
>set soc:soc_enable_detach_suspend=1 <-
>set socal:socal_enable_suspend=1<-
>set fcaw:force32 = 1<-
>set shmsys:shminfo_shmmax=4294967295
>set shmsys:shminfo_shmmin=1
>set shmsys:shminfo_shmmni=100
>set shmsys:shminfo_shmseg=10
>set semsys:seminfo_semmni=500
>set semsys:seminfo_semmsl=2010
>set semsys:seminfo_semmns=15000
>set semsys:seminfo_semopm=100
>set semsys:seminfo_semvmx=32767
>* End change # 144754
>
>
>
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Louis Avrami
>  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: David Miller
  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: Request Tracker Call for Assistance

[William Beilstein]

DISTINCT and UNIQUE in a select are synonyms for each other. They produce the same 
result in Oracle.

>>> [EMAIL PROTECTED] 03/27/01 09:31AM >>>
Hi All,
I have been involved with a perl/DBI trouble
ticketing system called Request Tracker. I have done a small 
piece of the work required to port the system to Oracle. 
The creators are almost finished but with my new
job I cannot devote the time necessary now that 
they are pushing to a beta release.

Jesse needs Oracle testers and both Oracle and perl
assistance.  

The current problem is the use of "DISTINCT" in a 
select clause from a table that has BLOB/CLOB etc
columns. 

This is an industrial strength web and email ticketing
system ala Remedy, but it is under an open source license.

http://www.fsck.com/projects/rt/ 
mailto:[EMAIL PROTECTED] 
TIA
Dave

Tobias Brox wrote:
> 
> > Anyone have a helpful
> > suggestion for how to make oracle happy with this:
> >
> > SELECT DISTINCT * from Tablename;
> >
> > Thanks,
> > Jesse
> 
> I've never tried Oracle, but I'd suggest trying this:
> 
> SELECT UNIQUE(*) from Tablename;
> 
> ___
> Rt-devel mailing list
> [EMAIL PROTECTED] 
> http://lists.fsck.com/mailman/listinfo/rt-devel 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Dave Morgan
  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: William Beilstein
  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).

OFF TOPIC: java servlet service provider

[Danisment Gazi Unal]

Hi,

I developed a java servlet based application. I need
an  ASP. do you know java service provider company ?

thanks in advance...

=
---
Danisment Gazi Unal
Web: http://www.geocities.com/danisment
---

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/?.refer=text
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal
  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: Execute priv to an isolated procedure inside a package

[Dasko, Dan]

I'm coming late to this thread, but then couldn't you set things up in an OO
paradigm and have the accesssible functions(methods) check the userid and
control access that way?  So if the package is a ccessible by anyone, and
function A is the one with no external access, build in functions B, C, & D
that access the functionality of function A like public methods in OO.  Then
include in B,C,&D a check against the userid for access to function A.
Maybe I'm missing something, and it does seem like a bit of work, but it
makes sense to me.

Dan

-Original Message-
Sent: Tuesday, March 27, 2001 9:22 AM
To: Multiple recipients of list ORACLE-L


Ian,

You are 100% correct, but then that program unit becomes internal to the
package and can only be accessed by other program units in that package.

HTH
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art !

*

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

*

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  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).

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  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).

startup/shutdown scripts for AIX

[Koen Lefever]

Hi,

Does anybody have a good set of startup/shutdown scripts for Oracle (Release 8.1.7) on 
IBM's AIX? I mean the kind of scripts that are executed when a certain UNIX runlevel 
is reached. I would appreciate a copy very much.

Thanks in advance,
Koen.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Koen Lefever
  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: OPS

[Gogala, Mladen]

For an OPS configuration, disks have to be shared among the nodes, 
which usually means some kind of common IO bus (SCSI, FCAL, SSA).
That means that the nodes must be within cca. 2 miles (3 km). 

-Original Message-
Sent: Tuesday, March 27, 2001 6:45 AM
To: Multiple recipients of list ORACLE-L


Hi all!
Does anyone know is it possible to configure OPS between two remote sites?

TIA,
Sonja
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?=
  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).

RE: Solaris security ?

[Gogala, Mladen]

Just make sure that the non-owner performing backup has the UID 0.

-Original Message-
Sent: Monday, March 26, 2001 8:00 PM
To: Multiple recipients of list ORACLE-L


Hi guys,

(With - Solaris 2.7)

Do you have any solution how to allow "non owner" to perform backup ? with
"tar command"

For example:
myfile.txt rw---

can you solve this puzzled ?
If you think I need to write a unix script would you please teaching me and
showing me the steps ?



Thank you,



Sinardy

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinardy Xing
  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).

RE: OPS Setup Steps ?

[Adams, Matthew (GEA, 088130)]

Title: RE: OPS Setup Steps ?





This is documented in the
Oracle 8i Parallel Server Setup and Configuration Guide
(chapter nine)


and basically consists of the following tasks
(copied straight from the doc.)


Task 1: Configure Hardware
Task 2: Evaluate Tablespaces and Log Files of Single Instance
Task 3: Create Raw Devices
Task 4: Export Data from Old Database
Task 5: Install Operating System Dependent Files
Task 6: Install Oracle8i Enterprise Edition and Oracle8i Parallel Server
Task 7: Create the Database
Task 8: Transfer Data From Old Data to Empty Database
Task 9: Start the Database



Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative array is like
  trying to club someone to death with a loaded Uzi.
 - Larry Wall (creator of Perl)



> -Original Message-
> From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 26, 2001 4:58 PM
> To: Multiple recipients of list ORACLE-L
> Subject: OPS Setup Steps ?
> 
> 
> 
> Have a Single Instance Database ( ORA 8.1.7 )Running on a 
> 2-node Cluster (
> Digital Unix 5.1)
> 
> Any Doc. Listing Steps to Convert it into a 2 instance OPS Database ?
> 
> 
> -- 
> 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).
> 

RE: OPS Setup Steps ?

[Nelson, Greg]

On the 8.1.7 Generic Documentation CD there are four manuals about Parallel
Server which should get you started.  

-Original Message-
Sent: Monday, March 26, 2001 4:58 PM
To: Multiple recipients of list ORACLE-L



Have a Single Instance Database ( ORA 8.1.7 )Running on a 2-node Cluster (
Digital Unix 5.1)

Any Doc. Listing Steps to Convert it into a 2 instance OPS Database ?


-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nelson, Greg
  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: OPS

[Adams, Matthew (GEA, 088130)]

Title: RE: OPS





There are some clustering technologies that allow 
'campus clusters' (such as SunCluster), but I 
don't believe it's possible over a wide geographic 
separation.



Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative array is like
  trying to club someone to death with a loaded Uzi.
 - Larry Wall (creator of Perl)



> -Original Message-
> From: Sonja ©ehovic [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 27, 2001 6:45 AM
> To: Multiple recipients of list ORACLE-L
> Subject: OPS
> 
> 
> Hi all!
> Does anyone know is it possible to configure OPS between two 
> remote sites?
> 
> TIA,
>   Sonja
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?=
>   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: help!!! data migration

[Ruth Gramolini]

Use the compression thru pipes method to do an export of the database.  FTP
the resulting file(s)  to the other server. Make sure you do the FTP in
binary mode.  Then import it thru a pipe to uncompress it on the way into
the database. (This gets around the 2 gig limit on exports.)

Look for the files by Rachel Carmichael on the LazyDBA website for a great
method for doing compressed exports and imports.

I have heard that if you are using the right version of Oracle  the export
will automatically be broken up into 2 gig chunks but I am not there.

HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 1:05 AM


> hi ppl,
>
>  i want to migrate oracle database from solaris to NT and vise versa..
> can anybody tell me the best way to do it. my database sixe is around
25GB.
>
>
> thanks
>
>
> - NIHAR SANGHVI
>
> NetMagic Solutions Pvt. Ltd.
> 22,Nirlon Complex,Western Express Highway,
> Goregaon (E), Mumabai 400 063
>
> Phone: 8723003 extn: 144
> www.netmagicsolutions.com
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nihar
>   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).

RE: Execute priv to an isolated procedure inside a package

[Jamadagni, Rajendra]

Ian,

You are 100% correct, but then that program unit becomes internal to the
package and can only be accessed by other program units in that package.

HTH
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art !

*

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

*

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  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).

Request Tracker Call for Assistance

[Dave Morgan]

Hi All,
I have been involved with a perl/DBI trouble
ticketing system called Request Tracker. I have done a small 
piece of the work required to port the system to Oracle. 
The creators are almost finished but with my new
job I cannot devote the time necessary now that 
they are pushing to a beta release.

Jesse needs Oracle testers and both Oracle and perl
assistance.  

The current problem is the use of "DISTINCT" in a 
select clause from a table that has BLOB/CLOB etc
columns. 

This is an industrial strength web and email ticketing
system ala Remedy, but it is under an open source license.

http://www.fsck.com/projects/rt/
mailto:[EMAIL PROTECTED]
TIA
Dave

Tobias Brox wrote:
> 
> > Anyone have a helpful
> > suggestion for how to make oracle happy with this:
> >
> > SELECT DISTINCT * from Tablename;
> >
> > Thanks,
> > Jesse
> 
> I've never tried Oracle, but I'd suggest trying this:
> 
> SELECT UNIQUE(*) from Tablename;
> 
> ___
> Rt-devel mailing list
> [EMAIL PROTECTED]
> http://lists.fsck.com/mailman/listinfo/rt-devel
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dave Morgan
  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: How to remove the Ora & Lstn services from the WinNT

[Rao, Maheswara]

Try the following command.

oradim80 -delete -srvc 

Rao

-Original Message-
Sent: Tuesday, March 27, 2001 4:55 AM
To: Multiple recipients of list ORACLE-L


from the nt resource kit u will get one utility called instsrv . use it to
remove the services



- NIHAR SANGHVI

NetMagic Solutions Pvt. Ltd.
22,Nirlon Complex,Western Express Highway,
Goregaon (E), Mumabai 400 063

Phone: 8723003 extn: 144
www.netmagicsolutions.com






-Original Message-
Sent: Tuesday, March 27, 2001 2:15 PM
To: Multiple recipients of list ORACLE-L


oradim  can be used to delete these services, though I've forgotten the
syntax at the moment and don't have any documentation to hand. Failing this,
you can also delete the services from the registry if you have permissions,
and are happy with doing this.

If memory serves they can be found in HKEY_LOCAL_MACHINE/SYSTEM/
*ControlSet* where the stars can be variables. usually looking for the
*Current* control set. Once deleted, you will need a reboot for the changes
to take place.

Now, I'm not sure if this is reccomended or not, or supported, so I'm going
to pull on my flamne retardent suit, and throws my hands in the air - If you
want to do this - it works!

HTH & YMMV

Mark


-Original Message-
Kumar Muthu Kumaran
Sent: Sunday, March 25, 2001 08:15
To: Multiple recipients of list ORACLE-L


Hi gurus,

I'm tried to Install Oracle 816, as the learner i did mistakes during
installation. Now i did sucessfully.

But when i checked in the WindowsNT servies, i found  many oracle services
that i was tried before.

Could you tell me, how to remove those things from ther serivce panel.

Thanks in Advance.

Regards,
Nirmal
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar  Muthu Kumaran
  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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nihar
  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: Rao, Maheswara
  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: Exp Imp Overwirte posiible or not?

[Paul Drake]

Azhar,

> Is it possible with exp, imp utilities or i have to delete data
> first and then import using imp utility.

what you describe sounds more like a sqlldr operation.

afaik, the answer is no and you'd have to:
(backup)
(alter database noarchivelog)
- disable FK constraints
- disable triggers if PK is already populated in import data
- truncate the tables in the schema
- import rows
- enable constraints
- enable disabled triggers
- compute statistics
- compile schema
(alter database archivelog)
(backup)


do you use a sequence/trigger combination to populate the Primary key or
will the PK already be populated?
if you're populating the PK at insert time, you'll want the insert
trigger firing on the tables
if the PK is already populated, you'll likely want to disable the insert
triggers
Also, if you populate a create_date field in the insert trigger, you'll
overwrite the existing value in the dump file during the insert if the
insert trigger is left enabled.

Here's a script from the O'Reilly Oracle Scripts book for generating the
DDL for the constraints.

rem Last Change 08/12/97 by Brian Lomasky
rem
set linesize 132
set pagesize 0
set heading off
set verify off
set echo off
set feedback off
set termout off
spool disconxx.sql
prompt spool discon.lis
select 'ALTER TABLE '||OWNER||'.'||TABLE_NAME||CHR(10)||
'  DISABLE CONSTRAINT '|| CONSTRAINT_NAME || ';'
  from dba_constraints
 where constraint_type = 'R' and status = 'ENABLED' 
   and table_name in
   (select table_name from dba_tables where owner != 'SYS');
select 'ALTER TABLE '||OWNER||'.'||TABLE_NAME||CHR(10)||
 '  DISABLE CONSTRAINT '|| CONSTRAINT_NAME || ';'
  from dba_constraints
 where constraint_type in ('P','U') 
   and status = 'ENABLED' and table_name in
   (select table_name from dba_tables where owner != 'SYS');
prompt spool off
spool off
@disconxx.sql
prompt Check discon.lis log file for any errors
exit

I can understand why you don't want to drop the schemas - if you're
tracking dba_objects.last_ddl_time - that info would not be preserved on
a drop/re-create.

Paul

[EMAIL PROTECTED] wrote:
> 
> Hi All,
>  I want to import data from a user dump file but when i import data, i want
> to overwrite the existing data . Normally imp utility append data to
> existing rows. Requirement of application is such  that we need to
> overwrite existing data  without  dropping objects and its dependent
> objects. Is it possible with exp , imp utilities or  i have to delete data
> first and then import  using imp utility.
> Is there any other possibility...
> Environment Oracle8i, Windows NT4
> TIA
> 
> Azhar Siddiq
-- 
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).

Re: OT -- Windows Shutdown folder

[Rodd Holman]

No Windows doesn't have a similar functionality for shutdown.  I have used 
the PC Mag utility in the past.  It did what I needed for shutdown tasks. 
On Tuesday 27 March 2001 06:15, you wrote:
> Does anyone know of an equivalent of the Startup folder in Windows, but
> that would run just before shutdowns?
>
> I found a utility from PC Mag but I was wondering if there was something
> else out there.
>
> This has nothing to do with work, it's for my old Windows95 PC at home.
>
> Regards,
>
> Patrice Boivin
> Systems Analyst (Oracle DBA)
> Bedford Institute of Oceanography
> Fisheries and Oceans Canada

-- 
Rodd Holman
Oracle DBA
(605) 988-1373
[EMAIL PROTECTED]
Comments made are my own opinions and views. They do not represent views, 
policies, or procedures of LodgeNet Entertainment Corporation


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rodd Holman
  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: Execute priv to an isolated procedure inside a package

[Abdul Aleem]

Ian,

To my understanding you mean local procedure / functions, these then would
not be available outside the package. And has to be defined before any
local/public function/procedure that uses it. Am I right?

Aleem

 -Original Message-
Sent:   Tuesday, March 27, 2001 6:45 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Execute priv to an isolated procedure inside a package

I have not tested this.  I believe ,with about a 60% level of confidence,
you can place a function/procedure in the body of a package without placing
its definition in the package's specification.  If so, the
function/procedure should not be available when exectute is granted on the
package. 

Ian MacGregor
Stanford Linear Accelerator Center
ian@slac,stanford.edu 

-Original Message-
Sent: Monday, March 26, 2001 5:40 PM
To: Multiple recipients of list ORACLE-L


Hi friends,

One cannot grant execute privilege to a specific procedure/function inside a
package, but only for all or nothing that is in that package.

Anybody has an idea how this limitation can be overcomed.  One idea is to
create a separate stand-alone procedure that will just be a wrapper around
the packaged procedure and call it.  Any other ideas.

Thanks.

Djordje


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: djordjej
  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: Abdul Aleem
  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:RE: Execute priv to an isolated procedure inside a packag

[dgoulet]

After having written thousands of lines of PL/SQL procedures to revamp some of
our operational systems I can say with certainty that is you can create a
function/procedure within a package, and not include it in the specification. 
Problem is that the procedure/function is totally invisible to any other
function/procedure/anonymous PL/SQL block outside of the package.  Therefore to
the root question, "Can you grant execute on a specific function within a
package?" the answer is no.  You have to grant execute on the entire package,
but the only way an end user can access the package is through the
functions/procedures that are inside the specification. 

Dick Goulet

Reply Separator
Author: "MacGregor; Ian A." <[EMAIL PROTECTED]>
Date:   3/27/2001 5:45 AM

I have not tested this.  I believe ,with about a 60% level of confidence,  you
can place a function/procedure in the body of a package without placing its
definition in the package's specification.  If so, the function/procedure should
not be available when exectute is granted on the package. 

Ian MacGregor
Stanford Linear Accelerator Center
ian@slac,stanford.edu 

-Original Message-
Sent: Monday, March 26, 2001 5:40 PM
To: Multiple recipients of list ORACLE-L


Hi friends,

One cannot grant execute privilege to a specific procedure/function inside a
package, but only for all or nothing that is in that package.

Anybody has an idea how this limitation can be overcomed.  One idea is to
create a separate stand-alone procedure that will just be a wrapper around
the packaged procedure and call it.  Any other ideas.

Thanks.

Djordje


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: djordjej
  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: Execute priv to an isolated procedure inside a package

[Paul Baumgartel]

That is correct.


Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)


-Original Message-
Sent: Tuesday, March 27, 2001 8:45 AM
To: Multiple recipients of list ORACLE-L


I have not tested this.  I believe ,with about a 60% level of confidence,
you can place a function/procedure in the body of a package without placing
its definition in the package's specification.  If so, the
function/procedure should not be available when exectute is granted on the
package. 

Ian MacGregor
Stanford Linear Accelerator Center
ian@slac,stanford.edu 

-Original Message-
Sent: Monday, March 26, 2001 5:40 PM
To: Multiple recipients of list ORACLE-L


Hi friends,

One cannot grant execute privilege to a specific procedure/function inside a
package, but only for all or nothing that is in that package.

Anybody has an idea how this limitation can be overcomed.  One idea is to
create a separate stand-alone procedure that will just be a wrapper around
the packaged procedure and call it.  Any other ideas.

Thanks.

Djordje


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: djordjej
  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: Paul Baumgartel
  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: Insert

[Toepke, Kevin M]

Just to add my $0.02

I was working on a large ODS project where we had to process 8+ million
records each night into an Oracle 8i database sitting on a RAID-5 disk
array. 

At the start of the processing we trucated the table. We used parallel
direct-path SQL*Loader (12 instances). We had SQL*loader
SKIP_INDEX_MAINTENANCE. After the loads were complete, we rebuild the
indexes (3 of them) in parallel (DEGREE 8). The while process took under 10
minutes and was I/O bound the whole time.

Kevin Toepke

-
The information in this electronic mail message is Cendant Confidential
and may be legally privileged. It is intended solely for the
addressee(s). Access to this Internet electronic mail message by anyone
else is unauthorized. If you are not the intended recipient, any
disclosure, copying, distribution or action taken or omitted to be taken
in reliance on it is prohibited and may be unlawful.
-
The sender believes that this E-mail and any attachments were free of
any virus, worm, Trojan horse, and/or malicious code when sent. This
message and its attachments could have been infected during
transmission. By reading the message and opening any attachments, the
recipient accepts full responsibility for taking protective and remedial
action about viruses and other defects. Cendant Corporation is not
liable for any loss or damage arising in any way from this message or
its attachments.
-


-Original Message-
Sent: Tuesday, March 27, 2001 8:01 AM
To: Multiple recipients of list ORACLE-L


Usually one drop indexes before massive inserts. Mostly in data loads in DW
- if using direct path in SQL*Loader is not an option. It should be decided
on the basis if saved time on inserts > then time to rebuild an indexes.
Also you cannot drop indexes if system should be available during inserts.
(PK, Unique, FK constraints, performance).

Oracle does not rebuild indexes during inserts - please RTFM. Index
organized tables are not good candidates for tables with a lot of DML -
performance issues.

Alex Hillman
<>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  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: Source Code about Java Classes

[Richard Ji]

Just a thought, can you try to use JAD to decompile the Java classes?
We are able to mess with ATG Dynamo's code even though they didn't provide
us the source.

Richard

-Original Message-
Moriano
Sent: Tuesday, March 27, 2001 2:40 AM
To: Multiple recipients of list ORACLE-L



Hi all,

[EMAIL PROTECTED] wrote:

> Sergio,
>
> It doesn't seem to likely that Oracle will
> provide the source for their products.

I supposed it, but I only want the source for the oracle.forms.ui or the
oracle.forms.ui.vbutton. If it's not possible, i would like to have a
complete information about the methods an the posibble values of the
attributes for the  oracle.forms.ui class.

Thanks in advance.

>
>
> Jraed
> On Mon, 26 Mar 2001, Sergio Boix Moriano wrote:
>
> > Hi all,
> >
> > Does anyody knows how to find the source code about Forms java
> > classes (oracle.forms.ui), i've looked for it at OTN, Technet and
> > Metalink, and haven't found no documentation about it.
> >
> > Thanks in advance
> >
> >
>
> --
> 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: Sergio Boix Moriano
  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: Execute priv to an isolated procedure inside a package

[MacGregor, Ian A.]

I have not tested this.  I believe ,with about a 60% level of confidence,  you can 
place a function/procedure in the body of a package without placing its definition in 
the package's specification.  If so, the function/procedure should not be available 
when exectute is granted on the package. 

Ian MacGregor
Stanford Linear Accelerator Center
ian@slac,stanford.edu 

-Original Message-
Sent: Monday, March 26, 2001 5:40 PM
To: Multiple recipients of list ORACLE-L


Hi friends,

One cannot grant execute privilege to a specific procedure/function inside a
package, but only for all or nothing that is in that package.

Anybody has an idea how this limitation can be overcomed.  One idea is to
create a separate stand-alone procedure that will just be a wrapper around
the packaged procedure and call it.  Any other ideas.

Thanks.

Djordje


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: djordjej
  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: Execute priv to an isolated procedure inside a package

[Hillman, Alex]

You can create the wrapper procedure owned by user A. Give this user execute
on the package you are wrapping and give users who need to use wrapper
execute in wrapper procedure.

Alex Hillman

-Original Message-
From:   djordjej [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, March 26, 2001 8:40 PM
To: Multiple recipients of list ORACLE-L
Subject:Execute priv to an isolated procedure inside a
package

Hi friends,

One cannot grant execute privilege to a specific procedure/function
inside a
package, but only for all or nothing that is in that package.

Anybody has an idea how this limitation can be overcomed.  One idea
is to
create a separate stand-alone procedure that will just be a wrapper
around
the packaged procedure and call it.  Any other ideas.

Thanks.

Djordje


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: djordjej
  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: Insert

[james ellis]

Yes inserting into a table with an index does cause
degradation in the process, but it is very unrealistic
to drop and rebuild the index every time you do an
insert, unless it is a batch process that runs when no
other processing is being done. Also, deleting from
the index causes the index to be very fragmented and
eventually you will need to rebuild it to reclaim
unused space. 

james

--- Kevin Kostyszyn <[EMAIL PROTECTED]> wrote:
> Hi DBA's,
>   One of my developers just asked me a question, and
> honestly I don't know
> what he's talking about.  But, it made me think of
> my own that I do know the
> answer to or at least I used to:(   Anyway, when
> doing an insert into a
> table, doesn't it increase performance to delete any
> indexes, do the insert
> then rebuild the index.  Or do you just have to
> disable the index?  Also,
> does this work the same for delete?  Also...is there
> anyway to guestemate
> how long an insert is going to take?
> 
> 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).


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/?.refer=text
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: james ellis
  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: Execute priv to an isolated procedure inside a package

[Jamadagni, Rajendra]

I think your idea is the only solution other than yanking out the packaged
procedure and making it standalone.

HTH
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art !

*

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

*

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  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: IOUG university

[Hillman, Alex]

Anybody knows if they supply aany kind of materials besides standard
Powerpoint presentation?

Alex Hillman

-Original Message-
From:   Weaver, Walt [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, March 26, 2001 5:36 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: IOUG university

Well, I haven't been to any classes taught by Cary Millsap, but I
worked
with Cary in the late '80's. One of the sharpest individuals I've
ever
worked with, very personable, friendly, and down to earth. I would
imagine
his classes/seminars are very useful.

I've been to seminars put on by Gaja and Dave at OpenWorld and, if
memory
serves me right (very debatable), at the IOUG conference. Their
presentations were very interesting and useful. In addition, Dave
Ensor
could probably be a stand-up comedian. Very entertaining guy.

IMHO, and despite not looking at the course outlines, I'd say you
can't go
wrong with any of'em.

--Walt Weaver
  Bozeman, Montana, USA 

-Original Message-
Sent: Monday, March 26, 2001 2:52 PM
To: Multiple recipients of list ORACLE-L


I am specifically interested in Gary Miilsap,  Gaja Vaidynata and
Dave Ensor
courses - opinions about level, usefullness, materials etc.
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: Weaver, Walt
  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: Insert

[Hillman, Alex]

Usually one drop indexes before massive inserts. Mostly in data loads in DW
- if using direct path in SQL*Loader is not an option. It should be decided
on the basis if saved time on inserts > then time to rebuild an indexes.
Also you cannot drop indexes if system should be available during inserts.
(PK, Unique, FK constraints, performance).

Oracle does not rebuild indexes during inserts - please RTFM. Index
organized tables are not good candidates for tables with a lot of DML -
performance issues.

Alex Hillman

-Original Message-
From:   Saurabh Sharma [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, March 27, 2001 3:31 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Insert

well Kevin Kostyszyn, this is true that often we ignore such small
issues
which sometime impact the performance a lot.
ya, it's good if we do inserts and then rebuild the indexes, but
generally
not done during usual work., since every time u insert records ,
oracle
rebuilds the index itself with every entry (..if i'm not correct pls
suggest..)
and thus impact ther performance.
we certainly have an alternative to this situation, where we have
Index
organised tables..which do not build index on tables rather it
stores the
table as index.. but has its own ups and down sides..

saurabh


- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 2:56 AM


> Hi DBA's,
> One of my developers just asked me a question, and honestly I
don't know
> what he's talking about.  But, it made me think of my own that I
do know
the
> answer to or at least I used to:(   Anyway, when doing an insert
into a
> table, doesn't it increase performance to delete any indexes, do
the
insert
> then rebuild the index.  Or do you just have to disable the index?
Also,
> does this work the same for delete?  Also...is there anyway to
guestemate
> how long an insert is going to take?
>
> 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: Saurabh 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).
-- 
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: olap?

[Witold Iwaniec]

Go to Oracle web site and search for Olap...

Witold

On 26 Mar 2001, at 23:05, [EMAIL PROTECTED] wrote:

> Hallo,
>
> Can anyone tell me:
>
> What is OLAP and how does it work, a short description, thanks.
>
>
> Roland Sköldblom
>
>
>
> --
> 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: Witold Iwaniec
  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: Exp Imp Overwirte posiible or not?

[Joseph S. Testa]

truncate is not an option?

Joe
[EMAIL PROTECTED] wrote:
> 
> Hi All,
>  I want to import data from a user dump file but when i import data, i want
> to overwrite the existing data . Normally imp utility append data to
> existing rows. Requirement of application is such  that we need to
> overwrite existing data  without  dropping objects and its dependent
> objects. Is it possible with exp , imp utilities or  i have to delete data
> first and then import  using imp utility.
> Is there any other possibility...
> Environment Oracle8i, Windows NT4
> TIA
> 
> Azhar Siddiq
> 
> --
> 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).

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. 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).

OT -- Windows Shutdown folder

[Boivin, Patrice J]

Does anyone know of an equivalent of the Startup folder in Windows, but that
would run just before shutdowns?

I found a utility from PC Mag but I was wondering if there was something
else out there.

This has nothing to do with work, it's for my old Windows95 PC at home.

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada


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

OPS

[Sonja Šehović]

Hi all!
Does anyone know is it possible to configure OPS between two remote sites?

TIA,
Sonja
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?=
  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: Which is faster??

[Martin Kendall]

Thanks guys.

-Original Message-
Sent: 26 March 2001 18:26
To: Multiple recipients of list ORACLE-L


Direct patch sqlldr (and insert-append) do allow
indexes - its just that you get slugged a little more
on rollback and redo...

I don't have any metrics to compare - typical usage of
either tends be to the ol'  a) drop ind, b) load, c)
redindex

hth
connor

--- Martin Kendall <[EMAIL PROTECTED]> wrote: >
I know that Direct Path of sqlldr does not allow
> Indexes
> so what is the comparative performance of this
> suggestion if
> the given Table is indexed ?
> 
> Martin
> 
> -Original Message-
> Sent: 23 March 2001 09:05
> To: Multiple recipients of list ORACLE-L
> 
> 
> If you're on 8.0 or higher, try
> 
> insert /*+ APPEND */ 
> into table
> select * from other_table;
> 
> where "table" is defined as nologging.  Then you
> won't
> hit either redo logs or rollback segments..Its the
> equivalent of a sqlldr direct load
> 
> hth
> connor
> 
> --- CC Harvest <[EMAIL PROTECTED]> wrote: > I have
> the following scripts:
> > 
> > insert into table
> > select * from table2
> > ;
> > 
> > So if use the about bulk statement in my 
> > application, and the table2 is big, say 10
> > million records, my concern is that it's 
> > going to fail because of the possible rollback
> > segments failure. So then I have to use PL/SQL
> > to create a cursor and commit every 5 records.
> > What's the disadvantage of this?Will it be much
> > slower
> > than a bulk insert?
> > 
> > Can I do it another way: create a stored procedure
> > for this bulk insert, then pin this procedure in
> > memory, does it still have RBS problem?
> > 
> > Anyone has similar experience?
> > 
> > Thanks in Advance,
> > 
> > Chris
> > 
> > 
> > __
> > Do You Yahoo!?
> > Get email at your own domain with Yahoo! Mail. 
> > http://personal.mail.yahoo.com/
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > -- 
> > Author: CC Harvest
> >   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).
> 
> 
> =
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at 
> http://www.oradba.freeserve.co.uk)
> 
> "Some days you're the pigeon, some days you're the
> statue"
> 
>

> Do You Yahoo!?
> Get your free @yahoo.co.uk address at
> http://mail.yahoo.co.uk
> or your free @yahoo.ie address at
> http://mail.yahoo.ie
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Connor=20McDonald?=
>   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: Martin Kendall
>   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).


=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"


Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

RE: Forms Server - MS IIS

[Kuijten, F. (Frank)]

Tamas,

> This question got suddenly a nice twist: Oracle support told me, that
> probably -  I have to go to sales to know for shure - I would 
> not be able to
> get Forms Server without iAS although Forms server is a CGI.exe ...
That's correct. Oracle has bundled it with the Application Server Enterprise
Edition.


Greetings,
Frank 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kuijten, F. (Frank)
  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: How to remove the Ora & Lstn services from the WinNT

[Nihar]

from the nt resource kit u will get one utility called instsrv . use it to
remove the services



- NIHAR SANGHVI

NetMagic Solutions Pvt. Ltd.
22,Nirlon Complex,Western Express Highway,
Goregaon (E), Mumabai 400 063

Phone: 8723003 extn: 144
www.netmagicsolutions.com






-Original Message-
Sent: Tuesday, March 27, 2001 2:15 PM
To: Multiple recipients of list ORACLE-L


oradim  can be used to delete these services, though I've forgotten the
syntax at the moment and don't have any documentation to hand. Failing this,
you can also delete the services from the registry if you have permissions,
and are happy with doing this.

If memory serves they can be found in HKEY_LOCAL_MACHINE/SYSTEM/
*ControlSet* where the stars can be variables. usually looking for the
*Current* control set. Once deleted, you will need a reboot for the changes
to take place.

Now, I'm not sure if this is reccomended or not, or supported, so I'm going
to pull on my flamne retardent suit, and throws my hands in the air - If you
want to do this - it works!

HTH & YMMV

Mark


-Original Message-
Kumar Muthu Kumaran
Sent: Sunday, March 25, 2001 08:15
To: Multiple recipients of list ORACLE-L


Hi gurus,

I'm tried to Install Oracle 816, as the learner i did mistakes during
installation. Now i did sucessfully.

But when i checked in the WindowsNT servies, i found  many oracle services
that i was tried before.

Could you tell me, how to remove those things from ther serivce panel.

Thanks in Advance.

Regards,
Nirmal
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar  Muthu Kumaran
  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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nihar
  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).

Question when run BIS Runtime Repository Installation Wizard

[mentor]

HELP!
I am an newer of oracle.
I wanna  develop warehouse  useing OWB.
After i install the EIS, I run the BIS Runtime Repository Installation wizard
to Create and install into new BIS Repository Schema.
But no matter i feed the APPS Schema user, wizard tell me:
"not able to connect to Oracle Application database ,please werify the server 
information."
infact I now onthing of 'APPS Schemer'
how can i do ??
Thanks ,James Tao
 


-- 
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: How to remove the Ora & Lstn services from the WinNT

[Mark Leith]

oradim  can be used to delete these services, though I've forgotten the
syntax at the moment and don't have any documentation to hand. Failing this,
you can also delete the services from the registry if you have permissions,
and are happy with doing this.

If memory serves they can be found in HKEY_LOCAL_MACHINE/SYSTEM/
*ControlSet* where the stars can be variables. usually looking for the
*Current* control set. Once deleted, you will need a reboot for the changes
to take place.

Now, I'm not sure if this is reccomended or not, or supported, so I'm going
to pull on my flamne retardent suit, and throws my hands in the air - If you
want to do this - it works!

HTH & YMMV

Mark


-Original Message-
Kumar Muthu Kumaran
Sent: Sunday, March 25, 2001 08:15
To: Multiple recipients of list ORACLE-L


Hi gurus,

I'm tried to Install Oracle 816, as the learner i did mistakes during
installation. Now i did sucessfully.

But when i checked in the WindowsNT servies, i found  many oracle services
that i was tried before.

Could you tell me, how to remove those things from ther serivce panel.

Thanks in Advance.

Regards,
Nirmal
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar  Muthu Kumaran
  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: Forms Server - MS IIS

[Szecsy Tamas]

Thanks to all who replied. 

This question got suddenly a nice twist: Oracle support told me, that
probably -  I have to go to sales to know for shure - I would not be able to
get Forms Server without iAS although Forms server is a CGI.exe ...

Tamas Szecsy

-Original Message-
Sent: 2001.March.23. 3:41 PM
To: Multiple recipients of list ORACLE-L


Hi Listers,

don't stone me for this question :-), but can Forms Server 6i cooperate with
Microsoft IIS to provide Forms over the Web?

TIA,

Tamas Szecsy
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Szecsy Tamas
  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: Szecsy Tamas
  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).

Parallel Server

[Muhammed Adnan Ansari]

Do any body worked with Parallel server without a
Hardware cluster...i mean just an evaluation of
parallel server ...if yes then how??/

Adnan

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/?.refer=text
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Muhammed Adnan Ansari
  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: OLAP again

[paquette stephane]

Hi,

You are right , Oracle 8i and Oracle Express are 2
different products. 

In Oracle 9i, Oracle will integrated OLAP server
capabilities called OLAP Services, like Microsoft ;-)

I'm not sure that OLAP tools are the answer to your
needs. OLAP tools are used to stored data in a cube
format to slice and dice the data not to explore the
data or handle massive storage.

If you're looking for a tool to do industrial strenght
reporting, go with Brio. It beats all the other
products for massive reports, on the negative side
it's not as nice looking as Business Objects or
Cognos.



--- Witold Iwaniec <[EMAIL PROTECTED]> a
écrit : > Hi
> 
> Our product uses quite complex data model and we are
> looking for 
> ways to speed up data access, especially large
> reports in the 
> range of 25,000+ records.
> One of the ideas was to look into OLAP, or now
> Business 
> Intelligence, tools. After some reading it seems to
> me that OLAP is 
> completely separate product - it is the Express
> Server that runs its 
> own database, and tools like Express Objects,
> Express Analyzer 
> that use the Oracle 9iAS and Express Server
> technology. You can 
> still connect to your Oracle database or
> import/export the data for 
> analysis, reporting, etc. but you have to set up
> completely new 
> environment.
> 
> We hoped that we could use OLAP tools to point to
> Oracle 8i 
> database and use it to provide faster access to our
> complex data 
> model but it does not seems so straightforward. Or
> maybe I 
> missed a tool. Could someone, please, correct me?
> 
> Thanks
> 
> Witold
> ==
> Witold Iwaniec
> Senior Software Developer
> NovaLIS Technologies
> [EMAIL PROTECTED] 
> http://www.novalistech.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Witold Iwaniec
>   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).


=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/?.refer=text
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  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: OLAP again

[paquette stephane]

Hi,

You are right , Oracle 8i and Oracle Express are 2
different products. 

In Oracle 9i, Oracle will integrated OLAP server
capabilities called OLAP Services, like Microsoft ;-)

I'm not sure that OLAP tools are the answer to your
needs. OLAP tools are used to stored data in a cube
format to slice and dice the data not to explore the
data or handle massive storage.

If you're looking for a tool to do industrial strenght
reporting, go with Brio. It beats all the other
products for massive reports, on the negative side
it's not as nice looking as Business Objects or
Cognos.




--- Witold Iwaniec <[EMAIL PROTECTED]> a
écrit : > Hi
> 
> Our product uses quite complex data model and we are
> looking for 
> ways to speed up data access, especially large
> reports in the 
> range of 25,000+ records.
> One of the ideas was to look into OLAP, or now
> Business 
> Intelligence, tools. After some reading it seems to
> me that OLAP is 
> completely separate product - it is the Express
> Server that runs its 
> own database, and tools like Express Objects,
> Express Analyzer 
> that use the Oracle 9iAS and Express Server
> technology. You can 
> still connect to your Oracle database or
> import/export the data for 
> analysis, reporting, etc. but you have to set up
> completely new 
> environment.
> 
> We hoped that we could use OLAP tools to point to
> Oracle 8i 
> database and use it to provide faster access to our
> complex data 
> model but it does not seems so straightforward. Or
> maybe I 
> missed a tool. Could someone, please, correct me?
> 
> Thanks
> 
> Witold
> ==
> Witold Iwaniec
> Senior Software Developer
> NovaLIS Technologies
> [EMAIL PROTECTED] 
> http://www.novalistech.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Witold Iwaniec
>   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).


=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED]

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/?.refer=text
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  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: Insert

[Saurabh Sharma]

well Kevin Kostyszyn, this is true that often we ignore such small issues
which sometime impact the performance a lot.
ya, it's good if we do inserts and then rebuild the indexes, but generally
not done during usual work., since every time u insert records , oracle
rebuilds the index itself with every entry (..if i'm not correct pls
suggest..)
and thus impact ther performance.
we certainly have an alternative to this situation, where we have Index
organised tables..which do not build index on tables rather it stores the
table as index.. but has its own ups and down sides..

saurabh


- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 2:56 AM


> Hi DBA's,
> One of my developers just asked me a question, and honestly I don't know
> what he's talking about.  But, it made me think of my own that I do know
the
> answer to or at least I used to:(   Anyway, when doing an insert into a
> table, doesn't it increase performance to delete any indexes, do the
insert
> then rebuild the index.  Or do you just have to disable the index?  Also,
> does this work the same for delete?  Also...is there anyway to guestemate
> how long an insert is going to take?
>
> 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: Saurabh 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).

Exp Imp Overwirte posiible or not?

[azhar]

Hi All,
 I want to import data from a user dump file but when i import data, i want
to overwrite the existing data . Normally imp utility append data to
existing rows. Requirement of application is such  that we need to
overwrite existing data  without  dropping objects and its dependent
objects. Is it possible with exp , imp utilities or  i have to delete data
first and then import  using imp utility.
Is there any other possibility...
Environment Oracle8i, Windows NT4
TIA

Azhar Siddiq

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