Sqlplus feedbk

[cosltemp-g . manoj]

Hi,
Is it possible to change the feedback generated by sqlplus.
e.g if a procedure xyz is compiled on sqlplus prompt.it gives message :

 procedure created .

 I want to change this to :

 procedure xyz created.

 
 
Thanks
Manoj.
   

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

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

RE: Performance tuning

[Cary Millsap]

Trace the slower procedure. Hit the 10046 paper on www.hotsos.com to see
how.

This sounds like maybe 'buffer busy wait' waits on the index are causing
contention among the procedures. But you need to prove whether it is
(and which block it is, if my guess is right) before you can take the
right corrective action on the first try.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Sent: Wednesday, November 06, 2002 10:38 PM
To: Multiple recipients of list ORACLE-L


I have a table in my application . This table gets all inserts during
one procedure and select during other . Now if I make an index on this
then the first procedure gets slow and if i drop the index then the
second procedure gets very slow.
Is there some solution to get out of this problem

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

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

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

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

RE: Performance tuning

[Vikas Khanna]

This is where the balancing comes into picture. If it is a bulk Insert then
definitely the performance would degrade to the extent that it has to create
an entry in the Index at a particular place. If there are so many indexes on
this table you should visualise them in such a manner that a concatenated
index could be formed to take care of all your selects on this table. 

The other alternative is to go in for partitioning and do the data
partioning by range to that the selective data is getting indexed by the
local index and not the global index on the table is getting effected.

However if the inserts are huge than the Selects than dropping the index is
beneficial, but if the Selects are too much that the index is beneficial. It
relayy depends on the nature of the application. If the rows you want to
retrieve from the table are in the range of 5% - 10% then index is
beneficial else it could be better for the CBO to go in for a Full table
scan.

Moreover if it's a buldk insert you can disable the index at that point of
time and then rebuild it online after the insert is over for that data to be
used in Selects but if the inserts are happening in an OLTP application then
you are the best judge,

Vikas Khanna 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, November 07, 2002 10:08 AM
To: Multiple recipients of list ORACLE-L



I have a table in my application . This table gets all inserts during
one procedure and select during other . Now if I make an index on this
then the first procedure gets slow and if i drop the index then the
second procedure gets very slow.
Is there some solution to get out of this problem

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

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

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

Re: Performance tuning

[Mark Richard]

Perhaps you should consider disabling / dropping the index during the first
procedure and then recreating it.  You can use commands like 'execute
immediate' within a procedure to issue DDL.

Otherwise perhaps you can change the inserts to some kind of bulk insert -
depending on how your application behaves.

If it's any compensation I've seen many situations where the application
does things like creating temporary indexes, analyzing tables, etc during a
procedure to get performance right.  A classic example was one procedure
which truncated a table, inserted a pile of rows and then did some complex
queries - we had to analyze the table after the inserts and before the
selects so that the optimiser could use the correct indexes, etc - made a
huge difference.

Regards,
 Mark.



   
  
dilmohan   
  
   
tcs.co.in> cc: 
  
Sent by:   Subject: Performance tuning 
  
[EMAIL PROTECTED]   
  
   
  
   
  
07/11/2002 15:38   
  
Please respond 
  
to ORACLE-L
  
   
  
   
  





I have a table in my application . This table gets all inserts during
one procedure and select during other . Now if I make an index on this
then the first procedure gets slow and if i drop the index then the
second procedure gets very slow.
Is there some solution to get out of this problem

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

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



<<>>
   Privileged/Confidential information may be contained in this message.
  If you are not the addressee indicated in this message
   (or responsible for delivery of the message to such person),
you may not copy or deliver this message to anyone.
In such case, you should destroy this message and kindly notify the sender
   by reply e-mail or by telephone on (61 3) 9612-6999.
   Please advise immediately if you or your employer does not consent to
Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this message
  that do not relate to the official business of
 Transurban City Link Ltd
 shall be understood as neither given nor endorsed by it.
<<<>

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

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

Performance tuning

[dilmohan]

I have a table in my application . This table gets all inserts during
one procedure and select during other . Now if I make an index on this
then the first procedure gets slow and if i drop the index then the
second procedure gets very slow.
Is there some solution to get out of this problem

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

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

RE: Oracle to Excel

[Johnson, Michael]

Title: Oracle to Excel



there 
is an ODBC driver you can set up to handle this as I recall.
 
hth.
 
mike

  -Original Message-From: Burton, Laura L. 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002 
  10:49 AMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle to Excel
  I think I have seen traffic concerning 
  the extracting of data from Oracle into an Excel spreadsheet.  We now 
  have a need for this.  Could anyone enlighten me?
  Thank you in advance.
  Laura 

RE: Data Purging Strategy

[paquette stephane]

Burnt mud ???
You're supposed to say peaty !
Or you could have said :
Classic Glenmorangie, matured for 10 years in American
white oak then finished in Sherry Butts. Light gold in
colour, this product has a complex aroma — full
bodied, sherry wine notes with traces of honey. Sherry
and nuts are both apparent in the flavour and these
produce a warm, long lasting after taste.

 --- Steve McClure <[EMAIL PROTECTED]> a écrit : >
Sherry Finish?  I thought you liked scotch that
> tasted like burnt mud?
> 
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Wednesday, November 06, 2002 10:55 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> That reminds me:
> 
> Mark, your annual stipend is due.
> 
> Make it a case of Glenmorangie this time, Sherry
> finish.  :)
> 
> Jared
> 
> 
> 
> 
> 
> 
> [EMAIL PROTECTED]
> Sent by: [EMAIL PROTECTED]
>  11/06/2002 07:56 AM
>  Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:RE: Data Purging Strategy
> 
> 
> Hey Dennis,
> Mark Leith is the only person on this list allowed
> to mention 3rd party
> products.
> I am sure he bought the franchise from Jared :)
> 
> John
> 
> -Original Message-
> Sent: 06 November 2002 14:15
> To: Multiple recipients of list ORACLE-L
> 
> 
> Prem - You are receiving some excellent advice from
> Tom and Tim. I would
> mention two items in addition:
>   - If you ever hope to re-use the data you archive
> off-line, you must 
> also
> archive all the related tables, because after all,
> this is a RELATIONAL
> database.
>   - PrincetonSoftech has a product Active Archiving
> that looks pretty good
> from the demos I've seen. I haven't used it myself.
> 
> 
> 
> Dennis Williams 
> DBA, 40%OCP 
> Lifetouch, Inc. 
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Wednesday, November 06, 2002 6:54 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Prem,
>  
> I would re-visit the requirement.  Why do you feel
> the need to delete the
> data from the database?  What is the purpose for
> this type of requirement?
> It would be far easier to modify the requirement
> than to do what you are
> thinking of doing.
>  
> Adding columns to database tables indicating that a
> record has passed it's
> retention policy and thus, is not included in
> queries, would be a much
> easier solution.
>  
> Or, simply moving these records to historical tables
> in the database - and
> NOT deleting them from the system - is a much better
> solution.  The data 
> is
> always accessible and not available in the current
> tables.  And you will 
> not
> be playing the "get the data from tape and reload
> it" game with all of 
> it's
> problems (writing an offload program, table
> structure changes & offload
> program versions).
>  
> Try and keep this as simple as possible.
>  
> Hope this helps
>  
> Tom Mercadante 
> Oracle Certified Professional 
> 
> -Original Message-
> Sent: Wednesday, November 06, 2002 4:13 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Dear List, 
> 
> I need some inputs from you all regarding purging
> data from the database. 
> 
> This is the requirement 
> 
> 
> We define a retention period for all the data in the
> system. 
> When the retention period is reached,  the data
> should be deleted, but 
> then
> at a later time, some user might request for this
> purged data. So it must 
> be
> possible to retrieve this data. 
> 
> This is the strategy we have designed for this. 
> 
> When the retention period is reached, move the data
> from the main database
> to an offline database. Then delete the data from
> the main database. 
> 
> In the offline database, we cannot again keep it
> from long, so it has to
> moved to tapes. Now my question, how can we move
> this data to tapes and at
> the same time retrieve data from the tapes based on
> dates. 
> i.e, the user will ask for the data on a particular
> date, so it must be
> possible to retrieve data from the tapes based on a
> date and load it to 
> the
> database tables. 
> 
> Regards 
> Prem 
> 
>  
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> ht

RE: Shared_pool

[Weaver, Walt]

Same way I figure out how full my septic tank is. Take the top off.

--Walt Weaver
  Bozeman, Montana

On Wed, Nov 06, 2002 at 04:34:28PM -0800, Jos Someone wrote:
> 
> List,
> 
> How do I find out how full my shared_pool is?
-- 

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

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

Help: ORA-980 raised if a PLSQL block references a remote public synonym

[Borrill, Chris]

Title: Help: ORA-980 raised if a PLSQL block references a remote public synonym






Hi,


Oracle Version 9014 for Tru64


We are encountering the above problem which appears to be an instance of Bug 1698784 which Oracle claims was fix in 9013.  It does not occur for private synonyms.  Can anyone offer a solution to this problem?

Thankyou,

Chris

RE: RE: Oracle DBA with SAP Needed

[Weaver, Walt]

I can't believe you people are talking about Toledo residents like this.
It's disgusting.

--Walt (Go Mudhens!) Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, November 06, 2002 5:08 PM
To: Multiple recipients of list ORACLE-L


I think the official term is "optimizing within the law."


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on Oracle® System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Lange
Sent: Wednesday, November 06, 2002 3:40 PM
To: Multiple recipients of list ORACLE-L

In other words  smart buisness sense  

-Original Message-
Sent: Wednesday, November 06, 2002 3:29 PM
To: Multiple recipients of list ORACLE-L


Yeah, but is smacks of being unethical and un-American.

Dick Goulet

Reply Separator
Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
Date:   11/6/2002 1:08 PM

Cary - I think you have a good insight. I've encountered that before.
Often
that is the reason for some strange employment advertisements in
national
magazines. As you say, posting on ORACLE-L may meet the requirement, is
free, and is fast (no need to wait months for the publication date).

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, November 06, 2002 2:39 PM
To: Multiple recipients of list ORACLE-L


An administrative requirement causes a lot of these types of postings
with odd-looking salary ranges. Chances are that the company already has
a foreign national candidate in the hiring pipeline for the job at this
salary. INS requires that US citizens be given a fair shot at the job
posting. One of the requirements is to advertise the position publicly.
Oracle-L is a public forum.

What usually happens is that either nobody applies for the position (the
salary's too low, so everybody pokes fun at it). Sometimes, somebody
does apply. But it's very unlikely that at this price, it'll be anyone
qualified.

Having seen this process to fruition and beyond, what often happens is
that the person immigrates to the US, works hard, and makes good. The
company benefits from good labor at a bargain price for at least a year
or two. The applicant benefits in several ways. He or she gets
physically to the USA, making well more than enough money than it takes
for most people to live on. If the person becomes indispensable, the
host company sponsors a green card application. From there, because the
person is free to compete in the USA job market, he or she begins making
the kind of money you'd expect.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Sent: Wednesday, November 06, 2002 12:24 PM
To: Multiple recipients of list ORACLE-L

Well with the ridiculous salary they are offering, they could at least
train you in the use of SAP.  This is a Fortune 500 company after all.

-- 

Alan Davey
[EMAIL PROTECTED]
212-604-0200  x106


On 11/6/2002 10:56 AM, Paulo Gomes <[EMAIL PROTECTED]> wrote:
>unfortunatly i don't work with SAP or i would be interessed
>regards
>Paulo
>
>-Original Message-
>Sent: quarta-feira, 6 de Novembro de 2002 14:49
>To: Multiple recipients of list ORACLE-L
>
>
>If you are an Oracle DBA With SAP experience looking for a stable 
>company 
>where you can work within a great team environment, this company 
>in Toledo,
>Ohio 
>is the place for you. This Fortune 500 employer has experienced steady
>growth over
>the hundred years it has been in business and is looking for a top 
>notch
>candidate.
>This company is located in a very reasonable cost of living area 
>and offers
>a varied choice 
>of neighborhood communities.
>If you are looking for a place to grow within your career in a smaller 
>city
>atmosphere 
>this is the opportunity to check out. 
>
>Relocation Assistance is provided.
>
>PLEASE DO NOT send your resume for this position UNLESS you have 
>the skills 
>outlined below for this position.
>
>DO NOT send your resume unless you have a stable work history.
>Candidates whose work history includes frequent job changes connot 
>be
>considered.
>If you are employed by a consulting company you must have a long 
>term
>project history.
>
>This is a full time staff position so no sub-contractors or third 
>parties
>please.
>
>NO H-1B candidates please.
>
>*Requirements:
>-MUST be a team player.
>-3+ years Oracle DBA experience.
>-SAP experience
>-Must have experience with:Installation, Backup and recovery,
>Implementation, Conversion, 
> Performance tuning, Troubleshooting, Development, Database Design,
>Monitoring, and Support.
>-MUST have excellent communications skills
>-Major plusses are: SQL Backtrack, D

Re: Shared_pool

[Ray Stell]

On Wed, Nov 06, 2002 at 04:34:28PM -0800, Jos Someone wrote:
> 
> List,
> 
> How do I find out how full my shared_pool is?
-- 

 Diagnosing and Resolving Error ORA-04031 
 Type: Note Doc ID: 146599.1 

 Understanding and Tuning the Shared Pool in Oracle7, Oracle8, and Oracle8i 
 Type: Note Doc ID: 62143.1 


good reading!
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

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

Shared_pool

[Jos Someone]

List,
How do I find out how full my shared_pool is?
Jos
Yahoo! Careers
- 1,000's of jobs waiting online for you!

Re: Oracle to Excel

[Mark Richard]

Laura,

I have seen custom developed XLA's (Excel Add-Ins) for doing this, however
I have also seen a couple of commercial ones.

Check out www.oraxcel.com and their product SQL*XL - it provides what looks
like nice functionality although I only looked at the demo and never
purchased the commercial product.  For end users who know how to query a
database though it probably provides a nice interface.

Regards,
 Mark.



   

"Burton, Laura 

L."  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
Subject: Oracle to Excel  

Sent by:   

[EMAIL PROTECTED] 

om 

   

   

07/11/2002 

05:48  

Please respond 

to ORACLE-L

   

   





I think I have seen traffic concerning the extracting of data from Oracle
into an Excel spreadsheet.  We now have a need for this.  Could anyone
enlighten me?


Thank you in advance.


Laura






<<>>
   Privileged/Confidential information may be contained in this message.
  If you are not the addressee indicated in this message
   (or responsible for delivery of the message to such person),
you may not copy or deliver this message to anyone.
In such case, you should destroy this message and kindly notify the sender
   by reply e-mail or by telephone on (61 3) 9612-6999.
   Please advise immediately if you or your employer does not consent to
Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this message
  that do not relate to the official business of
 Transurban City Link Ltd
 shall be understood as neither given nor endorsed by it.
<<<>

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

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

Re: blast from the past

[Jared . Still]

Oui, ce qui circule, vient autour.

Probable imperfect translation courtesy oif babelfish.

Jared





Stephane Faroult <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/06/2002 03:33 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: blast from the past


[EMAIL PROTECTED] wrote:
> 
> Things seem a little slow on the list ( like I need more email :)
> 
> Some choice bits from Dr Dobbs Journal, November 1988.
> 
> Some you may actually have been working in IT then.  ;)
> 
> Jared

Plus ça change plus c'est la même chose.

-- 
Regards,

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

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



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

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

Re: suggestion w/c platforms to choose from...

[grace]

this will be build in-house...

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 11:56 PM


> Grace - Amen to Yechiel's first rule. At the VERY least, warn your
> management that they need to consider a second system for the datamart.
This
> way, if it works terribly, you don't look dumb.
>My experience is mainly Unix, so 200 OLTP users on an NT box sounds
iffy
> from a throughput point of view. I would tend to go with a small 4-CPU
> Solaris server, especially if this is a critical application. From what
I've
> heard, and I will defer to list members that have more experience here,
200
> ERP users are near the upper limit of Windows-based systems, and if you
> ended up undersizing the system or you add users faster than expected, you
> might run out of headroom. A lot would depend on what your site's
experience
> base is. If you are used to maintaining high-availability NT systems, then
> that might work well for you.
>If you care to mention which ERP system you will be using for the order
> taking, PO, HR, GL, etc., you may garner advice specific to that system.
> Many of us support ERP systems of different stripes and it is possible
that
> different ERP systems behave better on some platforms.
>
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Wednesday, November 06, 2002 6:49 AM
> To: Multiple recipients of list ORACLE-L
>
>
> First rule: Do not mix OLTP and datamart.
> Datamart access is very heavy and complex SQL's that will impact your OLTP
> system.
>
> I think that an NT with 2-4 CPUs and a lot of memory will do (a not so
> educated guess).
> Controller with a lot of cache memory and fast disks (15,000 rpm).
>
> Yechiel Adar
> Mehish
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Wednesday, November 06, 2002 3:48 AM
>
>
> > database will be used for oltp and  data mart
> > # of users -- 200
> > very critical, since order taking , purchase order and accounting
> module,hr
> > will run on it..
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Tuesday, November 05, 2002 9:03 PM
> >
> >
> > > As a rule buy the biggest, meanest, fault tolerance, with gigabytes of
> > > memory and terabytes of disk storage that you can buy.
> > >
> > > If you will provide more data about:
> > >
> > > 1) The size of the database
> > > 2) How many users
> > > 3) How critical is the system
> > > 4) The use of the system - data warehouse, OLTP etc
> > >
> > > then you will probably get a more specified answer.
> > >
> > > Yechiel Adar
> > > Mehish
> > > - Original Message -
> > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > > Sent: Tuesday, November 05, 2002 2:13 PM
> > >
> > >
> > > > hi,
> > > >  can anyone suggestion w/c platform should i used to run oracle? wat
> are
> > > the
> > > > things to consider in choosing platform?
> > > >
> > > > thanks
> > > >
> > > > Best regards,
> > > > Grace Lim
> > > > MIS Department
> > > > Suy Sing Comm'l Corp.
> > > > T- (632)-2474134
> > > > F- (632)-2474160
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: grace
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > > San Diego, California-- Mailing list and web hosting
services
> > >
> -
> > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed from).  You may
> > > > also send the HELP command for other information (like subscribing).
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Yechiel Adar
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting services
> > > -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: grace
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosti

Re: blast from the past

[Paul Baumgartel]

I had mostly forgotten about the bus architecture wars.  The S-100 bus
was another one that was very popular for a time.  Every bus
architecture had its manufacturing proponents, development systems,
development environments.  That was when computer magazines like BYTE
were at their fattest--there was just so much to cover.  

In about 1984 I convinced an employer to purchase a Modula-2 compiler
for the PDP-11 running RSX-11M+.  The vendor was Brown Boveri and Co.
(now part of ABB) in Switzerland.  I remember how excited I was that
the package had cleared Customs, and a few days later, I had the large
reel-to-reel tapes in my hand.  As I recall, the project never got off
the ground, to my chagrin.  Imagine allowing a single developer to
choose a language that way now!

Paul Baumgartel

--- [EMAIL PROTECTED] wrote:
> Things seem a little slow on the list ( like I need more email :)
> 
> Some choice bits from Dr Dobbs Journal, November 1988.
> 
> Some you may actually have been working in IT then.  ;)
> 
> Jared
> 
> -
> 
> If a single word sums up the current state of computing, that word is
> 
> confusion. It's hard to remember a time when the PC industry
> was in a more confounding state of affairs. Now, more than ever,
> there is 
> a bewildering array of choices in everything from
> operating systems to hardware architectures. And the choices aren't 
> getting any easier.
> 
> Take a look at operating systems, for example. It was only a few
> years ago 
> that developers had a scarcity of options. There was
> CP/M, AppleDOS, and a few other systems available--TRS-DOS (boy,
> there's a 
> stab from the past) was one I worked
> with--but for the most part, choices were few and the stakes
> relatively 
> low.
> 
> Today, developers must decide between DOS, OS/2, Unix (pick your
> favorite 
> flavor), the Macintosh, and a host of other more
> specialized alternatives. If you pick the wrong development platform,
> the 
> results may not be a pretty sight.
> 
> In the same sense, the Macintosh was basically the only dominant
> windowing 
> system three or four years ago. Today, there's at
> least a dozen, including Windows/Presentation Manager, the Macintosh,
> 
> X-Windows, Rooms, GEM, and New Wave, to
> mention a few.
> 
> Now, throw in a wildcard, like Display Postscript (Steve Jobs'
> choice), 
> and take into consideration the rumor that former
> operating system rivals Digital Research and Microsoft are
> considering 
> offering DRI's GEM application-development tool kit as a
> development tool for Presentation Manager. Now you're faced with a 
> perplexing array of opportunities or quagmires, depending
> on your perspective.
> 
> And things are just as confusing on the hardware side. We've somehow
> moved 
> from a couple of accepted architectures (the AT
> bus and a closed-system Mac) to a plethora of standards that include
> the 
> Micro Channel Architecture (MCA), the NuBus, and,
> more recently, the Extended Industry Standard Architecture (EISA).
> (EISA 
> is a 32-bit extension of the AT bus that has been
> endorsed by several PC manufacturers--IBM not among them--that
> supposedly 
> provides the performance benefits of the MCA,
> yet is compatible with existing AT-bus cards.) Not to mention, last 
> month's introduction of Steve Jobs' NeXT workstation and the
> whisperings about an 80386 machine waiting in the wings at Apple. I'm
> 
> getting an ulcer just writing about it.
> 
> Now consider the various incarnations and implementations of
> programming 
> languages. Should you go with C or begin thinking
> about C++? What about Modula-2? There are some powerful new Modula 
> compilers out there that deserve consideration, and
> the renewed promise of Basic (hearken back to Bill Gates' remarks
> about 
> Object-Basic) as a serious development platform.
> 
> Anecdotically, a developer I know wrote a complicated Windows
> application 
> in Pascal. He wound up rewriting the entire project
> after he figured out that Modula-2 would enable him to better
> accomplish 
> what he was trying to do.
> 
> Regardless of what the soothsayers predicted a couple of years ago, 
> nothing about computing--from either the developer's or the
> end user's perspective--is getting any easier. Now, I'm not
> complaining 
> about more powerful systems, you understand, or about
> the diversity of choices we're faced with today. I'll put it this
> way, 
> it's better to be rich and healthy than sick and poor.
> 
> The point to all of this is that developing for and porting between 
> different environments is no easy matter. Developers must
> choose wisely and well. Some platforms won't be alive and kicking 
> tomorrow. For that matter, neither will developers who've
> made the wrong choice.
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://ww

Re: Data Purging Strategy

[Tim Gorman]

> In response to a post on data purging Tim Gorman wrote "some on SAN-based
> disk, some on NAS-based storage".
>
> Can someone please explain the differences between these technologies
> please.
>
> My understanding that a SAN is a group of disks which are available on a
> network and are not 'owned' by a server and have no direct cables into a
> server.
> I also understood NAS to be network based disk (duh!)

Please correct, clarify, or comment as needed;  I don't recall ever having
seen a formal definition for either acronym:

* SAN (storage area network): storage-arrays connected by dedicated
high-speed interconnects (i.e. SCSI, SSA, FC-AL, etc) managed by a dedicated
server, including switches and routers to provide storage for one or
multiple storage clients (i.e. what we tend to call "servers")...

* NAS (network-attached storage):  storage that is hosted by (i.e.
mounted on) a dedicated, special-purpose server and made available to
network clients via IP protocols like NFS, Samba, etc across general-purpose
IP networks.  For NAS, think "dedicated NFS server" or "dedicated file
server" or the like and you've got the idea...

There are so many technologies mixed into SANs that I find it difficult to
generalize.  It is probably more appropriate to define NAS first and then
say "SANs are everything else" in networked storage, but I thought I'd try
it the hard way...

Further generalizing:

* SANs are capable of faster and more sustainable I/O throughput rates,
but more complex and more expensive
* NAS are economical, easy to administer, and easy to implement, but
provide lower sustained I/O throughput rates

For this reason, I don't see the question as an "either-or" proposition
(i.e. either all SAN or all NAS).  They are each point-solutions along a
continuum, as illustrated in the "strategy" in my previous reply.  Data
passes through a life-cycle, just like anything else.  Requirements for
storage and retrieval can change during that life-cycle...

-

... "continuum" .. there's a high-class word I've been itching to use
. has the potential to become as hoity-toity and annoying as "paradigm"
and "juxtaposition", though...  :-)

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

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

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

RE: RE: Oracle DBA with SAP Needed

[Cary Millsap]

I think the official term is "optimizing within the law."


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on Oracle® System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Lange
Sent: Wednesday, November 06, 2002 3:40 PM
To: Multiple recipients of list ORACLE-L

In other words  smart buisness sense  

-Original Message-
Sent: Wednesday, November 06, 2002 3:29 PM
To: Multiple recipients of list ORACLE-L


