Re: How to downgrade database from 8.1.5 to 8.0.6 - Urgent Help P

[Saurabh Sharma]

for downgrading from oracle 8 to 7, u need to take 
complete export and import the file in oracle 7 by running the catexp7.sql 
utility.
look for more help on this utility.
 

  - Original Message - 
  From: 
  Djordje Jankovic 
  To: Multiple recipients of list ORACLE-L 
  Sent: Thursday, May 17, 2001 10:56 
  PM
  Subject: RE: How to downgrade database 
  from 8.1.5 to 8.0.6 - Urgent Help P
  
  The 
  safest way is to do a full database export, to create a new 8.0.6 database 
  instance and to import the data in the new database.  You have to 
  see for inter-version specifics - you might need to use 8.1.5 import version 
  to import in the 8.0.6 database - you have to check that, but it is for sure 
  doable.
   
  If 
  at all possible, I would not delete the original 8.1.5 database before I am 
  fully done with the import and I test that 8.0.6 is working 
  fine.
   
  If 
  you do not have enough space for 8.1.5 + export file + 8.0.5 (and you are on 
  unix) you might use the named pipes for export/import (again make sure that 
  the exp/imp versions are OK):
   
    
  · 
  create a named pipe:
  $ mknod p_expimp p
  · 
  export from the source database to the pipe:
  $ exp userid=src_username/password file=p_expimp OtherParameters
  · 
  at the same time importing from the pipe is started:
  $ imp userid=trg_username/password file=p_expimp buffer=1024000 
  OtherParameters
   
  Djordje
  
-Original Message-From: Helen rwulfjeq 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, May 17, 2001 12:16 
PMTo: Multiple recipients of list ORACLE-LSubject: How 
to downgrade database from 8.1.5 to 8.0.6 - Urgent Help 
Please!
Hello: 
Please help me on this crisis! What is the steps and safe procedures to 
downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon 
today.
 I have database 8.1.5 with all schemas and data. But the 
application can not support 8.1.5.  I have to install 8.0.6.(new one)   Then I need get all those data and 
schemas into 8.0.6. I know in some way this can be done, Now matter 
how risk I have to do at client's request. 
What is the steps and safe procedures???
Thanks in advance


Do You Yahoo!?Yahoo! 
Auctions $2 Million Sweepstakes - Got something to 
sell?

Errorhandling

[Roland . Skoldblom]

Hallo you DBA's:

Can  someone give me an example on how to write the code to trap errors where the 
field is too large to fit in the size of the  PL/SQL
variable?

 I also want the errors to be logged in a table. Please give me a good example on 
PL/SQL code and also includ ethe insert statement into the table.

Sincerely

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

OOT - Invitation to subscribe indonesia mailing list - [ORAID!]

[Ahmadsyah Algozhi Nugroho]

Title: OOT - Invitation to subscribe indonesia mailing list - [ORAID!]





Dear all,
I invite you all to subscibe [ORAID!] mailing list. This mailing list is for Indonesian speaking people to share information, tips & trick, technology, knowledge, job vacancy and many more that related with Oracle Database/Tools/Application/Development/etc. You could write using both Indonesian or English. To subscribe send blank mail to [EMAIL PROTECTED]

TIA,



Ahmadsyah Alghozi Nugroho
Database Engineering Specialist
PT Infoglobal AutOptima
Jl. Baruk Tengah I/49
Surabaya - Jawa Timur
Indonesia
phone : +62 (31) 8708456 ext.113

RE: Would you increase the shared pool? --URGENT

[Steve Adams]

Hi Pablo,

Your shared pool is too big, not too small, and you are parsing too frequently
(probably some literal SQL). Your use of synonyms is an exacerbating factor.
Your reloads are due to the invalidations. They do not indicate that your shared
pool is too small.

Of course, you should worry about the major issues first.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 18 May 2001 2:01
To: Multiple recipients of list ORACLE-L


Hello Gurus,

I need help in this performance issue.

Oracle 7.3.4
HPUX 10.20

I 've got this ratios:

BC hit ratio   98
dictionary cache hit rate 100
library cache get hit ratio91
library cache pin hit ratio98

Mayor waits are enqueue (57%), buffer busy waits(34%),
especially p3=0 for some big tables (buffer being read
from disk), and latch free (6%).

I'm dealing with enqueue and bbw, but what would you
do with the low LC ratio and the shared pool in this
case.

Latch free waits details

LATCH TYPEIMPACT SLEEP RATE   LATCH
-
shared pool  123285  1.05%  27097
library cache58841  0.06%103
cache buffers chains 18108  0.00%  0


This is the library cache stat:

NAMESPACE GETHITRATIO PINHITRATIO RELOADS INVALIDAT

SQL AREA .73288057 .97035171 47011 13891
TABLE/PROCEDURE  .99150783 .99813894 11758 0
BODY .9975282  .9971979   32   0
TRIGGER  .99816161 .99591602  61   0
INDEX .03401361   .02267574 5  0
CLUSTER   .   . 0  0
OBJECT1   1 0  0
PIPE  .9414   .9415 0  0


The keep object summary

TYPE OBJECTS  KEPT   RELOADSOWNERS
-- - - - -
TABLE389 0  166112
SYNONYM  348 0  2574 4
PACKAGE  294   293   131 4
PACKAGE BODY 292   29123 4
TRIGGER  220   22052 9
VIEW 170 0   373 3
SEQUENCE 108   108   13111
NON-EXISTENT  68 2   153 8
PROCEDURE 606047 2
FUNCTION  1616 4 1

PARAMETER  VALUE USAGE
-- - -
session_cached_cursors   100   81%
open_cursors 500   85%



Shared Pool

RECURRENT TRANSIENTFLUSHED PINS ANDORA-4031
   CHUNKSCHUNKSCHUNKS  RELEASESERRORS
- - - - -
 3051  5374655389   5351916 0



Shared pool free lists

   BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZE
BIGGEST
- -- --- 
-
0  795521707   46
72
1  45760 516   88
96
8   9480   1 9480
9480
9   41165488179722907
32776
   10   48335568109344222
65424
   11   20518744 24284788
130072
   124383200  26   168584
246496
   13 807072   2   403536
447040


TIA

___
Do You Yahoo!?
Yahoo! Messenger: Comunicación instantánea gratis con tu gente -
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).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: unhandled user-defined exception

[Raymond Lee Meng Hong]

Title: unhandled user-defined exception



 You do a DMBS-OUTPUT the SQLMM , SQLCODE to check 
on what might be the coz of error...in you PL/SQL.

  -Original Message-From: Venugopal, R (GEP, 
  Contractor) [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 
  17, 2001 7:25 PMTo: Multiple recipients of list 
  ORACLE-LSubject: unhandled user-defined exception 
  
  Hi Gurus       I am getting the error attached below when trigger fires. 
  what could be the reasons for this error. 
    DB error: ORA-06510: 
  PL/SQL: unhandled user-defined exception      Thanks in 
  Advance Venu   

RE: Temporary files and Quick i/o

[A. Bardeen]

Steve,

The only files that can be sparse are tempfiles with
8i+  See note 6224.1 "ALERT: Sparse Files and Oracle"
(don't be fooled by the Oracle6 in the note, it
includes 8i info as well).

HTH,

-- Anita

--- Steve Adams <[EMAIL PROTECTED]> wrote:
> Hi Johnson,
> 
> I don't believe that tempfiles can be sparse
> (although I may be wrong) and I am
> confident that datafiles cannot be. Maybe you should
> log a TAR with Oracle
> support to checkout whether tempfile can be sparse
> and just use datafiles until
> then. Anyway, can you please post the URL to the tip
> you mentioned. While it is
> the sort of thing I might say, I don't remember
> actually having said so.
> 
> @   Regards,
> @   Steve Adams
> @   http://www.ixora.com.au/
> @   http://www.christianity.net.au/
> 
> 
> -Original Message-
> Sent: Friday, 18 May 2001 0:05
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi,
> 
> After reading Steve Adams'  tip on making temp files
> quick io. I posed this question to Veritas as they
> had
>  told us not do so. The answer they give is the
> following.
> 
> Temporary datafiles should not be converted to quick
> i/o files.  The following is an excerpt from the
> administrator's Guide: Tablespaces marked TEMPORARY
> can be sparse, which means that not all blocks in
> the
> file are allocated. Quick I/O files cannot be
> sparse,
> as Quick I/O provides a raw-type interface to
> storage.
> If a sparse file is converted to a Quick I/O file,
> the
> Oracle instance can fail if Oracle attempts to write
> into one of these unallocated blocks.
> 
> I would appreciate your thoughts on this?
> 
> Johnson Job
> 
> 
> __
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great
> prices
> http://auctions.yahoo.com/
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Johnson Poovathummoottil
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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: Steve Adams
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

User-define Aggregate Function

[Ahmadsyah Algozhi Nugroho]

Title: User-define Aggregate Function





Dear Gurus,
Can I build user define aggregate function, like Sum,count,etc..


TIA,



Ahmadsyah Alghozi Nugroho
Database Engineering Specialist
PT Infoglobal AutOptima
Jl. Baruk Tengah I/49
Surabaya - Jawa Timur
Indonesia
phone : +62 (31) 8708456 ext.113

RE: OT - Books Covering Partitioning in 8i

[Raymond Lee Meng Hong]

Hei 

  I'm planning to know some brieft and detail on Data Warehouse and Data
Mart , but I don't know where to start from ? Any site /doc which I can get
the head start from there ??


-Original Message-
Sent: Friday, May 18, 2001 8:36 AM
To: Multiple recipients of list ORACLE-L


Listers,

I might end up on a Data Warehouse and Data Mart project using 8i. I've read
various white papers, Oracle doc's, etc on partitioning capabilities of
8/8i. And I've dinked around on my test machine a bit trying things out. Are
there any books out there that you would recommend for digging deeper into
the partitioning subject? I have some prior experience in the DW/DM arena on
*V7*, but, a book going into real detail on partitioning in 8i, what works
well when, what doesn't, gotcha's to look out for, etc would be helpful.

I've already been planning on getting Jonathan Lewis's "Practical Oracle
8i". And I heard and/or read that it does a good job of covering
partitioning. I've also accumulated a list of recommendations for Oracle
specific DW books, though I don't have any of them yet. I already own, and
have read, an assortment of Inmon and Kimball books on DW.

Thanks,

Larry G. Elkins
[EMAIL PROTECTED]

-- 
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: Raymond Lee Meng Hong
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 make DBA cannot 'see' User's Tables?

[A. Bardeen]

Doh!  I knew there was something else I was forgetting
(shows you how many times I've used it).  Thanks Paul
and Rachel and Jared!

-- Anita

--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> to carry this forward (hey Paul and Anita!)
> 
> you can also look at:
> 
>
http://www.cybcon.com/~jkstill/util/encryption/encryption.html
> 
> Jared's site with some VERY easy to understand
> explanations on how to use 
> encryption
> 
> and yes the string length has to be a multiple of 8
> characters
> 
> Rachel
> 
> >From: Paul Drake <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> >Subject: Re: How to make DBA cannot 'see' User's
> Tables?
> >Date: Wed, 16 May 2001 21:56:01 -0800
> >
> >"A. Bardeen" wrote:
> > >
> > > You can encrypt using only a 56-bit key (the key
> > > length limitation is a requirement of US
> regulations
> > > governing the export of cryptographic products).
> > >
> > > HTH,
> > >
> > > -- Anita
> >
> >Hi Anita.
> >
> >
> >Ahmadsyah,
> >
> >I believe that you also have to pad the string to a
> length that is a
> >multiple of 8 characters.
> >Your key string was 10 characters.
> >
> >here's the obligatory link to the fine manual:
> (that includes a code
> >example)
>
>http://technet.oracle.com/doc/oracle8i_816/server.816/a76936/dbms_obf.htm#6518
> >
> >Paul
> >
> >
> > >
> > > --- Ahmadsyah Algozhi Nugroho
> <[EMAIL PROTECTED]>
> > > wrote:
> > > > I'm using Oracle 8.1.7.
> > > > there was an error
> > > > ERROR at line 1:
> > > > ORA-28232: invalid input length for
> obfuscation
> > > > toolkit
> > > > ORA-06512: at
> "SYS.DBMS_OBFUSCATION_TOOLKIT_FFI",
> > > > line 0
> > > > ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT",
> line
> > > > 33
> > > > ORA-06512: at "SCOTT.IAO_PROTECT", line 15
> > > > ORA-06512: at line 1
> > > >
> > > > I check thath my key and my input string is
> > > > varchar12(10).
> > > > Key = 0123456789
> > > > input string = 'testtestte'
> > > >
> > > > dbms_obfuscation_toolkit.desencrypt (
> > > >   input_string => 'testtestte'
> > > >   , key_string => '1234567890'
> > > >   , encrypted_string => vEncrypted
> > > >   );
> > > > Am I forget something?
> > > >
> > > > TIA,
> > > >
> > > >
> > > > Ahmadsyah Alghozi Nugroho
> > > > Database Engineering Specialist
> > > > PT Infoglobal AutOptima
> > > > Jl. Baruk Tengah I/49
> > > > Surabaya - Jawa Timur
> > > > phone : +62 (31) 8708456 ext.113
> > > > > From: Srinagesh Battula
> > > > [mailto:[EMAIL PROTECTED]]
> > > > > Sent: Thursday, May 17, 2001 7:26 AM
> > > > > To: Multiple recipients of list ORACLE-L
> > > > > Subject: RE: How to make DBA cannot 'see'
> User's
> > > > Tables?
> > > > >
> > > > >
> > > > >
> > > > > You can encrypt & Decrypt data using the
> > > > > DBMS_OBFUSCATION_TOOLKIT package
> > > > > (comes with 8.1.6)
> > > > >
> > > > > Srinagesh "What do I know any way" Battula
> > > > >
> > > > > > -Original Message-
> > > > > > From: Khedr, Waleed
> > > > [mailto:[EMAIL PROTECTED]]
> > > > > > Sent: Wednesday, May 16, 2001 4:21 PM
> > > > > > To: Multiple recipients of list ORACLE-L
> > > > > > Subject: RE: How to make DBA cannot 'see'
> User's
> > > > Tables?
> > > > > >
> > > > > >
> > > > > > Data Encryption?
> > > > > >
> > > > > > -Original Message-
> > > > > > Sent: Wednesday, May 16, 2001 7:01 PM
> > > > > > To: Multiple recipients of list ORACLE-L
> > > > > >
> > > > > >
> > > > > >
> > > > > > Dear gurus,
> > > > > > How to make DBA cannot 'see' user's datas?
> > > > > > I build an application which very
> important and
> > > > top secret
> > > > > > even DBA cannot
> > > > > > 'see' this data. But DBA can backup this
> > > > data.What is the
> > > > > > solution for this
> > > > > > problem?
> > > > > >
> > > > > > TIA,
> > > > > >
> > > > > >
> > > > > > Ahmadsyah Alghozi Nugroho
> > > > > > Database Engineering Specialist
> > > > > > PT Infoglobal AutOptima
> > > > > > Jl. Baruk Tengah I/49
> > > > > > Surabaya - Jawa Timur
> > > > > > phone : +62 (31) 8708456 ext.113
> > > > > >
> > > > > > --
> > > > > > Please see the official ORACLE-L FAQ:
> > > > http://www.orafaq.com
> > > > > > --
> > > > > > Author: Khedr, Waleed
> > > > > >   INET: [EMAIL PROTECTED]
> > > > > >
> > > > > > Fat City Network Services-- (858)
> 538-5051
> > > > FAX: (858) 538-5051
> > > > > > San Diego, California-- Public
> Internet
> > > > access /
> > > > > Mailing Lists
> > > > > >
> > > >
> > >
>

> > > > > > To REMOVE yourself from this mailing list,
> send
> > > > an E-Mail message
> > > > > > to: [EMAIL PROTECTED] (note EXACT
> spelling of
> > > > 'ListGuru') and in
> > > > > > the message BODY, include a line
> containing:
> > > > UNSUB ORACLE-L
> > > > > > (or the name of mailing list you want to
> be
> > > > removed from).  You may
> > > > > > also send the HELP command for other
> information
> > 

Re: Moving a database to a different machine

[Jared Still]

Steve,

Do you recall doing this about 5 years ago?

I recall doing this same procedure there, but without
benefit of standby database.

Total downtime was less than 2 hours, and we did
it during a slow period.  ( probably Saturday night :(

Jared


On Thursday 17 May 2001 13:48, Steve McClure wrote:
> Koivu, Lisa said
> "A word of warning, and you probably already know this: you can't have both
> databases open at the same time or you will end up with incompatible
> archive logs and control files. Good luck !"
> 
> hehe I did know, but upon reading your warning it still frightened me for a
> moment. Because I was planning to do this one time prior to the move to
> allow for testing. Therefore having both databases up and running at the
> same time on the two different machines. I know I will have to do the
> migration again when we actually move, so that the database(s) will recover
> properly. Oh and thanks for the tip about just moving the arc/redo/control
> files back to the production machine to resynch the DBs. That will save me
> from some tedium on moving day.
> Steve McClure
> -Original Message-
> Sent: Thursday, May 17, 2001 11:47 AM
> To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
>
> Hi Steve,
> I used this same strategy with a migration last month. It minimized our
> database related downtime to 30 minutes (and then they unplugged the
> symmetrix and the app server was down for 12 hours. Oh well)
> This plan will work. Once your production machine is physically moved and
> set up, you can do the reverse to apply changes to the prod database
> without copying over the entire database from dev:
> Starting with production database down, the following steps will bring prod
> up to date:
> 1. Shutdown dev
> 2. Copy over control files/redo logs/arc logs
> 3. Start up prod
> 4. Initiate recovery
> Voila. Slick.
> A word of warning, and you probably already know this: you can't have both
> databases open at the same time or you will end up with incompatible
> archive logs and control files. Good luck !
>
> Lisa Rutland Koivu
> Oracle Database Administrator
> Certified Self-Important Database Deity
> Slayer of Unix Administrators
> Wanton Kickboxing Goddess
> [EMAIL PROTECTED]
>
> NeoMedia
>
> 2201 Second St., Suite 600
> Fort Myers, FL 33901, USA
> Phone: 941-337-3434
> Fax: 941-337-3668
> www.neom.com 
> www.paperclick.com 
> www.qode.com 
>
> P a p e r C l i c k . c o m 
> Enter Your PaperClick Code Here!
>
> -Original Message-
> Sent: Thursday, May 17, 2001 2:26 PM
> To: Multiple recipients of list ORACLE-L
> Allright,
> We are physically moving our office, and have an OLTP application that
> needs to be up and running with minimal downtime. The current plan is to
> use the development computer as the production platform while the Primary
> computer is physically moved to the new location. The development system
> was the production system about 6 months ago, so it will not be under too
> much strain.
> I have completely duplicated the filesystems of the Primary machine on the
> development box.
> This is my plan. Please comment if there is an obviously better way. Oh
> the database is version 7.3.4
> 1.Put the tablespaces of the production database in backup mode.
> 2.Copy datafiles across the network to the "development" machine. Approx 3
> GB
> 3.Take the production tablespaces out of backup mode.
> 4.Force a log switch.(Habit I guess)
> 5.wait until the production system is brought down.
> 6.move the control files and redo logs to the development system
> 7.move the initSID.ora and configSID.ora files.
> 8.edit configSID.ora to change the host associated to Listener.
> 9.fire up svrmgrl, and recover the database.
> 10.change the tnsnames on the client systems to point to the development
> machine.
> Of course. This needs to be tested to some degree first. And we(well
> management at least) don't want to bring the production machine down to
> roll the databases forward together just for a test. I can use make a
> backup control file for use during recovery, and move the curently offline
> redo logs. I am not sure what to do about the most current redo log in this
> case. I have played with backup and recovery, but not this scenario. I
> don't currently have my copy of the Velpuri backup and recovery handbook at
> hand(Loaned it to a colleague). So I am bouncing this off of you folks
> while I ponder this until I retrieve my backup and recovery bible. Any
> Comments are appreciated.
> Thanks,
> Steve McClure
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Steve McClure
> INET: [EMAIL PROTECTED]
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing li

9iAS Forms Stability Follow-up

[elkinsl]

Listers,

I asked about this question a while back (9iAS 1.0.2 / Forms 6i Patch 2 /
Apache / connect mode = http / HP-UX 11.0). I thought I would give an update
since a few people showed interested in the subject.

They were seeing the Forms server crash numerous times a day in a test
environment. After the SA and DBA's opened up a TAR, Oracle recommended
using sockets for the current version due to a handful of problems using
http/https connect mode. Oracle recommended going on up to Patch 5 when
available, but, in the meantime to use Patch 4 and apply a one off to that.
Supposedly that will stabilize things when using the http connection mode.
They also want to use native IE (lots of stuff on that, long story). And
while they have got that running well, Oracle Support said numerous problems
would be encountered, under load, going with native IE unless they got up to
date on the patches. They are also still considering, due to licensing costs
(I think), testing things using Win2k servers running 9iAS and the Forms
Servers as opposed to the 4 HP "D" boxes currently dedicated as Forms
Servers on the existing OAS/Forms 5.0 intranet deployed app.

Since changing to sockets on Patch 2, they haven't seen any problems with
the forms server crashing. This is testing with both JInitiator and native
IE. They aren't putting a huge load on it though.

If anyone has thoughts, war stories, or any other info they want to add, or,
correct anything said above, have at it.

If anyone is interested in keeping in the loop on what they find out, drop
me a *PRIVATE* email and I will do my best to relay any information,
pitfalls, problems, successes, etc that they encounter.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]

-- 
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: job offer from SAUDI ARABIA

[Gregory Conron]

On Thu, 17 May 2001, Gene Sais wrote:
> Only in America, can you rant!  Try to criticize China while living
there.  I have a friend there, her mail is read before she gets it. 
All she can write is general stuff, nothing negative, fearful of her
life.  The best thing about America is that you can b*tch if you want. 
I served for this country and love this country.  *GO USA*


As long as you don't criticize the church of scientology :)
http://slashdot.org/article.pl?sid=01/05/17/0238223&mode=nested


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: job offer from SAUDI ARABIA

[Regina Harter]

Statistically, handguns bought for protection are more likely to be used 
against a family member (intentionally or otherwise) than against any 
"criminal element".


At 04:05 PM 5/17/01 -0800, you wrote:
>reality check.
>
>Consider the poignant implications of the recent anniversary of the
>Oklahoma city terrorism.
>
>The simple fact is that a very high percentage of professional women
>that have jobs like real estate sales requiring isolated contact with
>strangers *are* armed (as you state, many with "boutique" designer
>guns). it is because they have been assaulted or threatened, or are
>close to women that have told vivid stories of such.
>
>Employees at this campus are required to take *mandatory* "campus
>violence" workshops now. Last year a professor was severly beaten by
>some petty thieves after leaving a night class about 2 minutes walk
>from my office. Several years ago, someone held an admission
>counselor hostage at gun point in the building I work in. The person
>was upset that they weren't admitted to the university.
>
>regards,
>ep
>(unarmed, but unrepentantly politically incorrect)
>
>On 17 May 2001, at 13:16, Marianne Brooks wrote:
>
>Date sent:  Thu, 17 May 2001 13:16:06 -0800
>To: Multiple recipients of list ORACLE-L 
><[EMAIL PROTECTED]>
>
> > SET MODE SILLY ON
> >
> > Damn, I  *knew* I forgot to buy something on my last shopping trip to
> > Nordstroms!
> >
> > Note to self:  - buy gun I didn't know I needed.  Remember to purchase
> >   extras for friends who don't have them either(the gift
> > that keeps
> >   on taking?)
>
>...
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Eric D. Pierce
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Temporary files and Quick i/o

[Khedr, Waleed]

I think that the failure will not be caused by Oracle but by the quick-io
driver itself since it has to have full access to all the physical allocated
blocks and also it depends on how Veritas will communicate back its failure
to Oracle.

Getting rid of the sparse space may be a good idea!

Regards,

Waleed

-Original Message-
Sent: Thursday, May 17, 2001 9:00 PM
To: Multiple recipients of list ORACLE-L


Hi All,

OK, you're all correct. Tempfiles can be sparse (it seems to be platform
specific). Nevertheless, I'm unclear why Veritas think that is it any more
of a
problem for Oracle to get ENOSPC from a sparse tempfile if it is a QIO file
than
otherwise. Presumably Oracle would just raise ORA-7376 in both cases. The
instance would not fail because tempfile I/O is always done direct (not by
DBWn). But if Veritas say not to do it, then I suppose that is good enough.
The
solution of course must be to use raw, rather than a filesystem based
tempfile
at all, for all the good reasons that would have pushed you toward QIO in
the
first place.

Johnson,

Could you please post the URL to the tip you mentioned so that I can fix it.

@   Thanks,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 18 May 2001 10:06
To: Multiple recipients of list ORACLE-L


I noticed this when I was playing with 9i. Regular tablespaces take long
time to be created and temporary ones take nothing.

Here is the proof:

$ ls -l temp01.dbf
-rw-rw-r--   1 oracle   dba  209719296 May 17 18:55 temp01.dbf

$ du -k temp01.dbf
40968   temp01.dbf

$ ls -l users01.dbf
-rw-rw-r--   1 oracle   dba  26218496 May 11 20:27 users01.dbf

$ du -k users01.dbf
25608   users01.dbf

Regards,

Waleed

-Original Message-
Sent: Thursday, May 17, 2001 7:41 PM
To: Multiple recipients of list ORACLE-L


If you create tablespace like - create temporary tablespace
 ... 
created file will be sparse.

Alex Hillman


-Original Message-
Sent: Thursday, May 17, 2001 6:30 PM
To: Multiple recipients of list ORACLE-L


Hi Johnson,

I don't believe that tempfiles can be sparse (although I may be wrong) and I
am
confident that datafiles cannot be. Maybe you should log a TAR with Oracle
support to checkout whether tempfile can be sparse and just use datafiles
until
then. Anyway, can you please post the URL to the tip you mentioned. While it
is
the sort of thing I might say, I don't remember actually having said so.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 18 May 2001 0:05
To: Multiple recipients of list ORACLE-L


Hi,

After reading Steve Adams'  tip on making temp files
quick io. I posed this question to Veritas as they had
 told us not do so. The answer they give is the
following.

Temporary datafiles should not be converted to quick
i/o files.  The following is an excerpt from the
administrator's Guide: Tablespaces marked TEMPORARY
can be sparse, which means that not all blocks in the
file are allocated. Quick I/O files cannot be sparse,
as Quick I/O provides a raw-type interface to storage.
If a sparse file is converted to a Quick I/O file, the
Oracle instance can fail if Oracle attempts to write
into one of these unallocated blocks.

I would appreciate your thoughts on this?

Johnson Job

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Khedr, Waleed
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Temporary files and Quick i/o

[Steve Adams]

Hi All,

Another correction. That error number has been changed to 7248 since Oracle8. I
think I need a coffee!

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 18 May 2001 10:01
To: Multiple recipients of list ORACLE-L


Hi All,

OK, you're all correct. Tempfiles can be sparse (it seems to be platform
specific). Nevertheless, I'm unclear why Veritas think that is it any more of a
problem for Oracle to get ENOSPC from a sparse tempfile if it is a QIO file than
otherwise. Presumably Oracle would just raise ORA-7376 in both cases. The
instance would not fail because tempfile I/O is always done direct (not by
DBWn). But if Veritas say not to do it, then I suppose that is good enough. The
solution of course must be to use raw, rather than a filesystem based tempfile
at all, for all the good reasons that would have pushed you toward QIO in the
first place.