Yeah, but is smacks of being unethical and un-American.

Dick Goulet

Reply Separator
Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
Date:   11/6/2002 1:08 PM

Cary - I think you have a good insight. I've encountered that before.
Often
that is the reason for some strange employment advertisements in
national
magazines. As you say, posting on ORACLE-L may meet the requirement, is
free, and is fast (no need to wait months for the publication date).

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, November 06, 2002 2:39 PM
To: Multiple recipients of list ORACLE-L


An administrative requirement causes a lot of these types of postings
with odd-looking salary ranges. Chances are that the company already has
a foreign national candidate in the hiring pipeline for the job at this
salary. INS requires that US citizens be given a fair shot at the job
posting. One of the requirements is to advertise the position publicly.
Oracle-L is a public forum.

What usually happens is that either nobody applies for the position (the
salary's too low, so everybody pokes fun at it). Sometimes, somebody
does apply. But it's very unlikely that at this price, it'll be anyone
qualified.

Having seen this process to fruition and beyond, what often happens is
that the person immigrates to the US, works hard, and makes good. The
company benefits from good labor at a bargain price for at least a year
or two. The applicant benefits in several ways. He or she gets
physically to the USA, making well more than enough money than it takes
for most people to live on. If the person becomes indispensable, the
host company sponsors a green card application. From there, because the
person is free to compete in the USA job market, he or she begins making
the kind of money you'd expect.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Sent: Wednesday, November 06, 2002 12:24 PM
To: Multiple recipients of list ORACLE-L

Well with the ridiculous salary they are offering, they could at least
train you in the use of SAP.  This is a Fortune 500 company after all.

-- 

Alan Davey
[EMAIL PROTECTED]
212-604-0200  x106


On 11/6/2002 10:56 AM, Paulo Gomes <[EMAIL PROTECTED]> wrote:
>unfortunatly i don't work with SAP or i would be interessed
>regards
>Paulo
>
>-Original Message-
>Sent: quarta-feira, 6 de Novembro de 2002 14:49
>To: Multiple recipients of list ORACLE-L
>
>
>If you are an Oracle DBA With SAP experience looking for a stable 
>company 
>where you can work within a great team environment, this company 
>in Toledo,
>Ohio 
>is the place for you. This Fortune 500 employer has experienced steady
>growth over
>the hundred years it has been in business and is looking for a top 
>notch
>candidate.
>This company is located in a very reasonable cost of living area 
>and offers
>a varied choice 
>of neighborhood communities.
>If you are looking for a place to grow within your career in a smaller 
>city
>atmosphere 
>this is the opportunity to check out. 
>
>Relocation Assistance is provided.
>
>PLEASE DO NOT send your resume for this position UNLESS you have 
>the skills 
>outlined below for this position.
>
>DO NOT send your resume unless you have a stable work history.
>Candidates whose work history includes frequent job changes connot 
>be
>considered.
>If you are employed by a consulting company you must have a long 
>term
>project history.
>
>This is a full time staff position so no sub-contractors or third 
>parties
>please.
>
>NO H-1B candidates please.
>
>*Requirements:
>-MUST be a team player.
>-3+ years Oracle DBA experience.
>-SAP experience
>-Must have experience with:Installation, Backup and recovery,
>Implementation, Conversion, 
> Performance tuning, Troubleshooting, Development, Database Design,
>Monitoring, and Support.
>-MUST have excellent communications skills
>-Major plusses are: SQL Backtrack, DB Artisan, Powerbuilder, Shell 
>scripting
>and experience with
> Sybase and/or SQL Server. 
>
>Base Salary is 55K-to maybe high 60s Firm.
>
>The employer itself offers a comprehensive medical plan, dental
insurance,
>life insurance, 
>sick leave and d

Re: blast from the past

[Stephane Faroult]

[EMAIL PROTECTED] wrote:
> 
> Things seem a little slow on the list ( like I need more email :)
> 
> Some choice bits from Dr Dobbs Journal, November 1988.
> 
> Some you may actually have been working in IT then.  ;)
> 
> Jared

Plus ça change plus c'est la même chose.

-- 
Regards,

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

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

Fw: Data Purging Strategy

[Tim Gorman]

Sorry, forgot to "reply-all"...

- Original Message -
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 4:51 PM


> The SAMFS and Legato "DiskExtender" HSM file-systems are based on the idea
> of "migration".  Just like on mainframes, a file has a "header" that stays
> resident on disk-based storage.  If the file is accessed, the necessary
> pieces will be retrieved from tape (or some other media such as CD-RW or
> magneto-optical) to disk-based storage, as needed.  The whole file is not
> necessarily retrieved;  consider it very similar to a paging algorithm.
The
> disk-based storage is managed as a cache, so after a time the retrieved
file
> data is aged out, either to be flushed back to tape (if modified) or
simply
> dropped (if read only).  All of this is kept transparent from end-users
> (i.e. applications like Oracle, etc), so they only see the file residing
in
> the normal-looking file-system, albeit not quite as peppy as other
> file-systems...
>
> Works surprisingly well and Oracle treats it like any other datafile, so
for
> archiving your application doesn't really have to be changed in any way.
> It's just out there, just like the "current" data, only on a slower
> datafile...
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Wednesday, November 06, 2002 4:26 PM
> Subject: Re: Data Purging Strategy
>
>
> > Tim,
> >
> > I missed the part earlier where you mentioned HSM.  Though somewhat
> > familiar with it, I've never used it.  Pretty common in mainframe
> > environments.
> >
> > Do you have experience with it?  Drawbacks other than performance?
> >
> > This seems like a much better solution to me than archiving onto tape
and
> > hoping you can use it later.
> >
> > Jared
> >
> >
> >
> >
> >
> > "Tim Gorman" <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> >  11/06/2002 03:08 PM
> >  Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> > cc:
> > Subject:Re: Data Purging Strategy
> >
> >
> > Agreed.  The current Oracle datafile format (7.3, 8.0, 8.1, 9.0, or 9.2)
> > may not survive 10i -- who the heck know?
> >
> > However, the tape-based file-systems (i.e. SAMFS, Legato DiskExtender,
> > etc) can be treated like a file-system in all respects (only slower).
In
> > other words, convert the datafiles in place just as you would if they
are
> > on disk.  After all, they are still active parts of an active Oracle
> > database, even if they are in READ ONLY.  The last time such a
conversion
> > was necessary was between Oracle7 and Oracle8;  I think that it is valid
> > to assume that Oracle will provide a similar migration utility should
> > another such conversion become necessary.  Whatever needs to be
performed
> > for one tablespace in converting file formats should be done for all, so
> > this is not a problem specific to the strategy I mentioned...
> > - Original Message -
> > From: Mercadante, Thomas F
> > To: Multiple recipients of list ORACLE-L
> > Sent: Wednesday, November 06, 2002 7:18 AM
> > Subject: RE: Data Purging Strategy
> >
> > Tim,
> >
> > my problem with moving data to tape is as follows:
> >
> > Your one strategy involved moving read-only tablespaces to tape.  what
if
> > you upgrade Oracle versions.  will these read-only files still be valid?
> > will they still be able to be put back on-line, or will they need to be
> > converted along with the rest of the files to the newer version and then
> > copied back to tape.  if this is the case, is there disk space to put
all
> > of these back?  if there is disk space, then why copy them to tape at
all?
> >  they could always be available and on-line.
> >
> > Having a plan to save data to tape in hopes of resurrecting it later on
> > has more challenges than anything I've come across lately.  It just
> > doesn't seem to make sense to do this anymore.  With disk space at an
> > all-time low-cost, why put ourselves thru this?  the logistics are just
> > too expensive, as well as the risk of never being able to get the data
> > back because of software compatibility issues.
> > Tom Mercadante
> > Oracle Certified Professional
> > -Original Message-
> > From: Tim Gorman [mailto:Tim@;SageLogix.com]
> > Sent: Wednesday, November 06, 2002 8:49 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Data Purging Strategy
> >
> > This is a data-archival requirement, not a data-purge requirement.  It
> > only resembles a purge requirement based on the
> > multiple-database-migration strategy you outlined.  There are
> > alternatives...
> >
> > Depending on the volume of data in your database and your availability
> > requirements, implementing table- and index-partitioning will likely be
> > crucial.  One strategy is to have the most-active tables partitioned by
a
> > date column and have different sets of these partitions reside in
> > time-var

Re: Data Purging Strategy

[Jared . Still]

Tim,

I missed the part earlier where you mentioned HSM.  Though somewhat
familiar with it, I've never used it.  Pretty common in mainframe 
environments.

Do you have experience with it?  Drawbacks other than performance?

This seems like a much better solution to me than archiving onto tape and
hoping you can use it later.

Jared





"Tim Gorman" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/06/2002 03:08 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: Data Purging Strategy


Agreed.  The current Oracle datafile format (7.3, 8.0, 8.1, 9.0, or 9.2) 
may not survive 10i -- who the heck know?
 
However, the tape-based file-systems (i.e. SAMFS, Legato DiskExtender, 
etc) can be treated like a file-system in all respects (only slower).  In 
other words, convert the datafiles in place just as you would if they are 
on disk.  After all, they are still active parts of an active Oracle 
database, even if they are in READ ONLY.  The last time such a conversion 
was necessary was between Oracle7 and Oracle8;  I think that it is valid 
to assume that Oracle will provide a similar migration utility should 
another such conversion become necessary.  Whatever needs to be performed 
for one tablespace in converting file formats should be done for all, so 
this is not a problem specific to the strategy I mentioned...
- Original Message - 
To: Multiple recipients of list ORACLE-L 
Sent: Wednesday, November 06, 2002 7:18 AM

Tim,
 
my problem with moving data to tape is as follows:
 
Your one strategy involved moving read-only tablespaces to tape.  what if 
you upgrade Oracle versions.  will these read-only files still be valid? 
will they still be able to be put back on-line, or will they need to be 
converted along with the rest of the files to the newer version and then 
copied back to tape.  if this is the case, is there disk space to put all 
of these back?  if there is disk space, then why copy them to tape at all? 
 they could always be available and on-line.
 
Having a plan to save data to tape in hopes of resurrecting it later on 
has more challenges than anything I've come across lately.  It just 
doesn't seem to make sense to do this anymore.  With disk space at an 
all-time low-cost, why put ourselves thru this?  the logistics are just 
too expensive, as well as the risk of never being able to get the data 
back because of software compatibility issues.
Tom Mercadante 
Oracle Certified Professional 
-Original Message-
Sent: Wednesday, November 06, 2002 8:49 AM
To: Multiple recipients of list ORACLE-L

This is a data-archival requirement, not a data-purge requirement.  It 
only resembles a purge requirement based on the 
multiple-database-migration strategy you outlined.  There are 
alternatives...
 
Depending on the volume of data in your database and your availability 
requirements, implementing table- and index-partitioning will likely be 
crucial.  One strategy is to have the most-active tables partitioned by a 
date column and have different sets of these partitions reside in 
time-variant tablespaces.  With this arrangement, you can archive data to 
tape by simply setting the archived tablespaces to READ ONLY and then 
migrating them to tape-based (instead of disk-based) file-systems and 
bringing them back online.  Legato has this file-system technology 
(recently purchased) and there is a share-ware product called SAMFS which 
is an HSM (hierarchical storage mgmt) filesystem used by some vendors 
(i.e. StorageTek, etc).  By setting tablespaces to READ ONLY it becomes 
very easy to move them from disk to tape while retaining them within the 
same original database, simplifying the task of later retrieval (which is 
really important).
 
Of course, Oracle's partitioning option is enormously expensive, but in 
this case it is a matter of the upfront license costs (with reduced 
downstream implementation costs due to simplicity) versus a large 
downstream application-development cost.  In this situation, I think 
roughly offsets everything.  Since I'm not spending the money, I can 
afford such a calculation...  :-)
 
With the various storage technologies available, a single database can 
straddle several simultaneously, optimizing performance or cost as needed. 
 Some files might reside on solid-state NVRAM "disk", some on SAN-based 
disk, some on NAS-based storage, and then finally reside in archive media 
file-systems such as tape or magneto-optical based HSM file-systems.
- Original Message - 
To: Multiple recipients of list ORACLE-L 
Sent: Wednesday, November 06, 2002 2:13 AM


Dear List, 

I need some inputs from you all regarding purging data from the database. 

This is the requirement 


We define a retention period for all the data in the system. 
When the retention period is reached,  the data should be deleted, but 
then at a later time, some user might request for this 

Re: Data Purging Strategy

[Tim Gorman]

Agreed.  The current Oracle datafile format 
(7.3, 8.0, 8.1, 9.0, or 9.2) may not survive 10i -- who the heck 
know?
 
However, the tape-based file-systems (i.e. SAMFS, 
Legato DiskExtender, etc) can be treated like a file-system in all respects 
(only slower).  In other words, convert the datafiles in place just as you 
would if they are on disk.  After all, they are still active parts of an 
active Oracle database, even if they are in READ ONLY.  The last time such 
a conversion was necessary was between Oracle7 and Oracle8;  I think that 
it is valid to assume that Oracle will provide a similar migration utility 
should another such conversion become necessary.  Whatever needs to be 
performed for one tablespace in converting file formats should be done for all, 
so this is not a problem specific to the strategy I mentioned...

  - Original Message - 
  From: 
  Mercadante, Thomas F 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, November 06, 2002 7:18 
  AM
  Subject: RE: Data Purging Strategy
  
  Tim,
   
  my 
  problem with moving data to tape is as follows:
   
  Your 
  one strategy involved moving read-only tablespaces to tape.  what if you 
  upgrade Oracle versions.  will these read-only files still be 
  valid?  will they still be able to be put back on-line, or will they need 
  to be converted along with the rest of the files to the newer version and then 
  copied back to tape.  if this is the case, is there disk space to put all 
  of these back?  if there is disk space, then why copy them to tape at 
  all?  they could always be available and on-line.
   
  Having a plan to save data to tape in hopes of resurrecting it later on 
  has more challenges than anything I've come across lately.  It just 
  doesn't seem to make sense to do this anymore.  With disk space at an 
  all-time low-cost, why put ourselves thru this?  the logistics are just 
  too expensive, as well as the risk of never being able to get the data back 
  because of software compatibility issues.
  Tom Mercadante Oracle Certified Professional 
  
-Original Message-From: Tim Gorman 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002 8:49 
AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
Data Purging Strategy
This is a data-archival requirement, not a 
data-purge requirement.  It only resembles a purge requirement based on 
the multiple-database-migration strategy you outlined.  There are 
alternatives...
 
Depending on the volume of data in your 
database and your availability requirements, implementing table- and 
index-partitioning will likely be crucial.  One strategy is 
to have the most-active tables partitioned by a date column and have 
different sets of these partitions reside in time-variant tablespaces.  
With this arrangement, you can archive data to tape by simply setting the 
archived tablespaces to READ ONLY and then migrating them to tape-based 
(instead of disk-based) file-systems and bringing them back online.  
Legato has this file-system technology (recently purchased) and there 
is a share-ware product called SAMFS which is an HSM (hierarchical storage 
mgmt) filesystem used by some vendors (i.e. StorageTek, etc).  By 
setting tablespaces to READ ONLY it becomes very easy to move them from disk 
to tape while retaining them within the same original database, simplifying 
the task of later retrieval (which is really important).
 
Of course, Oracle's partitioning option is 
enormously expensive, but in this case it is a matter of the upfront license 
costs (with reduced downstream implementation costs due to 
simplicity) versus a large downstream application-development 
cost.  In this situation, I think roughly offsets everything.  
Since I'm not spending the money, I can afford such a calculation...  
:-)
 
With the various storage technologies 
available, a single database can straddle several simultaneously, optimizing 
performance or cost as needed.  Some files might reside on 
solid-state NVRAM "disk", some on SAN-based disk, some on NAS-based storage, 
and then finally reside in archive media file-systems such as tape or 
magneto-optical based HSM file-systems.

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Wednesday, November 06, 2002 
  2:13 AM
  Subject: Data Purging Strategy
  Dear List, 
  I need some inputs from you all 
  regarding purging data from the database. This is the requirement We define a retention period for all the data in 
  the system. When the retention 
  period is reached,  the data should be deleted, but then at a later 
  time, some user might request for this purged data. So it must be possible 
  to retrieve this data. This is

blast from the past

[Jared . Still]

Things seem a little slow on the list ( like I need more email :)

Some choice bits from Dr Dobbs Journal, November 1988.

Some you may actually have been working in IT then.  ;)

Jared

-

If a single word sums up the current state of computing, that word is 
confusion. It's hard to remember a time when the PC industry
was in a more confounding state of affairs. Now, more than ever, there is 
a bewildering array of choices in everything from
operating systems to hardware architectures. And the choices aren't 
getting any easier.

Take a look at operating systems, for example. It was only a few years ago 
that developers had a scarcity of options. There was
CP/M, AppleDOS, and a few other systems available--TRS-DOS (boy, there's a 
stab from the past) was one I worked
with--but for the most part, choices were few and the stakes relatively 
low.

Today, developers must decide between DOS, OS/2, Unix (pick your favorite 
flavor), the Macintosh, and a host of other more
specialized alternatives. If you pick the wrong development platform, the 
results may not be a pretty sight.

In the same sense, the Macintosh was basically the only dominant windowing 
system three or four years ago. Today, there's at
least a dozen, including Windows/Presentation Manager, the Macintosh, 
X-Windows, Rooms, GEM, and New Wave, to
mention a few.

Now, throw in a wildcard, like Display Postscript (Steve Jobs' choice), 
and take into consideration the rumor that former
operating system rivals Digital Research and Microsoft are considering 
offering DRI's GEM application-development tool kit as a
development tool for Presentation Manager. Now you're faced with a 
perplexing array of opportunities or quagmires, depending
on your perspective.

And things are just as confusing on the hardware side. We've somehow moved 
from a couple of accepted architectures (the AT
bus and a closed-system Mac) to a plethora of standards that include the 
Micro Channel Architecture (MCA), the NuBus, and,
more recently, the Extended Industry Standard Architecture (EISA). (EISA 
is a 32-bit extension of the AT bus that has been
endorsed by several PC manufacturers--IBM not among them--that supposedly 
provides the performance benefits of the MCA,
yet is compatible with existing AT-bus cards.) Not to mention, last 
month's introduction of Steve Jobs' NeXT workstation and the
whisperings about an 80386 machine waiting in the wings at Apple. I'm 
getting an ulcer just writing about it.

Now consider the various incarnations and implementations of programming 
languages. Should you go with C or begin thinking
about C++? What about Modula-2? There are some powerful new Modula 
compilers out there that deserve consideration, and
the renewed promise of Basic (hearken back to Bill Gates' remarks about 
Object-Basic) as a serious development platform.

Anecdotically, a developer I know wrote a complicated Windows application 
in Pascal. He wound up rewriting the entire project
after he figured out that Modula-2 would enable him to better accomplish 
what he was trying to do.

Regardless of what the soothsayers predicted a couple of years ago, 
nothing about computing--from either the developer's or the
end user's perspective--is getting any easier. Now, I'm not complaining 
about more powerful systems, you understand, or about
the diversity of choices we're faced with today. I'll put it this way, 
it's better to be rich and healthy than sick and poor.

The point to all of this is that developing for and porting between 
different environments is no easy matter. Developers must
choose wisely and well. Some platforms won't be alive and kicking 
tomorrow. For that matter, neither will developers who've
made the wrong choice.


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

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

RE: Data Purging Strategy

[Steve McClure]

Sherry Finish?  I thought you liked scotch that tasted like burnt mud?

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 10:55 AM
To: Multiple recipients of list ORACLE-L


That reminds me:

Mark, your annual stipend is due.

Make it a case of Glenmorangie this time, Sherry finish.  :)

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 11/06/2002 07:56 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Data Purging Strategy


Hey Dennis,
Mark Leith is the only person on this list allowed to mention 3rd party
products.
I am sure he bought the franchise from Jared :)

John

-Original Message-
Sent: 06 November 2002 14:15
To: Multiple recipients of list ORACLE-L


Prem - You are receiving some excellent advice from Tom and Tim. I would
mention two items in addition:
  - If you ever hope to re-use the data you archive off-line, you must 
also
archive all the related tables, because after all, this is a RELATIONAL
database.
  - PrincetonSoftech has a product Active Archiving that looks pretty good
from the demos I've seen. I haven't used it myself.



Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, November 06, 2002 6:54 AM
To: Multiple recipients of list ORACLE-L


Prem,
 
I would re-visit the requirement.  Why do you feel the need to delete the
data from the database?  What is the purpose for this type of requirement?
It would be far easier to modify the requirement than to do what you are
thinking of doing.
 
Adding columns to database tables indicating that a record has passed it's
retention policy and thus, is not included in queries, would be a much
easier solution.
 
Or, simply moving these records to historical tables in the database - and
NOT deleting them from the system - is a much better solution.  The data 
is
always accessible and not available in the current tables.  And you will 
not
be playing the "get the data from tape and reload it" game with all of 
it's
problems (writing an offload program, table structure changes & offload
program versions).
 
Try and keep this as simple as possible.
 
Hope this helps
 
Tom Mercadante 
Oracle Certified Professional 

-Original Message-
Sent: Wednesday, November 06, 2002 4:13 AM
To: Multiple recipients of list ORACLE-L



Dear List, 

I need some inputs from you all regarding purging data from the database. 

This is the requirement 


We define a retention period for all the data in the system. 
When the retention period is reached,  the data should be deleted, but 
then
at a later time, some user might request for this purged data. So it must 
be
possible to retrieve this data. 

This is the strategy we have designed for this. 

When the retention period is reached, move the data from the main database
to an offline database. Then delete the data from the main database. 

In the offline database, we cannot again keep it from long, so it has to
moved to tapes. Now my question, how can we move this data to tapes and at
the same time retrieve data from the tapes based on dates. 
i.e, the user will ask for the data on a particular date, so it must be
possible to retrieve data from the tapes based on a date and load it to 
the
database tables. 

Regards 
Prem 

 

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

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

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



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

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

RE: How can I tell if MTS is activated -- more problems

[Molina, Gerardo]

Another place to look is how connections are made to the database.

Do you know if the connections are bypassing the tnsnames.ora altogether and
using their own connect string wherein they could be specifying a dedicated
server?

First thing to determine is whether connections are in fact using
tnsnames.ora.  The developers should be able to answer this question.

For example, an application could be using JDBC to connect to db and the
connection could specify a complete connect string and not use tnsnames.ora
at all.

HTH,
Gerardo

-Original Message-
Sent: Wednesday, November 06, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L


Dave,

   I've seen these processes (ora_S00... and
ora_d00..) but all connections are being made through
dedicated processes.

Here's my configuration:

mts_listener_address = "(ADDRESS=(PROTOCOL=TCP)
(HOST=10.20.81.78) (PORT=1521))"
mts_service  = PRUE1
mts_dispatchers  = "tcp,2"
mts_max_dispatchers  = 10
mts_servers  = 6
mts_max_servers  = 100


The listener has been started before the RDBMS:

listener.ora

LISTENER =
  (ADDRESS_LIST=
   
(ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=PRUE1)))
SID_LIST_LISTENER=
   (SID_LIST=
(SID_DESC=
  (GLOBAL_DBNAME=PRUE1)
  (SID_NAME=PRUE1)
  (ORACLE_HOME=/u01/app/oracle/product/8.1.7)
 )
   )


lsnrctl services

LSNRCTL for Linux: Version 8.1.7.0.0 - Production on 06-NOV-2002 16:40:58

(c) Copyright 1998 Oracle Corporation.  All rights
reserved.

Connecting to
(ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
Services Summary...
  PRUE1 has 2 service handler(s)
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
The command completed successfully


BUT the user processes are not using MTS.

Why aren't they using MTS?
What's wrong in this configuration?


thanks for your help.





--
To see how many dispatchers/shared servers are started
up with the RDBMS,  check the value of
'mts_dispatchers' and 'mts_servers' in the init.ora.  
You can also tell by looking in the alert.log(default
location is  $ORACLE_HOME/rdbms/log).
Sample:  
PMON started
DBWR started
LGWR started
RECO started
Thu Sep 14 09:24:15 1995
starting up 4 shared server(s) ...
starting up 4 dispatcher(s) for network
See Note:1012480.6 on Metastink for mor info on MTS
Processes

Dave

-Original Message-
Sent: Wednesday, November 06, 2002 10:59 AM
To: Multiple recipients of list ORACLE-L


Oracle 8i

How can I tell if MTS is activated?

Which parameters should I look at? (in init.ora and
listener.ora)


thanks
Pablo



___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
Descárgalo ya desde http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
  INET: [EMAIL PROTECTED]

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

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

___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
Descárgalo ya desde http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
  INET: [EMAIL PROTECTED]

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

RE: RE: Oracle DBA with SAP Needed

[Kevin Lange]

In other words  smart buisness sense  

-Original Message-
Sent: Wednesday, November 06, 2002 3:29 PM
To: Multiple recipients of list ORACLE-L


Yeah, but is smacks of being unethical and un-American.

Dick Goulet

Reply Separator
Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
Date:   11/6/2002 1:08 PM

Cary - I think you have a good insight. I've encountered that before. Often
that is the reason for some strange employment advertisements in national
magazines. As you say, posting on ORACLE-L may meet the requirement, is
free, and is fast (no need to wait months for the publication date).

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, November 06, 2002 2:39 PM
To: Multiple recipients of list ORACLE-L


An administrative requirement causes a lot of these types of postings
with odd-looking salary ranges. Chances are that the company already has
a foreign national candidate in the hiring pipeline for the job at this
salary. INS requires that US citizens be given a fair shot at the job
posting. One of the requirements is to advertise the position publicly.
Oracle-L is a public forum.

What usually happens is that either nobody applies for the position (the
salary's too low, so everybody pokes fun at it). Sometimes, somebody
does apply. But it's very unlikely that at this price, it'll be anyone
qualified.

Having seen this process to fruition and beyond, what often happens is
that the person immigrates to the US, works hard, and makes good. The
company benefits from good labor at a bargain price for at least a year
or two. The applicant benefits in several ways. He or she gets
physically to the USA, making well more than enough money than it takes
for most people to live on. If the person becomes indispensable, the
host company sponsors a green card application. From there, because the
person is free to compete in the USA job market, he or she begins making
the kind of money you'd expect.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Sent: Wednesday, November 06, 2002 12:24 PM
To: Multiple recipients of list ORACLE-L

Well with the ridiculous salary they are offering, they could at least
train you in the use of SAP.  This is a Fortune 500 company after all.

-- 

Alan Davey
[EMAIL PROTECTED]
212-604-0200  x106


On 11/6/2002 10:56 AM, Paulo Gomes <[EMAIL PROTECTED]> wrote:
>unfortunatly i don't work with SAP or i would be interessed
>regards
>Paulo
>
>-Original Message-
>Sent: quarta-feira, 6 de Novembro de 2002 14:49
>To: Multiple recipients of list ORACLE-L
>
>
>If you are an Oracle DBA With SAP experience looking for a stable 
>company 
>where you can work within a great team environment, this company 
>in Toledo,
>Ohio 
>is the place for you. This Fortune 500 employer has experienced steady
>growth over
>the hundred years it has been in business and is looking for a top 
>notch
>candidate.
>This company is located in a very reasonable cost of living area 
>and offers
>a varied choice 
>of neighborhood communities.
>If you are looking for a place to grow within your career in a smaller 
>city
>atmosphere 
>this is the opportunity to check out. 
>
>Relocation Assistance is provided.
>
>PLEASE DO NOT send your resume for this position UNLESS you have 
>the skills 
>outlined below for this position.
>
>DO NOT send your resume unless you have a stable work history.
>Candidates whose work history includes frequent job changes connot 
>be
>considered.
>If you are employed by a consulting company you must have a long 
>term
>project history.
>
>This is a full time staff position so no sub-contractors or third 
>parties
>please.
>
>NO H-1B candidates please.
>
>*Requirements:
>-MUST be a team player.
>-3+ years Oracle DBA experience.
>-SAP experience
>-Must have experience with:Installation, Backup and recovery,
>Implementation, Conversion, 
> Performance tuning, Troubleshooting, Development, Database Design,
>Monitoring, and Support.
>-MUST have excellent communications skills
>-Major plusses are: SQL Backtrack, DB Artisan, Powerbuilder, Shell 
>scripting
>and experience with
> Sybase and/or SQL Server. 
>
>Base Salary is 55K-to maybe high 60s Firm.
>
>The employer itself offers a comprehensive medical plan, dental
insurance,
>life insurance, 
>sick leave and disability plans, a retirement plan, vacation days, 
>a 401K
>Plan, and much more. 
>
>For immediate consideration, please email your resume as an attachment 
>to:
>
>OraStaff, Inc.
>Email: [EMAIL PROTECTED]
>Phone: 1-800-549-8502. 
>Please Use Job Code: one/Toledo/DBA-SAP/Jenni
>
>I pay referral fees.
>So please contact me if you know of anyone who would be
qualified/interested
>in the position described above- if 

Re: How can I tell if MTS is activated -- more problems

[Scott Stefick]

Pablo,

init.ora --> Look at the dispatchers=... parameter (You can comment it 
out if you don't want MTS)
listener.ora --> Look for (SERVER = DEDICATED) vs. (SERVER = SHARED)
In SQLPLUS --> SQL> SELECT servers_started FROM v$mts;

-Scott Stefick

> -Original Message-
> Sent: Wednesday, November 06, 2002 10:59 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Oracle 8i
>
> How can I tell if MTS is activated?
>
> Which parameters should I look at? (in init.ora and
> listener.ora)
>
>
> thanks
> Pablo



**
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Stefick
 INET: [EMAIL PROTECTED]

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

Re: Convert TEMP tablespace from datafiles to tempfiles

[Jared . Still]

create temporary tablespace temp2 
   tempfile '/u01/oradata/dv01/temp2.dbf' size 10m 
   extent management local uniform size 128k;

HTH

Jared






"Ron Rogers" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/06/2002 12:10 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: Convert TEMP tablespace from datafiles to tempfiles


List,
Would you please explain to me how you are able to get TEMP and LMT
combined together. I use 8.1.7 and it is not allowed.
"Oracle8i DBA Handbook" Loney and Theriault, Osborne Oracle Press, Page
598 NOTE 
"If you specify Local in a create tablespace command, you can not
specify a default storage clause, minextents, or temporary. If you use
the create temporary tablespace command to create the tablespace, you
can specify extent_management local."
The tablespace that is being created is a tablespace with type =
temporary not permanent? correct?
Ron
ROR mô¿ôm

>>> [EMAIL PROTECTED] 11/06/02 01:39PM >>>

Rich,

If you've got the disk space, do it while the DB is up.  Much simpler.

Create a new Temporary LMT - call it NewTemp - with the appropriate
tempfiles.

Switch everyone to NewTemp by spooling and executing this and running
the
spooled file:
Select 'Alter User ' || UserName || ' Temporary Tablespace NewTemp ;'
>From   DBA_Users;

After a day or two, or when you can determine that no one is using the
old
Temp tablespace, offline and drop Temp.

If you've just got to have the Temp tablespace named Temp, repeat the
above
steps to create a new Temp LMT.

Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
[EMAIL PROTECTED] 



 
 
"Jesse, Rich" 
 
 <[EMAIL PROTECTED]> 
 
Sent by:  cc: 
 
[EMAIL PROTECTED]   Subject: Convert TEMP
tablespace from 
m  datafiles to tempfiles 
 
 
 
 
 
11/06/2002 
 
09:56 AM 
 
Please respond 
 
to ORACLE-L 
 
 
 
 
 




Hey all,

I've got some downtime coming up on an 8.1.6 DB on Solaris, and I'd
like to
take the opportunity to convert the datafiles of the TEMP tablespace
to
tempfiles.  My reason for this change is primarily to get the TEMP
tablespace LMT, but also to shrink our hotbacks w/o modifying the
working
script.

I've been trying to reason out this task in my head, as I can't find
much
on
MetaLink, and here's what I've got so far:

1)  Shutdown DB.
2)  Backup DB.
3)  Startup restricted.
4)  Offline tablespace TEMP.
5)  Drop tablespace TEMP.
6)  Create new temporary TEMP LMT.
7)  Bounce instance.

I don't yet have an arena to try this in.  Will users whose assigned
TEMPORARY TABLESPACE is TEMP need to be ALTERed?  Anyone have any
comments
on the procedure?

TIA!

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex,
WI
USA



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

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

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



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

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

Re:RE: Oracle DBA with SAP Needed

[dgoulet]

Yeah, but is smacks of being unethical and un-American.

Dick Goulet

Reply Separator
Author: DENNIS WILLIAMS <[EMAIL PROTECTED]>
Date:   11/6/2002 1:08 PM

Cary - I think you have a good insight. I've encountered that before. Often
that is the reason for some strange employment advertisements in national
magazines. As you say, posting on ORACLE-L may meet the requirement, is
free, and is fast (no need to wait months for the publication date).

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, November 06, 2002 2:39 PM
To: Multiple recipients of list ORACLE-L


An administrative requirement causes a lot of these types of postings
with odd-looking salary ranges. Chances are that the company already has
a foreign national candidate in the hiring pipeline for the job at this
salary. INS requires that US citizens be given a fair shot at the job
posting. One of the requirements is to advertise the position publicly.
Oracle-L is a public forum.

What usually happens is that either nobody applies for the position (the
salary's too low, so everybody pokes fun at it). Sometimes, somebody
does apply. But it's very unlikely that at this price, it'll be anyone
qualified.

Having seen this process to fruition and beyond, what often happens is
that the person immigrates to the US, works hard, and makes good. The
company benefits from good labor at a bargain price for at least a year
or two. The applicant benefits in several ways. He or she gets
physically to the USA, making well more than enough money than it takes
for most people to live on. If the person becomes indispensable, the
host company sponsors a green card application. From there, because the
person is free to compete in the USA job market, he or she begins making
the kind of money you'd expect.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Sent: Wednesday, November 06, 2002 12:24 PM
To: Multiple recipients of list ORACLE-L

Well with the ridiculous salary they are offering, they could at least
train you in the use of SAP.  This is a Fortune 500 company after all.

-- 

Alan Davey
[EMAIL PROTECTED]
212-604-0200  x106


On 11/6/2002 10:56 AM, Paulo Gomes <[EMAIL PROTECTED]> wrote:
>unfortunatly i don't work with SAP or i would be interessed
>regards
>Paulo
>
>-Original Message-
>Sent: quarta-feira, 6 de Novembro de 2002 14:49
>To: Multiple recipients of list ORACLE-L
>
>
>If you are an Oracle DBA With SAP experience looking for a stable 
>company 
>where you can work within a great team environment, this company 
>in Toledo,
>Ohio 
>is the place for you. This Fortune 500 employer has experienced steady
>growth over
>the hundred years it has been in business and is looking for a top 
>notch
>candidate.
>This company is located in a very reasonable cost of living area 
>and offers
>a varied choice 
>of neighborhood communities.
>If you are looking for a place to grow within your career in a smaller 
>city
>atmosphere 
>this is the opportunity to check out. 
>
>Relocation Assistance is provided.
>
>PLEASE DO NOT send your resume for this position UNLESS you have 
>the skills 
>outlined below for this position.
>
>DO NOT send your resume unless you have a stable work history.
>Candidates whose work history includes frequent job changes connot 
>be
>considered.
>If you are employed by a consulting company you must have a long 
>term
>project history.
>
>This is a full time staff position so no sub-contractors or third 
>parties
>please.
>
>NO H-1B candidates please.
>
>*Requirements:
>-MUST be a team player.
>-3+ years Oracle DBA experience.
>-SAP experience
>-Must have experience with:Installation, Backup and recovery,
>Implementation, Conversion, 
> Performance tuning, Troubleshooting, Development, Database Design,
>Monitoring, and Support.
>-MUST have excellent communications skills
>-Major plusses are: SQL Backtrack, DB Artisan, Powerbuilder, Shell 
>scripting
>and experience with
> Sybase and/or SQL Server. 
>
>Base Salary is 55K-to maybe high 60s Firm.
>
>The employer itself offers a comprehensive medical plan, dental
insurance,
>life insurance, 
>sick leave and disability plans, a retirement plan, vacation days, 
>a 401K
>Plan, and much more. 
>
>For immediate consideration, please email your resume as an attachment 
>to:
>
>OraStaff, Inc.
>Email: [EMAIL PROTECTED]
>Phone: 1-800-549-8502. 
>Please Use Job Code: one/Toledo/DBA-SAP/Jenni
>
>I pay referral fees.
>So please contact me if you know of anyone who would be
qualified/interested
>in the position described above- if it is not a match for your skills.
>Thanks.
>
>
>
>
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: OraStaff
>  INET: [EMAIL PR

Re: How can I tell if MTS is activated -- more problems

[Ray Stell]

On Wed, Nov 06, 2002 at 11:39:06AM -0800, Pablo Rodriguez wrote:
> Dave,
> 
>I've seen these processes (ora_S00... and
> ora_d00..) but all connections are being made through
> dedicated processes.
> 
> Here's my configuration:
> 
> mts_listener_address = "(ADDRESS=(PROTOCOL=TCP)
> (HOST=10.20.81.78) (PORT=1521))"
> mts_service  = PRUE1
> mts_dispatchers  = "tcp,2"


I think this is old syntax for mts_dispatchers, v7ish, maybe.  Look at the docs on
where you are (I have not been following the thread).  Seems like this happened to 
me when moving from oracle 7 -> 8.  Maybe:

mts_dispatchers = "(PROTOCOL=TCP)(DISPATCHERS=1)"





> mts_max_dispatchers  = 10
> mts_servers  = 6
> mts_max_servers  = 100
> 
> 
> The listener has been started before the RDBMS:
> 
> listener.ora
> 
> LISTENER =
>   (ADDRESS_LIST=
>
> (ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
> (ADDRESS=(PROTOCOL=ipc)(KEY=PRUE1)))
> SID_LIST_LISTENER=
>(SID_LIST=
> (SID_DESC=
>   (GLOBAL_DBNAME=PRUE1)
>   (SID_NAME=PRUE1)
>   (ORACLE_HOME=/u01/app/oracle/product/8.1.7)
>  )
>)
> 
> 
> lsnrctl services
> 
> LSNRCTL for Linux: Version 8.1.7.0.0 - Production on
> 06-NOV-2002 16:40:58
> 
> (c) Copyright 1998 Oracle Corporation.  All rights
> reserved.
> 
> Connecting to
> (ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
> Services Summary...
>   PRUE1 has 2 service handler(s)
> DEDICATED SERVER established:0 refused:0
>   LOCAL SERVER
> DEDICATED SERVER established:0 refused:0
>   LOCAL SERVER
> The command completed successfully
> 
> 
> BUT the user processes are not using MTS.
> 
> Why aren't they using MTS?
> What's wrong in this configuration?
> 
> 
> thanks for your help.
> 
> 
> 
> 
> 
> --
> To see how many dispatchers/shared servers are started
> up with the RDBMS,  check the value of
> 'mts_dispatchers' and 'mts_servers' in the init.ora.  
> You can also tell by looking in the alert.log(default
> location is  $ORACLE_HOME/rdbms/log).
> Sample:  
> PMON started
> DBWR started
> LGWR started
> RECO started
> Thu Sep 14 09:24:15 1995
> starting up 4 shared server(s) ...
> starting up 4 dispatcher(s) for network
> See Note:1012480.6 on Metastink for mor info on MTS
> Processes
> 
> Dave
> 
> -Original Message-
> Sent: Wednesday, November 06, 2002 10:59 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Oracle 8i
> 
> How can I tell if MTS is activated?
> 
> Which parameters should I look at? (in init.ora and
> listener.ora)
> 
> 
> thanks
> Pablo
> 
> 
> 
> ___
> Yahoo! Messenger
> Nueva versi?n: Webcam, voz, y mucho m?s ?Gratis! 
> Desc?rgalo ya desde http://messenger.yahoo.es
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
> -
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information (like
> subscribing).
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Farnsworth, Dave
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
> -
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the 
> 
> ___
> Yahoo! Messenger
> Nueva versi?n: Webcam, voz, y mucho m?s ?Gratis! 
> Desc?rgalo ya desde http://messenger.yahoo.es
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want t

RE: Oracle to Excel

[Mirsky, Greg]

Laura,
 
Check out Tom Kyte's site. He has posted the source code for a PL/SQL
package called OWA_SYLK that will dump a SQL query to a *.SLK file (*.SLK
files can be directly opened by Excel). Plug in the SQL and then go... send
the output file to the user and they do the rest.
 
Here is the link:
 
http://asktom.oracle.com/pls/ask/f?p=4950:8:1556583::NO::F4950_P8_DISPLAYID,
F4950_P8_CRITERIA:828426949078,%7Bowa_sylk%7D
 
 
We use it constantly!
 
Greg

-Original Message-
Sent: Wednesday, November 06, 2002 4:00 PM
To: Multiple recipients of list ORACLE-L



Thank you for your response Tom.  I received other responses as well, and I
know that I can comma delimit a .txt file but I wanted to know if I could do
it all at one time, which is why I tried your suggestion first.  It works
except that each field is in a separate row instead of a column.  

 

Below is an example (1 record is shown):

 


53-041-02



0


2


AL POWER CO



51271


27-Nov-01


173.52


447-57



D412



173.52


226 DONNELL



43000


00014.04.D412



 



 

It looks like it thinks it is a carriage return instead of a tab.  Any
ideas?  

 

Laura

 

-Original Message-
Sent: Wednesday, November 06, 2002 1:24 PM
To: Multiple recipients of list ORACLE-L

 

Laura,

 

lots of tools do this for you automatically.  Oracle discoverer will export
the results of a query directly into Excel format.

 

You can do this yourself as follows:

 

in SqlPLus

 

select col1||chr(10)||col2||chr(10)

from table.

 

the chr(10) is the tab character.

spool the results to a output.xls

 

open the file using excel.  the tab character is the default column
delimiter.  You should see all your data in cells.

 

hope this helps.

Tom Mercadante 
Oracle Certified Professional 

-Original Message-
Sent: Wednesday, November 06, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L

I think I have seen traffic concerning the extracting of data from Oracle
into an Excel spreadsheet.  We now have a need for this.  Could anyone
enlighten me?

Thank you in advance.

Laura 

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

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

RE: OCP Exams - What to study out of?

[DENNIS WILLIAMS]

No (sigh), I just took the class, so now I've got to get the energy to take
the test.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, November 06, 2002 2:20 PM
To: Multiple recipients of list ORACLE-L


So you took and passed the upgrade exam already?

Brian

-Original Message-
Sent: Wednesday, November 06, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L


And I hope it is okay to take 9i New Features before you've finished all
your 8i modules, because I wound up taking a new features class to use up
some education money that was expiring. The Oracle instructor, John Hibbard,
is superb. He makes the class very entertaining and he has done a lot of
research outside the class manual and he throws that in as well. 
   I wanted a short "cram sheet" with a fast overview of topics likely to be
on the 9i New Features exam and ended up writing my own 5-page document, so
if anyone wants a copy, send me a private note and I'll send you a copy. No
guarantees, and if you find any errors, let me know.


Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Richards, Brian
  INET: [EMAIL PROTECTED]

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

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

RE: Oracle DBA with SAP Needed

[DENNIS WILLIAMS]

Cary - I think you have a good insight. I've encountered that before. Often
that is the reason for some strange employment advertisements in national
magazines. As you say, posting on ORACLE-L may meet the requirement, is
free, and is fast (no need to wait months for the publication date).

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, November 06, 2002 2:39 PM
To: Multiple recipients of list ORACLE-L


An administrative requirement causes a lot of these types of postings
with odd-looking salary ranges. Chances are that the company already has
a foreign national candidate in the hiring pipeline for the job at this
salary. INS requires that US citizens be given a fair shot at the job
posting. One of the requirements is to advertise the position publicly.
Oracle-L is a public forum.

What usually happens is that either nobody applies for the position (the
salary's too low, so everybody pokes fun at it). Sometimes, somebody
does apply. But it's very unlikely that at this price, it'll be anyone
qualified.

Having seen this process to fruition and beyond, what often happens is
that the person immigrates to the US, works hard, and makes good. The
company benefits from good labor at a bargain price for at least a year
or two. The applicant benefits in several ways. He or she gets
physically to the USA, making well more than enough money than it takes
for most people to live on. If the person becomes indispensable, the
host company sponsors a green card application. From there, because the
person is free to compete in the USA job market, he or she begins making
the kind of money you'd expect.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on Oracle® System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Sent: Wednesday, November 06, 2002 12:24 PM
To: Multiple recipients of list ORACLE-L

Well with the ridiculous salary they are offering, they could at least
train you in the use of SAP.  This is a Fortune 500 company after all.

-- 

Alan Davey
[EMAIL PROTECTED]
212-604-0200  x106


On 11/6/2002 10:56 AM, Paulo Gomes <[EMAIL PROTECTED]> wrote:
>unfortunatly i don't work with SAP or i would be interessed
>regards
>Paulo
>
>-Original Message-
>Sent: quarta-feira, 6 de Novembro de 2002 14:49
>To: Multiple recipients of list ORACLE-L
>
>
>If you are an Oracle DBA With SAP experience looking for a stable 
>company 
>where you can work within a great team environment, this company 
>in Toledo,
>Ohio 
>is the place for you. This Fortune 500 employer has experienced steady
>growth over
>the hundred years it has been in business and is looking for a top 
>notch
>candidate.
>This company is located in a very reasonable cost of living area 
>and offers
>a varied choice 
>of neighborhood communities.
>If you are looking for a place to grow within your career in a smaller 
>city
>atmosphere 
>this is the opportunity to check out. 
>
>Relocation Assistance is provided.
>
>PLEASE DO NOT send your resume for this position UNLESS you have 
>the skills 
>outlined below for this position.
>
>DO NOT send your resume unless you have a stable work history.
>Candidates whose work history includes frequent job changes connot 
>be
>considered.
>If you are employed by a consulting company you must have a long 
>term
>project history.
>
>This is a full time staff position so no sub-contractors or third 
>parties
>please.
>
>NO H-1B candidates please.
>
>*Requirements:
>-MUST be a team player.
>-3+ years Oracle DBA experience.
>-SAP experience
>-Must have experience with:Installation, Backup and recovery,
>Implementation, Conversion, 
> Performance tuning, Troubleshooting, Development, Database Design,
>Monitoring, and Support.
>-MUST have excellent communications skills
>-Major plusses are: SQL Backtrack, DB Artisan, Powerbuilder, Shell 
>scripting
>and experience with
> Sybase and/or SQL Server. 
>
>Base Salary is 55K-to maybe high 60s Firm.
>
>The employer itself offers a comprehensive medical plan, dental
insurance,
>life insurance, 
>sick leave and disability plans, a retirement plan, vacation days, 
>a 401K
>Plan, and much more. 
>
>For immediate consideration, please email your resume as an attachment 
>to:
>
>OraStaff, Inc.
>Email: [EMAIL PROTECTED]
>Phone: 1-800-549-8502. 
>Please Use Job Code: one/Toledo/DBA-SAP/Jenni
>
>I pay referral fees.
>So please contact me if you know of anyone who would be
qualified/interested
>in the position described above- if it is not a match for your skills.
>Thanks.
>
>
>
>
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: OraStaff
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-

Re:RE: How can I tell if MTS is activated -- more problems

[Pablo Rodriguez]

No there isn't.
This is my TNSNAMES.

PRUE1.world = 
  (DESCRIPTION = 
(ADDRESS_LIST = 
(ADDRESS = 
  (COMMUNITY = tcp.world)
  (PROTOCOL = TCP)
  (Host = 10.20.81.78)
  (Port = 1521)
)
)
(CONNECT_DATA = (SID = PRUE1)
)
  )




--- [EMAIL PROTECTED] escribió: > What does your
TNSNAMES.ORA file look like?  If
> there is a line in there
> '(server=dedicated)' you might as well turn MTS off.
> 
> Dick Goulet
> 
> Reply
> Separator
> Subject:RE: How can I tell if MTS is activated
> -- more problems
> Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
> <[EMAIL PROTECTED]>
> Date:   11/6/2002 11:39 AM
> 
> Dave,
> 
>I've seen these processes (ora_S00... and
> ora_d00..) but all connections are being made
> through
> dedicated processes.
> 
> Here's my configuration:
> 
> mts_listener_address = "(ADDRESS=(PROTOCOL=TCP)
> (HOST=10.20.81.78) (PORT=1521))"
> mts_service  = PRUE1
> mts_dispatchers  = "tcp,2"
> mts_max_dispatchers  = 10
> mts_servers  = 6
> mts_max_servers  = 100
> 
> 
> The listener has been started before the RDBMS:
> 
> listener.ora
> 
> LISTENER =
>   (ADDRESS_LIST=
>
>
(ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
> (ADDRESS=(PROTOCOL=ipc)(KEY=PRUE1)))
> SID_LIST_LISTENER=
>(SID_LIST=
> (SID_DESC=
>   (GLOBAL_DBNAME=PRUE1)
>   (SID_NAME=PRUE1)
>  
> (ORACLE_HOME=/u01/app/oracle/product/8.1.7)
>  )
>)
> 
> 
> lsnrctl services
> 
> LSNRCTL for Linux: Version 8.1.7.0.0 - Production on
> 06-NOV-2002 16:40:58
> 
> (c) Copyright 1998 Oracle Corporation.  All rights
> reserved.
> 
> Connecting to
>
(ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
> Services Summary...
>   PRUE1 has 2 service handler(s)
> DEDICATED SERVER established:0 refused:0
>   LOCAL SERVER
> DEDICATED SERVER established:0 refused:0
>   LOCAL SERVER
> The command completed successfully
> 
> 
> BUT the user processes are not using MTS.
> 
> Why aren't they using MTS?
> What's wrong in this configuration?
> 
> 
> thanks for your help.
> 
> 
> 
> 
> 
>
--
> To see how many dispatchers/shared servers are
> started
> up with the RDBMS,  check the value of
> 'mts_dispatchers' and 'mts_servers' in the init.ora.
>  
> You can also tell by looking in the
> alert.log(default
> location is  $ORACLE_HOME/rdbms/log).
> Sample:  
> PMON started
> DBWR started
> LGWR started
> RECO started
> Thu Sep 14 09:24:15 1995
> starting up 4 shared server(s) ...
> starting up 4 dispatcher(s) for network
> See Note:1012480.6 on Metastink for mor info on MTS
> Processes
> 
> Dave
> 
> -Original Message-
> Sent: Wednesday, November 06, 2002 10:59 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Oracle 8i
> 
> How can I tell if MTS is activated?
> 
> Which parameters should I look at? (in init.ora and
> listener.ora)
> 
> 
> thanks
> Pablo
> 
> 
> 
>
___
> Yahoo! Messenger
> Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
> Descárgalo ya desde http://messenger.yahoo.es
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like
> subscribing).
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Farnsworth, Dave
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the 
> 
>
___
> Yahoo! Messenger
> Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
> Descárgalo ya desde http://messenger.yahoo.es
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.

RE: Oracle to Excel

[Burton, Laura L.]

Title: Oracle to Excel









Thank you for your response Tom.  I received other responses as well, and
I know that I can comma delimit a .txt file but I wanted to know if I could do
it all at one time, which is why I tried your suggestion first.  It works except that each field is in a
separate row instead of a column.  

 

Below is an example (1 record is shown):

 


 
  
  53-041-02 
   
  
 
 
  
  0
  
 
 
  
  2
  
 
 
  
  AL POWER CO
  
  
 
 
  
  51271
  
 
 
  
  27-Nov-01
  
 
 
  
  173.52
  
 
 
  
  447-57 
  
  
 
 
  
  D412   
  
  
 
 
  
  173.52
  
 
 
  
  226 DONNELL  
    
  
 
 
  
  43000
  
 
 
  
  00014.04.D412   
     
  
 
 
  
   
     
  
 
 
  
   
  
 


It looks like it thinks it is a carriage
return instead of a tab.  Any ideas?  

 

Laura

 

-Original Message-
From: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, November 06, 2002
1:24 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Oracle to Excel

 



Laura,





 





lots of tools do this for
you automatically.  Oracle discoverer will export the results of a query
directly into Excel format.





 





You can do this yourself
as follows:





 





in SqlPLus





 





select
col1||chr(10)||col2||chr(10)





from table.





 





the chr(10) is the tab
character.





spool the results to a
output.xls





 





open the file using
excel.  the tab character is the default column delimiter.  You
should see all your data in cells.





 





hope this helps.



Tom Mercadante 
Oracle
Certified Professional 



-Original Message-
From: Burton, Laura L.
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 06, 2002
1:49 PM
To: Multiple recipients of list
ORACLE-L
Subject: Oracle to Excel

I think I have seen traffic concerning the extracting
of data from Oracle into an Excel spreadsheet.  We now have a need for
this.  Could anyone enlighten me?

Thank you in advance.

Laura 

RE: Convert TEMP tablespace from datafiles to tempfiles

[Jesse, Rich]

Yeah, from the List, this method seems to be preferred.  My only problem is
in step 7 -- change "a" to "several".  This could require more testing,
however.  I imagine I'll be trying to ATLER TABLESPAVE TMEP afterwards...

Thx all!  :)

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

> -Original Message-
> From: Mercadante, Thomas F [mailto:NDATFM@;labor.state.ny.us]
> Sent: Wednesday, November 06, 2002 11:59 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Convert TEMP tablespace from datafiles to tempfiles
> 
> 
> Rich,
> 
> I have a better set of steps for you:
> 
> 1).  Create a new tablespace (TEMPLMT) and make it a LMT.
> 2).  One by one, issue ALTER USER {username} TEMPORARY 
> TABLESPACE TEMPLMT;
> 3).  Bounce the database
> 4).  DROP TABLESPACE TEMP INCLUDING CONTENTS;
> 5).  Backup the database
> 6).  Let users at it.
> 7).  Go have a beer.
> 
> The only "negative" here is that your TEMP tablespace is 
> called TEMPLMT, but
> it just doesn't matter.  If you want, you can do it again, this time
> creating the tablespace as TEMP if it makes you feel better.
> 
> Your method would work just fine.  Not sure if the users 
> would lose the
> designation of their TEMPORARY TABLESPACE, but if they do, 
> you can easily
> create a script to set their temp tablespace to TEMP again.
> 
> Hope this helps.
> 
> Tom Mercadante
> Oracle Certified Professional
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