Johnson,

Could you please post the URL to the tip you mentioned so that I can fix it.

@   Thanks,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 18 May 2001 10:06
To: Multiple recipients of list ORACLE-L


I noticed this when I was playing with 9i. Regular tablespaces take long
time to be created and temporary ones take nothing.

Here is the proof:

$ ls -l temp01.dbf
-rw-rw-r--   1 oracle   dba  209719296 May 17 18:55 temp01.dbf

$ du -k temp01.dbf
40968   temp01.dbf

$ ls -l users01.dbf
-rw-rw-r--   1 oracle   dba  26218496 May 11 20:27 users01.dbf

$ du -k users01.dbf
25608   users01.dbf

Regards,

Waleed

-Original Message-
Sent: Thursday, May 17, 2001 7:41 PM
To: Multiple recipients of list ORACLE-L


If you create tablespace like - create temporary tablespace
 ... 
created file will be sparse.

Alex Hillman


-Original Message-
Sent: Thursday, May 17, 2001 6:30 PM
To: Multiple recipients of list ORACLE-L


Hi Johnson,

I don't believe that tempfiles can be sparse (although I may be wrong) and I
am
confident that datafiles cannot be. Maybe you should log a TAR with Oracle
support to checkout whether tempfile can be sparse and just use datafiles
until
then. Anyway, can you please post the URL to the tip you mentioned. While it
is
the sort of thing I might say, I don't remember actually having said so.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 18 May 2001 0:05
To: Multiple recipients of list ORACLE-L


Hi,

After reading Steve Adams'  tip on making temp files
quick io. I posed this question to Veritas as they had
 told us not do so. The answer they give is the
following.

Temporary datafiles should not be converted to quick
i/o files.  The following is an excerpt from the
administrator's Guide: Tablespaces marked TEMPORARY
can be sparse, which means that not all blocks in the
file are allocated. Quick I/O files cannot be sparse,
as Quick I/O provides a raw-type interface to storage.
If a sparse file is converted to a Quick I/O file, the
Oracle instance can fail if Oracle attempts to write
into one of these unallocated blocks.

I would appreciate your thoughts on this?

Johnson Job

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: job offer from SAUDI ARABIA

[Rajaram]

Just as a coin has two side, every thing has two sides - I'd say - good and 
bad.
What you are is determined by your behaviour
Your behaviour is determinied by your surroundings - be it parents , 
friends or foes.
Similarly, what a nation is determined by its ruler and its neighbours.

So, It largely depends on our attitude - how we take it.
As, one poet says -
  "Our attitude determines our altitude in life"

So, to sum it up - if you are going to make a living from Saudi - then you 
have to trust them and befriend them and respect them - and you will get 
respected..

I can keep writing like this on and on - but I think I'll stop here..

Bye now,
Rajaram.



-Original Message-
From:   Eric D. Pierce [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, May 17, 2001 8:06 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: job offer from SAUDI ARABIA

reality check.

Consider the poignant implications of the recent anniversary of the
Oklahoma city terrorism.

The simple fact is that a very high percentage of professional women
that have jobs like real estate sales requiring isolated contact with
strangers *are* armed (as you state, many with "boutique" designer
guns). it is because they have been assaulted or threatened, or are
close to women that have told vivid stories of such.

Employees at this campus are required to take *mandatory* "campus
violence" workshops now. Last year a professor was severly beaten by
some petty thieves after leaving a night class about 2 minutes walk
from my office. Several years ago, someone held an admission
counselor hostage at gun point in the building I work in. The person
was upset that they weren't admitted to the university.

regards,
ep
(unarmed, but unrepentantly politically incorrect)

On 17 May 2001, at 13:16, Marianne Brooks wrote:

Date sent:  Thu, 17 May 2001 13:16:06 -0800
To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>

> SET MODE SILLY ON
>
> Damn, I  *knew* I forgot to buy something on my last shopping trip to
> Nordstroms!
>
> Note to self:  - buy gun I didn't know I needed.  Remember to purchase
>   extras for friends who don't have them either(the gift
> that keeps
>   on taking?)

...


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

NetZero Platinum
No Banner Ads and Unlimited Access
Sign Up Today - Only $9.95 per month!
http://www.netzero.net
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rajaram
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Temporary files and Quick i/o

[Steve Adams]

Hi All,

OK, you're all correct. Tempfiles can be sparse (it seems to be platform
specific). Nevertheless, I'm unclear why Veritas think that is it any more of a
problem for Oracle to get ENOSPC from a sparse tempfile if it is a QIO file than
otherwise. Presumably Oracle would just raise ORA-7376 in both cases. The
instance would not fail because tempfile I/O is always done direct (not by
DBWn). But if Veritas say not to do it, then I suppose that is good enough. The
solution of course must be to use raw, rather than a filesystem based tempfile
at all, for all the good reasons that would have pushed you toward QIO in the
first place.

Johnson,

Could you please post the URL to the tip you mentioned so that I can fix it.

@   Thanks,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 18 May 2001 10:06
To: Multiple recipients of list ORACLE-L


I noticed this when I was playing with 9i. Regular tablespaces take long
time to be created and temporary ones take nothing.

Here is the proof:

$ ls -l temp01.dbf
-rw-rw-r--   1 oracle   dba  209719296 May 17 18:55 temp01.dbf

$ du -k temp01.dbf
40968   temp01.dbf

$ ls -l users01.dbf
-rw-rw-r--   1 oracle   dba  26218496 May 11 20:27 users01.dbf

$ du -k users01.dbf
25608   users01.dbf

Regards,

Waleed

-Original Message-
Sent: Thursday, May 17, 2001 7:41 PM
To: Multiple recipients of list ORACLE-L


If you create tablespace like - create temporary tablespace
 ... 
created file will be sparse.

Alex Hillman


-Original Message-
Sent: Thursday, May 17, 2001 6:30 PM
To: Multiple recipients of list ORACLE-L


Hi Johnson,

I don't believe that tempfiles can be sparse (although I may be wrong) and I
am
confident that datafiles cannot be. Maybe you should log a TAR with Oracle
support to checkout whether tempfile can be sparse and just use datafiles
until
then. Anyway, can you please post the URL to the tip you mentioned. While it
is
the sort of thing I might say, I don't remember actually having said so.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 18 May 2001 0:05
To: Multiple recipients of list ORACLE-L


Hi,

After reading Steve Adams'  tip on making temp files
quick io. I posed this question to Veritas as they had
 told us not do so. The answer they give is the
following.

Temporary datafiles should not be converted to quick
i/o files.  The following is an excerpt from the
administrator's Guide: Tablespaces marked TEMPORARY
can be sparse, which means that not all blocks in the
file are allocated. Quick I/O files cannot be sparse,
as Quick I/O provides a raw-type interface to storage.
If a sparse file is converted to a Quick I/O file, the
Oracle instance can fail if Oracle attempts to write
into one of these unallocated blocks.

I would appreciate your thoughts on this?

Johnson Job

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 - Books Covering Partitioning in 8i

[elkinsl]

Listers,

I might end up on a Data Warehouse and Data Mart project using 8i. I've read
various white papers, Oracle doc's, etc on partitioning capabilities of
8/8i. And I've dinked around on my test machine a bit trying things out. Are
there any books out there that you would recommend for digging deeper into
the partitioning subject? I have some prior experience in the DW/DM arena on
*V7*, but, a book going into real detail on partitioning in 8i, what works
well when, what doesn't, gotcha's to look out for, etc would be helpful.

I've already been planning on getting Jonathan Lewis's "Practical Oracle
8i". And I heard and/or read that it does a good job of covering
partitioning. I've also accumulated a list of recommendations for Oracle
specific DW books, though I don't have any of them yet. I already own, and
have read, an assortment of Inmon and Kimball books on DW.

Thanks,

Larry G. Elkins
[EMAIL PROTECTED]

-- 
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: Temporary files and Quick i/o

[Khedr, Waleed]

After creating the temp file and shutting down the database, you can use on
Solaris cp temp-file new-file and then
cp new-file temp-file.

After that you can convert it to quick-i/o.

Regards,

Waleed

-Original Message-
Sent: Thursday, May 17, 2001 8:06 PM
To: Multiple recipients of list ORACLE-L


I noticed this when I was playing with 9i. Regular tablespaces take long
time to be created and temporary ones take nothing.

Here is the proof:

$ ls -l temp01.dbf
-rw-rw-r--   1 oracle   dba  209719296 May 17 18:55 temp01.dbf

$ du -k temp01.dbf
40968   temp01.dbf

$ ls -l users01.dbf
-rw-rw-r--   1 oracle   dba  26218496 May 11 20:27 users01.dbf

$ du -k users01.dbf
25608   users01.dbf

Regards,

Waleed

-Original Message-
Sent: Thursday, May 17, 2001 7:41 PM
To: Multiple recipients of list ORACLE-L


If you create tablespace like - create temporary tablespace
 ... 
created file will be sparse.

Alex Hillman


-Original Message-
Sent: Thursday, May 17, 2001 6:30 PM
To: Multiple recipients of list ORACLE-L


Hi Johnson,

I don't believe that tempfiles can be sparse (although I may be wrong) and I
am
confident that datafiles cannot be. Maybe you should log a TAR with Oracle
support to checkout whether tempfile can be sparse and just use datafiles
until
then. Anyway, can you please post the URL to the tip you mentioned. While it
is
the sort of thing I might say, I don't remember actually having said so.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 18 May 2001 0:05
To: Multiple recipients of list ORACLE-L


Hi,

After reading Steve Adams'  tip on making temp files
quick io. I posed this question to Veritas as they had
 told us not do so. The answer they give is the
following.

Temporary datafiles should not be converted to quick
i/o files.  The following is an excerpt from the
administrator's Guide: Tablespaces marked TEMPORARY
can be sparse, which means that not all blocks in the
file are allocated. Quick I/O files cannot be sparse,
as Quick I/O provides a raw-type interface to storage.
If a sparse file is converted to a Quick I/O file, the
Oracle instance can fail if Oracle attempts to write
into one of these unallocated blocks.

I would appreciate your thoughts on this?

Johnson Job


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson Poovathummoottil
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Steve Adams
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailin

Re: ....A drop schema script ??

[Jared Still]

Luis,

Don't feel bad, this is a valid question.

DROP USER CASCADE is not always the most efficient way to
drop a user, especially a user with a large number of objects.

I've had that command fail a number of times, and had to rerun
it until I decided there must be a better way.

DROP USER CASCADE can generate a *lot* of recursive SQL,
and therefore can take a very long time.  It also eats up system
resources at a prodigious rate.

I've found that when dropping a schema owner, it's much easier
to drop their objects individually, then drop the user.

e.g.

spool '_dropscott.sql'

select 'drop ' || object_type || ' scott.' || object_name || 
decode(object_type, 'TABLE', ' cascade constraints;',';')
from dba_objects
where object_type in ('TABLE','PACKAGE','PROCEDURE','FUNCTION')
and owner = 'SCOTT';

spool off
@_dropscott.sql
drop user scott cascade;

I still include the 'cascade' on drop user to pick up any objects not
included in the above list.

Works for me, YMMV.

Jared



On Thursday 17 May 2001 13:25, Luis DeUrioste wrote:
> uhhh DUHHH !
>
> I could write the algorithm to solve the logarithm .. IF I ONLY HAD A
> BRAIN ..
>
> Thank you to all of you, and special thanks for not bashing me
>
> Luis Octavio
>
> Luis DeUrioste wrote:
> > All mighty and powerful DBA supremes !
> >
> > Do any of you have a drop schema script that would be willing to share
> > ??
> > It'll be greatly appreciated
> >
> > T I A


Content-Type: text/x-vcard; charset="us-ascii"; name="Luis_deUrioste.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Luis Octavio de Urioste

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: job offer from SAUDI ARABIA

[Eric D. Pierce]

reality check.

Consider the poignant implications of the recent anniversary of the 
Oklahoma city terrorism.

The simple fact is that a very high percentage of professional women 
that have jobs like real estate sales requiring isolated contact with 
strangers *are* armed (as you state, many with "boutique" designer 
guns). it is because they have been assaulted or threatened, or are 
close to women that have told vivid stories of such.

Employees at this campus are required to take *mandatory* "campus 
violence" workshops now. Last year a professor was severly beaten by 
some petty thieves after leaving a night class about 2 minutes walk 
from my office. Several years ago, someone held an admission 
counselor hostage at gun point in the building I work in. The person 
was upset that they weren't admitted to the university.

regards,
ep
(unarmed, but unrepentantly politically incorrect)

On 17 May 2001, at 13:16, Marianne Brooks wrote:

Date sent:  Thu, 17 May 2001 13:16:06 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> SET MODE SILLY ON
> 
> Damn, I  *knew* I forgot to buy something on my last shopping trip to
> Nordstroms! 
> 
> Note to self:  - buy gun I didn't know I needed.  Remember to purchase 
>   extras for friends who don't have them either(the gift
> that keeps
>   on taking?)

...


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Temporary files and Quick i/o

[Khedr, Waleed]

I noticed this when I was playing with 9i. Regular tablespaces take long
time to be created and temporary ones take nothing.

Here is the proof:

$ ls -l temp01.dbf
-rw-rw-r--   1 oracle   dba  209719296 May 17 18:55 temp01.dbf

$ du -k temp01.dbf
40968   temp01.dbf

$ ls -l users01.dbf
-rw-rw-r--   1 oracle   dba  26218496 May 11 20:27 users01.dbf

$ du -k users01.dbf
25608   users01.dbf

Regards,

Waleed

-Original Message-
Sent: Thursday, May 17, 2001 7:41 PM
To: Multiple recipients of list ORACLE-L


If you create tablespace like - create temporary tablespace
 ... 
created file will be sparse.

Alex Hillman


-Original Message-
Sent: Thursday, May 17, 2001 6:30 PM
To: Multiple recipients of list ORACLE-L


Hi Johnson,

I don't believe that tempfiles can be sparse (although I may be wrong) and I
am
confident that datafiles cannot be. Maybe you should log a TAR with Oracle
support to checkout whether tempfile can be sparse and just use datafiles
until
then. Anyway, can you please post the URL to the tip you mentioned. While it
is
the sort of thing I might say, I don't remember actually having said so.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 18 May 2001 0:05
To: Multiple recipients of list ORACLE-L


Hi,

After reading Steve Adams'  tip on making temp files
quick io. I posed this question to Veritas as they had
 told us not do so. The answer they give is the
following.