Re:RE: How can I tell if MTS is activated -- more problems

[dgoulet]

What does your TNSNAMES.ORA file look like?  If there is a line in there
'(server=dedicated)' you might as well turn MTS off.

Dick Goulet

Reply Separator
Author: =?iso-8859-1?q?Pablo=20Rodriguez?= <[EMAIL PROTECTED]>
Date:   11/6/2002 11:39 AM

Dave,

   I've seen these processes (ora_S00... and
ora_d00..) but all connections are being made through
dedicated processes.

Here's my configuration:

mts_listener_address = "(ADDRESS=(PROTOCOL=TCP)
(HOST=10.20.81.78) (PORT=1521))"
mts_service  = PRUE1
mts_dispatchers  = "tcp,2"
mts_max_dispatchers  = 10
mts_servers  = 6
mts_max_servers  = 100


The listener has been started before the RDBMS:

listener.ora

LISTENER =
  (ADDRESS_LIST=
   
(ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=PRUE1)))
SID_LIST_LISTENER=
   (SID_LIST=
(SID_DESC=
  (GLOBAL_DBNAME=PRUE1)
  (SID_NAME=PRUE1)
  (ORACLE_HOME=/u01/app/oracle/product/8.1.7)
 )
   )


lsnrctl services

LSNRCTL for Linux: Version 8.1.7.0.0 - Production on
06-NOV-2002 16:40:58

(c) Copyright 1998 Oracle Corporation.  All rights
reserved.

Connecting to
(ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
Services Summary...
  PRUE1 has 2 service handler(s)
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
The command completed successfully


BUT the user processes are not using MTS.

Why aren't they using MTS?
What's wrong in this configuration?


thanks for your help.





--
To see how many dispatchers/shared servers are started
up with the RDBMS,  check the value of
'mts_dispatchers' and 'mts_servers' in the init.ora.  
You can also tell by looking in the alert.log(default
location is  $ORACLE_HOME/rdbms/log).
Sample:  
PMON started
DBWR started
LGWR started
RECO started
Thu Sep 14 09:24:15 1995
starting up 4 shared server(s) ...
starting up 4 dispatcher(s) for network
See Note:1012480.6 on Metastink for mor info on MTS
Processes

Dave

-Original Message-
Sent: Wednesday, November 06, 2002 10:59 AM
To: Multiple recipients of list ORACLE-L


Oracle 8i

How can I tell if MTS is activated?

Which parameters should I look at? (in init.ora and
listener.ora)


thanks
Pablo



___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
Descárgalo ya desde http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
  INET: [EMAIL PROTECTED]

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

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

___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
Descárgalo ya desde http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
  INET: [EMAIL PROTECTED]

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

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

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

RE: Oracle DBA with SAP Needed

[Cary Millsap]

An administrative requirement causes a lot of these types of postings
with odd-looking salary ranges. Chances are that the company already has
a foreign national candidate in the hiring pipeline for the job at this
salary. INS requires that US citizens be given a fair shot at the job
posting. One of the requirements is to advertise the position publicly.
Oracle-L is a public forum.

What usually happens is that either nobody applies for the position (the
salary's too low, so everybody pokes fun at it). Sometimes, somebody
does apply. But it's very unlikely that at this price, it'll be anyone
qualified.

Having seen this process to fruition and beyond, what often happens is
that the person immigrates to the US, works hard, and makes good. The
company benefits from good labor at a bargain price for at least a year
or two. The applicant benefits in several ways. He or she gets
physically to the USA, making well more than enough money than it takes
for most people to live on. If the person becomes indispensable, the
host company sponsors a green card application. From there, because the
person is free to compete in the USA job market, he or she begins making
the kind of money you'd expect.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on Oracle® System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas


-Original Message-
Sent: Wednesday, November 06, 2002 12:24 PM
To: Multiple recipients of list ORACLE-L

Well with the ridiculous salary they are offering, they could at least
train you in the use of SAP.  This is a Fortune 500 company after all.

-- 

Alan Davey
[EMAIL PROTECTED]
212-604-0200  x106


On 11/6/2002 10:56 AM, Paulo Gomes <[EMAIL PROTECTED]> wrote:
>unfortunatly i don't work with SAP or i would be interessed
>regards
>Paulo
>
>-Original Message-
>Sent: quarta-feira, 6 de Novembro de 2002 14:49
>To: Multiple recipients of list ORACLE-L
>
>
>If you are an Oracle DBA With SAP experience looking for a stable 
>company 
>where you can work within a great team environment, this company 
>in Toledo,
>Ohio 
>is the place for you. This Fortune 500 employer has experienced steady
>growth over
>the hundred years it has been in business and is looking for a top 
>notch
>candidate.
>This company is located in a very reasonable cost of living area 
>and offers
>a varied choice 
>of neighborhood communities.
>If you are looking for a place to grow within your career in a smaller 
>city
>atmosphere 
>this is the opportunity to check out. 
>
>Relocation Assistance is provided.
>
>PLEASE DO NOT send your resume for this position UNLESS you have 
>the skills 
>outlined below for this position.
>
>DO NOT send your resume unless you have a stable work history.
>Candidates whose work history includes frequent job changes connot 
>be
>considered.
>If you are employed by a consulting company you must have a long 
>term
>project history.
>
>This is a full time staff position so no sub-contractors or third 
>parties
>please.
>
>NO H-1B candidates please.
>
>*Requirements:
>-MUST be a team player.
>-3+ years Oracle DBA experience.
>-SAP experience
>-Must have experience with:Installation, Backup and recovery,
>Implementation, Conversion, 
> Performance tuning, Troubleshooting, Development, Database Design,
>Monitoring, and Support.
>-MUST have excellent communications skills
>-Major plusses are: SQL Backtrack, DB Artisan, Powerbuilder, Shell 
>scripting
>and experience with
> Sybase and/or SQL Server. 
>
>Base Salary is 55K-to maybe high 60s Firm.
>
>The employer itself offers a comprehensive medical plan, dental
insurance,
>life insurance, 
>sick leave and disability plans, a retirement plan, vacation days, 
>a 401K
>Plan, and much more. 
>
>For immediate consideration, please email your resume as an attachment 
>to:
>
>OraStaff, Inc.
>Email: [EMAIL PROTECTED]
>Phone: 1-800-549-8502. 
>Please Use Job Code: one/Toledo/DBA-SAP/Jenni
>
>I pay referral fees.
>So please contact me if you know of anyone who would be
qualified/interested
>in the position described above- if it is not a match for your skills.
>Thanks.
>
>
>
>
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: OraStaff
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and 
>in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Paulo Gomes
>  INET: [EMAIL PROTEC

RE: OCP Exams - What to study out of?

[Richards, Brian]

So you took and passed the upgrade exam already?

Brian

-Original Message-
Sent: Wednesday, November 06, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L


And I hope it is okay to take 9i New Features before you've finished all
your 8i modules, because I wound up taking a new features class to use up
some education money that was expiring. The Oracle instructor, John Hibbard,
is superb. He makes the class very entertaining and he has done a lot of
research outside the class manual and he throws that in as well. 
   I wanted a short "cram sheet" with a fast overview of topics likely to be
on the 9i New Features exam and ended up writing my own 5-page document, so
if anyone wants a copy, send me a private note and I'll send you a copy. No
guarantees, and if you find any errors, let me know.


Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Richards, Brian
  INET: [EMAIL PROTECTED]

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

RE: Oracle DBA with SAP Needed

[Adams, Matthew (GECP, MABG, 088130)]

Title: RE: Oracle DBA with SAP Needed





It's Toledo.  That ought to automatically 
double the salary.


"Saturday night in Toledo Ohio is like being nowhere at all
All through the day, how the hours rush by
you visit the park and you watch the grass die."


 -  John Denver

Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to kick boxing.


-Original Message-
From: Weaver, Walt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 06, 2002 3:01 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle DBA with SAP Needed



The fact that the job's in or near Toledo might have something to do with
the salary. I doubt the cost of living is that high around there.


--Walt Weaver
  Bozeman, Montana


-Original Message-
Sent: Wednesday, November 06, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L



I doubt they can fill this position at that salary.


Oracle DBA's that work with SAP can easily earn much more than that.


Jared







"Markham, Richard" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/06/2002 07:56 AM
 Please respond to ORACLE-L


 
    To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
    cc: 
    Subject:    RE: Oracle DBA with SAP Needed



What does "Base Salary is 55K-to maybe high 60s Firm." mean?  You can 
throw the possibility of a raise out the window? =) 
-Original Message- 
Sent: Wednesday, November 06, 2002 9:49 AM 
To: Multiple recipients of list ORACLE-L 


If you are an Oracle DBA With SAP experience looking for a stable company 
where you can work within a great team environment, this company in 
Toledo, 
Ohio 
is the place for you. This Fortune 500 employer has experienced steady 
growth over 
the hundred years it has been in business and is looking for a top notch 
candidate. 
This company is located in a very reasonable cost of living area and 
offers 
a varied choice 
of neighborhood communities. 
If you are looking for a place to grow within your career in a smaller 
city 
atmosphere 
this is the opportunity to check out. 
Relocation Assistance is provided. 
PLEASE DO NOT send your resume for this position UNLESS you have the 
skills 
outlined below for this position. 
DO NOT send your resume unless you have a stable work history. 
Candidates whose work history includes frequent job changes connot be 
considered. 
If you are employed by a consulting company you must have a long term 
project history. 
This is a full time staff position so no sub-contractors or third parties 
please. 
NO H-1B candidates please. 
*Requirements: 
-MUST be a team player. 
-3+ years Oracle DBA experience. 
-SAP experience 
-Must have experience with:Installation, Backup and recovery, 
Implementation, Conversion, 
 Performance tuning, Troubleshooting, Development, Database Design, 
Monitoring, and Support. 
-MUST have excellent communications skills 
-Major plusses are: SQL Backtrack, DB Artisan, Powerbuilder, Shell 
scripting 
and experience with 
 Sybase and/or SQL Server. 
Base Salary is 55K-to maybe high 60s Firm. 
The employer itself offers a comprehensive medical plan, dental insurance, 
life insurance, 
sick leave and disability plans, a retirement plan, vacation days, a 401K 
Plan, and much more. 
For immediate consideration, please email your resume as an attachment to: 
OraStaff, Inc. 
Email: [EMAIL PROTECTED] 
Phone: 1-800-549-8502. 
Please Use Job Code: one/Toledo/DBA-SAP/Jenni 
I pay referral fees. 
So please contact me if you know of anyone who would be 
qualified/interested 
in the position described above- if it is not a match for your skills. 
Thanks. 





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



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


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

Re: Convert TEMP tablespace from datafiles to tempfiles

[Ron Rogers]

List,
Would you please explain to me how you are able to get TEMP and LMT
combined together. I use 8.1.7 and it is not allowed.
"Oracle8i DBA Handbook" Loney and Theriault, Osborne Oracle Press, Page
598 NOTE 
"If you specify Local in a create tablespace command, you can not
specify a default storage clause, minextents, or temporary. If you use
the create temporary tablespace command to create the tablespace, you
can specify extent_management local."
The tablespace that is being created is a tablespace with type =
temporary not permanent? correct?
Ron
ROR mô¿ôm

>>> [EMAIL PROTECTED] 11/06/02 01:39PM >>>

Rich,

If you've got the disk space, do it while the DB is up.  Much simpler.

Create a new Temporary LMT - call it NewTemp - with the appropriate
tempfiles.

Switch everyone to NewTemp by spooling and executing this and running
the
spooled file:
Select 'Alter User ' || UserName || ' Temporary Tablespace NewTemp ;'
>From   DBA_Users;

After a day or two, or when you can determine that no one is using the
old
Temp tablespace, offline and drop Temp.

If you've just got to have the Temp tablespace named Temp, repeat the
above
steps to create a new Temp LMT.

Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
[EMAIL PROTECTED] 



   
 
"Jesse, Rich"  
 
 <[EMAIL PROTECTED]>  
 
Sent by:  cc:  
 
[EMAIL PROTECTED]   Subject: Convert TEMP
tablespace from  
m  datafiles to tempfiles  
 
   
 
   
 
11/06/2002 
 
09:56 AM   
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




Hey all,

I've got some downtime coming up on an 8.1.6 DB on Solaris, and I'd
like to
take the opportunity to convert the datafiles of the TEMP tablespace
to
tempfiles.  My reason for this change is primarily to get the TEMP
tablespace LMT, but also to shrink our hotbacks w/o modifying the
working
script.

I've been trying to reason out this task in my head, as I can't find
much
on
MetaLink, and here's what I've got so far:

1)  Shutdown DB.
2)  Backup DB.
3)  Startup restricted.
4)  Offline tablespace TEMP.
5)  Drop tablespace TEMP.
6)  Create new temporary TEMP LMT.
7)  Bounce instance.

I don't yet have an arena to try this in.  Will users whose assigned
TEMPORARY TABLESPACE is TEMP need to be ALTERed?  Anyone have any
comments
on the procedure?

TIA!

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex,
WI
USA



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

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

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

RE: Oracle to Excel

[Kevin Lange]

Title: Oracle to Excel



Brain 
freeze  thats the only reason I did not think of it   doh 
!

  -Original Message-From: Rodd Holman 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002 
  1:39 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Oracle to ExcelIs there a reason why you can't just 
  extract it directly in to Excel using ODBC or Oracle Objects for OLE?  
  ODBC would be the easiest, OO4OLE will give you the most control and better 
  macro scripting for auto updating.  Both of these come with the Oracle 
  client install. Rodd On Wed, 2002-11-06 at 13:12, Kevin Lange 
  wrote: 
  Without extra software the 
easiest way is to setup a delimited file in a sql statement and spool output 
to a file.  Then import the file into a spreadsheet. 
  If you have it, Toad will save data into 
spreadsheets for you. 
-Original 
  Message- From: Burton, Laura L. 
  [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 06, 2002 12:49 
  PM To: 
  Multiple recipients of list ORACLE-L Subject: Oracle to Excel I think I have seen traffic concerning the 
  extracting of data from Oracle into an Excel spreadsheet.  We now 
  have a need for this.  Could anyone enlighten me? 
  Thank you in advance. 
  Laura 
  
  


  -- 
Rodd Holman
Enterprise Data Systems Engineer
LodgeNet Entertainment Corporation
[EMAIL PROTECTED]

RE: Oracle DBA with SAP Needed

[DENNIS WILLIAMS]

Walt - I'm surprised to hear that from somebody in Montana. I would have
expected you to say "really expensive to live in the big city, pay for food
rather than just kill your own, rent a house rather than just cut down some
trees and make your own cabin, buy gas instead of ride your horse." Or maybe
Montana isn't what it used to be. ;-)

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, November 06, 2002 2:01 PM
To: Multiple recipients of list ORACLE-L


The fact that the job's in or near Toledo might have something to do with
the salary. I doubt the cost of living is that high around there.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, November 06, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L


I doubt they can fill this position at that salary.

Oracle DBA's that work with SAP can easily earn much more than that.

Jared






"Markham, Richard" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/06/2002 07:56 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Oracle DBA with SAP Needed


What does "Base Salary is 55K-to maybe high 60s Firm." mean?  You can 
throw the possibility of a raise out the window? =) 
-Original Message- 
Sent: Wednesday, November 06, 2002 9:49 AM 
To: Multiple recipients of list ORACLE-L 

If you are an Oracle DBA With SAP experience looking for a stable company 
where you can work within a great team environment, this company in 
Toledo, 
Ohio 
is the place for you. This Fortune 500 employer has experienced steady 
growth over 
the hundred years it has been in business and is looking for a top notch 
candidate. 
This company is located in a very reasonable cost of living area and 
offers 
a varied choice 
of neighborhood communities. 
If you are looking for a place to grow within your career in a smaller 
city 
atmosphere 
this is the opportunity to check out. 
Relocation Assistance is provided. 
PLEASE DO NOT send your resume for this position UNLESS you have the 
skills 
outlined below for this position. 
DO NOT send your resume unless you have a stable work history. 
Candidates whose work history includes frequent job changes connot be 
considered. 
If you are employed by a consulting company you must have a long term 
project history. 
This is a full time staff position so no sub-contractors or third parties 
please. 
NO H-1B candidates please. 
*Requirements: 
-MUST be a team player. 
-3+ years Oracle DBA experience. 
-SAP experience 
-Must have experience with:Installation, Backup and recovery, 
Implementation, Conversion, 
 Performance tuning, Troubleshooting, Development, Database Design, 
Monitoring, and Support. 
-MUST have excellent communications skills 
-Major plusses are: SQL Backtrack, DB Artisan, Powerbuilder, Shell 
scripting 
and experience with 
 Sybase and/or SQL Server. 
Base Salary is 55K-to maybe high 60s Firm. 
The employer itself offers a comprehensive medical plan, dental insurance, 
life insurance, 
sick leave and disability plans, a retirement plan, vacation days, a 401K 
Plan, and much more. 
For immediate consideration, please email your resume as an attachment to: 
OraStaff, Inc. 
Email: [EMAIL PROTECTED] 
Phone: 1-800-549-8502. 
Please Use Job Code: one/Toledo/DBA-SAP/Jenni 
I pay referral fees. 
So please contact me if you know of anyone who would be 
qualified/interested 
in the position described above- if it is not a match for your skills. 
Thanks. 




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


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

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

RE: Data Purging Strategy

[Rachel Carmichael]

Port finish is better :)


--- [EMAIL PROTECTED] wrote:
> That reminds me:
> 
> Mark, your annual stipend is due.
> 
> Make it a case of Glenmorangie this time, Sherry finish.  :)
> 
> Jared
> 
> 
> 
> 
> 
> 
> [EMAIL PROTECTED]
> Sent by: [EMAIL PROTECTED]
>  11/06/2002 07:56 AM
>  Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:RE: Data Purging Strategy
> 
> 
> Hey Dennis,
> Mark Leith is the only person on this list allowed to mention 3rd
> party
> products.
> I am sure he bought the franchise from Jared :)
> 
> John
> 
> -Original Message-
> Sent: 06 November 2002 14:15
> To: Multiple recipients of list ORACLE-L
> 
> 
> Prem - You are receiving some excellent advice from Tom and Tim. I
> would
> mention two items in addition:
>   - If you ever hope to re-use the data you archive off-line, you
> must 
> also
> archive all the related tables, because after all, this is a
> RELATIONAL
> database.
>   - PrincetonSoftech has a product Active Archiving that looks pretty
> good
> from the demos I've seen. I haven't used it myself.
> 
> 
> 
> Dennis Williams 
> DBA, 40%OCP 
> Lifetouch, Inc. 
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Wednesday, November 06, 2002 6:54 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Prem,
>  
> I would re-visit the requirement.  Why do you feel the need to delete
> the
> data from the database?  What is the purpose for this type of
> requirement?
> It would be far easier to modify the requirement than to do what you
> are
> thinking of doing.
>  
> Adding columns to database tables indicating that a record has passed
> it's
> retention policy and thus, is not included in queries, would be a
> much
> easier solution.
>  
> Or, simply moving these records to historical tables in the database
> - and
> NOT deleting them from the system - is a much better solution.  The
> data 
> is
> always accessible and not available in the current tables.  And you
> will 
> not
> be playing the "get the data from tape and reload it" game with all
> of 
> it's
> problems (writing an offload program, table structure changes &
> offload
> program versions).
>  
> Try and keep this as simple as possible.
>  
> Hope this helps
>  
> Tom Mercadante 
> Oracle Certified Professional 
> 
> -Original Message-
> Sent: Wednesday, November 06, 2002 4:13 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Dear List, 
> 
> I need some inputs from you all regarding purging data from the
> database. 
> 
> This is the requirement 
> 
> 
> We define a retention period for all the data in the system. 
> When the retention period is reached,  the data should be deleted,
> but 
> then
> at a later time, some user might request for this purged data. So it
> must 
> be
> possible to retrieve this data. 
> 
> This is the strategy we have designed for this. 
> 
> When the retention period is reached, move the data from the main
> database
> to an offline database. Then delete the data from the main database. 
> 
> In the offline database, we cannot again keep it from long, so it has
> to
> moved to tapes. Now my question, how can we move this data to tapes
> and at
> the same time retrieve data from the tapes based on dates. 
> i.e, the user will ask for the data on a particular date, so it must
> be
> possible to retrieve data from the tapes based on a date and load it
> to 
> the
> database tables. 
> 
> Regards 
> Prem 
> 
>  
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECT

Re: Help required: Enterprise Manager Console -> Export/Import/Backup

[Reginald . W . Bailey]

You need to set the credentials for the node.  If you are doing an export
on the node, OEM must be able to log into the node.  As good practice, you
should create a valid userid and password for each node listed by OEM.  OEM
cannot run a job on a node without having a userid to log onto the node
with.

RWB


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

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

wrong financial calendar for an open period in 10.7 NCA

[Mandar A. Ghosalkar]

Hello Guys,

i have posted this in Oracle apps mailing list also.

We have a situation here. We have an Open Period for Oct defined as 01/oct/02 to 
30/oct/02.

We posted AP with no problems. While importing the sales from a different 
application(non-oracle) into GL we received errors in the journal import concurrent 
program.

Since the Oct end date is wrong, we found 3 different options infront of us to get 
this problem solved.

1. Oracle Supported way.
Create different set of books and consolidate. Yuck

2. Oracle unsupported way. 
Rollback the entries for Oct.
Correct calendar.
repost entries.
This has to be tested on the test instance first.

3. Oracle unsupported way. 
Since the entries in the GL Interface have not been posted yet, change the 
31/oct/02 transactions to reflect 30/oct/02 and reimport the entries. This has to be 
done for sales/credits/payroll which use non-oracle applications.

Tar has been raised with metalink.

I was wondering if any of ull have gone through this situation and would appreciate 
your inputs.

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

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

RE: Oracle DBA with SAP Needed

[Weaver, Walt]

The fact that the job's in or near Toledo might have something to do with
the salary. I doubt the cost of living is that high around there.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Wednesday, November 06, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L


I doubt they can fill this position at that salary.

Oracle DBA's that work with SAP can easily earn much more than that.

Jared






"Markham, Richard" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/06/2002 07:56 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Oracle DBA with SAP Needed


What does "Base Salary is 55K-to maybe high 60s Firm." mean?  You can 
throw the possibility of a raise out the window? =) 
-Original Message- 
Sent: Wednesday, November 06, 2002 9:49 AM 
To: Multiple recipients of list ORACLE-L 

If you are an Oracle DBA With SAP experience looking for a stable company 
where you can work within a great team environment, this company in 
Toledo, 
Ohio 
is the place for you. This Fortune 500 employer has experienced steady 
growth over 
the hundred years it has been in business and is looking for a top notch 
candidate. 
This company is located in a very reasonable cost of living area and 
offers 
a varied choice 
of neighborhood communities. 
If you are looking for a place to grow within your career in a smaller 
city 
atmosphere 
this is the opportunity to check out. 
Relocation Assistance is provided. 
PLEASE DO NOT send your resume for this position UNLESS you have the 
skills 
outlined below for this position. 
DO NOT send your resume unless you have a stable work history. 
Candidates whose work history includes frequent job changes connot be 
considered. 
If you are employed by a consulting company you must have a long term 
project history. 
This is a full time staff position so no sub-contractors or third parties 
please. 
NO H-1B candidates please. 
*Requirements: 
-MUST be a team player. 
-3+ years Oracle DBA experience. 
-SAP experience 
-Must have experience with:Installation, Backup and recovery, 
Implementation, Conversion, 
 Performance tuning, Troubleshooting, Development, Database Design, 
Monitoring, and Support. 
-MUST have excellent communications skills 
-Major plusses are: SQL Backtrack, DB Artisan, Powerbuilder, Shell 
scripting 
and experience with 
 Sybase and/or SQL Server. 
Base Salary is 55K-to maybe high 60s Firm. 
The employer itself offers a comprehensive medical plan, dental insurance, 
life insurance, 
sick leave and disability plans, a retirement plan, vacation days, a 401K 
Plan, and much more. 
For immediate consideration, please email your resume as an attachment to: 
OraStaff, Inc. 
Email: [EMAIL PROTECTED] 
Phone: 1-800-549-8502. 
Please Use Job Code: one/Toledo/DBA-SAP/Jenni 
I pay referral fees. 
So please contact me if you know of anyone who would be 
qualified/interested 
in the position described above- if it is not a match for your skills. 
Thanks. 




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


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

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

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

Re: Oracle to Excel

[Jared . Still]

If you can live with dumping to a comma delimited file, just do that
and import to Excel.

If you want to write directly to an Excel format, you could do that
with Perl.  Have any Perl programmers around?

Here's an example of one.  Not really too much code.

Jared

=

#!/home/oracle/perl/bin/perl

# template for DBI programs

use warnings;
use FileHandle;
use DBI;
use strict;
use Spreadsheet::WriteExcel;
use Spreadsheet::WriteExcel::Big;
use Getopt::Long;
use constant LINES_PER_BOOK => 60001;

# flush buffers
$|++;

my %optctl = ();

Getopt::Long::GetOptions(
\%optctl,
"database=s",
"username=s",
"password=s",
"sysdba!",
"sysoper!",
"z","h","help");

my($db, $username, $password, $connectionMode);

$connectionMode = 0;
if ( $optctl{sysoper} ) { $connectionMode = 4 }
if ( $optctl{sysdba} ) { $connectionMode = 2 }

if ( ! defined($optctl{database}) ) {
Usage();
die "database required\n";
}
$db=$optctl{database};

if ( ! defined($optctl{username}) ) {
Usage();
die "username required\n";
}

$username=$optctl{username};
$password = $optctl{password};

my $dbh = DBI->connect(
'dbi:Oracle:' . $db,
$username, $password,
{
RaiseError => 1,
AutoCommit => 0,
ora_session_mode => $connectionMode
}
);

die "Connect to  $db failed \n" unless $dbh;

$dbh->{RowCacheSize} = 100;

my $sql=q{
select *
from myschema.mytable
--where rownum < 10001
where year = '2000' -- year
and month = '01' -- month
order by year, month
};

print "Preparing SQL\n";

my $sth = $dbh->prepare($sql);

print "Executing SQL\n";

$sth->execute;

print "Creating Workbook\n";

my $workbook  = Spreadsheet::WriteExcel::Big->new(newWorkBookName());
die "unable to create workbook - $!\n" unless $workbook;
$workbook->set_tempdir('/u03/tmp');
my $worksheet = $workbook->addworksheet();

my $colNames = $sth->{NAME_uc};

print "Fetching data\n";

my $rowCount=0;
my $lineCount=0;
$worksheet->write_row($lineCount,0,$colNames);
print "\n";

while( my $ary = $sth->fetchrow_arrayref ) {

print "." unless $rowCount++%1000;

if ( ++$lineCount >= LINES_PER_BOOK ) {
$workbook->close;
my $workBookName = newWorkBookName();
$workbook  = 
Spreadsheet::WriteExcel::Big->new($workBookName);
die "unable to create workbook - $!\n" unless $workbook;
$worksheet = $workbook->addworksheet();
$lineCount=0;
$worksheet->write_row($lineCount,0,$colNames);
$lineCount=1;
print "\nNew Workbook: $workBookName\n";
}
$worksheet->write_row($lineCount,0,$ary);
}

print "\n";

$workbook->close;
$sth->finish;
$dbh->disconnect;

sub Usage {
print "\n";
print "usage:  we.pl\n";
print "we.pl -database dv07 -username scott -password tiger 
[-sysdba || -sysoper]\n";
print "\n";
}


{

my $workBookNumber = 0;
sub newWorkBookName {
return "/u01/tmp/excel_dump_" . ++$workBookNumber . ".xls";
}

}







"Burton, Laura L." <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/06/2002 10:48 AM
 Please respond to ORACLE-L

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


I think I have seen traffic concerning the extracting of data from Oracle 
into an Excel spreadsheet.  We now have a need for this.  Could anyone 
enlighten me?
Thank you in advance.
Laura 


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

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

RE: Oracle to Excel

[Rodd Holman]

Title: Oracle to Excel




Is there a reason why you can't just extract it directly in to Excel using ODBC or Oracle Objects for OLE?  ODBC would be the easiest, OO4OLE will give you the most control and better macro scripting for auto updating.  Both of these come with the Oracle client install.



Rodd



On Wed, 2002-11-06 at 13:12, Kevin Lange wrote:

Without extra software the easiest way is to setup a delimited file in a sql statement and spool output to a file.  Then import the file into a spreadsheet.

 

If you have it, Toad will save data into spreadsheets for you.

-Original Message-

From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]

Sent: Wednesday, November 06, 2002 12:49 PM

To: Multiple recipients of list ORACLE-L

Subject: Oracle to Excel







I think I have seen traffic concerning the extracting of data from Oracle into an Excel spreadsheet.  We now have a need for this.  Could anyone enlighten me?



Thank you in advance.



Laura







-- 
Rodd Holman
Enterprise Data Systems Engineer
LodgeNet Entertainment Corporation
[EMAIL PROTECTED]

RE: How can I tell if MTS is activated -- more problems

[Pablo Rodriguez]

Dave,

   I've seen these processes (ora_S00... and
ora_d00..) but all connections are being made through
dedicated processes.

Here's my configuration:

mts_listener_address = "(ADDRESS=(PROTOCOL=TCP)
(HOST=10.20.81.78) (PORT=1521))"
mts_service  = PRUE1
mts_dispatchers  = "tcp,2"
mts_max_dispatchers  = 10
mts_servers  = 6
mts_max_servers  = 100


The listener has been started before the RDBMS:

listener.ora

LISTENER =
  (ADDRESS_LIST=
   
(ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=PRUE1)))
SID_LIST_LISTENER=
   (SID_LIST=
(SID_DESC=
  (GLOBAL_DBNAME=PRUE1)
  (SID_NAME=PRUE1)
  (ORACLE_HOME=/u01/app/oracle/product/8.1.7)
 )
   )


lsnrctl services

LSNRCTL for Linux: Version 8.1.7.0.0 - Production on
06-NOV-2002 16:40:58

(c) Copyright 1998 Oracle Corporation.  All rights
reserved.

Connecting to
(ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
Services Summary...
  PRUE1 has 2 service handler(s)
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
DEDICATED SERVER established:0 refused:0
  LOCAL SERVER
The command completed successfully


BUT the user processes are not using MTS.

Why aren't they using MTS?
What's wrong in this configuration?


thanks for your help.





--
To see how many dispatchers/shared servers are started
up with the RDBMS,  check the value of
'mts_dispatchers' and 'mts_servers' in the init.ora.  
You can also tell by looking in the alert.log(default
location is  $ORACLE_HOME/rdbms/log).
Sample:  
PMON started
DBWR started
LGWR started
RECO started
Thu Sep 14 09:24:15 1995
starting up 4 shared server(s) ...
starting up 4 dispatcher(s) for network
See Note:1012480.6 on Metastink for mor info on MTS
Processes

Dave

-Original Message-
Sent: Wednesday, November 06, 2002 10:59 AM
To: Multiple recipients of list ORACLE-L


Oracle 8i

How can I tell if MTS is activated?

Which parameters should I look at? (in init.ora and
listener.ora)


thanks
Pablo



___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
Descárgalo ya desde http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
  INET: [EMAIL PROTECTED]

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

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

___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
Descárgalo ya desde http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
  INET: [EMAIL PROTECTED]

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

Re: Oracle DBA with SAP Needed

[Rachna Vaidya]

Makes sense if...
"Base Salary is 155K-to maybe high 160s Firm."

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 2:12 PM


I doubt they can fill this position at that salary.

Oracle DBA's that work with SAP can easily earn much more than that.

Jared






"Markham, Richard" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/06/2002 07:56 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Oracle DBA with SAP Needed


What does "Base Salary is 55K-to maybe high 60s Firm." mean?  You can 
throw the possibility of a raise out the window? =) 
-Original Message- 
Sent: Wednesday, November 06, 2002 9:49 AM 
To: Multiple recipients of list ORACLE-L 

If you are an Oracle DBA With SAP experience looking for a stable company 
where you can work within a great team environment, this company in 
Toledo, 
Ohio 
is the place for you. This Fortune 500 employer has experienced steady 
growth over 
the hundred years it has been in business and is looking for a top notch 
candidate. 
This company is located in a very reasonable cost of living area and 
offers 
a varied choice 
of neighborhood communities. 
If you are looking for a place to grow within your career in a smaller 
city 
atmosphere 
this is the opportunity to check out. 
Relocation Assistance is provided. 
PLEASE DO NOT send your resume for this position UNLESS you have the 
skills 
outlined below for this position. 
DO NOT send your resume unless you have a stable work history. 
Candidates whose work history includes frequent job changes connot be 
considered. 
If you are employed by a consulting company you must have a long term 
project history. 
This is a full time staff position so no sub-contractors or third parties 
please. 
NO H-1B candidates please. 
*Requirements: 
-MUST be a team player. 
-3+ years Oracle DBA experience. 
-SAP experience 
-Must have experience with:Installation, Backup and recovery, 
Implementation, Conversion, 
 Performance tuning, Troubleshooting, Development, Database Design, 
Monitoring, and Support. 
-MUST have excellent communications skills 
-Major plusses are: SQL Backtrack, DB Artisan, Powerbuilder, Shell 
scripting 
and experience with 
 Sybase and/or SQL Server. 
Base Salary is 55K-to maybe high 60s Firm. 
The employer itself offers a comprehensive medical plan, dental insurance, 
life insurance, 
sick leave and disability plans, a retirement plan, vacation days, a 401K 
Plan, and much more. 
For immediate consideration, please email your resume as an attachment to: 
OraStaff, Inc. 
Email: [EMAIL PROTECTED] 
Phone: 1-800-549-8502. 
Please Use Job Code: one/Toledo/DBA-SAP/Jenni 
I pay referral fees. 
So please contact me if you know of anyone who would be 
qualified/interested 
in the position described above- if it is not a match for your skills. 
Thanks. 




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


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

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

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

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

Re: Convert TEMP tablespace from datafiles to tempfiles

[Jared . Still]

If have the space, create the new TEMP tablespace first, alter all users
that have the old one to now use the new one, drop the old tablespace.

Jared






"Jesse, Rich" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/06/2002 07:56 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Convert TEMP tablespace from datafiles to tempfiles


Hey all,

I've got some downtime coming up on an 8.1.6 DB on Solaris, and I'd like 
to
take the opportunity to convert the datafiles of the TEMP tablespace to
tempfiles.  My reason for this change is primarily to get the TEMP
tablespace LMT, but also to shrink our hotbacks w/o modifying the working
script.

I've been trying to reason out this task in my head, as I can't find much 
on
MetaLink, and here's what I've got so far:

1)  Shutdown DB.
2)  Backup DB.
3)  Startup restricted.
4)  Offline tablespace TEMP.
5)  Drop tablespace TEMP.
6)  Create new temporary TEMP LMT.
7)  Bounce instance.

I don't yet have an arena to try this in.  Will users whose assigned
TEMPORARY TABLESPACE is TEMP need to be ALTERed?  Anyone have any comments
on the procedure?

TIA!

Rich


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

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



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

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

RE: SQL Brain Teaser Challenge

[Jared . Still]

I'm seeing some very strange results using _new_connect_by_enabled = true

Login to the database, run these 2 commands:

alter session set "_new_connect_by_enabled" = true;


  1  SELECT *
  2  FROM (SELECT * FROM treenode ORDER BY parentid, nodeorder)
  3  START WITH parentid=0
  4  CONNECT BY PRIOR ID = parentid
  5* order by parentid, nodeorder
11:22:48 rsysdevdb.radisys.com - jkstill@dv01 SQL> /

ID   PARENTID  NODEORDER DESCRIPTION
-- -- -- 
 1  0  0 top folder
 9  1  0 1st subfolder
 2  1  1 2nd subfolder
 4  2  1 folder 2 item 1
 3  2  2 folder 2 item 2
10  3  1 nested folder2.2.1
11 10  2 nested folder2.2.2
 6  2  3 folder 2 item 3
 7  1  2 3rd subfolder
 5  7  0 folder 3 item 1
 8  7  1 folder 3 item 2

11 rows selected.

11:22:49 rsysdevdb.radisys.com - jkstill@dv01 SQL>


These are the expected results.  Now I comment out the 'FROM' clause, and 
add a 
new FROM and ORDER by:

SELECT *
-- FROM (SELECT * FROM treenode ORDER BY parentid, nodeorder)
from treenode
START WITH parentid=0
CONNECT BY PRIOR ID = parentid
order by parentid, nodeorder;

Here are the results:

  SELECT *
  2  -- FROM (SELECT * FROM treenode ORDER BY parentid, nodeorder)
  3  from treenode
  4  START WITH parentid=0
  5  CONNECT BY PRIOR ID = parentid
  6* order by parentid, nodeorder
11:24:21 rsysdevdb.radisys.com - jkstill@dv01 SQL> /

ID   PARENTID  NODEORDER DESCRIPTION
-- -- -- 
 1  0  0 top folder
 9  1  0 1st subfolder
 2  1  1 2nd subfolder
 4  2  1 folder 2 item 1
 3  2  2 folder 2 item 2
10  3  1 nested folder2.2.1
11 10  2 nested folder2.2.2
 6  2  3 folder 2 item 3
 7  1  2 3rd subfolder
 5  7  0 folder 3 item 1
 8  7  1 folder 3 item 2

11 rows selected.

11:24:22 rsysdevdb.radisys.com - jkstill@dv01 SQL>

Hey look!  The output is working just the way we would like,
without the inline view.

Now, remove the commented out line:

SELECT *
from treenode
START WITH parentid=0
CONNECT BY PRIOR ID = parentid
order by parentid, nodeorder;


And the resulting output:


 1  SELECT *
  2  from treenode
  3  START WITH parentid=0
  4  CONNECT BY PRIOR ID = parentid
  5* order by parentid, nodeorder
11:25:12 rsysdevdb.radisys.com - jkstill@dv01 SQL> /

ID   PARENTID  NODEORDER DESCRIPTION
-- -- -- 
 1  0  0 top folder
 9  1  0 1st subfolder
 2  1  1 2nd subfolder
 7  1  2 3rd subfolder
 4  2  1 folder 2 item 1
 3  2  2 folder 2 item 2
 6  2  3 folder 2 item 3
10  3  1 nested folder2.2.1
 5  7  0 folder 3 item 1
 8  7  1 folder 3 item 2
11 10  2 nested folder2.2.2

11 rows selected.

11:25:13 rsysdevdb.radisys.com - jkstill@dv01 SQL>


Interesting, no?


Jared










"Madhavan Amruthur" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/06/2002 08:23 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: SQL Brain Teaser Challenge


Hi Steve,
You can get the below query to work in 8.1.7 (not sure about previous
versions) by setting the undoc parameter _new_connect_by_enabled = true
and can be set for a session

SELECT * 
FROM (SELECT * FROM treenode ORDER BY parentid, nodeorder) 
START WITH parentid=0 
CONNECT BY PRIOR ID = parentid 

You can also use sys_connect_by_path feature in 9i which gives you the
entire hierarchy path  (can be used in 8i with the above undoc parameter)

For eg:

select sys_connect_by_path(parent_id,'/')
from treenode
start with parent_id = 0
connect by prior id = parent_id

will give you a output like 
0/1/9
0/1/2
0/1/2/4

...etc

As always setting an undoc parameter is not advisable unless instructed
by Oracle support :-)

Hope this helps.
Regards,

Madhavan
http://www.dpapps.com

-- 
Madhavan Amruthur
DecisionPoint Applications

--
http://fastmail.fm - The holy hand grenade of email services
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Madhavan Amruthur
  INET: [EMAIL PROTECTED]

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

RE: Oracle to Excel

[Mercadante, Thomas F]

Title: Oracle to Excel



Laura,
 
lots 
of tools do this for you automatically.  Oracle discoverer will export the 
results of a query directly into Excel format.
 
You 
can do this yourself as follows:
 
in 
SqlPLus
 
select 
col1||chr(10)||col2||chr(10)
from 
table.
 
the 
chr(10) is the tab character.
spool 
the results to a output.xls
 
open 
the file using excel.  the tab character is the default column 
delimiter.  You should see all your data in cells.
 
hope 
this helps.
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Burton, Laura L. 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002 
  1:49 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle to Excel
  I think I have seen traffic concerning 
  the extracting of data from Oracle into an Excel spreadsheet.  We now 
  have a need for this.  Could anyone enlighten me?
  Thank you in advance.
  Laura 

RE: Oracle to Excel

[Saira Somani]

Title: Oracle to Excel









I usually spool my queries to a .txt (ascii) file and import into Excel.
Easiest way for me. I’m sure there are other
more sophisticated solutions out there.

 

Regards,

Saira

 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
On Behalf Of Burton, Laura L.
Sent: November 6, 2002 1:49 PM
To: Multiple recipients of list
ORACLE-L
Subject: Oracle to Excel

 

I think I have seen traffic concerning the extracting
of data from Oracle into an Excel spreadsheet.  We now have a need for
this.  Could anyone enlighten me?

Thank you in advance.

Laura 

RE: Oracle DBA with SAP Needed

[Jared . Still]

I doubt they can fill this position at that salary.

Oracle DBA's that work with SAP can easily earn much more than that.

Jared






"Markham, Richard" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/06/2002 07:56 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Oracle DBA with SAP Needed


What does "Base Salary is 55K-to maybe high 60s Firm." mean?  You can 
throw the possibility of a raise out the window? =) 
-Original Message- 
Sent: Wednesday, November 06, 2002 9:49 AM 
To: Multiple recipients of list ORACLE-L 

If you are an Oracle DBA With SAP experience looking for a stable company 
where you can work within a great team environment, this company in 
Toledo, 
Ohio 
is the place for you. This Fortune 500 employer has experienced steady 
growth over 
the hundred years it has been in business and is looking for a top notch 
candidate. 
This company is located in a very reasonable cost of living area and 
offers 
a varied choice 
of neighborhood communities. 
If you are looking for a place to grow within your career in a smaller 
city 
atmosphere 
this is the opportunity to check out. 
Relocation Assistance is provided. 
PLEASE DO NOT send your resume for this position UNLESS you have the 
skills 
outlined below for this position. 
DO NOT send your resume unless you have a stable work history. 
Candidates whose work history includes frequent job changes connot be 
considered. 
If you are employed by a consulting company you must have a long term 
project history. 
This is a full time staff position so no sub-contractors or third parties 
please. 
NO H-1B candidates please. 
*Requirements: 
-MUST be a team player. 
-3+ years Oracle DBA experience. 
-SAP experience 
-Must have experience with:Installation, Backup and recovery, 
Implementation, Conversion, 
 Performance tuning, Troubleshooting, Development, Database Design, 
Monitoring, and Support. 
-MUST have excellent communications skills 
-Major plusses are: SQL Backtrack, DB Artisan, Powerbuilder, Shell 
scripting 
and experience with 
 Sybase and/or SQL Server. 
Base Salary is 55K-to maybe high 60s Firm. 
The employer itself offers a comprehensive medical plan, dental insurance, 
life insurance, 
sick leave and disability plans, a retirement plan, vacation days, a 401K 
Plan, and much more. 
For immediate consideration, please email your resume as an attachment to: 
OraStaff, Inc. 
Email: [EMAIL PROTECTED] 
Phone: 1-800-549-8502. 
Please Use Job Code: one/Toledo/DBA-SAP/Jenni 
I pay referral fees. 
So please contact me if you know of anyone who would be 
qualified/interested 
in the position described above- if it is not a match for your skills. 
Thanks. 




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


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

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

RE: OCP Exams - What to study out of?

[DENNIS WILLIAMS]

And I hope it is okay to take 9i New Features before you've finished all
your 8i modules, because I wound up taking a new features class to use up
some education money that was expiring. The Oracle instructor, John Hibbard,
is superb. He makes the class very entertaining and he has done a lot of
research outside the class manual and he throws that in as well. 
   I wanted a short "cram sheet" with a fast overview of topics likely to be
on the 9i New Features exam and ended up writing my own 5-page document, so
if anyone wants a copy, send me a private note and I'll send you a copy. No
guarantees, and if you find any errors, let me know.


Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, November 06, 2002 12:29 PM
To: Multiple recipients of list ORACLE-L


You are not wrong! And I, too, am doing OCP 8i, then the upgrade. Using the
Couchman study guide and sample tests books, Self Test Software sample
tests, and (don't laugh) the CBTs by SmartForce (since our company paid for
them, might as well use them).
 
Brian
60% 8i OCP (SQL, B&R, A & A)
 
-Original Message-
Sent: Wednesday, November 06, 2002 12:04 PM
To: Multiple recipients of list ORACLE-L