Temporary datafiles should not be converted to quick
i/o files.  The following is an excerpt from the
administrator's Guide: Tablespaces marked TEMPORARY
can be sparse, which means that not all blocks in the
file are allocated. Quick I/O files cannot be sparse,
as Quick I/O provides a raw-type interface to storage.
If a sparse file is converted to a Quick I/O file, the
Oracle instance can fail if Oracle attempts to write
into one of these unallocated blocks.

I would appreciate your thoughts on this?

Johnson Job


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson Poovathummoottil
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Steve Adams
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

ODBC Driver setup does not launch

[Nguyen, Long (ITS, Limestone Ave)]

Hi,

A user has just installed Oracle Clien 8.0.5 on NT 4 machine. She then went to 
configure a system DSN in ODBC. She ckicked  Od button, highlighted the Oracle ODB 
8.0.5 driver and clicked Finish, but then the ODBC 8 Driver setup did not
appear. Anyone experienced this problem? and if so, how did you get around the problem.

Many thanks
Long
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nguyen, Long (ITS, Limestone Ave)
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: job offer from SAUDI ARABIA

[Eric D. Pierce]

Brian,

Clearly the USA is not perfect, or the end point of social evolution
on this planet (or others). The USA is the outcome of one set of
highly successful (anglo-american) experiments/innovations with
"freedom" and "commerce".  American individualism is not particulary
compatible with the other major world axiologies that are reflected
in collectivist cultures.

That "success" doesn't exclude "good", "truth" or "beauty" as they
have come to be experienced in other cultures.

Note that the whole idea of "freedom" is premised on the existence of
the opposite, which is to say the universal reality of "slavery" as a
social institution in every historical context experienced by
"civilized" human beings for 5,000 years (including the significant
reforms of slavery in Islam).

Historically, there has NEVER been a major culture free of slavery,
or the deeply ingrained patterns of thought and experience left in
slavery's wake.

Presumably at some (distant?) point in a more enlightened and just
future, the individual conciousness and social insitutions (as
expressions of individual conciousnes) will have evolved to reflect
additional aspects of human potential, and will have largely
transcended the shadows of the kinds of slavery/oppression that have
characterized virtually all of humanity's "civilized" history.

For an interesting summary of the basic democratic principles of
"civil society" and the relationship to the "information age", see
the statement on the web site of the

 Computer Professionals for Social Responsibility (CPSR)
 working in the Internet Democracy Project

  http://www.cpsr.org/internetdemocracy/Statement_July-13.html

   excerpt:

   "...Civil society is a third sector of society alongside the state
and the market. The values underlying civil society include
freedom of association, freedom of expression, participatory
democracy, and respect for diversity.  A vigorous civil society
is an important counter-balance to government and business.  The
growing global integration of markets and coordination of
governments creates the need for a corresponding global civil
society.

Technical coordination of the Internet’s core resources has
unavoidable social, economic, and political consequences.  The At
Large elections present a welcome opportunity to achieve balance
on ICANN’s governing Board and to promote democratic governance of
Internet technical coordination. "
   ---

Given the massive erosion of *participatory values* that are required
for the proper functioning of democratic capitalism, americans may
not have the luxury of just resting on their venerable traditions
much longer. Democracy is messy and inefficient, in other words, "high
maintenance". Get lazy, and all sorts of sh*t starts hitting the fan.

regards,
ep

On 17 May 2001, at 12:17, Brian MacLean wrote:

Date sent:  Thu, 17 May 2001 12:17:18 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> God I live in an awful country.  I'm sorry for all the tyranny my country
> has put the world through.  I guess I'll just shoot myself.

...


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Temporary files and Quick i/o

[Hillman, Alex]

If you create tablespace like - create temporary tablespace
 ... 
created file will be sparse.

Alex Hillman


-Original Message-
Sent: Thursday, May 17, 2001 6:30 PM
To: Multiple recipients of list ORACLE-L


Hi Johnson,

I don't believe that tempfiles can be sparse (although I may be wrong) and I
am
confident that datafiles cannot be. Maybe you should log a TAR with Oracle
support to checkout whether tempfile can be sparse and just use datafiles
until
then. Anyway, can you please post the URL to the tip you mentioned. While it
is
the sort of thing I might say, I don't remember actually having said so.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 18 May 2001 0:05
To: Multiple recipients of list ORACLE-L


Hi,

After reading Steve Adams'  tip on making temp files
quick io. I posed this question to Veritas as they had
 told us not do so. The answer they give is the
following.

Temporary datafiles should not be converted to quick
i/o files.  The following is an excerpt from the
administrator's Guide: Tablespaces marked TEMPORARY
can be sparse, which means that not all blocks in the
file are allocated. Quick I/O files cannot be sparse,
as Quick I/O provides a raw-type interface to storage.
If a sparse file is converted to a Quick I/O file, the
Oracle instance can fail if Oracle attempts to write
into one of these unallocated blocks.

I would appreciate your thoughts on this?

Johnson Job


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson Poovathummoottil
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Steve Adams
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: ??? how to interpret query plan

[Hillman, Alex]

He works with rule based optimizer (cost=  in explain plan). Maybe using
choose ad not analyzing. So it does not matter how values distributed -
if index exist rule based optimizer will use it.

Alex Hillman

-Original Message-
Sent: Wednesday, May 16, 2001 6:16 PM
To: Multiple recipients of list ORACLE-L


Yes, this looks fine.  You'll notice that most of the tables are accessed
via a unique index.  This means that most likely you only needed to read one
block in the index and one block in the table.
The only exception is the CUSTOMER_ACCOUNT_CONTACTS which is accessed via an
index range scan.  This is probably fine.  The exception is if for this
particular query the indexed column (for index CUSTOMER_ACCOUNT_CONTACTS_1)
has a particularly high number of hits for the value in the query.  I have
no idea what the distribution of data is in your tables, but if the query is
checking a large %age of the rows it is faster to do a full table than to an
index range scan first (since Oracle has to first read the Index blocks in
addition to the Table blocks).

If you have histogram on the column Oracle will check the distribution of
data automatically UNLESS the query is using bind varibles.

-Original Message-
Sent: Friday, May 11, 2001 6:56 PM
To: Multiple recipients of list ORACLE-L


Hi all,

I know how to generate the query plan but how to
interplate the query plan, really?  The only thing I
know is if there is a FULL TABLE SCAN, that most
probably is bad, need to build an index.  However, if
the query plan shows me something else, I don't know
what to improve.

For example, does the following look good???  (this is
just one example, please throw me any idad you can
think of.  Thank you!)

Query Plan
---
SELECT STATEMENT   cost=
  NESTED LOOPS OUTER
NESTED LOOPS OUTER
  NESTED LOOPS OUTER
NESTED LOOPS OUTER
  TABLE ACCESS BY INDEX ROWID
CUSTOMER_ACCOUNT_CONTACTS
INDEX RANGE SCAN
CUSTOMER_ACCOUNT_CONTACTS_1
  TABLE ACCESS BY INDEX ROWID PHONE
INDEX UNIQUE SCAN PK_PHONE
TABLE ACCESS BY INDEX ROWID PHONE
  INDEX UNIQUE SCAN PK_PHONE
  TABLE ACCESS BY INDEX ROWID PHONE
INDEX UNIQUE SCAN PK_PHONE
TABLE ACCESS BY INDEX ROWID PHONE
  INDEX UNIQUE SCAN PK_PHONE

__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janet Linsy
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Miller, Jay
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: job offer from SAUDI ARABIA

[Mohan, Ross]

Isn't Canada a state in the north of the USA?



|| -Original Message-
|| From: Kimberly Smith [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 17, 2001 6:11 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: job offer from SAUDI ARABIA
|| 
|| 
|| Um, I can critize Canada all I want.  Matter of fact, its kind 
|| of a requirement.  So your first sentence is wrong.  I asked one
|| of the guys I work with here if he drinks a lot when he goes out
|| and he said "Well, not for a Canadian".  He is Canadian.  (As am I)
|| 
|| -Original Message-
|| Sent: Thursday, May 17, 2001 1:52 PM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Only in America, can you rant!  Try to criticize China while 
|| living there.
|| I have a friend there, her mail is read before she gets it.  
|| All she can
|| write is general stuff, nothing negative, fearful of her 
|| life.  The best
|| thing about America is that you can b*tch if you want.  I 
|| served for this
|| country and love this country.  *GO USA*
|| 
|| Not that there are not other great countries!
|| 
|| -- 
|| 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: Kimberly Smith
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from).  You may
|| also send the HELP command for other information (like subscribing).
|| 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: job offer from SAUDI ARABIA

[Gene Sais]

I stand corrected.  Obviously there are other countries that don't dismember you for 
speaking out.

>>> [EMAIL PROTECTED] 05/17/01 06:10PM >>>
Um, I can critize Canada all I want.  Matter of fact, its kind 
of a requirement.  So your first sentence is wrong.  I asked one
of the guys I work with here if he drinks a lot when he goes out
and he said "Well, not for a Canadian".  He is Canadian.  (As am I)

-Original Message-
Sent: Thursday, May 17, 2001 1:52 PM
To: Multiple recipients of list ORACLE-L


Only in America, can you rant!  Try to criticize China while living there.
I have a friend there, her mail is read before she gets it.  All she can
write is general stuff, nothing negative, fearful of her life.  The best
thing about America is that you can b*tch if you want.  I served for this
country and love this country.  *GO USA*

Not that there are not other great countries!

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
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: Temporary files and Quick i/o

[Steve Adams]

Hi Johnson,

I don't believe that tempfiles can be sparse (although I may be wrong) and I am
confident that datafiles cannot be. Maybe you should log a TAR with Oracle
support to checkout whether tempfile can be sparse and just use datafiles until
then. Anyway, can you please post the URL to the tip you mentioned. While it is
the sort of thing I might say, I don't remember actually having said so.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 18 May 2001 0:05
To: Multiple recipients of list ORACLE-L


Hi,

After reading Steve Adams'  tip on making temp files
quick io. I posed this question to Veritas as they had
 told us not do so. The answer they give is the
following.

Temporary datafiles should not be converted to quick
i/o files.  The following is an excerpt from the
administrator's Guide: Tablespaces marked TEMPORARY
can be sparse, which means that not all blocks in the
file are allocated. Quick I/O files cannot be sparse,
as Quick I/O provides a raw-type interface to storage.
If a sparse file is converted to a Quick I/O file, the
Oracle instance can fail if Oracle attempts to write
into one of these unallocated blocks.

I would appreciate your thoughts on this?

Johnson Job


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson Poovathummoottil
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Steve Adams
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Export only users, roles, grants etc

[Browett, Darren]

I have a small datawarehouse that I would like to re-design and re-build.
All the scripts are in place to recreate the 
snapshots, tables and associated indexes.   But before I delete the existing
one,  and create the new one, I need to
retrieve all the users and their associated grants and roles.  

Can this be done using export ??  I have looked through the help, tried a
couple of things, but with no success.

Any help would be appreciated.

Oh yeah, this is oracle 8.0.5.1.1

Darren

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: enqueue waits -- CI

[Steve Adams]

Hi Diego,

I don't know of any way in which using DBMS_PIPE might be related to CI enqueue
waits. However, even if there is something to their suggestion, if your ID
values are 0 and 5 then the CI call you are waiting for is one of the reuse
block range calls.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 18 May 2001 5:56
To: Multiple recipients of list ORACLE-L


As usual, "thanks" for the answer Steve.

I'll try to reduce the number of shrinks in the rollback segments, so this
is going to impact on CI enqueue waits.

What do you think about Metalink DOC ID 1020355.102 recomendation?