I took 8i - am taking 8i because I am hoping that then I can just take an
upgrade exam for 9i without the $1,000+ course requirement.  I believe that
is still the case.  Please tell me if I am wrong. 

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

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

RE: Oracle to Excel

[Kevin Lange]

Title: Oracle to Excel



Without extra software the easiest way is to setup a delimited file in a 
sql statement and spool output to a file.  Then import the file into a 
spreadsheet.
 
If you 
have it, Toad will save data into spreadsheets for you.

  -Original Message-From: Burton, Laura L. 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002 
  12:49 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle to Excel
  I think I have seen traffic concerning 
  the extracting of data from Oracle into an Excel spreadsheet.  We now 
  have a need for this.  Could anyone enlighten me?
  Thank you in advance.
  Laura 

RE: Data Purging Strategy

[Jared . Still]

That reminds me:

Mark, your annual stipend is due.

Make it a case of Glenmorangie this time, Sherry finish.  :)

Jared






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 11/06/2002 07:56 AM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Data Purging Strategy


Hey Dennis,
Mark Leith is the only person on this list allowed to mention 3rd party
products.
I am sure he bought the franchise from Jared :)

John

-Original Message-
Sent: 06 November 2002 14:15
To: Multiple recipients of list ORACLE-L


Prem - You are receiving some excellent advice from Tom and Tim. I would
mention two items in addition:
  - If you ever hope to re-use the data you archive off-line, you must 
also
archive all the related tables, because after all, this is a RELATIONAL
database.
  - PrincetonSoftech has a product Active Archiving that looks pretty good
from the demos I've seen. I haven't used it myself.



Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, November 06, 2002 6:54 AM
To: Multiple recipients of list ORACLE-L


Prem,
 
I would re-visit the requirement.  Why do you feel the need to delete the
data from the database?  What is the purpose for this type of requirement?
It would be far easier to modify the requirement than to do what you are
thinking of doing.
 
Adding columns to database tables indicating that a record has passed it's
retention policy and thus, is not included in queries, would be a much
easier solution.
 
Or, simply moving these records to historical tables in the database - and
NOT deleting them from the system - is a much better solution.  The data 
is
always accessible and not available in the current tables.  And you will 
not
be playing the "get the data from tape and reload it" game with all of 
it's
problems (writing an offload program, table structure changes & offload
program versions).
 
Try and keep this as simple as possible.
 
Hope this helps
 
Tom Mercadante 
Oracle Certified Professional 

-Original Message-
Sent: Wednesday, November 06, 2002 4:13 AM
To: Multiple recipients of list ORACLE-L



Dear List, 

I need some inputs from you all regarding purging data from the database. 

This is the requirement 


We define a retention period for all the data in the system. 
When the retention period is reached,  the data should be deleted, but 
then
at a later time, some user might request for this purged data. So it must 
be
possible to retrieve this data. 

This is the strategy we have designed for this. 

When the retention period is reached, move the data from the main database
to an offline database. Then delete the data from the main database. 

In the offline database, we cannot again keep it from long, so it has to
moved to tapes. Now my question, how can we move this data to tapes and at
the same time retrieve data from the tapes based on dates. 
i.e, the user will ask for the data on a particular date, so it must be
possible to retrieve data from the tapes based on a date and load it to 
the
database tables. 

Regards 
Prem 

 

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

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

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



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

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

Oracle to Excel

[Burton, Laura L.]

Title: Oracle to Excel





I think I have seen traffic concerning the extracting of data from Oracle into an Excel spreadsheet.  We now have a need for this.  Could anyone enlighten me?

Thank you in advance.

Laura 

Re: Convert TEMP tablespace from datafiles to tempfiles

[JApplewhite]

Rich,

If you've got the disk space, do it while the DB is up.  Much simpler.

Create a new Temporary LMT - call it NewTemp - with the appropriate
tempfiles.

Switch everyone to NewTemp by spooling and executing this and running the
spooled file:
Select 'Alter User ' || UserName || ' Temporary Tablespace NewTemp ;'
>From   DBA_Users;

After a day or two, or when you can determine that no one is using the old
Temp tablespace, offline and drop Temp.

If you've just got to have the Temp tablespace named Temp, repeat the above
steps to create a new Temp LMT.

Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
[EMAIL PROTECTED]



   
  
"Jesse, Rich"  
  
 <[EMAIL PROTECTED]>  
  
Sent by:  cc:  
  
[EMAIL PROTECTED]   Subject: Convert TEMP tablespace from
  
m  datafiles to tempfiles  
  
   
  
   
  
11/06/2002 
  
09:56 AM   
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




Hey all,

I've got some downtime coming up on an 8.1.6 DB on Solaris, and I'd like to
take the opportunity to convert the datafiles of the TEMP tablespace to
tempfiles.  My reason for this change is primarily to get the TEMP
tablespace LMT, but also to shrink our hotbacks w/o modifying the working
script.

I've been trying to reason out this task in my head, as I can't find much
on
MetaLink, and here's what I've got so far:

1)  Shutdown DB.
2)  Backup DB.
3)  Startup restricted.
4)  Offline tablespace TEMP.
5)  Drop tablespace TEMP.
6)  Create new temporary TEMP LMT.
7)  Bounce instance.

I don't yet have an arena to try this in.  Will users whose assigned
TEMPORARY TABLESPACE is TEMP need to be ALTERed?  Anyone have any comments
on the procedure?

TIA!

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI
USA



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

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

RE: Convert TEMP tablespace from datafiles to tempfiles

[Mercadante, Thomas F]

Rich,

I have a better set of steps for you:

1).  Create a new tablespace (TEMPLMT) and make it a LMT.
2).  One by one, issue ALTER USER {username} TEMPORARY TABLESPACE TEMPLMT;
3).  Bounce the database
4).  DROP TABLESPACE TEMP INCLUDING CONTENTS;
5).  Backup the database
6).  Let users at it.
7).  Go have a beer.

The only "negative" here is that your TEMP tablespace is called TEMPLMT, but
it just doesn't matter.  If you want, you can do it again, this time
creating the tablespace as TEMP if it makes you feel better.

Your method would work just fine.  Not sure if the users would lose the
designation of their TEMPORARY TABLESPACE, but if they do, you can easily
create a script to set their temp tablespace to TEMP again.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, November 06, 2002 10:56 AM
To: Multiple recipients of list ORACLE-L


Hey all,

I've got some downtime coming up on an 8.1.6 DB on Solaris, and I'd like to
take the opportunity to convert the datafiles of the TEMP tablespace to
tempfiles.  My reason for this change is primarily to get the TEMP
tablespace LMT, but also to shrink our hotbacks w/o modifying the working
script.

I've been trying to reason out this task in my head, as I can't find much on
MetaLink, and here's what I've got so far:

1)  Shutdown DB.
2)  Backup DB.
3)  Startup restricted.
4)  Offline tablespace TEMP.
5)  Drop tablespace TEMP.
6)  Create new temporary TEMP LMT.
7)  Bounce instance.

I don't yet have an arena to try this in.  Will users whose assigned
TEMPORARY TABLESPACE is TEMP need to be ALTERed?  Anyone have any comments
on the procedure?

TIA!

Rich


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

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

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

Re:Is Oracle Forms going away?

[dgoulet]

JDeveloper

Reply Separator
Author: Gillian <[EMAIL PROTECTED]>
Date:   11/6/2002 9:18 AM


Have anyone heard about Oracle Forms going away with Oracle 9.0.1.4?

I was in a technical meeting with Retek (a retail application), and they
presenter said that. I did not see anything on the metalink site relating to
that information.

If Forms is going away, what will replace it?

Thanks in advance

Gillian



-
Do you Yahoo!?
HotJobs - Search new jobs daily now
Have anyone heard about Oracle Forms going away with Oracle 9.0.1.4?
I was in a technical meeting with Retek (a retail application), and they
presenter said that. I did not see anything on the metalink site relating to
that information.
If Forms is going away, what will replace it?
Thanks in advance
GillianDo you Yahoo!?
http://rd.yahoo.com/careers/mailsig/*http://www.hotjobs.com
">HotJobs - Search new jobs daily now
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

Re: Oracle DBA with SAP Needed

[Alan Davey]

Well with the ridiculous salary they are offering, they could at least train you in 
the use of SAP.  This is a Fortune 500 company after all.

-- 

Alan Davey
[EMAIL PROTECTED]
212-604-0200  x106


On 11/6/2002 10:56 AM, Paulo Gomes <[EMAIL PROTECTED]> wrote:
>unfortunatly i don't work with SAP or i would be interessed
>regards
>Paulo
>
>-Original Message-
>Sent: quarta-feira, 6 de Novembro de 2002 14:49
>To: Multiple recipients of list ORACLE-L
>
>
>If you are an Oracle DBA With SAP experience looking for a stable 
>company 
>where you can work within a great team environment, this company 
>in Toledo,
>Ohio 
>is the place for you. This Fortune 500 employer has experienced steady
>growth over
>the hundred years it has been in business and is looking for a top 
>notch
>candidate.
>This company is located in a very reasonable cost of living area 
>and offers
>a varied choice 
>of neighborhood communities.
>If you are looking for a place to grow within your career in a smaller 
>city
>atmosphere 
>this is the opportunity to check out. 
>
>Relocation Assistance is provided.
>
>PLEASE DO NOT send your resume for this position UNLESS you have 
>the skills 
>outlined below for this position.
>
>DO NOT send your resume unless you have a stable work history.
>Candidates whose work history includes frequent job changes connot 
>be
>considered.
>If you are employed by a consulting company you must have a long 
>term
>project history.
>
>This is a full time staff position so no sub-contractors or third 
>parties
>please.
>
>NO H-1B candidates please.
>
>*Requirements:
>-MUST be a team player.
>-3+ years Oracle DBA experience.
>-SAP experience
>-Must have experience with:Installation, Backup and recovery,
>Implementation, Conversion, 
> Performance tuning, Troubleshooting, Development, Database Design,
>Monitoring, and Support.
>-MUST have excellent communications skills
>-Major plusses are: SQL Backtrack, DB Artisan, Powerbuilder, Shell 
>scripting
>and experience with
> Sybase and/or SQL Server. 
>
>Base Salary is 55K-to maybe high 60s Firm.
>
>The employer itself offers a comprehensive medical plan, dental insurance,
>life insurance, 
>sick leave and disability plans, a retirement plan, vacation days, 
>a 401K
>Plan, and much more. 
>
>For immediate consideration, please email your resume as an attachment 
>to:
>
>OraStaff, Inc.
>Email: [EMAIL PROTECTED]
>Phone: 1-800-549-8502. 
>Please Use Job Code: one/Toledo/DBA-SAP/Jenni
>
>I pay referral fees.
>So please contact me if you know of anyone who would be qualified/interested
>in the position described above- if it is not a match for your skills.
>Thanks.
>
>
>
>
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: OraStaff
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and 
>in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Paulo Gomes
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and 
>in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>

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

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

RE: OCP Exams - What to study out of?

[Richards, Brian]

Title: RE: OCP Exams - What to study out of?



You 
are not wrong! And I, too, am doing OCP 8i, then the upgrade. Using the Couchman 
study guide and sample tests books, Self Test Software sample tests, and (don't 
laugh) the CBTs by SmartForce (since our company paid for them, might as well 
use them).
 
Brian
60% 8i 
OCP (SQL, B&R, A & A)
 
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 
2002 12:04 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: OCP Exams - What to study out 
of?
I took 
8i - am taking 8i because I am hoping that then I can just take an upgrade exam 
for 9i without the $1,000+ course requirement.  I believe that is still the 
case.  Please tell me if I am 
wrong. 

Re:Convert TEMP tablespace from datafiles to tempfiles

[dgoulet]

Jesse,

When you drop the temp tablespace everyone who had it assigned as their temp
space will have that changed to SYSTEM.  The following should fix that:

declare
 s varchar2(200);
  begin
 for a in (select username from dba_users) loop
  s := 'alter user '||a.username||' temporary tablespace temp';
  execute immediate s;
 end loop;
  end;


Dick Goulet

Reply Separator
Author: "Jesse; Rich" <[EMAIL PROTECTED]>
Date:   11/6/2002 7:56 AM

Hey all,

I've got some downtime coming up on an 8.1.6 DB on Solaris, and I'd like to
take the opportunity to convert the datafiles of the TEMP tablespace to
tempfiles.  My reason for this change is primarily to get the TEMP
tablespace LMT, but also to shrink our hotbacks w/o modifying the working
script.

I've been trying to reason out this task in my head, as I can't find much on
MetaLink, and here's what I've got so far:

1)  Shutdown DB.
2)  Backup DB.
3)  Startup restricted.
4)  Offline tablespace TEMP.
5)  Drop tablespace TEMP.
6)  Create new temporary TEMP LMT.
7)  Bounce instance.

I don't yet have an arena to try this in.  Will users whose assigned
TEMPORARY TABLESPACE is TEMP need to be ALTERed?  Anyone have any comments
on the procedure?

TIA!

Rich


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

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

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

Re: Help required: Enterprise Manager Console -> Export/Import/Backup

[Yechiel Adar]

If I remember correctly ( a big if) there is an option in the OEM menus to
set the preferred credentials.

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 5:04 PM


> Come on folks...Help me, I am stuck...
>
> I run Oracle 8.1.6 on Win 2k (Both standard ed.). I am trying to run the
> export wizard through the Enterprise Manager Console by doing the
following:
> Under Database folder, I right click the Global Name (say ORCL) -> Data
> Management -> Export ...
> and it comes back with the error Either Preferred Credentials are not set
or
> the username and/or password are invalid for this database and node. You
> must set the Preferred Credentials for the database and node in the Oracle
> Enterprise Manager Console <>
>
> I have logged in to EM-Console with SYSMAN user. Under System ->
Preferences
> -> Preferred Credential, for ORCL, I have tried using SYSMAN, SYSTEM and
SYS
> with Role as NORMAL, SYSDBA & SYSOPER.
>
> I have no credentials setup  for the Node (say ORATEST).
>
> I am pretty new to Oracle 8i and hence may not be taking the right steps
> required.
>
> So, what Id should I log in to EM-Console with???
> What ID should I put under preferred credential against ORCL database
> What permissions does this ID need to have (Can they be provided logging
in
> to sql plus with System or Sys account)
> What ID should I put under preferred credential against Node ORATEST (Does
> this ID need to have any prerequisites/permissions)
> Any other info. I need to provide???
>
> Thanks
> Arif
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Arif Khan (GWL)
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

Re: Differences between Oracle 9.2.0 EE and SE

[Yechiel Adar]

The list of 9i options can be found at:

http://www.oracle.com/ip/deploy/database/oracle9i/index.html?packagingandopt
ions.html

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 4:49 PM


> I have given up on trying to find document detailing differences between
> Oracle 9i (9.2.0) EE and SE.
> Can someone provide a link,etc for this?
>
> Thanks
> Rick
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

RE: Oracle DBA with SAP Needed

[Paulo Gomes]

unfortunatly i don't work with SAP or i would be interessed
regards
Paulo

-Original Message-
Sent: quarta-feira, 6 de Novembro de 2002 14:49
To: Multiple recipients of list ORACLE-L


If you are an Oracle DBA With SAP experience looking for a stable company 
where you can work within a great team environment, this company in Toledo,
Ohio 
is the place for you. This Fortune 500 employer has experienced steady
growth over
the hundred years it has been in business and is looking for a top notch
candidate.
This company is located in a very reasonable cost of living area and offers
a varied choice 
of neighborhood communities.
If you are looking for a place to grow within your career in a smaller city
atmosphere 
this is the opportunity to check out. 

Relocation Assistance is provided.

PLEASE DO NOT send your resume for this position UNLESS you have the skills 
outlined below for this position.

DO NOT send your resume unless you have a stable work history.
Candidates whose work history includes frequent job changes connot be
considered.
If you are employed by a consulting company you must have a long term
project history.

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

NO H-1B candidates please.

*Requirements:
-MUST be a team player.
-3+ years Oracle DBA experience.
-SAP experience
-Must have experience with:Installation, Backup and recovery,
Implementation, Conversion, 
 Performance tuning, Troubleshooting, Development, Database Design,
Monitoring, and Support.
-MUST have excellent communications skills
-Major plusses are: SQL Backtrack, DB Artisan, Powerbuilder, Shell scripting
and experience with
 Sybase and/or SQL Server. 

Base Salary is 55K-to maybe high 60s Firm.

The employer itself offers a comprehensive medical plan, dental insurance,
life insurance, 
sick leave and disability plans, a retirement plan, vacation days, a 401K
Plan, and much more. 

For immediate consideration, please email your resume as an attachment to:

OraStaff, Inc.
Email: [EMAIL PROTECTED]
Phone: 1-800-549-8502. 
Please Use Job Code: one/Toledo/DBA-SAP/Jenni

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





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

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

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

Re: Help required: Enterprise Manager Console -> Export/Import/Backup

[Ruth Gramolini]

Sysman is not a user on the database. Set preferered 
credentials to someone who has sysdba privs or export full database, import full 
database privs.
 
Ruth

  - Original Message - 
  From: 
  Arif Khan 
  (GWL) 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, November 06, 2002 10:04 
  AM
  Subject: Help required: Enterprise 
  Manager Console -> Export/Import/Backup
  Come on folks...Help me, I am stuck...I run Oracle 
  8.1.6 on Win 2k (Both standard ed.). I am trying to run theexport wizard 
  through the Enterprise Manager Console by doing the following:Under 
  Database folder, I right click the Global Name (say ORCL) -> 
  DataManagement -> Export ...and it comes back with the error Either 
  Preferred Credentials are not set orthe username and/or password are 
  invalid for this database and node. Youmust set the Preferred Credentials 
  for the database and node in the OracleEnterprise Manager Console 
  <>I have logged in to EM-Console with SYSMAN user. 
  Under System -> Preferences-> Preferred Credential, for ORCL, I have 
  tried using SYSMAN, SYSTEM and SYSwith Role as NORMAL, SYSDBA & 
  SYSOPER.I have no credentials setup  for the Node (say 
  ORATEST).I am pretty new to Oracle 8i and hence may not be taking the 
  right stepsrequired. So, what Id should I log in to EM-Console 
  with???What ID should I put under preferred credential against ORCL 
  databaseWhat permissions does this ID need to have (Can they be provided 
  logging into sql plus with System or Sys account)What ID should I put 
  under preferred credential against Node ORATEST (Doesthis ID need to have 
  any prerequisites/permissions)Any other info. I need to 
  provide???ThanksArif-- Please see the official 
  ORACLE-L FAQ: http://www.orafaq.com-- 
  Author: Arif Khan (GWL)  INET: [EMAIL PROTECTED]Fat City 
  Network Services    -- 858-538-5051 http://www.fatcity.comSan Diego, 
  California    -- Mailing list and web 
  hosting 
  services-To 
  REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT 
  spelling of 'ListGuru') and inthe message BODY, include a line containing: 
  UNSUB ORACLE-L(or the name of mailing list you want to be removed 
  from).  You mayalso send the HELP command for other information (like 
  subscribing).

RE: Help required: Enterprise Manager Console -> Export/Import/Ba

[Phil Wilson (DBA)]

A couple of things come to mind...

1. Set credentials for the node ORATEST, usually the user you installed
oracle with on the node.
2. Set credentials for the database to be a user with DBA privileges,
possibly even create a specific user to act as the primary user that you
will do this and other jobs as.
3. Ensure that the 'Logon as Batch Job' privilege is set for the Windows
user that you used in the preferred credentials for the node.
4. Connect to EM Repository as the SYSMAN user, this will enable you to test
the functionality and you can use a specific user once the problems are
worked out.

HTH...

Phil Wilson  ([EMAIL PROTECTED])
DBA,  Operations Group
SkillSoft, Learning Solutions for the Human Enterprise
506.462.1124(w)
506.447.0334(c)


-Original Message-
Sent: Wednesday, November 06, 2002 11:04 AM
To: Multiple recipients of list ORACLE-L

Come on folks...Help me, I am stuck...

I run Oracle 8.1.6 on Win 2k (Both standard ed.). I am trying to run the
export wizard through the Enterprise Manager Console by doing the following:
Under Database folder, I right click the Global Name (say ORCL) -> Data
Management -> Export ...
and it comes back with the error Either Preferred Credentials are not set or
the username and/or password are invalid for this database and node. You
must set the Preferred Credentials for the database and node in the Oracle
Enterprise Manager Console <>

I have logged in to EM-Console with SYSMAN user. Under System -> Preferences
-> Preferred Credential, for ORCL, I have tried using SYSMAN, SYSTEM and SYS
with Role as NORMAL, SYSDBA & SYSOPER.

I have no credentials setup  for the Node (say ORATEST).

I am pretty new to Oracle 8i and hence may not be taking the right steps
required. 

So, what Id should I log in to EM-Console with???
What ID should I put under preferred credential against ORCL database
What permissions does this ID need to have (Can they be provided logging in
to sql plus with System or Sys account)
What ID should I put under preferred credential against Node ORATEST (Does
this ID need to have any prerequisites/permissions)
Any other info. I need to provide???

Thanks
Arif

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

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

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

RE: How can I tell if MTS is activated

[Farnsworth, Dave]

To see how many dispatchers/shared servers are started up with the RDBMS,  check the 
value of 'mts_dispatchers' and 'mts_servers' in the init.ora.  
You can also tell by looking in the alert.log(default location is  
$ORACLE_HOME/rdbms/log).
Sample:  
PMON started
DBWR started
LGWR started
RECO started
Thu Sep 14 09:24:15 1995
starting up 4 shared server(s) ...
starting up 4 dispatcher(s) for network
See Note:1012480.6 on Metastink for mor info on MTS Processes

Dave

-Original Message-
Sent: Wednesday, November 06, 2002 10:59 AM
To: Multiple recipients of list ORACLE-L


Oracle 8i

How can I tell if MTS is activated?

Which parameters should I look at? (in init.ora and
listener.ora)


thanks
Pablo



___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
Descárgalo ya desde http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
  INET: [EMAIL PROTECTED]

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

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

RE: Data Purging Strategy

[Mark Leith]

LOL! Thanks John! ;)

As a matter of fact.. ;P

I do actually know of another tool that does just this, it's called
Checkmate from a company called BitByBit http://www.bitbybit.co.uk (which I
have just checked and it now seems they have been acquired by OuterBay!)..
We actually used to promote Checkmate for them, but in all honesty it was a
little hard for the every day DBA to use.. When we came across DataBee,
which performs the function that most DBA's wanted anyway (subsetting), we
decided to go that route instead..

Prepare to have some $$'s if your going to look at Checkmate. Checkmate does
take a referentially correct archive, and purges the data after it has been
archived (and checked for data integrity etc).. Checkmate also has the
ability to archive to an "historic" database, so that all data is still
"online", and accessible through database links if need be, whilst keeping
the size of the "live" system down.. This also give the benefit of all
historic reporting being run against a separate system as well. This is
along the same lines as what Tom is saying really, although you will still
get the historical reporting loads against your prod system with his
guidelines.

And no, I don't get any gains from saying any of this :) Hey, they also have
modules for Oracle Apps, and Peopl$lop! Go get 'em Dick!



Mark

-Original Message-
[EMAIL PROTECTED]
Sent: 06 November 2002 15:56
To: Multiple recipients of list ORACLE-L


Hey Dennis,
Mark Leith is the only person on this list allowed to mention 3rd party
products.
I am sure he bought the franchise from Jared :)

John

-Original Message-
Sent: 06 November 2002 14:15
To: Multiple recipients of list ORACLE-L


Prem - You are receiving some excellent advice from Tom and Tim. I would
mention two items in addition:
  - If you ever hope to re-use the data you archive off-line, you must also
archive all the related tables, because after all, this is a RELATIONAL
database.
  - PrincetonSoftech has a product Active Archiving that looks pretty good
from the demos I've seen. I haven't used it myself.



Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]

-Original Message-
Sent: Wednesday, November 06, 2002 6:54 AM
To: Multiple recipients of list ORACLE-L


Prem,

I would re-visit the requirement.  Why do you feel the need to delete the
data from the database?  What is the purpose for this type of requirement?
It would be far easier to modify the requirement than to do what you are
thinking of doing.

Adding columns to database tables indicating that a record has passed it's
retention policy and thus, is not included in queries, would be a much
easier solution.

Or, simply moving these records to historical tables in the database - and
NOT deleting them from the system - is a much better solution.  The data is
always accessible and not available in the current tables.  And you will not
be playing the "get the data from tape and reload it" game with all of it's
problems (writing an offload program, table structure changes & offload
program versions).

Try and keep this as simple as possible.

Hope this helps

Tom Mercadante
Oracle Certified Professional

-Original Message-
Sent: Wednesday, November 06, 2002 4:13 AM
To: Multiple recipients of list ORACLE-L



Dear List,

I need some inputs from you all regarding purging data from the database.

This is the requirement


We define a retention period for all the data in the system.
When the retention period is reached,  the data should be deleted, but then
at a later time, some user might request for this purged data. So it must be
possible to retrieve this data.

This is the strategy we have designed for this.

When the retention period is reached, move the data from the main database
to an offline database. Then delete the data from the main database.

In the offline database, we cannot again keep it from long, so it has to
moved to tapes. Now my question, how can we move this data to tapes and at
the same time retrieve data from the tapes based on dates.
i.e, the user will ask for the data on a particular date, so it must be
possible to retrieve data from the tapes based on a date and load it to the
database tables.

Regards
Prem



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

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

F

RE: ORA-01089

[John . Hallas]

Don't know the exact  circumstances but the following note from Metalink
(1014091.102) may be appropriate
However the best way to learn anything is to ask the senior DBA what he
meant. An explanation from him may include looking at the alert log and the
scripts that were used. That is more than most people on this list can offer

Good luck

John


Problem Description: 
 
You issue a shutdown immediate and receive the following error: 
ORA-01089: immediate shutdown in progress - no operations are permitted 
Cause: The SHUTDOWN IMMEDIATE command was used to shut down a running 
Oracle instance, terminating any active operations. 
Action: Wait for the instance to be restarted or contact the database 
administrator. 
You may be running a shutdown script that performs a shutdown abort, then a 
startup, followed by a shutdown immediate. The error is recorded in the
alert 
log, and a trace file is generated by one or more snp processes. 
Solution Description: 
= 
The error is actually expected behavior based on the conditions present
during 
the shutdown immediate. The following workarounds are available: 
Workaround 1: 
= 
Modify your shutdown script to issue a shutdown normal instead of a shutdown

immediate. 
Issuing a shutdown normal allows the snp processes to complete their work 
prior to shutting down, thus avoiding the error. The implication of this 
workaround is that the database will not shut down until all user and snp 
processes have completed. 
Workaround 2: 
= 
Increase the JOB_QUEUE_INTERVAL parameter in the INIT.ORA file. 
*NOTE: Increase by increments and test to determine what interval is 
necessary to avoid the error. 
This increases the time before the snp processes wake up after starting 
up the database, allowing the shutdown immediate to be issued before the 
snp processes wake up. 
Workaround 3: 
= 
Start the database with a different INIT.ORA file. Modify the startup 
script to use a separate INIT.ORA file that does not include the 
JOB_QUEUE_PROCESSES or JOB_QUEUE_INTERVAL parameters. 
For Oracle 8i versions you can set the JOB_QUEUE_PROCESSES to 0, this will 
ensure that no snp processes startup. 
Since no snp processes will start during the startup, no error will occur 
during the shutdown immediate. 
Explanation: 
 
During the startup portion of the shutdown script, Oracle starts a number of

snp processes based on the "init.ora" parameter "JOB_QUEUE_PROCESSES". 
Depending on how long Oracle takes to process the shutdown immediate portion
of 
the shutdown script and the value specified in the "init.ora" parameter 
"JOB_QUEUE_INTERVAL", one or more of the snp processes may wake up to check
the 
jobs queue. The smaller the value of "JOB_QUEUE_INTERVAL", the sooner the
snp 
processes will wake up. If these processes wake up between the time the 
database was started and the shutdown immediate was issued, the ORA-1089
error 
will occur. The snp process cannot continue because a shutdown is in
process. 
References: 
=== 
[BUG:775116] ORA-604, ORA-1089, AND ORA-7445 DURING SHUTDOWN IMMEDIATE 
-Original Message-
Sent: 06 November 2002 14:59
To: Multiple recipients of list ORACLE-L


Hello Gurus,

This morning our database locked us out with the error code ORA-01089.
Circumstances surrounding this occurrence were that a cold backup by
Tivoli is taken performed every night at 4AM. 

When I spoke with our senior DBA, he confirmed that the database never
shutdown properly before the backup and sure enough, I could see the
processes this morning from yesterday. This is the second occurrence in
5 days.

So my first question is, why would this happen? And secondly, how do I
deal with it? 

Further to my conversation with the senior DBA, I was informed that
indeed a shutdown abort command was issued but only after it was
confirmed that "everything was ok". What does he mean by that statement?
What is he checking for before issuing the abort command?

Thanks in advance and I would like to apologize if this question has
been posed earlier at some point in time. I did search the archives but
didn't find a satisfactory explanation. 

Saira Somani
IT Support/Analyst
Hospital Logistics Inc.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

RE: OCP Exams - What to study out of?

[Paula_Stankus]

Title: RE: OCP Exams - What to study out of?



I took 
8i - am taking 8i because I am hoping that then I can just take an upgrade exam 
for 9i without the $1,000+ course requirement.  I believe that is still the 
case.  Please tell me if I am wrong.  

  -Original Message-From: KENNETH JANUSZ 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002 9:34 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  OCP Exams - What to study out of?
  Unfortunately there are no Corioulus books for 
  9i.
   
  Ken
  
- Original Message - 
From: 
[EMAIL PROTECTED] 

To: Multiple recipients of list ORACLE-L 

Sent: Wednesday, November 06, 2002 8:08 
AM
Subject: RE: OCP Exams - What to study 
out of?

But I did.  All I did was study the Corioulus book - 
and took the exams. 
-Original Message- From: 
DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, November 05, 2002 4:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: OCP Exams - What to study out of? 
Ken - Wow, I'm impressed. I took and passed one APICS module 
years and years ago and I can testify that they 
aren't easy. And I took the module related to my 
daily job.    Can you share any tips on 
how to study for the SQL exam? I find I learn MUCH 
more from someone that was forced to reassess their strategy than 
from people that say "oh, I took the manual home two 
nights and breezed through it". 
Dennis Williams DBA, 40%OCP 
Lifetouch, Inc. [EMAIL PROTECTED] 
-Original Message- Sent: 
Tuesday, November 05, 2002 2:04 PM To: Multiple 
recipients of list ORACLE-L 
I agree that the SQL exam is very difficult.  I've 
taken it twice and missed passing by just a couple 
of points.  But I will persist. 
Interestingly enough when I got my APICS CPIM certification 
I took six exams and passed them all on the first 
try.  The passing grade is 90%. 
Ken Janusz, CPIM 
- Original Message - To: 
"Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> 
Sent: Tuesday, November 05, 2002 11:03 AM 
> Eva - Everything I've heard says that all the exam 
questions come out of the > Oracle University class Student Guides. To put it bluntly, your 
goal is to > pass the exam. You could study the 
Oracle manuals, but there is a lot of > material 
to cover and what strikes you as important might not be covered 
on > the exam, and vice-versa. 
Essentially you are getting two levels of > 
filtering. Somebody read the manuals and used that to prepare student 
> guides, then a group of Oracle instructors read the 
student guide and > prepared questions. I think 
that most of the exam guides were prepared from > the Oracle Student Guides and the 
author has at least taken the exam, so > they 
have a general idea of how the test is approached. Everyone has their 
> favorite exam preparation book and I consider this a 
worthwhile investment, > 
I bought Couchman - > http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0 
> H >  0H&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=007 
> 2133414> > 
&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=00721 
> 33414 >    
Two issues: Which exam track are you planning to take? 9i? 8i? 
>    The advice I received is "don't take 
the SQL exam as your first exam". > Take the DBA 
exam first. The SQL exam is reported to be quite hard because 
> it covers all the odd SQL functions and can really 
catch you unawares. As a > practicing DBA you should find the DBA exam pretty easy. I 
didn't personally > take 
that path for my own reasons, but I still consider it good advice. 
> > > > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. 
> [EMAIL PROTECTED] > > -Original Message- 
> Sent: Tuesday, November 05, 2002 6:09 AM 
> To: Multiple recipients of list ORACLE-L 
> > > > Hello Everyone, > > 1. I have now made the humungous 
decision to start studying and to write the 
> OCP exams. > 2. Do I study 
out of the Oracle Manuals? > 3. I do have the 
Sybex Study Guides, would studying these be all that is > needed? > 4. Or do the questions come 
out of the Course material ( Which I have not > 
attended ). > 5. I do have some of the Oreilly 
"Insect" Books - would these be any help? > > Any views, opinions etc 
appreciated. > Regards > Denham Eva > Oracle DBA 
> "UNIX is basically a simple operating system, but you 
have to be a genius to > 
understand the simplicity." > Dennis 
Ritchie. > > 
> >   _ 
> > DISCLAIMER 
> > > > This message is for the named 
person's use only. It may contain > co

Convert TEMP tablespace from datafiles to tempfiles

[Jesse, Rich]

Hey all,

I've got some downtime coming up on an 8.1.6 DB on Solaris, and I'd like to
take the opportunity to convert the datafiles of the TEMP tablespace to
tempfiles.  My reason for this change is primarily to get the TEMP
tablespace LMT, but also to shrink our hotbacks w/o modifying the working
script.

I've been trying to reason out this task in my head, as I can't find much on
MetaLink, and here's what I've got so far:

1)  Shutdown DB.
2)  Backup DB.
3)  Startup restricted.
4)  Offline tablespace TEMP.
5)  Drop tablespace TEMP.
6)  Create new temporary TEMP LMT.
7)  Bounce instance.

I don't yet have an arena to try this in.  Will users whose assigned
TEMPORARY TABLESPACE is TEMP need to be ALTERed?  Anyone have any comments
on the procedure?

TIA!

Rich


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

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

Is Oracle Forms going away?

[Gillian]

Have anyone heard about Oracle Forms going away with Oracle 9.0.1.4?
I was in a technical meeting with Retek (a retail application), and they presenter said that. I did not see anything on the metalink site relating to that information.
If Forms is going away, what will replace it?
Thanks in advance
GillianDo you Yahoo!?
HotJobs - Search new jobs daily now

RE: Help required: Enterprise Manager Console -> Export/Import/Ba

[Paulo Gomes]

u need to set the system operating credentials for the node u are using with
a acount that has at least "logon as a batch job" directly assigned to it.
Noramally it would administrator/Password
regards
Paulo

-Original Message-
Sent: quarta-feira, 6 de Novembro de 2002 15:04
To: Multiple recipients of list ORACLE-L
Export/Import/Backup


Come on folks...Help me, I am stuck...

I run Oracle 8.1.6 on Win 2k (Both standard ed.). I am trying to run the
export wizard through the Enterprise Manager Console by doing the following:
Under Database folder, I right click the Global Name (say ORCL) -> Data
Management -> Export ...
and it comes back with the error Either Preferred Credentials are not set or
the username and/or password are invalid for this database and node. You
must set the Preferred Credentials for the database and node in the Oracle
Enterprise Manager Console <>

I have logged in to EM-Console with SYSMAN user. Under System -> Preferences
-> Preferred Credential, for ORCL, I have tried using SYSMAN, SYSTEM and SYS
with Role as NORMAL, SYSDBA & SYSOPER.

I have no credentials setup  for the Node (say ORATEST).

I am pretty new to Oracle 8i and hence may not be taking the right steps
required. 

So, what Id should I log in to EM-Console with???
What ID should I put under preferred credential against ORCL database
What permissions does this ID need to have (Can they be provided logging in
to sql plus with System or Sys account)
What ID should I put under preferred credential against Node ORATEST (Does
this ID need to have any prerequisites/permissions)
Any other info. I need to provide???

Thanks
Arif

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

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

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

AW: Differences between Oracle 9.2.0 EE and SE

[Daiminger, Helmut]

Title: AW: Differences between Oracle 9.2.0 EE and SE





Rick,


there is a note on Metalink that gives you all the differences: 112591.1


But it only covers releases up to 8i. 9i should be somewhat similar (of course stuff like RAC only works with EE). As far as I know, there is no document from Oracle Support that gives you that info for 9iR2.

hth,
Helmut



-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Gesendet: Mittwoch, 6. November 2002 15:49
An: Multiple recipients of list ORACLE-L
Betreff: Differences between Oracle 9.2.0 EE and SE



I have given up on trying to find document detailing differences between Oracle 9i (9.2.0) EE and SE. Can someone provide a link,etc for this?

Thanks
Rick



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


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

RE: Differences between Oracle 9.2.0 EE and SE

[DENNIS WILLIAMS]

http://otn.oracle.com/products/oracle9i/pdf/9idb_rel2_prod_fam.pdf

At the end of the paper is a matrix that compares feature-by-feature. 

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, November 06, 2002 8:49 AM
To: Multiple recipients of list ORACLE-L


I have given up on trying to find document detailing differences between
Oracle 9i (9.2.0) EE and SE.
Can someone provide a link,etc for this?

Thanks
Rick


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

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

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

How can I tell if MTS is activated

[Pablo Rodriguez]

Oracle 8i

How can I tell if MTS is activated?

Which parameters should I look at? (in init.ora and
listener.ora)


thanks
Pablo



___
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis! 
Descárgalo ya desde http://messenger.yahoo.es
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
  INET: [EMAIL PROTECTED]

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

RE: OCP Exams - What to study out of?

[Peter Barnett]

In many cases the exams extract exact sentences from
the Oracle Uinversity manuals for their correct
answers.


--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Eva - Everything I've heard says that all the exam
> questions come out of the
> Oracle University class Student Guides. To put it
> bluntly, your goal is to
> pass the exam. You could study the Oracle manuals,
> but there is a lot of
> material to cover and what strikes you as important
> might not be covered on
> the exam, and vice-versa. Essentially you are
> getting two levels of
> filtering. Somebody read the manuals and used that
> to prepare student
> guides, then a group of Oracle instructors read the
> student guide and
> prepared questions. I think that most of the exam
> guides were prepared from
> the Oracle Student Guides and the author has at
> least taken the exam, so
> they have a general idea of how the test is
> approached. Everyone has their
> favorite exam preparation book and I consider this a
> worthwhile investment,
> I bought Couchman -
>
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0
> H
>

0H&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=007
> 2133414>
>
&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=00721
> 33414
>Two issues: Which exam track are you planning to
> take? 9i? 8i? 
>The advice I received is "don't take the SQL exam
> as your first exam".
> Take the DBA exam first. The SQL exam is reported to
> be quite hard because
> it covers all the odd SQL functions and can really
> catch you unawares. As a
> practicing DBA you should find the DBA exam pretty
> easy. I didn't personally
> take that path for my own reasons, but I still
> consider it good advice.
> 
> 
> 
> Dennis Williams 
> DBA, 40%OCP 
> Lifetouch, Inc. 
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Tuesday, November 05, 2002 6:09 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Hello Everyone, 
> 
> 1. I have now made the humungous decision to start
> studying and to write the
> OCP exams. 
> 2. Do I study out of the Oracle Manuals? 
> 3. I do have the Sybex Study Guides, would studying
> these be all that is
> needed? 
> 4. Or do the questions come out of the Course
> material ( Which I have not
> attended ). 
> 5. I do have some of the Oreilly "Insect" Books -
> would these be any help? 
> 
> Any views, opinions etc appreciated. 
> Regards 
> Denham Eva 
> Oracle DBA 
> "UNIX is basically a simple operating system, but
> you have to be a genius to
> understand the simplicity." 
> Dennis Ritchie. 
> 
> 
> 
>   _  
> 
> DISCLAIMER 
> 
> 
> 
> This message is for the named person's use only. It
> may contain
> confidential, proprietary or legally privileged
> information. No
> confidentiality or privilege is waived or lost by
> any mistransmission. If
> you receive this message in error, please
> immediately delete it and all
> copies of it from your system, destroy any hard
> copies of it and notify the
> sender. You must not, directly or indirectly, use,
> disclose, distribute,
> print, or copy any part of this message if you are
> not the intended
> recipient. TFMC, its holding company, and any of its
> subsidiaries each
> reserve the right to monitor and manage all e-mail
> communications through
> its networks. 
> 
> Any views expressed in this message are those of the
> individual sender,
> except where the message states otherwise and the
> sender is authorized to
> state them to be views of any such entity. 
> 
>   _  
> 
> 
> 
> 
>   _  
> 
> This e-mail message has been scanned for Viruses and
> Content and cleared by
> MailMarshal - For more information please visit
> 
> www.marshalsoftware.com 
>   _  
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


=
Pete Barnett
Lead Database Administrator
The Regence Group
[EMAIL PROTECTED]

__
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Barnett
  INET: [EMAIL PROTECTED]

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

Re: Data Purging Strategy

[Jared . Still]

Someone asked about this 3 weeks ago.  Here's my take
on archiving data.  I don't expect everyone to agree with this,
but nonetheless,  I have an opinion.   :)

Here's an email from last month.  You can undoubtedly find
some other ideas on this by searching the archives of this
list at fatcity.com

Jared

==

I'm not a proponent of purging data.

Unless of course, you expect to never see it again.

That word 'archive' rolls of the tongues of managers
and consultants pretty easily, but what's behind it?

There are a few gotchas with purging and archiving.

Let's assume you have some 3 year old data that 
you need to see again, and it has been purged.

Here are some of the possible problems:

*  Your backup tapes are corrupted
*  Your new backup hardware can't read the old tapes
*  Your software no longer understands the format that
the data is in.
* You have the correct software, but it won't work on the
   current version of OS on your hardware.
* The data format/software/whatever is not well documented
*  The employees that understood the data 3 years ago
   have been laid off.
* ... lots more stuff

Read Bryon Bergeron's "Dark Ages II: When the Digital Data Die"
http://www.powells.com/cgi-bin/biblio?inkey=2-0130661074-0

Perhaps much better than archiving the data, is to stick with the
idea of moving it to another database, and using lots of cheap
disk storage (NAS) or a heirarchical file system to store it.

The point being that if it's online somewhere, it will be maintained.

Don't purge it till Finance, HR, the IRS and any other stakeholder
says it's ok.  Only then purge it and archive it to offline tape with the
knowledge that you may never see that data again.

Jared





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 11/06/2002 01:13 AM
 Please respond to ORACLE-L

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



Dear List, 

I need some inputs from you all regarding purging data from the database. 

This is the requirement 


We define a retention period for all the data in the system. 
When the retention period is reached,  the data should be deleted, but 
then at a later time, some user might request for this purged data. So it 
must be possible to retrieve this data. 

This is the strategy we have designed for this. 

When the retention period is reached, move the data from the main database 
to an offline database. Then delete the data from the main database. 

In the offline database, we cannot again keep it from long, so it has to 
moved to tapes. Now my question, how can we move this data to tapes and at 
the same time retrieve data from the tapes based on dates. 
i.e, the user will ask for the data on a particular date, so it must be 
possible to retrieve data from the tapes based on a date and load it to 
the database tables. 

Regards 
Prem 

 


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

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

RE: ORA-01089

[Jack van Zanen]

Do you have Enterprise manager running? 
That may hang up a shutdown immediate as well.
Shut down agent first and then the database.

Everything ok.?
He felt gutsy and decided ORACLE was robust enough to handle the abort.
Maybe he checked the previous backup was alright and that archives were
available as well:-)

Jack

-Original Message-
Sent: woensdag 6 november 2002 15:59
To: Multiple recipients of list ORACLE-L


Hello Gurus,

This morning our database locked us out with the error code ORA-01089.
Circumstances surrounding this occurrence were that a cold backup by
Tivoli is taken performed every night at 4AM. 

When I spoke with our senior DBA, he confirmed that the database never
shutdown properly before the backup and sure enough, I could see the
processes this morning from yesterday. This is the second occurrence in
5 days.

So my first question is, why would this happen? And secondly, how do I
deal with it? 

Further to my conversation with the senior DBA, I was informed that
indeed a shutdown abort command was issued but only after it was
confirmed that "everything was ok". What does he mean by that statement?
What is he checking for before issuing the abort command?

Thanks in advance and I would like to apologize if this question has
been posed earlier at some point in time. I did search the archives but
didn't find a satisfactory explanation. 

Saira Somani
IT Support/Analyst
Hospital Logistics Inc.

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

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

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

RE: OCP Exams - What to study out of?

[John . Hallas]

Just bought Oracle Press 9i New Features by the illustrious Robert Freeman.
Seems good and I have also seen another Oracle Press Book  9i New Features
Exam Guide by Daniel Benjamin. This follows the Corioulus format  of a
chapter and questions and a big test at the end.
 
The worrying thing about Robert's book is that in the introduction he states
that due to lack of space he has had to miss certain features out.
Unfortunately he does not even list the ones he has missed out. However
these books should be used in conjunction with the Oracle documentation so
should it should not be too much of an issue.
 
John

-Original Message-
Sent: 06 November 2002 14:34
To: Multiple recipients of list ORACLE-L


Unfortunately there are no Corioulus books for 9i.
 
Ken

- Original Message - 
To: Multiple   recipients of list ORACLE-L 
Sent: Wednesday, November 06, 2002 8:08 AM


But I did.  All I did was study the Corioulus book - and took the exams. 

-Original Message- 
 ] 
Sent: Tuesday, November 05, 2002 4:34 PM 
To: Multiple recipients of list ORACLE-L 


Ken - Wow, I'm impressed. I took and passed one APICS module years and years

ago and I can testify that they aren't easy. And I took the module related 
to my daily job. 
   Can you share any tips on how to study for the SQL exam? I find I learn 
MUCH more from someone that was forced to reassess their strategy than from 
people that say "oh, I took the manual home two nights and breezed through 
it". 

Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 


-Original Message- 
Sent: Tuesday, November 05, 2002 2:04 PM 
To: Multiple recipients of list ORACLE-L 


I agree that the SQL exam is very difficult.  I've taken it twice and missed

passing by just a couple of points.  But I will persist. 

Interestingly enough when I got my APICS CPIM certification I took six exams

and passed them all on the first try.  The passing grade is 90%. 

Ken Janusz, CPIM 

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> 
Sent: Tuesday, November 05, 2002 11:03 AM 


> Eva - Everything I've heard says that all the exam questions come out of 
the 
> Oracle University class Student Guides. To put it bluntly, your goal is to

> pass the exam. You could study the Oracle manuals, but there is a lot of 
> material to cover and what strikes you as important might not be covered 
on 
> the exam, and vice-versa. Essentially you are getting two levels of 
> filtering. Somebody read the manuals and used that to prepare student 
> guides, then a group of Oracle instructors read the student guide and 
> prepared questions. I think that most of the exam guides were prepared 
from 
> the Oracle Student Guides and the author has at least taken the exam, so 
> they have a general idea of how the test is approached. Everyone has their

> favorite exam preparation book and I consider this a worthwhile 
investment, 
> I bought Couchman - 
> 
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0
  
> H 
> 
<
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL
  
> 
0H&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=007

> 2133414> 
> 
&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=00721

> 33414 
>Two issues: Which exam track are you planning to take? 9i? 8i? 
>The advice I received is "don't take the SQL exam as your first exam". 
> Take the DBA exam first. The SQL exam is reported to be quite hard because

> it covers all the odd SQL functions and can really catch you unawares. As 
a 
> practicing DBA you should find the DBA exam pretty easy. I didn't 
personally 
> take that path for my own reasons, but I still consider it good advice. 
> 
> 
> 
> Dennis Williams 
> DBA, 40%OCP 
> Lifetouch, Inc. 
> [EMAIL PROTECTED] 
> 
> -Original Message- 
> Sent: Tuesday, November 05, 2002 6:09 AM 
> To: Multiple recipients of list ORACLE-L 
> 
> 
> 
> Hello Everyone, 
> 
> 1. I have now made the humungous decision to start studying and to write 
the 
> OCP exams. 
> 2. Do I study out of the Oracle Manuals? 
> 3. I do have the Sybex Study Guides, would studying these be all that is 
> needed? 
> 4. Or do the questions come out of the Course material ( Which I have not 
> attended ). 
> 5. I do have some of the Oreilly "Insect" Books - would these be any help?

> 
> Any views, opinions etc appreciated. 
> Regards 
> Denham Eva 
> Oracle DBA 
> "UNIX is basically a simple operating system, but you have to be a genius 
to 
> understand the simplicity." 
> Dennis Ritchie. 
> 
> 
> 
>   _ 
> 
> DISCLAIMER 
> 
> 
> 
> This message is for the named person's use only. It may contain 
> confidential, propr

RE: Oracle DBA with SAP Needed

[Markham, Richard]

Title: RE: Oracle DBA with SAP Needed





What does "Base Salary is 55K-to maybe high 60s Firm." mean?  You can
throw the possibility of a raise out the window? =)