(from my previous email)
"> I've also read a metalink document (1020355.102). According to this, one
> possible cause is that my application is using ***dbms_pipe*** extensively
(it may
> be right, I've seen "pipe get" event very high). The suggested solution is
> to increase the shared_pool. I can't access the other documents mentioned
> in the paper."

Eventtotal_waits   time_waited
pipe get910593342266184


Thank you.
DC


- Original Message -
To: Diego Cutrone <[EMAIL PROTECTED]>; Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 1:53 AM


> Hi Diego,
>
> No, those are block buffers. When a segment is dropped, truncated or
shrunk
> (normally a rollback segment) then a "reuse block range" cross instance
call is
> needed to flush the unwanted blocks from cache. Similarly, before a
parallel
> direct read a "checkpoint block range" or "checkpoint object" cross
instance
> call is needed (otherwise changes made prior to the start of the query and
> committed but not yet flushed to disk could be missed by the direct
reads).
> These are "cross-instance" calls even in single-instance Oracle because
the code
> allows for the possibility of parallel server, and the DBWn processes in
all
> instance need to flush the cache in their own instances.
>
> @   Regards,
> @   Steve Adams
> @   http://www.ixora.com.au/
> @   http://www.christianity.net.au/
>
>
> -Original Message-
> From: Diego Cutrone [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 17 May 2001 4:11
> To: Multiple recipients of list ORACLE-L
> Subject: RE: enqueue waits -- CI
>
>
> Thanks for answering Unal, John.
>
> John, you were right about the query. I've corrected it. And I'm not
getting
> "T[" and "CK" anymore,now I get TX and CI.
> I've also done further investigation and I also know now what p2 and p3
> mean.
>
> This is the updated data: (from the dumps)
> 
> count TYPE  MODE
>  13  CI  6  p2=0 p3=5 ela=0
>   19 TX 6 p2=262223 p3=53352 ela=301
>   75 TX 4 p2=524391 p3=50022 ela=301
>   75 TX 6 p2=720923 p3=5194 ela=301
>  104TX 6 p2=196736 p3=52393 ela=301
>  305TX 6 p2=393276 p3=50281 ela=301
> 
>
> Now, how can I get the rollback segment number involved in the TX ? (I
know
> its from p2 and p3, but how?) --just curious. I'll also take John advise,
> and I'll try to identify the locking session(s).
>
> Now, although CI enqueue waits (cross instance call invocation) are brief
on
> this sample, Sometimes it's not.
> So I'm trying to understand what it means. According to p2 and p3 flags,
> they are indicating "Flush buffers for reuse as new class", that means
that
> a session needs a buffer (in the shared pool I think) and it has to flush
> some others in order to get space. am I correct?.
> I've also read a metalink document (1020355.102). According to this, one
> possible cause is that my application is using dbms_pipe extensively (it
may
> be right, I've seen event "pipe get" very high). The suggested solution is
> to increase the shared_pool. I can't access the other documents mentioned
> in the paper.
>
>
> Can someone explain to me what means this CI enqueue and how can I reduce
> it.
> TIA
>
>
>
>
>
>
>
>
>
>
>
>
>
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Tuesday, May 15, 2001 6:16 PM
>
>
> > Hi Diego,
> >
> > Without going into details, an 'enqueue' wait is mostly due to a
> > user/program initated transaction lock and I see it a lot in Financial
> > databases (I see you are on 10.7?). I deduce you were looking at
> > V$SYSTEM_EVENT - If a user locked one row (probably queried a row in
> Forms,
> > inadvertly changed one character which issues a 'SELECT for UPDATE, thus
> > locking that row) and anotehr user (through a form or a report) needs to
> > perform DML on that particular row, then (I believe) you will clock up
> time
> > against the 'enqueue' event.
> >
> > What I would suggest is that you use the following query to determine if
> > someone is locking someone else out

RE: Another big bang for Larry

[Kimberly Smith]

Matter of fact, I believe that they are the biggest users
of Trusted Oracle.  A product I was forced to deal with when
on a Nato project.  I think I contradicted myself in my first
sentence but oh well...

-Original Message-
Sent: Thursday, May 17, 2001 2:16 PM
To: Multiple recipients of list ORACLE-L


Actually NATO has been using Oracle's RDBMS product for years.

>> Original Message <<

On 5/17/01, 4:01:34 PM, Ron Rogers <[EMAIL PROTECTED]> wrote regarding 
Re: Another big bang for Larry:


> It's started. After slick willy was invited to speak the kickbacks 
are showing up.  Oracle will be running the Government.   Slick move... you 
don't dare bust up the monopoly that is running the Governmential 
department's programs. Will the NEW controling body be called "the 
GOVERACLEMENT"???
> ROR mô¿ôm

> >>> [EMAIL PROTECTED] 05/17/01 04:08PM >>>
> From InformationWeek:

> ** Oracle Hooks NATO On 11i

> The North Atlantic Treaty Organization has begun implementing
> Oracle's 11i E-business software in its 19 regional headquarters.

> NATO program director David Oakley says NATO's new Automated
> Financial System will incorporate Oracle's enterprise resource
> planning and E-business software to manage a range of operations,
> including budgeting, travel, treasury, disbursement, procurement,
> and supply functions. NATO also will use Oracle's
> business-analysis and reporting tools.

> Oracle will provide training for an estimated 700 NATO personnel.
> Oakley says NATO's initiative is designed to let the organization
> adopt international public-sector accounting standards and have
> access to more meaningful and timely information about its own
> operations.

> The new system is expected to reduce the number of paper
> documents that must be handled by NATO personnel, such as
> requisitions and travel requests, and let the alliance use
> financial forecasting tools that Oakley says will help it use
> funds more efficiently. The value of the deal, and its deployment
> schedule, weren't released. - Steve Konicki

> Check out these related stories:

> Will Oracle Finally Deliver With Release Of 11.5.3?
> http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2Q0AC

> Apps Made Easy?
> http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20Niw0Aj

> The Big Picture: The Encryption Enigma
> http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2R0AD
> --
> 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: Ron Rogers
>   INET: [EMAIL PROTECTED]

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want 

RE: job offer from SAUDI ARABIA

[Kimberly Smith]

Um, I can critize Canada all I want.  Matter of fact, its kind 
of a requirement.  So your first sentence is wrong.  I asked one
of the guys I work with here if he drinks a lot when he goes out
and he said "Well, not for a Canadian".  He is Canadian.  (As am I)

-Original Message-
Sent: Thursday, May 17, 2001 1:52 PM
To: Multiple recipients of list ORACLE-L


Only in America, can you rant!  Try to criticize China while living there.
I have a friend there, her mail is read before she gets it.  All she can
write is general stuff, nothing negative, fearful of her life.  The best
thing about America is that you can b*tch if you want.  I served for this
country and love this country.  *GO USA*

Not that there are not other great countries!

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: index FS vs index FFS - what's the difference ?

[Shevtsov, Eduard]

Hi Riyaj,
 
Thanks for your response. Very interesting! I 
completely agree with you about index fast full scan.
But I'm still unclear about index full scan. 
I've always thought that this operation is serviced with 
1-block reads. So it would be possible 
to go through 2-way list of leaf blocks. And if my memory
services me right the docs say the same 
about 1-block reads for IFS.
But dump file shows db scattered reads. I 
don't think that 11 blocks per read is due passing the extent 
boundaries
The LMTablespace has big extents (50Mb) 
and all such events have the same p3 = 11 in the trace file.
Certainly I should have given you much more 
info. I had restarted DB (shutdown immediately) before I got  
each 
trace file. I just did it in order 
to clean db cache and catch 'db file %' 
waits during the following index scan.
So I did clean shutdown. I checked 
each execution plan. Also it's unlikely that someone modified this 
index at that time. 
I may be totally wrong here. Just my thoughts.
 
Thanks again I took your tips and will go 
into detail tomorrow.
 
Ed
 
 
Hi Ed         I think, For full index scan, oracle server 
process reads the root block and branch blocks 1 block at a time. It reads the 
leaf blocks at a db file multiblock -read count blocks per read call.  For 
the fast full scan, it reads all the block from the segment header to high water 
mark at a db_file_multiblock_read count blocks per read call. So, root blocks 
and branch blocks are read 1 block at a time, hence the db file sequential read. 
Where as for the fast full index scan you will see sequential read events only 
for the root block. Also, for the full index scan apparently knows about the 
extent boundary and if the next group of blocks to be read (in the current 
extent) is less than the db file multiblock read count , then it tries to read 
until the end of the current extent. That's why 11 blocks instead of 8 
blocks.         For 
the 'db file parallel read' the segment read are file 1 block 11, which is a 
system rollback segment extent. If you dump the block, you could see the redo 
for index leaf operations. I guess, this is due to delayed instance recovery. 
        All these, I 
found from dumping blocks and doing research myself. Steve,   
      Can you please clarify ? ThanksRiyaj "Re-yas" ShamsudeenCertified Oracle 
DBAi2 technologies   www.i2.com 

RE: data migration

[Mohan, Ross]

Praful, 

This is a bit of a shot from the hip, but.
the gap shouldn't make much of a difference in
the end. 

I'd be more concerned about allocating space for
all your stuff initially, not just the first 10%.
The gaps should be handled seamlessly by indexes
(the way a b*tree works...) and anything that seems
to act much differently you can always do select 
activation of histograms to account for data skew
if you come to think that's a problem. (You *are* in
cost-mode, yes?)

Of course, there's always the "design" solution. Put
another field in there that tells the app whether it's
"phase I" or "phase II" data. Then you could overlap
primary keys, which from your description i gather
are sequence-based. (But i think that's weird and 
sloppy somehow, and I wouldn't do it.)

hth, 

- Ross

|| -Original Message-
|| From: Praful Thakkar [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 17, 2001 5:46 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: data migration
|| 
|| 
|| Hi,
|| 
|| We are planning to do two-phase data migration - split by data.
|| In first phase, about 10% of the data will be moved as is -
|| without changing the primary keys (generated from sequences).
|| Once we start using the database with phase 1 data, sequences
|| will generate new primary keys and add to this data - which
|| could be same as primary key for the remaining data, which is
|| not yet migrated. In phase 2, to avoid unique constraint
|| problems, we'll add 1,000,000 to primary keys before we migrate
|| remaining data. This will lead to imbalance of primary keys.
|| After complete migration, we'll have about 10% of the keys with
|| low values and remaining with very high values. What is the
|| impact of this huge gap in primary keys? How will be the
|| performance affected? Is there a way in which we can avoid this
|| huge gap in primary keys (We do not have an option of going for
|| single migration. Business needs force us to test the
|| application with partial data. ) One option I thought of is to
|| use high value keys in first migration itself - but when
|| sequences reach these high values, we'll have same problems of
|| unique constraint being violated.
|| 
|| Thanks.
|| 
|| - Praful
|| 
|| 
|| __
|| Do You Yahoo!?
|| Yahoo! Auctions - buy the things you want at great prices
|| http://auctions.yahoo.com/
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Praful Thakkar
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Another big bang for Larry

[Seley, Linda]

E-Business is the new term for Oracle Applications, and yes, 11i has been
out awhile, running against an 8i database.  

It's a full time job just keeping up with Oracle's naming convention!

Linda

-Original Message-
Sent: Thursday, May 17, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L


Don't I feel silly!  I didn't even know that 9i was out yet, much less 10i
or 11i!  I guess I don't dare blink.

DM

-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, May 17, 2001 1:09 PM
To: Multiple recipients of list ORACLE-L


>From InformationWeek:

** Oracle Hooks NATO On 11i

The North Atlantic Treaty Organization has begun implementing
Oracle's 11i E-business software in its 19 regional headquarters.

NATO program director David Oakley says NATO's new Automated
Financial System will incorporate Oracle's enterprise resource
planning and E-business software to manage a range of operations,
including budgeting, travel, treasury, disbursement, procurement,
and supply functions. NATO also will use Oracle's
business-analysis and reporting tools.

Oracle will provide training for an estimated 700 NATO personnel.
Oakley says NATO's initiative is designed to let the organization
adopt international public-sector accounting standards and have
access to more meaningful and timely information about its own
operations.

The new system is expected to reduce the number of paper
documents that must be handled by NATO personnel, such as
requisitions and travel requests, and let the alliance use
financial forecasting tools that Oakley says will help it use
funds more efficiently. The value of the deal, and its deployment
schedule, weren't released. - Steve Konicki

Check out these related stories:

Will Oracle Finally Deliver With Release Of 11.5.3?
http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2Q0AC

Apps Made Easy?
http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20Niw0Aj

The Big Picture: The Encryption Enigma
http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2R0AD
--
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: David Messer
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Seley, Linda
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

data migration

[Praful Thakkar]

Hi,

We are planning to do two-phase data migration - split by data.
In first phase, about 10% of the data will be moved as is -
without changing the primary keys (generated from sequences).
Once we start using the database with phase 1 data, sequences
will generate new primary keys and add to this data - which
could be same as primary key for the remaining data, which is
not yet migrated. In phase 2, to avoid unique constraint
problems, we'll add 1,000,000 to primary keys before we migrate
remaining data. This will lead to imbalance of primary keys.
After complete migration, we'll have about 10% of the keys with
low values and remaining with very high values. What is the
impact of this huge gap in primary keys? How will be the
performance affected? Is there a way in which we can avoid this
huge gap in primary keys (We do not have an option of going for
single migration. Business needs force us to test the
application with partial data. ) One option I thought of is to
use high value keys in first migration itself - but when
sequences reach these high values, we'll have same problems of
unique constraint being violated.

Thanks.

- Praful


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Praful Thakkar
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OT RE: job offer from SAUDI ARABIA

[Mohan, Ross]

Gene, 

Being part of a nation with people (such as yourself)
who have a willingness to let other's have their opinions 
-- some of who are a part of the military force that 
defends that right -- is why all my tickets out of town 
are always marked "round trip".

Above all, thanks for your service. 

- Ross

|| -Original Message-
|| From: Gene Sais [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 17, 2001 4:52 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: job offer from SAUDI ARABIA
|| 
|| 
|| Only in America, can you rant!  Try to criticize China while 
|| living there.  I have a friend there, her mail is read 
|| before she gets it.  All she can write is general stuff, 
|| nothing negative, fearful of her life.  The best thing about 
|| America is that you can b*tch if you want.  I served for 
|| this country and love this country.  *GO USA*
|| 
|| Not that there are not other great countries!
|| 
|| -- 
|| 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: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Another big bang for Larry

[Suri, Deepak]

I think it is Oracle Applications ver 11i and not an Oracle server release.

-Original Message-
Sent: Thursday, May 17, 2001 4:09 PM
To: Multiple recipients of list ORACLE-L


>From InformationWeek:

** Oracle Hooks NATO On 11i

The North Atlantic Treaty Organization has begun implementing 
Oracle's 11i E-business software in its 19 regional headquarters. 

NATO program director David Oakley says NATO's new Automated 
Financial System will incorporate Oracle's enterprise resource 
planning and E-business software to manage a range of operations, 
including budgeting, travel, treasury, disbursement, procurement, 
and supply functions. NATO also will use Oracle's 
business-analysis and reporting tools.

Oracle will provide training for an estimated 700 NATO personnel. 
Oakley says NATO's initiative is designed to let the organization 
adopt international public-sector accounting standards and have 
access to more meaningful and timely information about its own 
operations. 

The new system is expected to reduce the number of paper 
documents that must be handled by NATO personnel, such as 
requisitions and travel requests, and let the alliance use 
financial forecasting tools that Oakley says will help it use 
funds more efficiently. The value of the deal, and its deployment 
schedule, weren't released. - Steve Konicki

Check out these related stories:

Will Oracle Finally Deliver With Release Of 11.5.3?
http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2Q0AC

Apps Made Easy?
http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20Niw0Aj

The Big Picture: The Encryption Enigma
http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2R0AD
-- 
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: Suri, Deepak
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Another big bang for Larry

[Rodd Holman]

Actually NATO has been using Oracle's RDBMS product for years.

>> Original Message <<

On 5/17/01, 4:01:34 PM, Ron Rogers <[EMAIL PROTECTED]> wrote regarding 
Re: Another big bang for Larry:


> It's started. After slick willy was invited to speak the kickbacks 
are showing up.  Oracle will be running the Government.   Slick move... you 
don't dare bust up the monopoly that is running the Governmential 
department's programs. Will the NEW controling body be called "the 
GOVERACLEMENT"???
> ROR mô¿ôm

> >>> [EMAIL PROTECTED] 05/17/01 04:08PM >>>
> From InformationWeek:

> ** Oracle Hooks NATO On 11i

> The North Atlantic Treaty Organization has begun implementing
> Oracle's 11i E-business software in its 19 regional headquarters.

> NATO program director David Oakley says NATO's new Automated
> Financial System will incorporate Oracle's enterprise resource
> planning and E-business software to manage a range of operations,
> including budgeting, travel, treasury, disbursement, procurement,
> and supply functions. NATO also will use Oracle's
> business-analysis and reporting tools.

> Oracle will provide training for an estimated 700 NATO personnel.
> Oakley says NATO's initiative is designed to let the organization
> adopt international public-sector accounting standards and have
> access to more meaningful and timely information about its own
> operations.

> The new system is expected to reduce the number of paper
> documents that must be handled by NATO personnel, such as
> requisitions and travel requests, and let the alliance use
> financial forecasting tools that Oakley says will help it use
> funds more efficiently. The value of the deal, and its deployment
> schedule, weren't released. - Steve Konicki

> Check out these related stories:

> Will Oracle Finally Deliver With Release Of 11.5.3?
> http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2Q0AC

> Apps Made Easy?
> http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20Niw0Aj

> The Big Picture: The Encryption Enigma
> http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2R0AD
> --
> 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: Ron Rogers
>   INET: [EMAIL PROTECTED]

> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
--
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: job offer from SAUDI ARABIA

[Marianne Brooks]

Title:  RE: job offer from SAUDI ARABIA





SET MODE SILLY ON


Damn, I  *knew* I forgot to buy something on my last shopping trip to Nordstroms! 


Note to self:  - buy gun I didn't know I needed.  Remember to purchase 
  extras for friends who don't have them either(the gift that keeps
            on taking?)
           - remember to abdicate my parental responsibilities 
            by exposing my kids to media violence we haven't
            been watching
           - remember to not encourage my children to ask 'why' or 
            'why not'?


Phew, I feel better now that I know what I was forgetting to do.  Curse that Palm Pilot for not having it already loaded! 

SET MODE SILLY OFF


|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 17, 2001 3:07 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: job offer from SAUDI ARABIA
|| 
|| 
|| Many professional women in the USA have found it necessary to 
|| purchase handguns to protect themselves from criminal elements in 
|| public places. Children are constantly under psychological assault 
|| being exposed to media violence. The "liberal" education system is 
|| devoted to indoctrinating children with mindless "PC" relativism, 
|| materialism/consumerism and hatred of God (or at least arrogant 
|| dismissal).  
|| 
|| Western "freedoms" can be seen from a variety of perspectives.  
|| 
|| 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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[2]: How to make DBA cannot 'see' User's Tables?

[Willett, Mark]

I could see a reason to encrypt the data so that "even a DBA can not see
it".  Our company has formulas and mixtures that are kept extremely
confidential.  Very few people need to know, very few people do know.  In
addition, those "in the know" have determined that we need a central
repository for this information, such as a database.  Once the info is
loaded and encrypted "so that even a DBA can not see it", the data should be
safe from interior eyes (employees) and exterior eyes (hackers).  This may
not be the best method to secure the information, but it is one that we have
considered.  And I do feel that they trust me here with their data even if I
could not view it.  If they didn't, I'm sure I would be looking for another
job.

Mark Willett
Corporate Database Administrator
Sunnen Products Company
E-mail:  [EMAIL PROTECTED]


 The statements and opinions expressed  herein are my own and do not
 necessarily reflect those of Sunnen Products Company.  

---


-Original Message-
Sent: Thursday, May 17, 2001 1:07 PM
To: Multiple recipients of list ORACLE-L


Yes you can encrypt the data, or you could invest in Trusted Oracle.  But
the
question really becomes one of what are you trying to do.  If the problem is
that you question the integrity of the DBA that becomes a management
problem. 
On the other hand, if you don't question his/her integrity then what's the
problem?  Most DBA's that I know of, myself included, don't have the time
and/or
inclination to browse through application data no matter how sensitive it
may
be.  And on top of all that, the data in your database is not your personal
property, but the property of your employer and the DBA is one of his
employees.
 He/she just happens to have GOD privileges and is intrusted with the
security
and integrity of all of the data.  That's why he/she has those privileges.

Dick Goulet

Reply Separator
Author: Paul Drake <[EMAIL PROTECTED]>
Date:   5/16/2001 9:55 PM

"A. Bardeen" wrote:
> 
> You can encrypt using only a 56-bit key (the key
> length limitation is a requirement of US regulations
> governing the export of cryptographic products).
> 
> HTH,
> 
> -- Anita

Hi Anita.


Ahmadsyah,

I believe that you also have to pad the string to a length that is a
multiple of 8 characters.
Your key string was 10 characters.

here's the obligatory link to the fine manual: (that includes a code
example)
http://technet.oracle.com/doc/oracle8i_816/server.816/a76936/dbms_obf.htm#65
18

Paul


> 
> --- Ahmadsyah Algozhi Nugroho <[EMAIL PROTECTED]>
> wrote:
> > I'm using Oracle 8.1.7.
> > there was an error
> > ERROR at line 1:
> > ORA-28232: invalid input length for obfuscation
> > toolkit
> > ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT_FFI",
> > line 0
> > ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT", line
> > 33
> > ORA-06512: at "SCOTT.IAO_PROTECT", line 15
> > ORA-06512: at line 1
> >
> > I check thath my key and my input string is
> > varchar12(10).
> > Key = 0123456789
> > input string = 'testtestte'
> >
> > dbms_obfuscation_toolkit.desencrypt (
> >   input_string => 'testtestte'
> >   , key_string => '1234567890'
> >   , encrypted_string => vEncrypted
> >   );
> > Am I forget something?
> >
> > TIA,
> >
> >
> > Ahmadsyah Alghozi Nugroho
> > Database Engineering Specialist
> > PT Infoglobal AutOptima
> > Jl. Baruk Tengah I/49
> > Surabaya - Jawa Timur
> > phone : +62 (31) 8708456 ext.113
> > > From: Srinagesh Battula
> > [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, May 17, 2001 7:26 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: How to make DBA cannot 'see' User's
> > Tables?
> > >
> > >
> > >
> > > You can encrypt & Decrypt data using the
> > > DBMS_OBFUSCATION_TOOLKIT package
> > > (comes with 8.1.6)
> > >
> > > Srinagesh "What do I know any way" Battula
> > >
> > > > -Original Message-
> > > > From: Khedr, Waleed
> > [mailto:[EMAIL PROTECTED]]
> > > > Sent: Wednesday, May 16, 2001 4:21 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > > Subject: RE: How to make DBA cannot 'see' User's
> > Tables?
> > > >
> > > >
> > > > Data Encryption?
> > > >
> > > > -Original Message-
> > > > Sent: Wednesday, May 16, 2001 7:01 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > >
> > > > Dear gurus,
> > > > How to make DBA cannot 'see' user's datas?
> > > > I build an application which very important and
> > top secret
> > > > even DBA cannot
> > > > 'see' this data. But DBA can backup this
> > data.What is the
> > > > solution for this
> > > > problem?
> > > >
> > > > TIA,
> > > >
> > > >
> > > > Ahmadsyah Alghozi Nugroho
> > > > Database Engineering Specialist
> > > > PT Infoglobal AutOptima
> > > > Jl. Baruk Tengah I/49

RE: Another big bang for Larry

[Mohan, Ross]

Well...technically it's not out yet. Like alot
of list member's, I got my copies about a month 
ago in the mail, and the general availability (GA) 
date is June 10th ( I think..I could be confusing 
that with IBM's next release ).

I wouldn't feel silly. A bunch of us around here
in this shop are still getting familiar with new 
features in 8i. 

|| -Original Message-
|| From: David Messer [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 17, 2001 4:56 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Another big bang for Larry
|| 
|| 
|| Don't I feel silly!  I didn't even know that 9i was out yet, 
|| much less 10i
|| or 11i!  I guess I don't dare blink.
|| 
|| DM
|| 
|| -Original Message-
|| [EMAIL PROTECTED]
|| Sent: Thursday, May 17, 2001 1:09 PM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| From InformationWeek:
|| 
|| ** Oracle Hooks NATO On 11i
|| 
|| The North Atlantic Treaty Organization has begun implementing
|| Oracle's 11i E-business software in its 19 regional headquarters.
|| 
|| NATO program director David Oakley says NATO's new Automated
|| Financial System will incorporate Oracle's enterprise resource
|| planning and E-business software to manage a range of operations,
|| including budgeting, travel, treasury, disbursement, procurement,
|| and supply functions. NATO also will use Oracle's
|| business-analysis and reporting tools.
|| 
|| Oracle will provide training for an estimated 700 NATO personnel.
|| Oakley says NATO's initiative is designed to let the organization
|| adopt international public-sector accounting standards and have
|| access to more meaningful and timely information about its own
|| operations.
|| 
|| The new system is expected to reduce the number of paper
|| documents that must be handled by NATO personnel, such as
|| requisitions and travel requests, and let the alliance use
|| financial forecasting tools that Oakley says will help it use
|| funds more efficiently. The value of the deal, and its deployment
|| schedule, weren't released. - Steve Konicki
|| 
|| Check out these related stories:
|| 
|| Will Oracle Finally Deliver With Release Of 11.5.3?
|| http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2Q0AC
|| 
|| Apps Made Easy?
|| http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20Niw0Aj
|| 
|| The Big Picture: The Encryption Enigma
|| http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2R0AD
|| --
|| 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: David Messer
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: RE: job offer from SAUDI ARABIA

[Mohan, Ross]

Not sorry if I touched a nerve, Rocky. 

That's what it's all about. It's democracy, 
suck it up, or spit it out. 


|| -Original Message-
|| From: Rocky Welch [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 17, 2001 4:36 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: OT: RE: job offer from SAUDI ARABIA
|| 
|| 
|| And freedom to leave the country any time you wish. Have a 
|| nice flight.
|| 
|| --- "Mohan, Ross" <[EMAIL PROTECTED]> wrote:
|| > 
|| > 
|| > ep, 
|| > 
|| > Any idiot can see we're the freest country in the world! 
|| > Free to do what is expected, or get thrown in jail at a 
|| > rate exceeding most other "civilized" nations. Free to 
|| > subsidize tobacco and alcohol (and related deaths) and 
|| > throw "dangerous criminals" in jail for using cannabis. 
|| > Free to have almost the highest teenage pregnancy rate 
|| > in the world. Free to fight for your rights just as long 
|| > as your money lasts! Free to buy as much of whatever you
|| > want until the money, environment, or patience of the
|| > less fortunate runs out. 
|| > 
|| > So much freedom, you could almost choke on it. 
|| > 
|| > Come on, you commie, admit it: you just stay here for 
|| > the Burgers and Coca-Cola!
|| > 
|| > "You have no chance to survive make your time"
|| > 
|| > rm
|| > 
|| > p.s. If you want to reach me, I'll be in the prayer meeting 
|| > John Ashcroft, the Attorney General, now holds each morning 
|| > inside the Department of Justice. 
|| > 
|| > 
|| > 
|| > || -Original Message-
|| > || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| > || Sent: Thursday, May 17, 2001 3:07 PM
|| > || To: Multiple recipients of list ORACLE-L
|| > || Subject: Re: job offer from SAUDI ARABIA
|| > || 
|| > || 
|| > || Many professional women in the USA have found it necessary to 
|| > || purchase handguns to protect themselves from criminal 
|| elements in 
|| > || public places. Children are constantly under 
|| psychological assault 
|| > || being exposed to media violence. The "liberal" 
|| education system is 
|| > || devoted to indoctrinating children with mindless "PC" 
|| relativism, 
|| > || materialism/consumerism and hatred of God (or at least arrogant 
|| > || dismissal).  
|| > || 
|| > || Western "freedoms" can be seen from a variety of perspectives.  
|| > || 
|| > || 
|| > -- 
|| > Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| > -- 
|| > Author: Mohan, Ross
|| >   INET: [EMAIL PROTECTED]
|| > 
|| > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| > San Diego, California-- Public Internet access / 
|| Mailing Lists
|| > 
|| 
|| > To REMOVE yourself from this mailing list, send an E-Mail message
|| > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| > the message BODY, include a line containing: UNSUB ORACLE-L
|| > (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!?
|| Yahoo! Auctions - buy the things you want at great prices
|| http://auctions.yahoo.com/
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Rocky Welch
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from).  You may
|| also send the HELP command for other information (like subscribing).
|| 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: job offer from SAUDI ARABIA

[Gene Sais]

Only in America, can you rant!  Try to criticize China while living there.  I have a 
friend there, her mail is read before she gets it.  All she can write is general 
stuff, nothing negative, fearful of her life.  The best thing about America is that 
you can b*tch if you want.  I served for this country and love this country.  *GO USA*

Not that there are not other great countries!

--
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: Another big bang for Larry

[David Messer]

Don't I feel silly!  I didn't even know that 9i was out yet, much less 10i
or 11i!  I guess I don't dare blink.

DM

-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, May 17, 2001 1:09 PM
To: Multiple recipients of list ORACLE-L


>From InformationWeek:

** Oracle Hooks NATO On 11i

The North Atlantic Treaty Organization has begun implementing
Oracle's 11i E-business software in its 19 regional headquarters.

NATO program director David Oakley says NATO's new Automated
Financial System will incorporate Oracle's enterprise resource
planning and E-business software to manage a range of operations,
including budgeting, travel, treasury, disbursement, procurement,
and supply functions. NATO also will use Oracle's
business-analysis and reporting tools.

Oracle will provide training for an estimated 700 NATO personnel.
Oakley says NATO's initiative is designed to let the organization
adopt international public-sector accounting standards and have
access to more meaningful and timely information about its own
operations.

The new system is expected to reduce the number of paper
documents that must be handled by NATO personnel, such as
requisitions and travel requests, and let the alliance use
financial forecasting tools that Oakley says will help it use
funds more efficiently. The value of the deal, and its deployment
schedule, weren't released. - Steve Konicki

Check out these related stories:

Will Oracle Finally Deliver With Release Of 11.5.3?
http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2Q0AC

Apps Made Easy?
http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20Niw0Aj

The Big Picture: The Encryption Enigma
http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2R0AD
--
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: David Messer
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Another big bang for Larry

[Ron Rogers]

It's started. After slick willy was invited to speak the kickbacks are showing up. 
 Oracle will be running the Government.   Slick move... you don't dare bust up the 
monopoly that is running the Governmential department's programs. Will the NEW 
controling body be called "the GOVERACLEMENT"???
ROR mô¿ôm

>>> [EMAIL PROTECTED] 05/17/01 04:08PM >>>
>From InformationWeek:

** Oracle Hooks NATO On 11i

The North Atlantic Treaty Organization has begun implementing 
Oracle's 11i E-business software in its 19 regional headquarters. 

NATO program director David Oakley says NATO's new Automated 
Financial System will incorporate Oracle's enterprise resource 
planning and E-business software to manage a range of operations, 
including budgeting, travel, treasury, disbursement, procurement, 
and supply functions. NATO also will use Oracle's 
business-analysis and reporting tools.

Oracle will provide training for an estimated 700 NATO personnel. 
Oakley says NATO's initiative is designed to let the organization 
adopt international public-sector accounting standards and have 
access to more meaningful and timely information about its own 
operations. 

The new system is expected to reduce the number of paper 
documents that must be handled by NATO personnel, such as 
requisitions and travel requests, and let the alliance use 
financial forecasting tools that Oakley says will help it use 
funds more efficiently. The value of the deal, and its deployment 
schedule, weren't released. - Steve Konicki

Check out these related stories:

Will Oracle Finally Deliver With Release Of 11.5.3?
http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2Q0AC 

Apps Made Easy?
http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20Niw0Aj 

The Big Picture: The Encryption Enigma
http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2R0AD 
-- 
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: Ron Rogers
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: job offer from SAUDI ARABIA

[Kevin Kostyszyn]

WOW!!  I need to pay more attantion, what the hay is going on here?

-Original Message-
Sent: Thursday, May 17, 2001 4:14 PM
To: Multiple recipients of list ORACLE-L




ep, 

Any idiot can see we're the freest country in the world! 
Free to do what is expected, or get thrown in jail at a 
rate exceeding most other "civilized" nations. Free to 
subsidize tobacco and alcohol (and related deaths) and 
throw "dangerous criminals" in jail for using cannabis. 
Free to have almost the highest teenage pregnancy rate 
in the world. Free to fight for your rights just as long 
as your money lasts! Free to buy as much of whatever you
want until the money, environment, or patience of the
less fortunate runs out. 

So much freedom, you could almost choke on it. 

Come on, you commie, admit it: you just stay here for 
the Burgers and Coca-Cola!

"You have no chance to survive make your time"

rm

p.s. If you want to reach me, I'll be in the prayer meeting 
John Ashcroft, the Attorney General, now holds each morning 
inside the Department of Justice. 



|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 17, 2001 3:07 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: job offer from SAUDI ARABIA
|| 
|| 
|| Many professional women in the USA have found it necessary to 
|| purchase handguns to protect themselves from criminal elements in 
|| public places. Children are constantly under psychological assault 
|| being exposed to media violence. The "liberal" education system is 
|| devoted to indoctrinating children with mindless "PC" relativism, 
|| materialism/consumerism and hatred of God (or at least arrogant 
|| dismissal).  
|| 
|| Western "freedoms" can be seen from a variety of perspectives.  
|| 
|| 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Moving a database to a different machine

[Steve McClure]

Koivu, Lisa said
"A word of warning, and you probably already know this: you can't have both
databases open at the same time or you will end up with incompatible archive
logs and control files. Good luck !"

hehe I did know, but upon reading your warning it still frightened me for a
moment. Because I was planning to do this one time prior to the move to
allow for testing. Therefore having both databases up and running at the
same time on the two different machines. I know I will have to do the
migration again when we actually move, so that the database(s) will recover
properly. Oh and thanks for the tip about just moving the arc/redo/control
files back to the production machine to resynch the DBs. That will save me
from some tedium on moving day.
Steve McClure
-Original Message-
Sent: Thursday, May 17, 2001 11:47 AM
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'

Hi Steve,
I used this same strategy with a migration last month. It minimized our
database related downtime to 30 minutes (and then they unplugged the
symmetrix and the app server was down for 12 hours. Oh well)
This plan will work. Once your production machine is physically moved and
set up, you can do the reverse to apply changes to the prod database without
copying over the entire database from dev:
Starting with production database down, the following steps will bring prod
up to date:
1. Shutdown dev
2. Copy over control files/redo logs/arc logs
3. Start up prod
4. Initiate recovery
Voila. Slick.
A word of warning, and you probably already know this: you can't have both
databases open at the same time or you will end up with incompatible archive
logs and control files. Good luck !

Lisa Rutland Koivu
Oracle Database Administrator
Certified Self-Important Database Deity
Slayer of Unix Administrators
Wanton Kickboxing Goddess
[EMAIL PROTECTED]

NeoMedia

2201 Second St., Suite 600
Fort Myers, FL 33901, USA
Phone: 941-337-3434
Fax: 941-337-3668
www.neom.com 
www.paperclick.com 
www.qode.com 

P a p e r C l i c k . c o m 
Enter Your PaperClick Code Here!

-Original Message-
Sent: Thursday, May 17, 2001 2:26 PM
To: Multiple recipients of list ORACLE-L
Allright,
We are physically moving our office, and have an OLTP application that needs
to be up and running with minimal downtime. The current plan is to use the
development computer as the production platform while the Primary computer
is physically moved to the new location. The development system was the
production system about 6 months ago, so it will not be under too much
strain.
I have completely duplicated the filesystems of the Primary machine on the
development box.
This is my plan. Please comment if there is an obviously better way. Oh
the database is version 7.3.4
1.Put the tablespaces of the production database in backup mode.
2.Copy datafiles across the network to the "development" machine. Approx 3
GB
3.Take the production tablespaces out of backup mode.
4.Force a log switch.(Habit I guess)
5.wait until the production system is brought down.
6.move the control files and redo logs to the development system
7.move the initSID.ora and configSID.ora files.
8.edit configSID.ora to change the host associated to Listener.
9.fire up svrmgrl, and recover the database.
10.change the tnsnames on the client systems to point to the development
machine.
Of course. This needs to be tested to some degree first. And we(well
management at least) don't want to bring the production machine down to roll
the databases forward together just for a test. I can use make a backup
control file for use during recovery, and move the curently offline redo
logs. I am not sure what to do about the most current redo log in this
case. I have played with backup and recovery, but not this scenario. I
don't currently have my copy of the Velpuri backup and recovery handbook at
hand(Loaned it to a colleague). So I am bouncing this off of you folks
while I ponder this until I retrieve my backup and recovery bible.
Any Comments are appreciated.
Thanks,
Steve McClure



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Steve McClure
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- P

OT RE: job offer from SAUDI ARABIA

[Mohan, Ross]

Brian of MacLean, 
 
I guess that's a good way of putting it, too. Sometimes I like to rant about
( i.e. "for" ) Amerikkka, but that's usually when she's under attack, in a
way that is 
perceived by me as being unfair or 
misinformed. 
 
- Ross

-Original Message-
Sent: Thursday, May 17, 2001 4:17 PM
To: Multiple recipients of list ORACLE-L



God I live in an awful country.  I'm sorry for all the tyranny my country
has put the world through.  I guess I'll just shoot myself.

Seriously.  I encourage the individual that is looking at working in Saudi
Arabia to do so if that is the experiences he wishes to have.  I am the
first to scream from the highest mountain all the things that are wrong with
America, and if it's okay with you, what is right with America.  The point
being that in America, "I CAN" if I want to.

Have a nice day and I hope you enjoy your move to Saudi Arabia. 

-Original Message- 

Sent: Thursday, May 17, 2001 12:07 PM 
To: Multiple recipients of list ORACLE-L 


Many professional women in the USA have found it necessary to 
purchase handguns to protect themselves from criminal elements in 
public places. Children are constantly under psychological assault 
being exposed to media violence. The "liberal" education system is 
devoted to indoctrinating children with mindless "PC" relativism, 
materialism/consumerism and hatred of God (or at least arrogant 
dismissal).  

Western "freedoms" can be seen from a variety of perspectives.  


> Conditions cut both ways - depends on how you see it... Loss of religious,

> social and cultural freedom against the possibility of earning (and saving

> because you can't spend) lots of $$. Having said that, as long as you
stick 
> to the straight and narrow path (as defined by the Saudi authorities) you 
> will be on the safest place on earth as far as crime goes. (E.g. stealing
is 
> punishable by cutting off your arm/fingers!!) 

... 


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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: RE: job offer from SAUDI ARABIA

[Rocky Welch]

And freedom to leave the country any time you wish. Have a nice flight.

--- "Mohan, Ross" <[EMAIL PROTECTED]> wrote:
> 
> 
> ep, 
> 
> Any idiot can see we're the freest country in the world! 
> Free to do what is expected, or get thrown in jail at a 
> rate exceeding most other "civilized" nations. Free to 
> subsidize tobacco and alcohol (and related deaths) and 
> throw "dangerous criminals" in jail for using cannabis. 
> Free to have almost the highest teenage pregnancy rate 
> in the world. Free to fight for your rights just as long 
> as your money lasts! Free to buy as much of whatever you
> want until the money, environment, or patience of the
> less fortunate runs out. 
> 
> So much freedom, you could almost choke on it. 
> 
> Come on, you commie, admit it: you just stay here for 
> the Burgers and Coca-Cola!
> 
> "You have no chance to survive make your time"
> 
> rm
> 
> p.s. If you want to reach me, I'll be in the prayer meeting 
> John Ashcroft, the Attorney General, now holds each morning 
> inside the Department of Justice. 
> 
> 
> 
> || -Original Message-
> || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
> || Sent: Thursday, May 17, 2001 3:07 PM
> || To: Multiple recipients of list ORACLE-L
> || Subject: Re: job offer from SAUDI ARABIA
> || 
> || 
> || Many professional women in the USA have found it necessary to 
> || purchase handguns to protect themselves from criminal elements in 
> || public places. Children are constantly under psychological assault 
> || being exposed to media violence. The "liberal" education system is 
> || devoted to indoctrinating children with mindless "PC" relativism, 
> || materialism/consumerism and hatred of God (or at least arrogant 
> || dismissal).  
> || 
> || Western "freedoms" can be seen from a variety of perspectives.  
> || 
> || 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mohan, Ross
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

View v_$session

[Gilberto Gampert]

Hi guys!

Since the upgrade of my Oracle server to the version 8.1.6 (I applied all
the patches) and the rebuild of the clients applications with the libraries
from the same version, the column PROGRAM of the view v_$session is empty.
If the application is using the old libs, the program apears in the view.
Does anybody know the solution?  What to do to see the program that is
running?

I thank in advance!!!

--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--
Gilberto Gampert  Universidade de Passo Fundo
Administrador de Banco de Dados   Passo Fundo - RS - Brazil
[EMAIL PROTECTED]   http://www.upf.tche.br
--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 drop schema script ??

[Luis DeUrioste]

uhhh DUHHH !

I could write the algorithm to solve the logarithm .. IF I ONLY HAD A
BRAIN ..

Thank you to all of you, and special thanks for not bashing me

Luis Octavio

Luis DeUrioste wrote:

> All mighty and powerful DBA supremes !
>
> Do any of you have a drop schema script that would be willing to share
> ??
> It'll be greatly appreciated
>
> T I A


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

RE: Script that will remove redundant rows from table

[Rachel Carmichael]

GROAN


>From: "Eric D. Pierce" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Script that will remove redundant rows from table
>Date: Thu, 17 May 2001 10:50:39 -0800
>
>Mr. Rhet Device
>(rhet oracle device, that is)
>
>On 17 May 2001, at 8:21, Alan Aschenbrenner wrote:
>
> > Who was the half person?
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Eric D. Pierce
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

OT: RE: job offer from SAUDI ARABIA

[Mohan, Ross]

ep, 

Any idiot can see we're the freest country in the world! 
Free to do what is expected, or get thrown in jail at a 
rate exceeding most other "civilized" nations. Free to 
subsidize tobacco and alcohol (and related deaths) and 
throw "dangerous criminals" in jail for using cannabis. 
Free to have almost the highest teenage pregnancy rate 
in the world. Free to fight for your rights just as long 
as your money lasts! Free to buy as much of whatever you
want until the money, environment, or patience of the
less fortunate runs out. 

So much freedom, you could almost choke on it. 

Come on, you commie, admit it: you just stay here for 
the Burgers and Coca-Cola!

"You have no chance to survive make your time"

rm

p.s. If you want to reach me, I'll be in the prayer meeting 
John Ashcroft, the Attorney General, now holds each morning 
inside the Department of Justice. 



|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 17, 2001 3:07 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: job offer from SAUDI ARABIA
|| 
|| 
|| Many professional women in the USA have found it necessary to 
|| purchase handguns to protect themselves from criminal elements in 
|| public places. Children are constantly under psychological assault 
|| being exposed to media violence. The "liberal" education system is 
|| devoted to indoctrinating children with mindless "PC" relativism, 
|| materialism/consumerism and hatred of God (or at least arrogant 
|| dismissal).  
|| 
|| Western "freedoms" can be seen from a variety of perspectives.  
|| 
|| 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Another big bang for Larry

[dgoulet]

>From InformationWeek:

** Oracle Hooks NATO On 11i

The North Atlantic Treaty Organization has begun implementing 
Oracle's 11i E-business software in its 19 regional headquarters. 

NATO program director David Oakley says NATO's new Automated 
Financial System will incorporate Oracle's enterprise resource 
planning and E-business software to manage a range of operations, 
including budgeting, travel, treasury, disbursement, procurement, 
and supply functions. NATO also will use Oracle's 
business-analysis and reporting tools.

Oracle will provide training for an estimated 700 NATO personnel. 
Oakley says NATO's initiative is designed to let the organization 
adopt international public-sector accounting standards and have 
access to more meaningful and timely information about its own 
operations. 

The new system is expected to reduce the number of paper 
documents that must be handled by NATO personnel, such as 
requisitions and travel requests, and let the alliance use 
financial forecasting tools that Oakley says will help it use 
funds more efficiently. The value of the deal, and its deployment 
schedule, weren't released. - Steve Konicki

Check out these related stories:

Will Oracle Finally Deliver With Release Of 11.5.3?
http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2Q0AC

Apps Made Easy?
http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20Niw0Aj

The Big Picture: The Encryption Enigma
http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2R0AD
-- 
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: job offer from SAUDI ARABIA

[Brian MacLean]

Title: RE: job offer from SAUDI ARABIA





God I live in an awful country.  I'm sorry for all the tyranny my country has put the world through.  I guess I'll just shoot myself.

Seriously.  I encourage the individual that is looking at working in Saudi Arabia to do so if that is the experiences he wishes to have.  I am the first to scream from the highest mountain all the things that are wrong with America, and if it's okay with you, what is right with America.  The point being that in America, "I CAN" if I want to.

Have a nice day and I hope you enjoy your move to Saudi Arabia.


-Original Message-
From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 12:07 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: job offer from SAUDI ARABIA



Many professional women in the USA have found it necessary to 
purchase handguns to protect themselves from criminal elements in 
public places. Children are constantly under psychological assault 
being exposed to media violence. The "liberal" education system is 
devoted to indoctrinating children with mindless "PC" relativism, 
materialism/consumerism and hatred of God (or at least arrogant 
dismissal).  


Western "freedoms" can be seen from a variety of perspectives.  



> Conditions cut both ways - depends on how you see it... Loss of religious,
> social and cultural freedom against the possibility of earning (and saving
> because you can't spend) lots of $$. Having said that, as long as you stick
> to the straight and narrow path (as defined by the Saudi authorities) you
> will be on the safest place on earth as far as crime goes. (E.g. stealing is
> punishable by cutting off your arm/fingers!!) 


...



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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ....A drop schema script ??

[Diego Cutrone]

Or...may be

select 'drop user '||username||' cascade;'
from dba_users
where username not in ('SYS','SYSTEM'); --and perhaps some other user you'd
like to conserve

...and then run the spool.

hope it helps
DC

- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 4:48 PM


> How about:
>
> drop user  cascade;
>
>
> --- Luis DeUrioste <[EMAIL PROTECTED]> wrote:
> > All mighty and powerful DBA supremes !
> >
> > Do any of you have a drop schema script that would be willing to share
> > ??
> > It'll be greatly appreciated
> >
> > T I A
> >
> > > begin:vcard
> > n:de Urioste;Luis Octavio
> > tel;fax:850.455.0673
> > tel;work:850.457.3218
> > x-mozilla-html:FALSE
> > org:Raytheon Aerospace;IT
> > version:2.1
> > email;internet:[EMAIL PROTECTED]
> > title:Systems Analyst
> > adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 -
> > UNFO;Pensacola;Florida;32534;U.S.A.
> > fn:Luis Octavio de Urioste
> > end:vcard
> >
>
>
> __
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
> http://auctions.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rocky Welch
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Oracle DBA Needed in Cleveland area..

[OraStaff]

This Client in the Cleveland Ohio area, is dedicated to creating a work
environment 
enabling ALL employees to contribute and to grow into their fullest potential. 
They have a full-time staff opportunity available for an Oracle DBA.

This is a full time staff position so no sub-contractors or third parties
please.

Please do not call or send a resume if you are not in the U.S. and/or need 
sponsorship.

*Responsibilities:
The qualified candidate will be responsible for the production support of
all Oracle
and SQL Server databases in a 7X24 environment.  
Responsibilities include performance monitoring and tuning, the implementation 
and support of an effective backup and recovery plan, new object installation
and some database design.
 
*Requirements:
*   2 years prior experience in an Oracle or SQL Server environment is required.
*   Desired:
*   Experience with the Solaris and NT operating system.
*   Ability to work in a team environment with minimal supervision.
*   Able to provide support in a 7X24 environment.
*   Strong organizational skills.
*   Familiarity with UNIX (SUN Solaris), NT, Novell and MVS
operating systems.
*   Familiarity with relational technology.
*   Familiarity with midrange DBMS's (Oracle SQL Server).
*   Familiarity with Network technology.
 
- U.S. Citizenship or permanent residency also required.
  

These positions offer:
   * Stability 
   * The opportunity to become a key member of the team.
   * Base salary of 50-75K-D.O.E.
   

NO sub contracting positions available.

PLEASE do not send your resume if you are not in the United States.

For  immediate consideration, please send your resume as a Word attachment to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
ph: 1-800 -549-8502
Please use job code One/Cleve/DBA/Gayle

Candidates who we are interested in will be contacted immediately.

*We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the posiition described above- if it is not a match for your skills.
Thanks,
Bill Law




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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: enqueue waits -- CI

[Diego Cutrone]

As usual, "thanks" for the answer Steve.

I'll try to reduce the number of shrinks in the rollback segments, so this
is going to impact on CI enqueue waits.

What do you think about Metalink DOC ID 1020355.102 recomendation?

(from my previous email)
"> I've also read a metalink document (1020355.102). According to this, one
> possible cause is that my application is using ***dbms_pipe*** extensively
(it may
> be right, I've seen "pipe get" event very high). The suggested solution is
> to increase the shared_pool. I can't access the other documents mentioned
> in the paper."

Eventtotal_waits   time_waited
pipe get910593342266184


Thank you.
DC


- Original Message -
To: Diego Cutrone <[EMAIL PROTECTED]>; Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 1:53 AM


> Hi Diego,
>
> No, those are block buffers. When a segment is dropped, truncated or
shrunk
> (normally a rollback segment) then a "reuse block range" cross instance
call is
> needed to flush the unwanted blocks from cache. Similarly, before a
parallel
> direct read a "checkpoint block range" or "checkpoint object" cross
instance
> call is needed (otherwise changes made prior to the start of the query and
> committed but not yet flushed to disk could be missed by the direct
reads).
> These are "cross-instance" calls even in single-instance Oracle because
the code
> allows for the possibility of parallel server, and the DBWn processes in
all
> instance need to flush the cache in their own instances.
>
> @   Regards,
> @   Steve Adams
> @   http://www.ixora.com.au/
> @   http://www.christianity.net.au/
>
>
> -Original Message-
> From: Diego Cutrone [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 17 May 2001 4:11
> To: Multiple recipients of list ORACLE-L
> Subject: RE: enqueue waits -- CI
>
>
> Thanks for answering Unal, John.
>
> John, you were right about the query. I've corrected it. And I'm not
getting
> "T[" and "CK" anymore,now I get TX and CI.
> I've also done further investigation and I also know now what p2 and p3
> mean.
>
> This is the updated data: (from the dumps)
> 
> count TYPE  MODE
>  13  CI  6  p2=0 p3=5 ela=0
>   19 TX 6 p2=262223 p3=53352 ela=301
>   75 TX 4 p2=524391 p3=50022 ela=301
>   75 TX 6 p2=720923 p3=5194 ela=301
>  104TX 6 p2=196736 p3=52393 ela=301
>  305TX 6 p2=393276 p3=50281 ela=301
> 
>
> Now, how can I get the rollback segment number involved in the TX ? (I
know
> its from p2 and p3, but how?) --just curious. I'll also take John advise,
> and I'll try to identify the locking session(s).
>
> Now, although CI enqueue waits (cross instance call invocation) are brief
on
> this sample, Sometimes it's not.
> So I'm trying to understand what it means. According to p2 and p3 flags,
> they are indicating "Flush buffers for reuse as new class", that means
that
> a session needs a buffer (in the shared pool I think) and it has to flush
> some others in order to get space. am I correct?.
> I've also read a metalink document (1020355.102). According to this, one
> possible cause is that my application is using dbms_pipe extensively (it
may
> be right, I've seen event "pipe get" very high). The suggested solution is
> to increase the shared_pool. I can't access the other documents mentioned
> in the paper.
>
>
> Can someone explain to me what means this CI enqueue and how can I reduce
> it.
> TIA
>
>
>
>
>
>
>
>
>
>
>
>
>
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Tuesday, May 15, 2001 6:16 PM
>
>
> > Hi Diego,
> >
> > Without going into details, an 'enqueue' wait is mostly due to a
> > user/program initated transaction lock and I see it a lot in Financial
> > databases (I see you are on 10.7?). I deduce you were looking at
> > V$SYSTEM_EVENT - If a user locked one row (probably queried a row in
> Forms,
> > inadvertly changed one character which issues a 'SELECT for UPDATE, thus
> > locking that row) and anotehr user (through a form or a report) needs to
> > perform DML on that particular row, then (I believe) you will clock up
> time
> > against the 'enqueue' event.
> >
> > What I would suggest is that you use the following query to determine if
> > someone is locking someone else out:
> >
> > select event, count(*) from v$session_wait
> > group by event
> >
> > If you see the 'enqueue' event in this list, some process is probably
> > waiting on a lock... You can then trace the user/process via Lock
> detection
> > scripts (see Metablink) and kill the blocking process. You could also
> query
> > from sys.dba_waiters which will present an easier picture in this case..
> >
> > As far as the SQL goes, see below:
> >
> >  select
> > chr(b

RE: ....A drop schema script ??

[John Lewis]

Login in as system:
drop user user_name cascade;

-Original Message-
Sent: Thursday, May 17, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L


All mighty and powerful DBA supremes !

Do any of you have a drop schema script that would be willing to share
??
It'll be greatly appreciated

T I A

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: newbie question

[Diego Cutrone]

Hi Julia,

"Can I have two different ports for two
database in the same **tnsname.ora** on the same server?"

I think you are referring to the file listener.ora, and you want to
configure 2 "listeners" in the same box.
If that's the question the answer is "yes".

hope it helps



- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 2:05 AM


Thank you so much for the info, DC.

I have another stupid question. Can I have two different ports for two
database in the same tnsname.ora on the same server?

Cheers,
Julia



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


Hi,
Yes, you can modify instance parameters in the initXYZ.ora file.
 After you change them, they take effect when you bounce the instance
(shutdown and startup)

 Also, there are some parameters that can be modify on the fly, without
bouncing the instance.

check this.

SQL> desc v$parameter
 NameNull?Type
 ---  
 NUM  NUMBER
 NAME VARCHAR2(64)
 TYPE NUMBER
 VALUEVARCHAR2(512)
 ISDEFAULTVARCHAR2(9)
 ISSES_MODIFIABLE VARCHAR2(5)
 ISSYS_MODIFIABLE VARCHAR2(9)
 ISMODIFIED   VARCHAR2(10)
 ISADJUSTED   VARCHAR2(5)
 DESCRIPTION  VARCHAR2(64)

SQL> column name format a60
SQL> column value format a20
SQL> column ISSYS_MODIFIABLE format a6
SQL> select name,value,ISSYS_MODIFIABLE from v$parameter;


NAME VALUE
ISSYS_
 ---
- --
processes50
FALSE
sessions 60
FALSE
timed_statistics TRUE
IMMEDIATE<<<---

You can change timed_statistics value with this command:

alter system set timed_statistics=true;


Hope it helps
DC


- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, May 16, 2001 3:19 PM


> Hi, guru,
>
> After I created a XYZ database using the Database Configuration Assistant,
> can I modify some parameters in the initXYZ.ora file? What steps should I
> take after the modification? Please advise.
>
> Regards,
> Julia
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: PHU,JULIA (HP-Sunnyvale,ex2)
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Diego Cutrone
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: PHU,JULIA (HP-Sunnyvale,ex2)
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Diego Cutrone
  INET: [EMAIL PROTECTED]

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

RE: Moving a database to a different machine

[Koivu, Lisa]

Title: RE: Moving a database to a different machine





Hi Steve, 


I used this same strategy with a migration last month.  It minimized our database related downtime to 30 minutes (and then they unplugged the symmetrix and the app server was down for 12 hours.  Oh well) 

This plan will work.  Once your production machine is physically moved and set up, you can do the reverse to apply changes to the prod database without copying over the entire database from dev:

Starting with production database down, the following steps will bring prod up to date:


1.  Shutdown dev
2.  Copy over control files/redo logs/arc logs
3.  Start up prod
4.  Initiate recovery


Voila.  Slick. 


A word of warning, and you probably already know this:  you can't have both databases open at the same time or you will end up with incompatible archive logs and control files.  Good luck !

 
Lisa Rutland Koivu
Oracle Database Administrator
Certified Self-Important Database Deity
Slayer of Unix Administrators
Wanton Kickboxing Goddess


[EMAIL PROTECTED]
 
 NeoMedia
 
2201 Second St., Suite 600
Fort Myers, FL 33901, USA
Phone: 941-337-3434
Fax: 941-337-3668
www.neom.com  
www.paperclick.com  
www.qode.com  
 
P a p e r C l i c k . c o m  
 



 Enter Your PaperClick Code Here!
 
 



-Original Message-
From: Steve McClure [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 2:26 PM
To: Multiple recipients of list ORACLE-L
Subject: Moving a database to a different machine



Allright,
We are physically moving our office, and have an OLTP application that needs
to be up and running with minimal downtime.  The current plan is to use the
development computer as the production platform while the Primary computer
is physically moved to the new location.  The development system was the
production system about 6 months ago, so it will not be under too much
strain.


  I have completely duplicated the filesystems of the Primary machine on the
development box.


This is my plan.  Please comment if there is an obviously better way.  Oh
the database is version 7.3.4


1.Put the tablespaces of the production database in backup mode.
2.Copy datafiles across the network to the "development" machine.  Approx 3
GB
3.Take the production tablespaces out of backup mode.
4.Force a log switch.(Habit I guess)
5.wait until the production system is brought down.
6.move the control files and redo logs to the development system
7.move the initSID.ora and configSID.ora files.
8.edit configSID.ora to change the host associated to Listener.
9.fire up svrmgrl, and recover the database.
10.change the tnsnames on the client systems to point to the development
machine.


Of course.  This needs to be tested to some degree first.  And we(well
management at least) don't want to bring the production machine down to roll
the databases forward together just for a test.  I can use make a backup
control file for use during recovery, and move the curently offline redo
logs.  I am not sure what to do about the most current redo log in this
case.  I have played with backup and recovery, but not this scenario.  I
don't currently have my copy of the Velpuri backup and recovery handbook at
hand(Loaned it to a colleague).  So I am bouncing this off of you folks
while I ponder this until I retrieve my backup and recovery bible.


Any Comments are appreciated.


Thanks,
Steve McClure





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


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 drop schema script ??

[Rocky Welch]

How about:

drop user  cascade;


--- Luis DeUrioste <[EMAIL PROTECTED]> wrote:
> All mighty and powerful DBA supremes !
> 
> Do any of you have a drop schema script that would be willing to share
> ??
> It'll be greatly appreciated
> 
> T I A
> 
> > begin:vcard 
> n:de Urioste;Luis Octavio
> tel;fax:850.455.0673
> tel;work:850.457.3218
> x-mozilla-html:FALSE
> org:Raytheon Aerospace;IT
> version:2.1
> email;internet:[EMAIL PROTECTED]
> title:Systems Analyst
> adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 -
> UNFO;Pensacola;Florida;32534;U.S.A.
> fn:Luis Octavio de Urioste
> end:vcard
> 


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Forms and Reports Server versions vs. RDBMS versions

[Eric D. Pierce]

It takes a lot of digging for multiple versions, but on Metalink, 
under "product life cycle" there is a certification facility with 
various levels of "drill-down".  

regards,
ep

--
   

 Certify - Certification Matrix: Oracle Forms 6i on Microsoft Windows 
2000


 Client Certifications 

OS
 Product
 Server
 Status
 Addtl.
  Info.
 Components
 Other
 
Issues
   2000
  6.0.8.13, (Patch
4)
  8.1.7
  (8i)
Certified
  Yes
Yes
  Yes
  
None
   2000
  6.0.8.13, (Patch
4)
  8.1.6
  (8i)
Certified
  Yes
Yes
  Yes
  
None
   2000
  6.0.8.12.1(Patch
   3A)
  8.1.7
  (8i)
Certified
  Yes
Yes
  Yes
  
Yes
   2000
  6.0.8.12.1(Patch
   3A)
  8.1.6
  (8i)
Certified
  Yes
Yes
  Yes
  
Yes
   2000
   6.0.8.11.3 (Rel
2)
  8.1.7
  (8i)
Certified
  Yes
Yes
  None
  
None
   2000
   6.0.8.11.3 (Rel
2)
  8.1.6
  (8i)
Certified
  Yes
Yes
  None
  
None




   Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. 
Legal Notices and
   Terms of Use.

--

  

   

 Certify - Certification Matrix: Oracle (Web) Application Server on 
Microsoft Windows 2000


 Application Tier Certifications 

OS
   Product
Server
 Status
  Addtl.
   Info.
   Components
Other
 
Issues
2000
   4.0.8.2.1
8.1.6 (8i)
 Certified
   None
  None
 Yes
 
None




  Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. 
Legal Notices and Terms of
  Use.




--





On 17 May 2001, at 10:41, Boivin, Patrice J wrote:

Date sent:  Thu, 17 May 2001 10:41:42 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

...
> What I want to know is, which versions of OAS , OEM or Developer were
> designed on concert with which version of the RDBMS.
...


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

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

Re: index FS vs index FFS - what's the difference ?

[Jared Still]

Re the 'scattered read' for full index scan.

This term is counter intuitive at first glance, and is commonly
seen on full table scans.  It makes sense that it would show up
on full index scans as well.

Here's an explanation of 'scattered read' found at
http://fncduh.fnal.gov/supportdb/working/logbook/db_file_multiblock_read_count.htm


 The Explain Plan for a given query will reveal if a full table scan will be
 performed. The BSTAT/ESTAT report lists statistics for multi-block reads as
 "db file scattered read". The term "scattered read" refers to multiple blocks
 read into DB block buffers that are "scattered" throughout memory. High
 values for db file scattered read is often an indicator of many full table
 scans being performed. BSTAT/ESTAT is a useful tool in tuning this and other
 init.ora parameters.

Jared


On Thursday 17 May 2001 01:40, Shevtsov, Eduard wrote:
> Hi List,
>
> I've made two corresponding dumps and ... I must admit I have much less
> understanding than I had before.
> Please look at them.
>
> =
> PARSING IN CURSOR #1 len=68 dep=0 uid=32 oct=3 lid=32 tim=219058914
> hv=168660475 ad='aa69f79c'
> select /*+ INDEX(documents pk_documents) */ count(*)
> from documents
> END OF STMT
> PARSE #1:c=12,e=29,p=27,cr=322,cu=6,mis=1,r=0,dep=0,og=4,tim=219058914
> EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=219058914
> WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
> WAIT #1: nam='file open' ela= 0 p1=0 p2=0 p3=0
> WAIT #1: nam='db file sequential read' ela= 1 p1=22 p2=108810 p3=1
> WAIT #1: nam='db file sequential read' ela= 1 p1=22 p2=109485 p3=1
> WAIT #1: nam='db file sequential read' ela= 0 p1=22 p2=108811 p3=1
> WAIT #1: nam='db file scattered read' ela= 1 p1=22 p2=108812 p3=11
> [skip]
>
> WAIT #1: nam='db file parallel read' ela= 1 p1=1 p2=11 p3=11
> WAIT #1: nam='db file parallel read' ela= 0 p1=1 p2=11 p3=11
>
> [skip]
>
> WAIT #1: nam='db file scattered read' ela= 0 p1=22 p2=109472 p3=11
> WAIT #1: nam='db file sequential read' ela= 0 p1=22 p2=109483 p3=1
> WAIT #1: nam='db file sequential read' ela= 0 p1=22 p2=109486 p3=1
> WAIT #1: nam='db file parallel read' ela= 0 p1=1 p2=11 p3=11
>
> =
> PARSING IN CURSOR #1 len=72 dep=0 uid=32 oct=3 lid=32 tim=219108177
> hv=3669603672 ad='aa6a4f84'
> select /*+ INDEX_FFS(documents pk_documents) */
> count(*)
> from documents
> END OF STMT
> PARSE #1:c=11,e=13,p=27,cr=322,cu=6,mis=1,r=0,dep=0,og=4,tim=219108177
> EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=219108177
> WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
> WAIT #1: nam='file open' ela= 0 p1=0 p2=0 p3=0
> WAIT #1: nam='db file sequential read' ela= 1 p1=22 p2=108809 p3=1
> WAIT #1: nam='db file scattered read' ela= 2 p1=22 p2=108810 p3=8
> WAIT #1: nam='db file scattered read' ela= 0 p1=22 p2=108818 p3=8
>
> [skip, all next lines are the same]
>
> My questions are
>
> 1. Why I get 'db file scattered read' waits for index full scan ?
> 2. Why p3 for this event is 11 even though my db_file_multiblock_read_count
> = 8 ?
> 3. What does mean 'db file parallel read' event?
>
> Anjo Kolk's paper doesn't describe it (guess the wait is Oracle8-specific).
> Oracle 8i Reference says:
>
>  This happens during recovery. Database blocks that need to be
> changed as
> part of recovery are read in parallel from the database.
>
> But it seems not my case.
>
> 4. Finally, what is the difference between the two index paths in that case
> ?
>
> I'm on 8.1.7.0 Solaris, file-based system, LMT
>
>
> Thanks in advance,
> Ed
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 drop schema script ??

[Luis DeUrioste]

All mighty and powerful DBA supremes !

Do any of you have a drop schema script that would be willing to share
??
It'll be greatly appreciated

T I A



begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Re: How to make DBA cannot 'see' User's Tables?

[Jared Still]

The key must be on 8 byte boundaries.

See my article on encryption at www.cybcon.com/~jkstill/util

Jared


On Wednesday 16 May 2001 18:30, Ahmadsyah Algozhi Nugroho wrote:
> I'm using Oracle 8.1.7.
> there was an error
> ERROR at line 1:
> ORA-28232: invalid input length for obfuscation toolkit
> ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT_FFI", line 0
> ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT", line 33
> ORA-06512: at "SCOTT.IAO_PROTECT", line 15
> ORA-06512: at line 1
>
> I check thath my key and my input string is varchar12(10).
> Key = 0123456789
> input string = 'testtestte'
>
> dbms_obfuscation_toolkit.desencrypt (
>   input_string => 'testtestte'
>   , key_string => '1234567890'
>   , encrypted_string => vEncrypted
>   );
> Am I forget something?
>
> TIA,
>
>
> Ahmadsyah Alghozi Nugroho
> Database Engineering Specialist
> PT Infoglobal AutOptima
> Jl. Baruk Tengah I/49
> Surabaya - Jawa Timur
> phone : +62 (31) 8708456 ext.113
>
> > From: Srinagesh Battula [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 17, 2001 7:26 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: How to make DBA cannot 'see' User's Tables?
> >
> >
> >
> > You can encrypt & Decrypt data using the
> > DBMS_OBFUSCATION_TOOLKIT package
> > (comes with 8.1.6)
> >
> > Srinagesh "What do I know any way" Battula
> >
> > > -Original Message-
> > > From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, May 16, 2001 4:21 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: How to make DBA cannot 'see' User's Tables?
> > >
> > >
> > > Data Encryption?
> > >
> > > -Original Message-
> > > Sent: Wednesday, May 16, 2001 7:01 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >
> > > Dear gurus,
> > > How to make DBA cannot 'see' user's datas?
> > > I build an application which very important and top secret
> > > even DBA cannot
> > > 'see' this data. But DBA can backup this data.What is the
> > > solution for this
> > > problem?
> > >
> > > TIA,
> > >
> > >
> > > Ahmadsyah Alghozi Nugroho
> > > Database Engineering Specialist
> > > PT Infoglobal AutOptima
> > > Jl. Baruk Tengah I/49
> > > Surabaya - Jawa Timur
> > > phone : +62 (31) 8708456 ext.113
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Khedr, Waleed
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access /
> >
> > Mailing Lists
> >
> > > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (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: Srinagesh Battula
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).


Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: job offer from SAUDI ARABIA

[Eric D. Pierce]

Many professional women in the USA have found it necessary to 
purchase handguns to protect themselves from criminal elements in 
public places. Children are constantly under psychological assault 
being exposed to media violence. The "liberal" education system is 
devoted to indoctrinating children with mindless "PC" relativism, 
materialism/consumerism and hatred of God (or at least arrogant 
dismissal).  

Western "freedoms" can be seen from a variety of perspectives.  


> Conditions cut both ways - depends on how you see it... Loss of religious,
> social and cultural freedom against the possibility of earning (and saving
> because you can't spend) lots of $$. Having said that, as long as you stick
> to the straight and narrow path (as defined by the Saudi authorities) you
> will be on the safest place on earth as far as crime goes. (E.g. stealing is
> punishable by cutting off your arm/fingers!!) 

...


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How to make DBA cannot 'see' User's Tables?

[Jared Still]

oops!

My previous post said that the key must be on 8 byte boundaries.

That is incorrect.  I believe the data must be on 8 byte boundaries.

Guess I should re-read my own article.  

Jared

On Wednesday 16 May 2001 18:30, Ahmadsyah Algozhi Nugroho wrote:
> I'm using Oracle 8.1.7.
> there was an error
> ERROR at line 1:
> ORA-28232: invalid input length for obfuscation toolkit
> ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT_FFI", line 0
> ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT", line 33
> ORA-06512: at "SCOTT.IAO_PROTECT", line 15
> ORA-06512: at line 1
>
> I check thath my key and my input string is varchar12(10).
> Key = 0123456789
> input string = 'testtestte'
>
> dbms_obfuscation_toolkit.desencrypt (
>   input_string => 'testtestte'
>   , key_string => '1234567890'
>   , encrypted_string => vEncrypted
>   );
> Am I forget something?
>
> TIA,
>
>
> Ahmadsyah Alghozi Nugroho
> Database Engineering Specialist
> PT Infoglobal AutOptima
> Jl. Baruk Tengah I/49
> Surabaya - Jawa Timur
> phone : +62 (31) 8708456 ext.113
>
> > From: Srinagesh Battula [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 17, 2001 7:26 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: How to make DBA cannot 'see' User's Tables?
> >
> >
> >
> > You can encrypt & Decrypt data using the
> > DBMS_OBFUSCATION_TOOLKIT package
> > (comes with 8.1.6)
> >
> > Srinagesh "What do I know any way" Battula
> >
> > > -Original Message-
> > > From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, May 16, 2001 4:21 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: How to make DBA cannot 'see' User's Tables?
> > >
> > >
> > > Data Encryption?
> > >
> > > -Original Message-
> > > Sent: Wednesday, May 16, 2001 7:01 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >
> > > Dear gurus,
> > > How to make DBA cannot 'see' user's datas?
> > > I build an application which very important and top secret
> > > even DBA cannot
> > > 'see' this data. But DBA can backup this data.What is the
> > > solution for this
> > > problem?
> > >
> > > TIA,
> > >
> > >
> > > Ahmadsyah Alghozi Nugroho
> > > Database Engineering Specialist
> > > PT Infoglobal AutOptima
> > > Jl. Baruk Tengah I/49
> > > Surabaya - Jawa Timur
> > > phone : +62 (31) 8708456 ext.113
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Khedr, Waleed
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > San Diego, California-- Public Internet access /
> >
> > Mailing Lists
> >
> > > 
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (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: Srinagesh Battula
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).


Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Truncate listener.log how?

[Lucy Lin]

Hi seema,

you can do:

echo '' > listener.log


On Thu, 17 May 2001, Seema Singh wrote:

> Gurus
> I want to truncate listener.log file.I am using oracle 8.1.5 and 8.1.7 on 
> solaris 8.Plese suggest.As I understand
> go to listener.log file directory
> copy listener.log listener.old
> tail -10 >listener.log
> Thanks in advance.
> -seema
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
> 
> 

-- 
Lucy Lin Oracle DBA

condenet.com 212-286-3852

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Moving a database to a different machine

[Rachel Carmichael]

I think this will work fine. You could play with doing it with a standby 
database, the only advantage to that is that you could start the backup and 
move of files earlier in the process and just keep recovering the archived 
logs as you ship them across.

This has the advantage of giving you time to plan, test and play with 
starting the standby db.

So the steps would be:

create the standby database
ship archived logs to standby site, recover logs

when ready to move over:

on production db, force log switch, shutdown, and move the last archived log 
over

on standby machine, recover the last log. Open the database.

make the necessary changes to various tnsnames.ora and you are in business

Then when you move back to the "real" production machine, you do the same 
thing.


Rachel


>From: "Steve McClure" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Moving a database to a different machine
>Date: Thu, 17 May 2001 10:25:34 -0800
>
>Allright,
>We are physically moving our office, and have an OLTP application that 
>needs
>to be up and running with minimal downtime.  The current plan is to use the
>development computer as the production platform while the Primary computer
>is physically moved to the new location.  The development system was the
>production system about 6 months ago, so it will not be under too much
>strain.
>
>   I have completely duplicated the filesystems of the Primary machine on 
>the
>development box.
>
>This is my plan.  Please comment if there is an obviously better way.  Oh
>the database is version 7.3.4
>
>1.Put the tablespaces of the production database in backup mode.
>2.Copy datafiles across the network to the "development" machine.  Approx 3
>GB
>3.Take the production tablespaces out of backup mode.
>4.Force a log switch.(Habit I guess)
>5.wait until the production system is brought down.
>6.move the control files and redo logs to the development system
>7.move the initSID.ora and configSID.ora files.
>8.edit configSID.ora to change the host associated to Listener.
>9.fire up svrmgrl, and recover the database.
>10.change the tnsnames on the client systems to point to the development
>machine.
>
>Of course.  This needs to be tested to some degree first.  And we(well
>management at least) don't want to bring the production machine down to 
>roll
>the databases forward together just for a test.  I can use make a backup
>control file for use during recovery, and move the curently offline redo
>logs.  I am not sure what to do about the most current redo log in this
>case.  I have played with backup and recovery, but not this scenario.  I
>don't currently have my copy of the Velpuri backup and recovery handbook at
>hand(Loaned it to a colleague).  So I am bouncing this off of you folks
>while I ponder this until I retrieve my backup and recovery bible.
>
>Any Comments are appreciated.
>
>Thanks,
>Steve McClure
>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Steve McClure
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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).

Re: sqlldr help

[Jared Still]

Sounds like a job for Perl. 

Here's an example of cleaning up this data before you
send it to the database.  

Really, this is much easier than doing it with PL/SQL or Java.

Jared

--
#!/usr/bin/perl

our %hashData;

while() {

my($key, @data) = split(/\s/);
if (defined($hashData{$key} ) ) {
$hashData{$key} .= ' ' . join(' ',@data);
} else {
$hashData{$key} = join(' ',@data);
}

}

foreach my $key ( sort keys %hashData ) {
print "Key: $key - |$hashData{$key}|\n";
}


__DATA__
100 Memo line 1 information.
100 more information for record 100.
100 extra information again.
200 Memo for 200.
200 more info for 200
300 info for 300
300 next memo
300 and more
300 yet more again.

--

On Thursday 17 May 2001 10:45, Glenn Travis wrote:
> I have a data file that looks like this;
>
> 100Memo line 1 information.
> 100more information for record 100.
> 100extra information again.
> 200Memo for 200.
> 200more info for 200
> 300info for 300
> 300next memo
> 300and more
> 300yet more again.
>
> I want to load to a table (col1, infodesc) to look like this;
>
> col1infodesc
> --
> 100Memo line 1 information. more information for record 100. extra
> information again
> 200extra information again. Memo for 200. more info for 200
> 300info for 300 next memo and more yet more again.
>
> Can this be done with sqlldr or do I need to load the data as is and use
> PL/SQL (and cursor loops) to concatentate the data?
>
> thanks for any help!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Script that will remove redundant rows from table

[Eric D. Pierce]

Mr. Rhet Device
(rhet oracle device, that is)

On 17 May 2001, at 8:21, Alan Aschenbrenner wrote:

> Who was the half person?

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Script that will remove redundant rows from table

[Rachel Carmichael]

Deal! :)


>From: "Eric D. Pierce" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Script that will remove redundant rows from table
>Date: Thu, 17 May 2001 09:31:33 -0800
>
>How about we split the difference?
>
>|  1* select (25.25+27.5)/2 from dual
>|SQL> /
>|
>|(25.25+27.5)/2
>|--
>|26.375
>|
>
>  (no this is not the mean)
>
>
>On 16 May 2001, at 19:36, Rachel Carmichael wrote:
>
> > now now, don't exaggerate it was only 25 & 1/4 people
>...
>
> > >didn't 27 & 1/2 people post the answer to this yesterday???
>
>...
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Eric D. Pierce
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

RE: Forms and Reports Server versions vs. RDBMS versions

[Boivin, Patrice J]

I logged a TAR with Oracle, and their Metalink technician replied that...
all the current versions are certified to work together.

I knew that.

What I want to know is, which versions of OAS , OEM or Developer were
designed on concert with which version of the RDBMS.

E.g. as part of the server technology track, Application Server CDs, tend to
come with an RDBMS CD - iAS 1.0.2 came with 8.1.7. and Jdeveloper 3.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   Boivin, Patrice J [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, May 17, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L
Subject:Forms and Reports Server versions vs. RDBMS versions

We are planning to upgrade our databases to 8.1.6. or 8.1.7, and I
am trying
to figure out which OAS/iAS, Forms / Reports and RDBMS versions go
together
best.

This is my list so far (RDBMS --> Developer/Forms/Reports -->
OWS/OAS/iAS
--> OEM):

Oracle 7.3.3. --> Developer 1.6.1 --> n/a --> n/a
Oracle 7.3.4. --> Developer 2.1 --> OWS 3.0.1.1.  --> OEM 1.3 (?)
Oracle 8.0.4/8.0.5 --> Developer 6 --> OAS 4.0.8.1. --> OEM 1.6
Oracle 8.0.6 --> Forms / Reports 6i patch 2 --> OAS 4.0.8.2. --> OEM
2.0
Oracle 8.1.6. --> Forms / Reports 6i  patch 4 (6.0.8.14) --> iAS
1.0.1.0
--> OEM 2.1
Oracle 8.1.7 --> Forms / Reports 6i patch 5 --> iAS 1.0.2.0  --> OEM
2.2
Oracle 9.0 --> Forms / Reports (?) --> iAS (?) --> OEM (?)

Is this correct?

I wish there was a page on the Oracle web site with a matrix like
this.

TIA
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO
-- 
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Script that will remove redundant rows from table

[Jared Still]

Are you an idiot?

( oh god, I can't believe I said that.  might as well finish it )

ALL YOUR BASE ARE BELONG TO US

;^{)

On Thursday 17 May 2001 11:07, Mohan, Ross wrote:
> HELP
>
> || -Original Message-
> || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
> || Sent: Thursday, May 17, 2001 1:32 PM
> || To: Multiple recipients of list ORACLE-L
> || Subject: Re: Script that will remove redundant rows from table
> ||
> ||
> || How about we split the difference?
> ||
> || |  1* select (25.25+27.5)/2 from dual
> || |SQL> /
> || |
> || |(25.25+27.5)/2
> || |--
> || |26.375
> ||
> ||  (no this is not the mean)
> ||
> || On 16 May 2001, at 19:36, Rachel Carmichael wrote:
> || > now now, don't exaggerate it was only 25 & 1/4 people
> ||
> || ...
> ||
> || > >didn't 27 & 1/2 people post the answer to this yesterday???
> ||
> || ...
> ||
> ||
> || --
> || Please see the official ORACLE-L FAQ: http://www.orafaq.com
> || --
> || Author: Eric D. Pierce
> ||   INET: [EMAIL PROTECTED]
> ||
> || Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> || San Diego, California-- Public Internet access /
> || Mailing Lists
> || 
> || To REMOVE yourself from this mailing list, send an E-Mail message
> || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> || the message BODY, include a line containing: UNSUB ORACLE-L
> || (or the name of mailing list you want to be removed from).  You may
> || also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Truncate listener.log how?

[Seema Singh]

Gurus
I want to truncate listener.log file.I am using oracle 8.1.5 and 8.1.7 on 
solaris 8.Plese suggest.As I understand
go to listener.log file directory
copy listener.log listener.old
tail -10 >listener.log
Thanks in advance.
-seema
_
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).

Moving a database to a different machine

[Steve McClure]

Allright,
We are physically moving our office, and have an OLTP application that needs
to be up and running with minimal downtime.  The current plan is to use the
development computer as the production platform while the Primary computer
is physically moved to the new location.  The development system was the
production system about 6 months ago, so it will not be under too much
strain.

  I have completely duplicated the filesystems of the Primary machine on the
development box.

This is my plan.  Please comment if there is an obviously better way.  Oh
the database is version 7.3.4

1.Put the tablespaces of the production database in backup mode.
2.Copy datafiles across the network to the "development" machine.  Approx 3
GB
3.Take the production tablespaces out of backup mode.
4.Force a log switch.(Habit I guess)
5.wait until the production system is brought down.
6.move the control files and redo logs to the development system
7.move the initSID.ora and configSID.ora files.
8.edit configSID.ora to change the host associated to Listener.
9.fire up svrmgrl, and recover the database.
10.change the tnsnames on the client systems to point to the development
machine.

Of course.  This needs to be tested to some degree first.  And we(well
management at least) don't want to bring the production machine down to roll
the databases forward together just for a test.  I can use make a backup
control file for use during recovery, and move the curently offline redo
logs.  I am not sure what to do about the most current redo log in this
case.  I have played with backup and recovery, but not this scenario.  I
don't currently have my copy of the Velpuri backup and recovery handbook at
hand(Loaned it to a colleague).  So I am bouncing this off of you folks
while I ponder this until I retrieve my backup and recovery bible.

Any Comments are appreciated.

Thanks,
Steve McClure




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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Script that will remove redundant rows from table

[Hillman, Alex]

Are you an idiot? :-)

Alex Hillman

-Original Message-
Sent: Thursday, May 17, 2001 2:07 PM
To: Multiple recipients of list ORACLE-L


HELP









|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 17, 2001 1:32 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: Script that will remove redundant rows from table
|| 
|| 
|| How about we split the difference?
|| 
|| |  1* select (25.25+27.5)/2 from dual
|| |SQL> /
|| |
|| |(25.25+27.5)/2
|| |--
|| |26.375
|| |
|| 
||  (no this is not the mean)
|| 
|| 
|| On 16 May 2001, at 19:36, Rachel Carmichael wrote:
|| 
|| > now now, don't exaggerate it was only 25 & 1/4 people
|| ...
|| 
|| > >didn't 27 & 1/2 people post the answer to this yesterday???
|| 
|| ...
|| 
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Eric D. Pierce
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from).  You may
|| also send the HELP command for other information (like subscribing).
|| 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: index FS vs index FFS - what's the difference ?

[Riyaj_Shamsudeen]

Hi Ed
        I think, For full index scan, oracle server process reads the root block and branch blocks 1 block at a time. It reads the leaf blocks at a db file multiblock -read count blocks per read call.  For the fast full scan, it reads all the block from the segment header to high water mark at a db_file_multiblock_read count blocks per read call. So, root blocks and branch blocks are read 1 block at a time, hence the db file sequential read. Where as for the fast full index scan you will see sequential read events only for the root block. Also, for the full index scan apparently knows about the extent boundary and if the next group of blocks to be read (in the current extent) is less than the db file multiblock read count , then it tries to read until the end of the current extent. That's why 11 blocks instead of 8 blocks.
        For the 'db file parallel read' the segment read are file 1 block 11, which is a system rollback segment extent. If you dump the block, you could see the redo for index leaf operations. I guess, this is due to delayed instance recovery. 
        All these, I found from dumping blocks and doing research myself. 

Steve,
        Can you please clarify ?

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






"Shevtsov, Eduard" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/17/01 03:40 AM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        index FS vs index FFS - what's the difference ?


Hi List,

I've made two corresponding dumps and ... I must admit I have much less
understanding than I had before.
Please look at them.

=
PARSING IN CURSOR #1 len=68 dep=0 uid=32 oct=3 lid=32 tim=219058914
hv=168660475 ad='aa69f79c'
select /*+ INDEX(documents pk_documents) */ count(*)
from documents
END OF STMT
PARSE #1:c=12,e=29,p=27,cr=322,cu=6,mis=1,r=0,dep=0,og=4,tim=219058914
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=219058914
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #1: nam='file open' ela= 0 p1=0 p2=0 p3=0
WAIT #1: nam='db file sequential read' ela= 1 p1=22 p2=108810 p3=1
WAIT #1: nam='db file sequential read' ela= 1 p1=22 p2=109485 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=22 p2=108811 p3=1
WAIT #1: nam='db file scattered read' ela= 1 p1=22 p2=108812 p3=11
[skip]

WAIT #1: nam='db file parallel read' ela= 1 p1=1 p2=11 p3=11
WAIT #1: nam='db file parallel read' ela= 0 p1=1 p2=11 p3=11

[skip]

WAIT #1: nam='db file scattered read' ela= 0 p1=22 p2=109472 p3=11
WAIT #1: nam='db file sequential read' ela= 0 p1=22 p2=109483 p3=1
WAIT #1: nam='db file sequential read' ela= 0 p1=22 p2=109486 p3=1
WAIT #1: nam='db file parallel read' ela= 0 p1=1 p2=11 p3=11

=
PARSING IN CURSOR #1 len=72 dep=0 uid=32 oct=3 lid=32 tim=219108177
hv=3669603672 ad='aa6a4f84'
select /*+ INDEX_FFS(documents pk_documents) */
count(*)
from documents
END OF STMT
PARSE #1:c=11,e=13,p=27,cr=322,cu=6,mis=1,r=0,dep=0,og=4,tim=219108177
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=219108177
WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #1: nam='file open' ela= 0 p1=0 p2=0 p3=0
WAIT #1: nam='db file sequential read' ela= 1 p1=22 p2=108809 p3=1
WAIT #1: nam='db file scattered read' ela= 2 p1=22 p2=108810 p3=8
WAIT #1: nam='db file scattered read' ela= 0 p1=22 p2=108818 p3=8
[skip, all next lines are the same]

My questions are

1. Why I get 'db file scattered read' waits for index full scan ?
2. Why p3 for this event is 11 even though my db_file_multiblock_read_count
= 8 ?
3. What does mean 'db file parallel read' event? 

Anjo Kolk's paper doesn't describe it (guess the wait is Oracle8-specific).
Oracle 8i Reference says:

 This happens during recovery. Database blocks that need to be
changed as 
part of recovery are read in parallel from the database.

But it seems not my case.

4. Finally, what is the difference between the two index paths in that case
?

I'm on 8.1.7.0 Solaris, file-based system, LMT


Thanks in advance,
Ed
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shevtsov, Eduard
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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[2]: How to make DBA cannot 'see' User's Tables?

[dgoulet]

Yes you can encrypt the data, or you could invest in Trusted Oracle.  But the
question really becomes one of what are you trying to do.  If the problem is
that you question the integrity of the DBA that becomes a management problem. 
On the other hand, if you don't question his/her integrity then what's the
problem?  Most DBA's that I know of, myself included, don't have the time and/or
inclination to browse through application data no matter how sensitive it may
be.  And on top of all that, the data in your database is not your personal
property, but the property of your employer and the DBA is one of his employees.
 He/she just happens to have GOD privileges and is intrusted with the security
and integrity of all of the data.  That's why he/she has those privileges.

Dick Goulet

Reply Separator
Author: Paul Drake <[EMAIL PROTECTED]>
Date:   5/16/2001 9:55 PM

"A. Bardeen" wrote:
> 
> You can encrypt using only a 56-bit key (the key
> length limitation is a requirement of US regulations
> governing the export of cryptographic products).
> 
> HTH,
> 
> -- Anita

Hi Anita.


Ahmadsyah,

I believe that you also have to pad the string to a length that is a
multiple of 8 characters.
Your key string was 10 characters.

here's the obligatory link to the fine manual: (that includes a code
example)
http://technet.oracle.com/doc/oracle8i_816/server.816/a76936/dbms_obf.htm#6518

Paul


> 
> --- Ahmadsyah Algozhi Nugroho <[EMAIL PROTECTED]>
> wrote:
> > I'm using Oracle 8.1.7.
> > there was an error
> > ERROR at line 1:
> > ORA-28232: invalid input length for obfuscation
> > toolkit
> > ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT_FFI",
> > line 0
> > ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT", line
> > 33
> > ORA-06512: at "SCOTT.IAO_PROTECT", line 15
> > ORA-06512: at line 1
> >
> > I check thath my key and my input string is
> > varchar12(10).
> > Key = 0123456789
> > input string = 'testtestte'
> >
> > dbms_obfuscation_toolkit.desencrypt (
> >   input_string => 'testtestte'
> >   , key_string => '1234567890'
> >   , encrypted_string => vEncrypted
> >   );
> > Am I forget something?
> >
> > TIA,
> >
> >
> > Ahmadsyah Alghozi Nugroho
> > Database Engineering Specialist
> > PT Infoglobal AutOptima
> > Jl. Baruk Tengah I/49
> > Surabaya - Jawa Timur
> > phone : +62 (31) 8708456 ext.113
> > > From: Srinagesh Battula
> > [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, May 17, 2001 7:26 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: How to make DBA cannot 'see' User's
> > Tables?
> > >
> > >
> > >
> > > You can encrypt & Decrypt data using the
> > > DBMS_OBFUSCATION_TOOLKIT package
> > > (comes with 8.1.6)
> > >
> > > Srinagesh "What do I know any way" Battula
> > >
> > > > -Original Message-
> > > > From: Khedr, Waleed
> > [mailto:[EMAIL PROTECTED]]
> > > > Sent: Wednesday, May 16, 2001 4:21 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > > Subject: RE: How to make DBA cannot 'see' User's
> > Tables?
> > > >
> > > >
> > > > Data Encryption?
> > > >
> > > > -Original Message-
> > > > Sent: Wednesday, May 16, 2001 7:01 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > >
> > > > Dear gurus,
> > > > How to make DBA cannot 'see' user's datas?
> > > > I build an application which very important and
> > top secret
> > > > even DBA cannot
> > > > 'see' this data. But DBA can backup this
> > data.What is the
> > > > solution for this
> > > > problem?
> > > >
> > > > TIA,
> > > >
> > > >
> > > > Ahmadsyah Alghozi Nugroho
> > > > Database Engineering Specialist
> > > > PT Infoglobal AutOptima
> > > > Jl. Baruk Tengah I/49
> > > > Surabaya - Jawa Timur
> > > > phone : +62 (31) 8708456 ext.113
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > > --
> > > > Author: Khedr, Waleed
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051
> > FAX: (858) 538-5051
> > > > San Diego, California-- Public Internet
> > access /
> > > Mailing Lists
> > > >
> >
> 
> > > > To REMOVE yourself from this mailing list, send
> > an E-Mail message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > > > the message BODY, include a line containing:
> > UNSUB ORACLE-L
> > > > (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: Srinagesh Battula
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051
> > FAX: (858) 538-5051
> > > San Diego, California-- Public Internet
> > access / Mailing Lists
> > >
> >
> ---

RE: enqueue waits -- CI (still remains)

[Diego Cutrone]

Thanks for the TX information Jeffery.
But my question about CI enqueue still remains.


Here's the query to get enqueue waits statistics, it's from Steve Adams'
site.

select
  q.ksqsttyp type,
  q.ksqstget gets,
  q.ksqstwat waits
from
  sys.x_$ksqst  q
where
  q.ksqstget > 0
/

thanks again



- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 5:55 AM


> Hi Diego,
>
>  If lock type is 'TX',  rollback segment number = trunc(p2/65536)
>  and slot number = p2 - 65536*trunc(p2/65536).
>
>  May I know which table you are looking at to get the following
> detailed info about enqueue waits?
>
>  Enqueue Stats
> --
> TY  GETS WAITS
> -- - -
> CF68 0
> CI 1117884
> CU 1797012
> DL   109 0
> DR   102 0
> DX  6219 0
> IS72 0
> MR   140 0
> RT 1 0
> SQ  2472 5
> SS 1 0
> ST  320734
> TM278918 5
> TS  4655 0
> TX21005757
> UL  3500 0
> US 30496 0
> WL10 0
>
> 18 rows selected.
>
>  Thanks
>
>  Jeffery
>
>
>
> Diego Cutrone wrote:
>
> > Thanks for answering Unal, John.
> >
> > John, you were right about the query. I've corrected it. And I'm not
getting
> > "T[" and "CK" anymore,now I get TX and CI.
> > I've also done further investigation and I also know now what p2 and p3
> > mean.
> >
> > This is the updated data: (from the dumps)
> > 
> > count TYPE  MODE
> >  13  CI  6  p2=0 p3=5 ela=0
> >   19 TX 6 p2=262223 p3=53352 ela=301
> >   75 TX 4 p2=524391 p3=50022 ela=301
> >   75 TX 6 p2=720923 p3=5194 ela=301
> >  104TX 6 p2=196736 p3=52393 ela=301
> >  305TX 6 p2=393276 p3=50281 ela=301
> > 
> >
> > Now, how can I get the rollback segment number involved in the TX ? (I
know
> > its from p2 and p3, but how?) --just curious. I'll also take John
advise,
> > and I'll try to identify the locking session(s).
> >
> > Now, although CI enqueue waits (cross instance call invocation) are
brief on
> > this sample, Sometimes it's not.
> > So I'm trying to understand what it means. According to p2 and p3 flags,
> > they are indicating "Flush buffers for reuse as new class", that means
that
> > a session needs a buffer (in the shared pool I think) and it has to
flush
> > some others in order to get space. am I correct?.
> > I've also read a metalink document (1020355.102). According to this, one
> > possible cause is that my application is using dbms_pipe extensively (it
may
> > be right, I've seen event "pipe get" very high). The suggested solution
is
> > to increase the shared_pool. I can't access the other documents
mentioned
> > in the paper.
> >
> > Can someone explain to me what means this CI enqueue and how can I
reduce
> > it.
> > TIA
> >
> > - Original Message -
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Sent: Tuesday, May 15, 2001 6:16 PM
> >
> > > Hi Diego,
> > >
> > > Without going into details, an 'enqueue' wait is mostly due to a
> > > user/program initated transaction lock and I see it a lot in Financial
> > > databases (I see you are on 10.7?). I deduce you were looking at
> > > V$SYSTEM_EVENT - If a user locked one row (probably queried a row in
> > Forms,
> > > inadvertly changed one character which issues a 'SELECT for UPDATE,
thus
> > > locking that row) and anotehr user (through a form or a report) needs
to
> > > perform DML on that particular row, then (I believe) you will clock up
> > time
> > > against the 'enqueue' event.
> > >
> > > What I would suggest is that you use the following query to determine
if
> > > someone is locking someone else out:
> > >
> > > select event, count(*) from v$session_wait
> > > group by event
> > >
> > > If you see the 'enqueue' event in this list, some process is probably
> > > waiting on a lock... You can then trace the user/process via Lock
> > detection
> > > scripts (see Metablink) and kill the blocking process. You could also
> > query
> > > from sys.dba_waiters which will present an easier picture in this
case..
> > >
> > > As far as the SQL goes, see below:
> > >
> > >  select
> > > chr(bitand(&&p1,-16777216)/16777215)||chr(bitand(&&p1,16711680)/63365)
> > > "Lock",   <- I believe the value is '65535', rather than 63365)
> > >  to_char(bitand(&&p1,65535)) "Mode"
> > >  from dual
> > >
> > > You can learn a lot from the Oracle 8.1 Reference Manual - Appendix A.
> > > "Oracle Wait Events" and App B "Oracle Enqueue Names". While they are
> > > applicable for 8.1, most of the info is valid for 7.3 as well...
> > >
> > > Please let us know if you need additional inf

Forms and Reports Server versions vs. RDBMS versions

[Boivin, Patrice J]

We are planning to upgrade our databases to 8.1.6. or 8.1.7, and I am trying
to figure out which OAS/iAS, Forms / Reports and RDBMS versions go together
best.

This is my list so far (RDBMS --> Developer/Forms/Reports --> OWS/OAS/iAS
--> OEM):

Oracle 7.3.3. --> Developer 1.6.1 --> n/a --> n/a
Oracle 7.3.4. --> Developer 2.1 --> OWS 3.0.1.1.  --> OEM 1.3 (?)
Oracle 8.0.4/8.0.5 --> Developer 6 --> OAS 4.0.8.1. --> OEM 1.6
Oracle 8.0.6 --> Forms / Reports 6i patch 2 --> OAS 4.0.8.2. --> OEM 2.0
Oracle 8.1.6. --> Forms / Reports 6i  patch 4 (6.0.8.14) --> iAS 1.0.1.0
--> OEM 2.1
Oracle 8.1.7 --> Forms / Reports 6i patch 5 --> iAS 1.0.2.0  --> OEM 2.2
Oracle 9.0 --> Forms / Reports (?) --> iAS (?) --> OEM (?)

Is this correct?

I wish there was a page on the Oracle web site with a matrix like this.

TIA
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Script that will remove redundant rows from table

[Mohan, Ross]

HELP









|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 17, 2001 1:32 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: Script that will remove redundant rows from table
|| 
|| 
|| How about we split the difference?
|| 
|| |  1* select (25.25+27.5)/2 from dual
|| |SQL> /
|| |
|| |(25.25+27.5)/2
|| |--
|| |26.375
|| |
|| 
||  (no this is not the mean)
|| 
|| 
|| On 16 May 2001, at 19:36, Rachel Carmichael wrote:
|| 
|| > now now, don't exaggerate it was only 25 & 1/4 people
|| ...
|| 
|| > >didn't 27 & 1/2 people post the answer to this yesterday???
|| 
|| ...
|| 
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Eric D. Pierce
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from).  You may
|| also send the HELP command for other information (like subscribing).
|| 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Oracle Gateway Product for Progress Database

[Sam Bootsma]

Does anybody know if a gateway exists between the Oracle database and
Progress database?

Thanks.

Sam Bootsma
Technical Support Analyst
CPAS Systems Inc.


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 the cost of replication?

[Eric D. Pierce]

A.,

Just out of curiosity, is your paper pertinent to NT/Win2K? Is the 
replication done strictly within Oracle?  

what about stuff like this?: 
 http://www.nsisw.com/main/pages/products.html


regarding your private question about rifts in space/time continuums, 
the world is probably safe for the time being since there is a 3,000 
mile separation, but here are some ideas that you , Ross and I can 
work on in case we ever get together w/ the Oracle-L group at a 
conference or whatever:  

 http://wc4.com/fartfart/index.html
-
 http://www.headscape.com/windbreak.htm

And of course lest anyone think that there aren't implications to 
these issues that threaten the very existence of our species (or more 
generally the evolutionary process that leads to organisms being 
capable of excercising powers of higher conciousness), please see 
below (no pun intended);  

  http://www.electricearl.com/fart/fartnews.html

---excerpt---

  "...Now, according to the
   August 2, 2000, edition of the Daily Sport in London, 
   Great Britain's Agricultural Ministry is spending 
   267,000 pounds 'to find out what happens when cows fart.'
   According to the newspaper, 'Scientists say a massive 
   25 per cent of all methane gas in the world's
   atmosphere is produced by cows.' One Member of 
   Parliament, Gordon Prentice, said, 'It beggars belief 
   that cows, with their legendary five stomachs, are 
   responsible for doing so much damage.' Stay tuned for 
   more details. ..."

---end---

regards,
ep


On 16 May 2001, at 20:30, A. Bardeen wrote:


> Replication is not for the faint of heart and it would
> behoove you to research this to see if replication is
> really the right way to accomplish your goal.

...

> -- Anita
> 
> P.S. I'm sending you my paper which discusses many of
> the issues you should consider before implementing
> replication.
> 
> --- "Smith, Ron L." <[EMAIL PROTECTED]> wrote:
> > We have a small but critical application running on
> > NT.  The user wants to
> > implement replication.  

...


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How to downgrade database from 8.1.5 to 8.0.6 - Urgent Help Please!

[Roy Ferguson]

Export/Import

this was actually mentioned in chapter 3 in the Oracle8i Migration Release 
(A76957-01)



>Hello: 
>
>Please help me on this crisis! What is the steps and safe procedures to 
downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon 
today.
>
> I have database 8.1.5 with all schemas and data. But the application can not 
support 8.1.5.  I have to install 8.0.6.(new one)   Then I need get all those 
data and schemas into 8.0.6. I know in some way this can be done, Now matter how 
risk I have to do at client's request. 
>
>What is the steps and safe procedures???
>
>Thanks in advance
>
>
>
>-
>Do You Yahoo!?
>Yahoo! Auctions $2 Million Sweepstakes  -  Got something to sell?



Roy E. Ferguson II
Intel Sacramento
916-854-1123

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

sqlldr help

[Glenn Travis]

I have a data file that looks like this;

100Memo line 1 information.
100more information for record 100.
100extra information again.
200Memo for 200.
200more info for 200
300info for 300
300next memo
300and more
300yet more again.

I want to load to a table (col1, infodesc) to look like this;

col1infodesc
--
100Memo line 1 information. more information for record 100. extra
information again
200extra information again. Memo for 200. more info for 200
300info for 300 next memo and more yet more again.

Can this be done with sqlldr or do I need to load the data as is and use
PL/SQL (and cursor loops) to concatentate the data?

thanks for any help!

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: BMC Patrol - 2nd Wave

[Glenn Travis]

You haven't been a DBA too long have you?

... if you manage the db, you are responsible.  period.

at least that's the way it's been everywhere for me, but I could be wrong...

-Original Message-
Sent: Wednesday, May 16, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L


One advantage to never having been consulted on whether it should be done
and having consultants installing it is that it would be hard to blame me
for anything that goes wrong :).

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



My experience is that BMC leaves a big footprint on the systems it monitors.
So unless you have a system with 6+ cpu's the hogs reported are BMC related
or the slow system is caused by BMC.  And the $$ it costs, ouch.

I have seen better results in shops using Big Brother ( http://bb4.com/
 ) or NetSaint ( http://netsaint.sourceforge.net/
 ).

Maybe Patrol works for some people. But my advise is to stay away so that
when the project dies and they try to decide who is to blame for spending
$$ on a POS you will not be within ear shot.

That's just my opinion, I could be wrong.

-Original Message-
 ]
Sent: Wednesday, May 16, 2001 1:03 PM
To: Multiple recipients of list ORACLE-L


So my boss calls me over yesterday and tells me he needs two servers for 2nd

Wave to install BMC on to monitor the databases.
I say, huh?

Apparently the CIO decided to have a consulting company (2nd Wave) install
and configure BMC to monitor all the databases (Oracle and SQL Server) in
the company.
I met with them briefly today (only because I asked to, it hadn't been
deemed necessary before that) and I'll admit it doesn't look too bad so far,

even if we already get all the information they provide (plus more) from
various sql scripts and statspack.

Does anyone have any gotchas, warnings, "send out your resume NOW"
recommendations for working with the BMC Patrol product?
Any experience with 2nd Wave?

Thanks in advance!

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

--
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Miller, Jay
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Glenn Travis
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Script that will remove redundant rows from table

[Eric D. Pierce]

How about we split the difference?

|  1* select (25.25+27.5)/2 from dual
|SQL> /
|
|(25.25+27.5)/2
|--
|26.375
|

 (no this is not the mean)


On 16 May 2001, at 19:36, Rachel Carmichael wrote:

> now now, don't exaggerate it was only 25 & 1/4 people
...

> >didn't 27 & 1/2 people post the answer to this yesterday???

...


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How to downgrade database from 8.1.5 to 8.0.6 - Urgent

[Tim Sawmiller]

Hoo boy...I guess the safest approach is to run the catalog script against the 8.1.6 
database that changes the export views to be 8.0.6 compatible, then do a full export 
and import.  

>>> [EMAIL PROTECTED] 05/17/01 12:15PM >>>

Hello DBAs: 
Please help me on this crisis! What is the steps and safe procedures to downgrade 
database from 8.1.5 to 8.0.6 ??? I need to have this done by noon today.

I have database 8.1.5 with all schemas and data. But the application can not support 
8.1.5. I have to install 8.0.6.(new one) Then I need get all those data and schemas 
into 8.0.6. I know in some way this can be done, Now matter how risk I have to do at 
client's request. 

What is the steps and safe procedures???

Thanks in advance



-
Do You Yahoo!?
Yahoo! Auctions $2 Million Sweepstakes  -  Got something to sell?

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 downgrade database from 8.1.5 to 8.0.6 - Urgent Help P

[Djordje Jankovic]

The 
safest way is to do a full database export, to create a new 8.0.6 database 
instance and to import the data in the new database.  You have to see 
for inter-version specifics - you might need to use 8.1.5 import version to 
import in the 8.0.6 database - you have to check that, but it is for sure 
doable.
 
If at 
all possible, I would not delete the original 8.1.5 database before I am fully 
done with the import and I test that 8.0.6 is working fine.
 
If you 
do not have enough space for 8.1.5 + export file + 8.0.5 (and you are on unix) 
you might use the named pipes for export/import (again make sure that the 
exp/imp versions are OK):
 
 
· 
create a named pipe:
$ mknod p_expimp p
· 
export from the source database to the pipe:
$ exp userid=src_username/password file=p_expimp OtherParameters
· 
at the same time importing from the pipe is started:
$ imp userid=trg_username/password file=p_expimp buffer=1024000 OtherParameters
 
Djordje

  -Original Message-From: Helen rwulfjeq 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 17, 2001 12:16 
  PMTo: Multiple recipients of list ORACLE-LSubject: How 
  to downgrade database from 8.1.5 to 8.0.6 - Urgent Help 
  Please!
  Hello: 
  Please help me on this crisis! What is the steps and safe procedures to 
  downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon 
  today.
   I have database 8.1.5 with all schemas and data. But the application 
  can not support 8.1.5.  I have to install 8.0.6.(new 
  one)   Then I need get all those data and schemas into 8.0.6. 
  I know in some way this can be done, Now matter how risk I 
  have to do at client's request. 
  What is the steps and safe procedures???
  Thanks in advance
  
  
  Do You Yahoo!?Yahoo! 
  Auctions $2 Million Sweepstakes - Got something to 
sell?

Re: unhandled user-defined exception

[Connor McDonald]

The trigger code would probably help...

--- "Venugopal, R (GEP, Contractor)"
<[EMAIL PROTECTED]> wrote: > Hi Gurus  
>  
>I am getting the error attached below when
> trigger fires. what could be
> the reasons 
> for this error. 
>  
> DB error: ORA-06510: PL/SQL: unhandled user-defined
> exception  
>  
>  
> Thanks in Advance 
> Venu 
>  
> 


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

RE: Script that will remove redundant rows from table

[Alan Aschenbrenner]

Who was the half person?


-Original Message-
Sent: Wednesday, May 16, 2001 9:37 PM
To: Multiple recipients of list ORACLE-L


now now, don't exaggerate it was only 25 & 1/4 people




>From: "Eric D. Pierce" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Script that will remove redundant rows from table
>Date: Wed, 16 May 2001 17:45:22 -0800
>
>didn't 27 & 1/2 people post the answer to this yesterday???
>
>On 16 May 2001, at 17:10, Haskins, Ed wrote:
>
> > A few months ago I remember seeing a script that enabled the removal
of
> > redundant rows in a table.
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Eric D. Pierce
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

_
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alan Aschenbrenner
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: ??? strange database link problem

[Smith, Ron L.]

That was it.
 
Thanks!

-Original Message-
Sent: Thursday, May 17, 2001 10:31 AM
To: Multiple recipients of list ORACLE-L


# Global Naming -- enforce that a dblink has same name as the db it connects
to
global_names = true
 
 
Your problem is this.
make it to false or obey the rules.

 

- Original Message - 
To: Multiple   recipients of list ORACLE-L 
Sent: Thursday, May 17, 2001 5:41 PM

Check
NAMES.DEFAULT_DOMAIN in sqlnet.ora
Regards
Ivo Libal
 

-Original Message-
 ]
Sent: Thursday, May 17, 2001 03:55 PM
To: Multiple recipients of list ORACLE-L



Check out the global_name init.ora parameter. 

It is probably set to true, which forces the name of the 
database link to be the same as the alias. 

 
R. Matt Adams  - GE Appliances - [EMAIL PROTECTED] 
  Meddle not in the affairs of troff, 
  for it is subtle and quick to anger. 



> -Original Message- 
> From: Andrea Oracle [ mailto:[EMAIL PROTECTED]
 ] 
> Sent: Wednesday, May 16, 2001 11:30 PM 
> To: Multiple recipients of list ORACLE-L 
> Subject: ??? strange database link problem 
> 
> 
> Hi all, 
> 
> I tried to create a database link like this: 
> 
> create database link test connect icssowner identified 
> by icssowner using 'AU40CNV'; 
> 
> when I used it, I got: 
> ERROR at line 1: 
> ORA-02085: database link TEST.WORLD connects to 
> AU34TD.WORLD 
> 
> I created other links to AU40CNV, but I got that err 
> again, the link ALWAYS goes to AU34TD.WORLD!!! why? 
> 
> Thanks 
> 
> Andrea 
> 
> __ 
> Do You Yahoo!? 
> Yahoo! Auctions - buy the things you want at great prices 
> http://auctions.yahoo.com/   
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
> -- 
> Author: Andrea Oracle 
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
> San Diego, California-- Public Internet access / Mailing Lists 
>  
> To REMOVE yourself from this mailing list, send an E-Mail message 
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> the message BODY, include a line containing: UNSUB ORACLE-L 
> (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: Smith, Ron L.
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 downgrade database from 8.1.5 to 8.0.6 - Urgent

[Kimberly Smith]

The upgrade doco also has the downgrade steps.  Check your documentation.  

-Original Message-
Sent: Thursday, May 17, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L


Hoo boy...I guess the safest approach is to run the catalog script against
the 8.1.6 database that changes the export views to be 8.0.6 compatible,
then do a full export and import.  

>>> [EMAIL PROTECTED] 05/17/01 12:15PM >>>

Hello DBAs: 
Please help me on this crisis! What is the steps and safe procedures to
downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon
today.

I have database 8.1.5 with all schemas and data. But the application can not
support 8.1.5. I have to install 8.0.6.(new one) Then I need get all those
data and schemas into 8.0.6. I know in some way this can be done, Now matter
how risk I have to do at client's request. 

What is the steps and safe procedures???

Thanks in advance



-
Do You Yahoo!?
Yahoo! Auctions $2 Million Sweepstakes  -  Got something to sell?

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

How to downgrade database from 8.1.5 to 8.0.6 - Urgent Help Please!

[Helen rwulfjeq]

Hello DBAs: 
Please help me on this crisis! What is the steps and safe procedures to downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon today.
I have database 8.1.5 with all schemas and data. But the application can not support 8.1.5. I have to install 8.0.6.(new one) Then I need get all those data and schemas into 8.0.6. I know in some way this can be done, Now matter how risk I have to do at client's request. 
What is the steps and safe procedures???
Thanks in advanceDo You Yahoo!?
Yahoo! Auctions $2 Million Sweepstakes  -  Got something to sell?

Would you increase the shared pool? --URGENT

[Pablo ksksksk]

Hello Gurus,

I need help in this performance issue.

Oracle 7.3.4
HPUX 10.20

I 've got this ratios:

BC hit ratio   98 
dictionary cache hit rate 100   
library cache get hit ratio91
library cache pin hit ratio98  

Mayor waits are enqueue (57%), buffer busy waits(34%),
especially p3=0 for some big tables (buffer being read
from disk), and latch free (6%).

I'm dealing with enqueue and bbw, but what would you
do with the low LC ratio and the shared pool in this
case.

Latch free waits details

LATCH TYPEIMPACT SLEEP RATE   LATCH
-  
shared pool  123285  1.05%  27097
library cache58841  0.06%103
cache buffers chains 18108  0.00%  0


This is the library cache stat:

NAMESPACE GETHITRATIO PINHITRATIO RELOADS INVALIDAT
  
SQL AREA .73288057 .97035171 47011 13891
TABLE/PROCEDURE  .99150783 .99813894 11758 0
BODY .9975282  .9971979   32   0
TRIGGER  .99816161 .99591602  61   0
INDEX .03401361   .02267574 5  0
CLUSTER   .   . 0  0
OBJECT1   1 0  0
PIPE  .9414   .9415 0  0


The keep object summary

TYPE OBJECTS  KEPT   RELOADSOWNERS
-- - - - -
TABLE389 0  166112
SYNONYM  348 0  2574 4
PACKAGE  294   293   131 4
PACKAGE BODY 292   29123 4
TRIGGER  220   22052 9
VIEW 170 0   373 3
SEQUENCE 108   108   13111
NON-EXISTENT  68 2   153 8
PROCEDURE 606047 2
FUNCTION  1616 4 1

PARAMETER  VALUE USAGE
-- - -
session_cached_cursors   100   81%  
open_cursors 500   85%  



Shared Pool 

RECURRENT TRANSIENTFLUSHED PINS ANDORA-4031
   CHUNKSCHUNKSCHUNKS  RELEASESERRORS
- - - - - 
 3051  5374655389   5351916 0



Shared pool free lists

   BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZE  
BIGGEST
- -- --- 
-
0  795521707   46   
72
1  45760 516   88   
96
8   9480   1 9480 
9480
9   41165488179722907
32776
   10   48335568109344222
65424
   11   20518744 24284788   
130072
   124383200  26   168584   
246496
   13 807072   2   403536   
447040


TIA

___
Do You Yahoo!?
Yahoo! Messenger: Comunicación instantánea gratis con tu gente -
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).

How to downgrade database from 8.1.5 to 8.0.6 - Urgent Help Please!

[Helen rwulfjeq]

Hello: 
Please help me on this crisis! What is the steps and safe procedures to downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon today.
 I have database 8.1.5 with all schemas and data. But the application can not support 8.1.5.  I have to install 8.0.6.(new one)   Then I need get all those data and schemas into 8.0.6. I know in some way this can be done, Now matter how risk I have to do at client's request. 
What is the steps and safe procedures???
Thanks in advanceDo You Yahoo!?
Yahoo! Auctions $2 Million Sweepstakes  -  Got something to sell?