-Original Message-
From: OraStaff [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 06, 2002 9:49 AM
To: Multiple recipients of list ORACLE-L
Subject: Oracle DBA with SAP Needed



If you are an Oracle DBA With SAP experience looking for a stable company 
where you can work within a great team environment, this company in Toledo,
Ohio 
is the place for you. This Fortune 500 employer has experienced steady
growth over
the hundred years it has been in business and is looking for a top notch
candidate.
This company is located in a very reasonable cost of living area and offers
a varied choice 
of neighborhood communities.
If you are looking for a place to grow within your career in a smaller city
atmosphere 
this is the opportunity to check out. 


Relocation Assistance is provided.


PLEASE DO NOT send your resume for this position UNLESS you have the skills 
outlined below for this position.


DO NOT send your resume unless you have a stable work history.
Candidates whose work history includes frequent job changes connot be
considered.
If you are employed by a consulting company you must have a long term
project history.


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


NO H-1B candidates please.


*Requirements:
-MUST be a team player.
-3+ years Oracle DBA experience.
-SAP experience
-Must have experience with:Installation, Backup and recovery,
Implementation, Conversion, 
 Performance tuning, Troubleshooting, Development, Database Design,
Monitoring, and Support.
-MUST have excellent communications skills
-Major plusses are: SQL Backtrack, DB Artisan, Powerbuilder, Shell scripting
and experience with
 Sybase and/or SQL Server. 


Base Salary is 55K-to maybe high 60s Firm.


The employer itself offers a comprehensive medical plan, dental insurance,
life insurance, 
sick leave and disability plans, a retirement plan, vacation days, a 401K
Plan, and much more. 


For immediate consideration, please email your resume as an attachment to:


OraStaff, Inc.
Email: [EMAIL PROTECTED]
Phone: 1-800-549-8502. 
Please Use Job Code: one/Toledo/DBA-SAP/Jenni


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






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


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

RE: OCP Exams - What to study out of?

[Hately, Mike (NESL-IT)]

Hi,
I remember that replication isn't really covered in Robert's book. 
The way I did this was to step through the candidate guide and compare it to
the index of the New Features book to see what was missing. 

Regards,
Mike Hately


-Original Message-
Sent: Wednesday, November 06, 2002 3:56 PM
To: Multiple recipients of list ORACLE-L


Just bought Oracle Press 9i New Features by the illustrious Robert Freeman.
Seems good and I have also seen another Oracle Press Book  9i New Features
Exam Guide by Daniel Benjamin. This follows the Corioulus format  of a
chapter and questions and a big test at the end.
 
The worrying thing about Robert's book is that in the introduction he states
that due to lack of space he has had to miss certain features out.
Unfortunately he does not even list the ones he has missed out. However
these books should be used in conjunction with the Oracle documentation so
should it should not be too much of an issue.
 
John
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hately, Mike (NESL-IT)
  INET: [EMAIL PROTECTED]

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

RE: ORA-01089

[Paulo Gomes]

could u check please the user rigths on disk place he needs?
colud u please check the ramaing free space of any directory needded to
oracle and its backup?
i supose the problem is in one of those steeps
regards
paulo

-Original Message-
Sent: quarta-feira, 6 de Novembro de 2002 14:59
To: Multiple recipients of list ORACLE-L


Hello Gurus,

This morning our database locked us out with the error code ORA-01089.
Circumstances surrounding this occurrence were that a cold backup by
Tivoli is taken performed every night at 4AM. 

When I spoke with our senior DBA, he confirmed that the database never
shutdown properly before the backup and sure enough, I could see the
processes this morning from yesterday. This is the second occurrence in
5 days.

So my first question is, why would this happen? And secondly, how do I
deal with it? 

Further to my conversation with the senior DBA, I was informed that
indeed a shutdown abort command was issued but only after it was
confirmed that "everything was ok". What does he mean by that statement?
What is he checking for before issuing the abort command?

Thanks in advance and I would like to apologize if this question has
been posed earlier at some point in time. I did search the archives but
didn't find a satisfactory explanation. 

Saira Somani
IT Support/Analyst
Hospital Logistics Inc.

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

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

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

RE: Data Purging Strategy

[DENNIS WILLIAMS]

Hey, thanks for mentioning that, I'll have to mind my manners. I really
don't have a connection to that vendor, just attended a demo.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, November 06, 2002 9:56 AM
To: Multiple recipients of list ORACLE-L


Hey Dennis,
Mark Leith is the only person on this list allowed to mention 3rd party
products.
I am sure he bought the franchise from Jared :)

John

-Original Message-
Sent: 06 November 2002 14:15
To: Multiple recipients of list ORACLE-L


Prem - You are receiving some excellent advice from Tom and Tim. I would
mention two items in addition:
  - If you ever hope to re-use the data you archive off-line, you must also
archive all the related tables, because after all, this is a RELATIONAL
database.
  - PrincetonSoftech has a product Active Archiving that looks pretty good
from the demos I've seen. I haven't used it myself.



Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, November 06, 2002 6:54 AM
To: Multiple recipients of list ORACLE-L


Prem,
 
I would re-visit the requirement.  Why do you feel the need to delete the
data from the database?  What is the purpose for this type of requirement?
It would be far easier to modify the requirement than to do what you are
thinking of doing.
 
Adding columns to database tables indicating that a record has passed it's
retention policy and thus, is not included in queries, would be a much
easier solution.
 
Or, simply moving these records to historical tables in the database - and
NOT deleting them from the system - is a much better solution.  The data is
always accessible and not available in the current tables.  And you will not
be playing the "get the data from tape and reload it" game with all of it's
problems (writing an offload program, table structure changes & offload
program versions).
 
Try and keep this as simple as possible.
 
Hope this helps
 
Tom Mercadante 
Oracle Certified Professional 

-Original Message-
Sent: Wednesday, November 06, 2002 4:13 AM
To: Multiple recipients of list ORACLE-L



Dear List, 

I need some inputs from you all regarding purging data from the database. 

This is the requirement 


We define a retention period for all the data in the system. 
When the retention period is reached,  the data should be deleted, but then
at a later time, some user might request for this purged data. So it must be
possible to retrieve this data. 

This is the strategy we have designed for this. 

When the retention period is reached, move the data from the main database
to an offline database. Then delete the data from the main database. 

In the offline database, we cannot again keep it from long, so it has to
moved to tapes. Now my question, how can we move this data to tapes and at
the same time retrieve data from the tapes based on dates. 
i.e, the user will ask for the data on a particular date, so it must be
possible to retrieve data from the tapes based on a date and load it to the
database tables. 

Regards 
Prem 

 

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

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

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

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

RE: suggestion w/c platforms to choose from...

[DENNIS WILLIAMS]

Grace - Amen to Yechiel's first rule. At the VERY least, warn your
management that they need to consider a second system for the datamart. This
way, if it works terribly, you don't look dumb.
   My experience is mainly Unix, so 200 OLTP users on an NT box sounds iffy
from a throughput point of view. I would tend to go with a small 4-CPU
Solaris server, especially if this is a critical application. From what I've
heard, and I will defer to list members that have more experience here, 200
ERP users are near the upper limit of Windows-based systems, and if you
ended up undersizing the system or you add users faster than expected, you
might run out of headroom. A lot would depend on what your site's experience
base is. If you are used to maintaining high-availability NT systems, then
that might work well for you. 
   If you care to mention which ERP system you will be using for the order
taking, PO, HR, GL, etc., you may garner advice specific to that system.
Many of us support ERP systems of different stripes and it is possible that
different ERP systems behave better on some platforms.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, November 06, 2002 6:49 AM
To: Multiple recipients of list ORACLE-L


First rule: Do not mix OLTP and datamart.
Datamart access is very heavy and complex SQL's that will impact your OLTP
system.

I think that an NT with 2-4 CPUs and a lot of memory will do (a not so
educated guess).
Controller with a lot of cache memory and fast disks (15,000 rpm).

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 3:48 AM


> database will be used for oltp and  data mart
> # of users -- 200
> very critical, since order taking , purchase order and accounting
module,hr
> will run on it..
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, November 05, 2002 9:03 PM
>
>
> > As a rule buy the biggest, meanest, fault tolerance, with gigabytes of
> > memory and terabytes of disk storage that you can buy.
> >
> > If you will provide more data about:
> >
> > 1) The size of the database
> > 2) How many users
> > 3) How critical is the system
> > 4) The use of the system - data warehouse, OLTP etc
> >
> > then you will probably get a more specified answer.
> >
> > Yechiel Adar
> > Mehish
> > - Original Message -
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Sent: Tuesday, November 05, 2002 2:13 PM
> >
> >
> > > hi,
> > >  can anyone suggestion w/c platform should i used to run oracle? wat
are
> > the
> > > things to consider in choosing platform?
> > >
> > > thanks
> > >
> > > Best regards,
> > > Grace Lim
> > > MIS Department
> > > Suy Sing Comm'l Corp.
> > > T- (632)-2474134
> > > F- (632)-2474160
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: grace
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting services
> > > -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).  You may
> > > also send the HELP command for other information (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Yechiel Adar
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: grace
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like sub

RE: SQL Brain Teaser Challenge

[Madhavan Amruthur]

Hi Steve,
You can get the below query to work in 8.1.7 (not sure about previous
versions) by setting the undoc parameter _new_connect_by_enabled = true
and can be set for a session

SELECT * 
FROM (SELECT * FROM treenode ORDER BY parentid, nodeorder) 
START WITH parentid=0 
CONNECT BY PRIOR ID = parentid 

You can also use sys_connect_by_path feature in 9i which gives you the
entire hierarchy path  (can be used in 8i with the above undoc parameter)

For eg:

select sys_connect_by_path(parent_id,'/')
from treenode
start with parent_id = 0
connect by prior id = parent_id

will give you a output like 
0/1/9
0/1/2
0/1/2/4

...etc

As always setting an undoc parameter is not advisable unless instructed
by Oracle support :-)

Hope this helps.
Regards,

Madhavan
http://www.dpapps.com

-- 
Madhavan Amruthur
DecisionPoint Applications

--
http://fastmail.fm - The holy hand grenade of email services
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Madhavan Amruthur
  INET: [EMAIL PROTECTED]

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

RE: Data Purging Strategy

[John . Hallas]

Hey Dennis,
Mark Leith is the only person on this list allowed to mention 3rd party
products.
I am sure he bought the franchise from Jared :)

John

-Original Message-
Sent: 06 November 2002 14:15
To: Multiple recipients of list ORACLE-L


Prem - You are receiving some excellent advice from Tom and Tim. I would
mention two items in addition:
  - If you ever hope to re-use the data you archive off-line, you must also
archive all the related tables, because after all, this is a RELATIONAL
database.
  - PrincetonSoftech has a product Active Archiving that looks pretty good
from the demos I've seen. I haven't used it myself.



Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, November 06, 2002 6:54 AM
To: Multiple recipients of list ORACLE-L


Prem,
 
I would re-visit the requirement.  Why do you feel the need to delete the
data from the database?  What is the purpose for this type of requirement?
It would be far easier to modify the requirement than to do what you are
thinking of doing.
 
Adding columns to database tables indicating that a record has passed it's
retention policy and thus, is not included in queries, would be a much
easier solution.
 
Or, simply moving these records to historical tables in the database - and
NOT deleting them from the system - is a much better solution.  The data is
always accessible and not available in the current tables.  And you will not
be playing the "get the data from tape and reload it" game with all of it's
problems (writing an offload program, table structure changes & offload
program versions).
 
Try and keep this as simple as possible.
 
Hope this helps
 
Tom Mercadante 
Oracle Certified Professional 

-Original Message-
Sent: Wednesday, November 06, 2002 4:13 AM
To: Multiple recipients of list ORACLE-L



Dear List, 

I need some inputs from you all regarding purging data from the database. 

This is the requirement 


We define a retention period for all the data in the system. 
When the retention period is reached,  the data should be deleted, but then
at a later time, some user might request for this purged data. So it must be
possible to retrieve this data. 

This is the strategy we have designed for this. 

When the retention period is reached, move the data from the main database
to an offline database. Then delete the data from the main database. 

In the offline database, we cannot again keep it from long, so it has to
moved to tapes. Now my question, how can we move this data to tapes and at
the same time retrieve data from the tapes based on dates. 
i.e, the user will ask for the data on a particular date, so it must be
possible to retrieve data from the tapes based on a date and load it to the
database tables. 

Regards 
Prem 

 

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

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

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

RE: Data Purging Strategy

[John . Hallas]

In response to a post on data purging Tim Gorman wrote "some on SAN-based
disk, some on NAS-based storage".
 
Can someone please explain the differences between these technologies
please.
 
My understanding that a SAN is a group of disks which are available on a
network and are not 'owned' by a server and have no direct cables into a
server.
I also understood NAS to be network based disk (duh!)
 
Thanks
 
 
John
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

Help required: Enterprise Manager Console -> Export/Import/Backup

[Arif Khan (GWL)]

Come on folks...Help me, I am stuck...

I run Oracle 8.1.6 on Win 2k (Both standard ed.). I am trying to run the
export wizard through the Enterprise Manager Console by doing the following:
Under Database folder, I right click the Global Name (say ORCL) -> Data
Management -> Export ...
and it comes back with the error Either Preferred Credentials are not set or
the username and/or password are invalid for this database and node. You
must set the Preferred Credentials for the database and node in the Oracle
Enterprise Manager Console <>

I have logged in to EM-Console with SYSMAN user. Under System -> Preferences
-> Preferred Credential, for ORCL, I have tried using SYSMAN, SYSTEM and SYS
with Role as NORMAL, SYSDBA & SYSOPER.

I have no credentials setup  for the Node (say ORATEST).

I am pretty new to Oracle 8i and hence may not be taking the right steps
required. 

So, what Id should I log in to EM-Console with???
What ID should I put under preferred credential against ORCL database
What permissions does this ID need to have (Can they be provided logging in
to sql plus with System or Sys account)
What ID should I put under preferred credential against Node ORATEST (Does
this ID need to have any prerequisites/permissions)
Any other info. I need to provide???

Thanks
Arif

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

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

RE: Data Purging Strategy

[DENNIS WILLIAMS]

Prem - You are receiving some excellent advice from Tom and Tim. I would
mention two items in addition:
  - If you ever hope to re-use the data you archive off-line, you must also
archive all the related tables, because after all, this is a RELATIONAL
database.
  - PrincetonSoftech has a product Active Archiving that looks pretty good
from the demos I've seen. I haven't used it myself.



Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, November 06, 2002 6:54 AM
To: Multiple recipients of list ORACLE-L


Prem,
 
I would re-visit the requirement.  Why do you feel the need to delete the
data from the database?  What is the purpose for this type of requirement?
It would be far easier to modify the requirement than to do what you are
thinking of doing.
 
Adding columns to database tables indicating that a record has passed it's
retention policy and thus, is not included in queries, would be a much
easier solution.
 
Or, simply moving these records to historical tables in the database - and
NOT deleting them from the system - is a much better solution.  The data is
always accessible and not available in the current tables.  And you will not
be playing the "get the data from tape and reload it" game with all of it's
problems (writing an offload program, table structure changes & offload
program versions).
 
Try and keep this as simple as possible.
 
Hope this helps
 
Tom Mercadante 
Oracle Certified Professional 

-Original Message-
Sent: Wednesday, November 06, 2002 4:13 AM
To: Multiple recipients of list ORACLE-L



Dear List, 

I need some inputs from you all regarding purging data from the database. 

This is the requirement 


We define a retention period for all the data in the system. 
When the retention period is reached,  the data should be deleted, but then
at a later time, some user might request for this purged data. So it must be
possible to retrieve this data. 

This is the strategy we have designed for this. 

When the retention period is reached, move the data from the main database
to an offline database. Then delete the data from the main database. 

In the offline database, we cannot again keep it from long, so it has to
moved to tapes. Now my question, how can we move this data to tapes and at
the same time retrieve data from the tapes based on dates. 
i.e, the user will ask for the data on a particular date, so it must be
possible to retrieve data from the tapes based on a date and load it to the
database tables. 

Regards 
Prem 

 

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

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

Differences between Oracle 9.2.0 EE and SE

[Rick_Cale]

I have given up on trying to find document detailing differences between
Oracle 9i (9.2.0) EE and SE.
Can someone provide a link,etc for this?

Thanks
Rick


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

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

ORA-01089

[Saira Somani]

Hello Gurus,

This morning our database locked us out with the error code ORA-01089.
Circumstances surrounding this occurrence were that a cold backup by
Tivoli is taken performed every night at 4AM. 

When I spoke with our senior DBA, he confirmed that the database never
shutdown properly before the backup and sure enough, I could see the
processes this morning from yesterday. This is the second occurrence in
5 days.

So my first question is, why would this happen? And secondly, how do I
deal with it? 

Further to my conversation with the senior DBA, I was informed that
indeed a shutdown abort command was issued but only after it was
confirmed that "everything was ok". What does he mean by that statement?
What is he checking for before issuing the abort command?

Thanks in advance and I would like to apologize if this question has
been posed earlier at some point in time. I did search the archives but
didn't find a satisfactory explanation. 

Saira Somani
IT Support/Analyst
Hospital Logistics Inc.

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

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

RE: Data Purging Strategy

[Conboy, Jim]

  A 
  poor man's solution might be to load the offline database with appropriate 
  data, then do a tablespace export and store the results on CD labelled by 
  date.  Restoring needed data would entail a tablespace import of stuff 
  from the appropriate CD into the offline DB.  I'm sure here's some 
  gotchas involved but some variation on that theme might 
  work.
   
  Jim
   
   
  -Original Message-From: Tim Gorman 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002 8:49 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  Data Purging Strategy
  This is a data-archival requirement, not a 
  data-purge requirement.  It only resembles a purge requirement based on 
  the multiple-database-migration strategy you outlined.  There are 
  alternatives...
   
  Depending on the volume of data in your database 
  and your availability requirements, implementing table- and index-partitioning 
  will likely be crucial.  One strategy is to have the 
  most-active tables partitioned by a date column and have different sets of 
  these partitions reside in time-variant tablespaces.  With this 
  arrangement, you can archive data to tape by simply setting the archived 
  tablespaces to READ ONLY and then migrating them to tape-based (instead 
  of disk-based) file-systems and bringing them back online.  Legato has 
  this file-system technology (recently purchased) and there is a 
  share-ware product called SAMFS which is an HSM (hierarchical storage mgmt) 
  filesystem used by some vendors (i.e. StorageTek, etc).  By setting 
  tablespaces to READ ONLY it becomes very easy to move them from disk to tape 
  while retaining them within the same original database, simplifying the task 
  of later retrieval (which is really important).
   
  Of course, Oracle's partitioning option is 
  enormously expensive, but in this case it is a matter of the upfront license 
  costs (with reduced downstream implementation costs due to 
  simplicity) versus a large downstream application-development 
  cost.  In this situation, I think roughly offsets everything.  Since 
  I'm not spending the money, I can afford such a calculation...  
  :-)
   
  With the various storage technologies available, 
  a single database can straddle several simultaneously, optimizing performance 
  or cost as needed.  Some files might reside on solid-state NVRAM 
  "disk", some on SAN-based disk, some on NAS-based storage, and then finally 
  reside in archive media file-systems such as tape or magneto-optical based HSM 
  file-systems.
  
- Original Message - 
From: 
[EMAIL PROTECTED] 

To: Multiple recipients of list ORACLE-L 

Sent: Wednesday, November 06, 2002 2:13 
AM
Subject: Data Purging Strategy
Dear List, 
I need some inputs from you all 
regarding purging data from the database. This is the requirement We define a retention period for all the data in the 
system. When the retention period is 
reached,  the data should be deleted, but then at a later time, some 
user might request for this purged data. So it must be possible to retrieve 
this data. This is the strategy 
we have designed for this. When 
the retention period is reached, move the data from the main database to an 
offline database. Then delete the data from the main database. 
In the offline database, we 
cannot again keep it from long, so it has to moved to tapes. Now my 
question, how can we move this data to tapes and at the same time retrieve 
data from the tapes based on dates. i.e, the user will ask for the data on a particular date, so it must 
be possible to retrieve data from the tapes based on a date and load it to 
the database tables. Regards Prem 
 

RE: OCP Exams - What to study out of?

[Paula_Stankus]

Title: RE: OCP Exams - What to study out of?





Just the first one.  That is the only one I have tried.  I have the second one Nov. 12th.  I am spacing them out a little because I have football games to go to, holidays, elderly parents, etc.  I will let you know the gory details if you wish.  My approach for the second exam I signed up for (backup and recovery) was the same study Cor. book, take self exams.  I haven't gotten a chance to do the self exams yet.  Too many other commitments.  So this is probably more from the seat of my pants.  However, while going through Cor. I am using that to tidy up backup/recovery, writing disaster recovery plans, etc.  Killing a few birds with one stone.  

-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 05, 2002 2:39 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OCP Exams - What to study out of?



Paula - You're losing me on the connection between SQL and GUI. I can see a
connection between command-line DBA actions and GUI DBA tools. And some GUI
report writing tools create SQL for you, but usually we DBAs are called when
it creates bad SQL code and we must straighten it out.  
 So have you passed all 5 OCP modules?




Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 


-Original Message-
Sent: Tuesday, November 05, 2002 12:29 PM
To: Multiple recipients of list ORACLE-L




I took the SQL exam first and had no problems although I have heard others
have.  I think it has to do with how I learned - I forced myself to use SQL
before getting hooked into a GUI tool of any kind.  In the long-run that is
a good approach as you will always have that but might not always have the
GUI.


-Original Message- 
 ] 
Sent: Tuesday, November 05, 2002 12:04 PM 
To: Multiple recipients of list ORACLE-L 



Eva - Everything I've heard says that all the exam questions come out of the


Oracle University class Student Guides. To put it bluntly, your goal is to 
pass the exam. You could study the Oracle manuals, but there is a lot of 
material to cover and what strikes you as important might not be covered on 
the exam, and vice-versa. Essentially you are getting two levels of 
filtering. Somebody read the manuals and used that to prepare student 
guides, then a group of Oracle instructors read the student guide and 
prepared questions. I think that most of the exam guides were prepared from 
the Oracle Student Guides and the author has at least taken the exam, so 
they have a general idea of how the test is approached. Everyone has their 
favorite exam preparation book and I consider this a worthwhile investment, 
I bought Couchman - 
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0
  
H 
<
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL
  
0H&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=007


2133414> 
&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=00721


33414 
   Two issues: Which exam track are you planning to take? 9i? 8i? 
   The advice I received is "don't take the SQL exam as your first exam". 
Take the DBA exam first. The SQL exam is reported to be quite hard because 
it covers all the odd SQL functions and can really catch you unawares. As a 
practicing DBA you should find the DBA exam pretty easy. I didn't personally


take that path for my own reasons, but I still consider it good advice. 




Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 


-Original Message- 
Sent: Tuesday, November 05, 2002 6:09 AM 
To: Multiple recipients of list ORACLE-L 




Hello Everyone, 


1. I have now made the humungous decision to start studying and to write the


OCP exams. 
2. Do I study out of the Oracle Manuals? 
3. I do have the Sybex Study Guides, would studying these be all that is 
needed? 
4. Or do the questions come out of the Course material ( Which I have not 
attended ). 
5. I do have some of the Oreilly "Insect" Books - would these be any help? 


Any views, opinions etc appreciated. 
Regards 
Denham Eva 
Oracle DBA 
"UNIX is basically a simple operating system, but you have to be a genius to


understand the simplicity." 
Dennis Ritchie. 




  _  


DISCLAIMER 




This message is for the named person's use only. It may contain 
confidential, proprietary or legally privileged information. No 
confidentiality or privilege is waived or lost by any mistransmission. If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender. You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. TFMC,

Oracle DBA with SAP Needed

[OraStaff]

If you are an Oracle DBA With SAP experience looking for a stable company 
where you can work within a great team environment, this company in Toledo,
Ohio 
is the place for you. This Fortune 500 employer has experienced steady
growth over
the hundred years it has been in business and is looking for a top notch
candidate.
This company is located in a very reasonable cost of living area and offers
a varied choice 
of neighborhood communities.
If you are looking for a place to grow within your career in a smaller city
atmosphere 
this is the opportunity to check out. 

Relocation Assistance is provided.

PLEASE DO NOT send your resume for this position UNLESS you have the skills 
outlined below for this position.

DO NOT send your resume unless you have a stable work history.
Candidates whose work history includes frequent job changes connot be
considered.
If you are employed by a consulting company you must have a long term
project history.

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

NO H-1B candidates please.

*Requirements:
-MUST be a team player.
-3+ years Oracle DBA experience.
-SAP experience
-Must have experience with:Installation, Backup and recovery,
Implementation, Conversion, 
 Performance tuning, Troubleshooting, Development, Database Design,
Monitoring, and Support.
-MUST have excellent communications skills
-Major plusses are: SQL Backtrack, DB Artisan, Powerbuilder, Shell scripting
and experience with
 Sybase and/or SQL Server. 

Base Salary is 55K-to maybe high 60s Firm.

The employer itself offers a comprehensive medical plan, dental insurance,
life insurance, 
sick leave and disability plans, a retirement plan, vacation days, a 401K
Plan, and much more. 

For immediate consideration, please email your resume as an attachment to:

OraStaff, Inc.
Email: [EMAIL PROTECTED]
Phone: 1-800-549-8502. 
Please Use Job Code: one/Toledo/DBA-SAP/Jenni

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





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

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