Re:

u can always have multiple oracle homes on NT. create new home for installing new version. if u want to install higher version it will ask u for migrating the DB. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple

Re:

yes coz I am a novice Oracle Certifiable DBBS - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 06, 2001 11:45 AM Hello guys, can anyone tell me how can i have two versions of oracle on the same machine. Is it possible. I have

Re: Urgent: modify column name

Djaroud Salim wrote: hi every body, I'm on oracle 7.3.4 is it possible to mdify a column name ? very urgent !!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim INET: [EMAIL PROTECTED] No, unless you do morally questionable updates to

RE: OFA (Optimal Flexible Architecture) in practice

Hi, If you can cd to a single directory and list all of your files then it means that all of your files are in a single filesystem probably (unless you've been VERY clever) sharing the same disks. I agree with the suggestion that you can create links to the datafiles from a central directory

xdk

Hi, Does anyone know where I can get the Oracle 8i version of the Java XDK version 2.0? Oracle, in their infinite wisdom, have decided to only make the 9i version available on TechNet now. Looking for 8.1.7 versions, they say, click there, but the page it links to doesn't exist! Nice QA there.

RE: can i place online redologs with oracle engine ?

infact i should have been more clearer offcourse i can place them on any disk..the reason i asked was... how much IO does the root + oracle engine do when an instance is running...? and given no other choice, i plan to place them with root+oracle rather than with some data or indexes.

RE: OT Bears

A bit touristy I know but I had a marvellous holiday about 2 years ago now in Vancouver. Jumped on a sea plane on Vancouver Island and flew over to Knights Inlet on the mainland. Stayed in a cabin (showered by torchlight !!) and spent 2 days watching grizzlies during the Salmon run. No guns were

RE: OT Bears

Closest I've ever come to a bear was when I was on holiday a few weeks ago in Spain - went to the Barcelona Zoo, down by the docks, and saw one in a cage.. Not the same as seeing them in their natural environment at all I guess..:) The one truly amazing animal they had there though was the

RE: can i place online redologs with oracle engine ?

Hi, There's very little I/O done to the ORACLE_HOME unless you've chosen to store and database files under it. As for Unix, it would depend on how your filesystems are alocated. Steer clear of /tmp and you should be OK but don't let anything fill up any 'OS' filesystems such as /, /var etc.

Re: RULE versus CHOOSE

Qs.1 How does optimizer_mode=CHOOSE Compare with RULE ? There's a world of difference between them. Using the Cost-Based Optimizer (CBO) versus Rule-Based is like using a GPS system to navigate a city you've not been to in a while versus your own vague memories of it. In the latter case, you

Please help!! - Error 472

Hi Gurus Please could you shed some light. Server is a Compaq Proliant 8500 - RAID 5 Oracle 8.1.6 Windows 2000 The new changes to the system is - I have converted to the MTS listener service(server), one day ago. Just a short while ago - the database is still warm - she crashed with the

RE: OT Bears

Northern Minnesota is a great place to see bears. Bears running down the side of the road, bears in your back yard, bears rifling your stuff when you are camping, and on a warm late summer evening you can go to the Vince Shute Wildlife preserve (http://www.americanbear.org/) and see the bears up

RE: RULE versus CHOOSE - sorry it's long

Title: RE: RULE versus CHOOSE - sorry it's long Hi Vivek, comments inline. List, please correct me if I am wrong. -Original Message- From: VIVEK_SHARMA [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 06, 2001 1:56 AM To: Multiple recipients of list ORACLE-L Subject: RULE versus CHOOSE

RE: RULE versus CHOOSE

Jon, Great write up. Several times you mentioned creating Histograms for skewed data distributions. I am just curious if you have ever studied the performance impact with and without them? We used to maintain histograms but when we studied the performance impact (with and without them) we

RE: * Oracle DBA Needed in Phoenix..

orastaff wrote: We would like to submit someone who is a renter and who is interested in Phoenix but has not applied to Phoenix companies and is not working with other recruiters for Phoenix companies. Is this some super secret job or what??? -Original Message- Sent: Thursday,

Re: OT Bears

When I was growing up, my family went to Yellowstone Park almost every year. This was in the days before some idiot gave LSD to the bears. The bears would come right up to the cars. Saw lots of them right next to the car window. (Dad would NOT let us roll the windows down enough for Mr. Bear

RE: OT Bears

I love nature and animals, but I think the only place on ever want to see a bear is either on the Discovery Channel or in a Zoo. I have nightmares about bears, I know, it's pathetic. KK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL

RE: * Oracle DBA Needed in Phoenix..

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

Re: OFA (Optimal Flexible Architecture) in practice

Hagedorn, Linda wrote: Does anyone use OFA as their company standard? If so, are there any complaints about it's structure? For example, the commingling of different database subdirectories under a given mount point? yes i do use it, and have used it here and at other companies. and i

strange explain plan

Hi. This is a second attempt. My first Email never got posted. I have the following query: select a1.MBR_TYP_CDE MBR_TYP_CDE, (COUNT ( DISTINCT a1.NOVS_NTWRK_MBR_KYD )) DISTINCTALLMERCHCO from MDSS_STAR.NOVUS_NETWRK_MBR_D a1 group by a1.MBR_TYP_CDE The explain plan for it is as follows:

RE: * Oracle DBA Needed in Phoenix..

Maybe it's Palo Verde Nuclear Power Station. -Original Message- Sent: Friday, July 06, 2001 8:30 AM To: Multiple recipients of list ORACLE-L Is the NSA maybe located there?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat

RE: OT Bears

Won't go to zoos on principal !! nuff said. -Original Message- Sent: 06 July 2001 13:05 To: Multiple recipients of list ORACLE-L Closest I've ever come to a bear was when I was on holiday a few weeks ago in Spain - went to the Barcelona Zoo, down by the docks, and saw one in a cage..

Re: Please help!! - Error 472

Hi I don't know if you have access to metalink or not, but there are quite a few documents there about bugs relating to error 472 (some are in combination with mts). Have a look there. Jack

Oracle9i on Suse Linux

I installed Oracle9i on Suse Linux 7.1 (384MB RAM, 400MB swap), and ran into a bit of a snag. The install ran fine until the end when the database creation assistant attempted to start the seed database. At that point I received an ORA-03113: End of File on Communication Channel error, and my

RULE versus CHOOSE - Basic Qs.

Qs. Is there ANY Benefit of keeping optimizer_mode=CHOOSE WITHOUT having Any Statistics Existent on the Application Tables , Indexes ? Qs With NO Statistics Existant on ALL Objects , yet with optmizer_mode = CHOOSE , does it mean that RULE (RBO) will be Used ? Following Excerpts seem to imply

Re: OT Bears

Mark Leith wrote: Closest I've ever come to a bear was when I was on holiday a few weeks ago in Spain - went to the Barcelona Zoo, down by the docks, and saw one in a cage.. Not the same as seeing them in their natural environment at all I guess..:) Your going to Spain to see bears

RE: RE: RULE versus CHOOSE

Tom: I never did any official benchmark studies, per se. I studied the CBO/histograms about 4 months ago when we were converting an app over from Oracle 7 to 8i. The new version of the app had queries that were very different from its earlier version and so performance on 8i as compared to 7

image in database

Dear mailing list, how to store an image in the database from a form written in Java servlets ? Also how to retrive the image from the database ? Thanks in advance Do You Yahoo!? For regular News updates go to http://in.news.yahoo.com

RE: OT: Learning Curve for Informatica ETL Products

This is true, unless of course it is running on Ardent's UniData or Universe database. That is something else to work with. Dave -Original Message- Sent: Friday, July 06, 2001 1:15 AM To: Multiple recipients of list ORACLE-L Larry, I took several training courses last year for one

sqlplus command

Dear mailing list, is it possible to execute SQLPLUS commands from subprograms like procedures and functions ? If possible pl. send me how to do it ? If not please tell me why and alternate way as i want to write sub programs(procedures) that would generate reports on the SQL prompt by using the

RE: OT: Just chatter about Wireless costs and PocketDBA

I agree, I love my Palm:) -Original Message- Smith Sent: Thursday, July 05, 2001 5:55 PM To: Multiple recipients of list ORACLE-L But you can play games on them. I actually used to think the same way until the company agreed to by me one. Since I use Outlook so much they are actually

RE: * Oracle DBA Needed in Phoenix..

Title: RE: * Oracle DBA Needed in Phoenix.. Cheap! Cheap Cheap Cheap $75,000? To move across the country with MINIMAL relo? Are they kidding?? I hope this isn't our parent company Happy Friday everyone! Lisa, the anti-recruiter ninja -Original Message- From:

RE: OT: Ari and his company have been noted in InfoWorld.

Actually, I have Ari's product. I have to admit, it is a pretty neat little tool. The idea is that you don't need to lug around a laptop with a wireless Ricochet modem. Yeah, that would be a much better combination, you could ultimately do more in a shorter amount of time. But, with my Palm

RE: * Oracle DBA Needed in Phoenix..

Preferably with no close friends or relatives, nobody to notice if you just...disappear. Jim [EMAIL PROTECTED] 07/06/01 09:10AM orastaff wrote:We would like to submit someone who is a renter and who is interestedin Phoenix but has not applied to Phoenix companies and is not

RE: OT: Learning Curve for Informatica ETL Products

I do not know your background, congratulations if you were able to develop performant mappings. But it's not the case on most clients I've seen where average developper were developping with the ETL tool. I'm sure that an experienced DBA with a good knowledge of its working environnement and

Re: * Oracle DBA Needed in Phoenix..

Peter, It probably means that they're willing to relocate someone but don't want to pay a ton of money to relocate someone who owns a house. There can be more than $10,000 worth of closing costs, moving costs, guarantee to buy your house if it doesn't sell, etc. Renters are simpler and

RE: OT: Learning Curve for Informatica ETL Products

Actually I do not know what is hard about learning Informatica or Sagent! In my opinion it's a toy. It's very easy and nothing is difficult to learn. Sagent is more intuitive than Informatica but Informatica engine might be more stable. Regards, Waleed -Original Message- Sent:

RE: OFA (Optimal Flexible Architecture) in practice

We used OFA with a small modification.. We used raw devices for the data files of the tablespaces. Then we built symbolic links to all of the necessary devices from a core directory. Those sym links were placed in a single directory off the $ORACLE_BASE. For example, all of the sym links

Range partition

Hello, Oracle 8.1.7 on Sun Solaris Scenario: We have a table where we store the consolidated weekly numbers on the number of disconnects, reconnects, transfers etc. Our business week is from Wednesday to Tuesday and so each week has a number assigned to it. Also, the week doesn't span across

RE: OT: Just chatter about Wireless costs and PocketDBA

LOL! Todd Carlson Oracle 8i Certified DBA Bunge North America Robertson To:

Using data dictionary tables to manage application

Hi All, Our Application design group is designing an application which looks in to data ditionary tables for roles granted to the user who logs in and decide which web pages he can view. The only problem we foresee is the if oracle changes the data dictionary then the application too needs

RE: OT: Just chatter about Wireless costs and PocketDBA

Look out, you may go blind !! :-) -Original Message- Sent: 06 July 2001 14:57 To: Multiple recipients of list ORACLE-L I agree, I love my Palm:) -Original Message- Smith Sent: Thursday, July 05, 2001 5:55 PM To: Multiple recipients of list ORACLE-L But you can play games on

Re: Oracle9i on Suse Linux

Jonathan, I saw almost exactly the same thing with 512MB , 512MB swap, Suse Linux 7.1 also.. Some stuff that springs to mind: Did you dynamically change the SHMMAX setting before the install and if so, did you make the same change once the machine had rebooted? When you're prompted for the JDK

Standby Database

Just wondering if anyone sees any problems with creating a second instance and DB on a standby database server that would be used for reporting querying against a small dataset??? Running the standby DB in read only mode is not an option since I'm applying archived logs every 10 minutes. If

RE: * Oracle DBA Needed in Phoenix..

Title: RE: * Oracle DBA Needed in Phoenix.. Lisa, imitating a bird... "Cheap! Cheap Cheap Cheap " next will be "I taught I taw a puddy-tat" Tom Mercadante Oracle Certified Professional -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Friday, July

RE: Range partition

Your partition key would be activity_year,week_num -Original Message- Sent: Friday, July 06, 2001 10:26 AM To: Multiple recipients of list ORACLE-L Hello, Oracle 8.1.7 on Sun Solaris Scenario: We have a table where we store the consolidated weekly numbers on the number of

RE: OT: Just chatter about Wireless costs and PocketDBA

Ahhh yesI knew someone would say that:) Get your minds out of the gutter dba's:) KK -Original Message- Lee - lerobe Sent: Friday, July 06, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Look out, you may go blind !! :-) -Original Message- Sent: 06 July 2001 14:57

Re: Oracle9i on Suse Linux

Jonathan, SuSE 7.1 uses glibc 2.2, while previous versions used version 2.1. You can find the location of the patch to fix this on both www.suse.com and at MetaLink. Sorry, can't help with the other stuff, though I did have problems with Java. There's some MetaLink stuff about that too.

Batch updates

I'd appreciate hearing from folk what solutions there are for the following scenario. Users with laptops want to be able to input data whilst not connected to database for subsequent upload to database. Apart from developing PL/SQL code to realise this functionality with associated integrity

RE: * Oracle DBA Needed in Phoenix..

May they bought you already, keep the HP example in mind... Koivu, Lisa [EMAIL PROTECTED]@fatcity.com on 06.07.2001 15:56:40 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Cheap!  Cheap Cheap Cheap

Re: OT: Learning Curve for Informatica ETL Products

I just gave it disk space and largely ignored it. Never had a problem with it. Jared On Friday 06 July 2001 06:46, Farnsworth, Dave wrote: This is true, unless of course it is running on Ardent's UniData or Universe database. That is something else to work with. Dave -Original

Re: OT: friday rambelings....

for the weakest link, depends on how the DBAs are up against. Duhvelopers?, Damagement. now dont all you developers get offended, unless of course the title fits :) bye all, i'm off to camping for the weekend, no cell, no pager, no laptop, first time in like 7 years, i'll be totally

Re: Where is the lock?

Sean, A lock would normally go away when the database is shut down, but if the problem was in the application (or the users), the lock would probably come right back again. Check In v$lock for type TX locks with lmode=6 . These are exclusive row locks caused by updates or select for

Re[2]: OFA (Optimal Flexible Architecture) in practice

IMHO I think you all have got the reasons for OFA somewhat backwards. Back in the older days one had one and only one version of Oracle running on a particular machine at one time. This made upgrading/migrating or running a new version in test while the older one was still running production

Re: Oracle9i on Suse Linux

Jared, Oracle 9i is certified with Suse 7.1 out of the box. It specifically needs the 2.4.4 kernel and glibc 2.2. There should be no need for any patches. Regards, Mike |+--- || Jared Still | || jkstill@cybc| ||

Index Behaviour

Hi, In the following query membno is a Non Unique Indexed field: select surnam from basic where membno 10. Whether the table is analyzed or not the Explain Plan still shows a Full Table Scan unless I specify a Hint to use the Index. Using the index is more costly so I would expect CBO to

Re: * Oracle DBA Needed in Phoenix..

With our current economic conditions it's a buyer's market. Peter, It probably means that they're willing to relocate someone but don't want to pay a ton of money to relocate someone who owns a house. There can be more than $10,000 worth of closing costs, moving costs, guarantee to

Re: * Oracle DBA Needed in Phoenix..

Mercadante, Thomas F wrote: Lisa, imitating a bird... Cheap! Cheap Cheap Cheap next will be I taught I taw a puddy-tat i DID, i did see a puddy-tat!;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED]

RE: strange explain plan

Gene, This is not much help I'm afraid but are the statistics etc on both the old and new table at the same stage (preferrable both up to date)?. I've tried to recreate this on NT with no success, keep me informed. Dave Leach -Original Message- Sent: 06 July 2001 14:36 To: Multiple

Re: Range partition

a multi-key partition will not work for you or am i missing something in the question? joe, living on the bleeding edge trying to get stupid management server of OEM to work for 9i :) [EMAIL PROTECTED] 07/06/01 10:26AM Hello,Oracle 8.1.7 on Sun SolarisScenario: We have a table where we

OT: friday rambelings....

having watched both weakest link and who wants to be i wonder how the DBA crowd would fair on them? -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta

Re: sqlplus command

Milind, You can't do sqlplus from procedures. There are some ways to get output from pl/sql. One is to use the dbms_output package, which does send output to a sqlplus session if you have set serveroutput on. Another idea that's used might be to put your output lines into a staging table, each

Re: Standby Database

Rich, no problems other than, the "performance" issue, if they are hitting it hard and oracle lags in trying to post the logs to the standby database. other than that it should be fine. Joe [EMAIL PROTECTED] 07/06/01 11:27AM Just wondering if anyone sees any problems with creating a

Re: Using data dictionary tables to manage application

I have use Oracle data dictionnary tables and packages . Just make sure you encapsulate them with views and your own packages in order to be more independant. --- Johnson Poovathummoottil [EMAIL PROTECTED] a écrit : Hi All, Our Application design group is designing an application which

RE: Range partition

Waleed, I have already tried this approach. The data didn't go to the right partition. Oracle is just using the first column to determine the partition. Thanks Prakash -Original Message- Sent: Friday, July 06, 2001 12:27 PM To: Multiple recipients of list ORACLE-L Your partition key

Rollback usage

Hi All, Does anyone have a script or know of a way to determine which user is using which rollback segment? I had a developer issue a set transaction before she started a migration and I wanted to see if I could make sure that she was using the proper rollback segment. Thanks a lot:)

RE: Rollback usage

I believe that I got this off of this list a while back... clear columns column rbs format A7 heading 'RBS' column ora_usr format a10 column program format a39 column sid format select r.name rbs, s.sid SID, substr(osuser,1,10) os_user, nvl(s.username, ' -- ')

RE: Standby Database

Richard, As long as the 2nd instance doesn't interfere with the application of archived redo logs to the standby, I don't see a problem. I routinely use the extra CPU available on our standby server (Win2K) to zip up exports from production and other, similar tasks that would otherwise put

notification of password expiration?

Hello all, Can anyone share any ideas on this? We have a procedure in our Oracle databases that forces a user to change there password after x number of days. This password procedure also forces them to use num-alpha characters. Our lead Oracle admin turned off the procedure because

Re: How to implement and use DBMS_STATS?

Don Burleson just released (via Oracle Press) and entire BOOK on using STATSPACK. From: Jesse, Rich [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How to implement and use DBMS_STATS? Date: Fri, 06 Jul 2001 08:20:56 -0800

Re: Re[2]: OFA (Optimal Flexible Architecture) in practice

This was my memory as well. I thought separating archive, redo, indexes, data and so on predated OFA. Also, I read through the comments pretty quickly but I thought Oracle discouraged the use of symbolic links for data files. I've seen this done without trouble but isn't there some potential

Re: Batch updates

We briefly thought of using Oracle Lite. It uses a subset of replication and advanced queueing to do its magic. It looked like it might have worked. But, as we wanted to sell a product, Oracle Lite licensing added like 300 bucks a seat to the product, so the boss decided not to go with it. Of

RE: RULE versus CHOOSE

See http://www.sucs.swan.ac.uk/~arthur/jargon/html/The-Jargon-Lexicon.html At 09:20 AM 7/6/01 -0800, you wrote: Jon Great Answers Indeed . What does IMHO stand for though ? Thanks Again so much . Vivek -Original Message- Sent: Friday, July 06, 2001 8:11 AM To: Multiple

Re: Re[2]: OFA (Optimal Flexible Architecture) in practice

On Fri, 6 Jul 2001,[EMAIL PROTECTED] scribbled on the wall in glitter...: -This was my memory as well. I thought separating archive, redo, indexes, data -and so on predated OFA. Also, I read through the comments pretty quickly but I -thought Oracle discouraged the use of symbolic links for

Re: Oracle9i on Suse Linux

9i? I must have been thinking of my 8i install. Sorry. Jared MHately@etech-

Re: OT Bears

Keep in mind that many many animals only still exist at all because of zoos. And unfortunately that will continue to be more and more true in the future. I much prefer my animals wild as well, but I'd rather see them then not see them at all. Marc Perkowitz. - Original Message - To:

export in cron

I beleave I asked this question already but did not get any answers. If I run export from cron and somehow userid is incorrect or dump file name is incorrect ( let say somebody renamed directory) - process of export is stopped. Is it possible to catch this situation in the same script that

DBMS_JOB

Dear DBAs I have submitted a job to run at a time but never go. I had to send dbms_job.run(jobno) and then the job will run at defined interval. My question is 1. I have to exec dbms_job.run(jobno) everytime to init the the new job. 2. What is real meaning for JOB_QUEUE_PROCESSES and

RE: * Oracle DBA Needed in Phoenix..

$75,000 is pretty good. Our company (in Washington, DC) just hire a ORACLE DBA. He claimed he have OCP certificate and ONLY asked $60,000. From: Mercadante, Thomas F [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: * Oracle

RE: OT: friday rambelings....

Mmfriends, family, tent, fire and beer:) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: Friday, July 06, 2001 12:53 PMTo: Multiple recipients of list ORACLE-LSubject: Re: OT: friday rambelings for the

RE: Range partition

I tried that but it didn't work. Oracle is just using the first column to determine the partition. Prakash -Original Message- Sent: Friday, July 06, 2001 1:33 PM To: Multiple recipients of list ORACLE-L Can't you use a composed range key. --- Bala, Prakash [EMAIL PROTECTED] a écrit 

RE: Rollback usage

Wow thank you:) I knew it had to exist. KK -Original Message- Tom Sent: Friday, July 06, 2001 1:21 PM To: Multiple recipients of list ORACLE-L I believe that I got this off of this list a while back... clear columns column rbs format A7 heading 'RBS' column ora_usr format a10

SAP R3 and Locally Managed Tablespaces

In working with our SAP consultant, I've discovered that SAP may not yet support the use of LMT's on Oracle. Yes I know that SAP should not really care about this, but SAP seems to care about a number of things that would be best left to the DBA. Does anyone have experience with SAP and LMT's?

RE: Accessing Oracle and MVS/CICS (IMS) data sources

We don't have CICS, but we have IMS on the mainframe and we have BMC's ChangeDataMove to capture changes in IMS and move the changes on to UNIX Oracle data base. We also have IMS online transactions communicating with Unix Oracle data bases thru Neon's Shadow Web Server which runs on the

RE: OT Bears

Bears become a problem when they get too familiar with man and when man intrudes into the bear realm and is not familiar with bear behavior. When bears get too familiar with man the rangers sometimes have to destroy them. Sometimes the Yosemite rangers helicopter problem bears to the Yolla Bolly

Re[2]: Range partition

Joe, My thought exactly. Normally we think of partitioning in a linear fashion, namely one table broken up into pieces that should stack one on top of the other. But two dimension partitioning is possible using the multi-key method. Only problem that I'm aware of, through 8.1.6 is that

RE: notification of password expiration?

Oh man...have I been dealing with this lately! We had a similar problem. We had a security audit come in and ask us how often the users changed passwords. The honest answer of 'to my knowledge they never have' did not sit well with them. Go figure. So first we set up user profiles. We

RE: export in cron

If I understood what you want clearly, In the same shell script, immediately after export command,have some grep command to look for errors in export log file.Depending on the sucess/failure($?) of grepping, have commands to do whatever you want. hth, Suren -Original Message- Sent:

Re: Re[2]: OFA (Optimal Flexible Architecture) in practice

www.hotsos.com --- Thater, William [EMAIL PROTECTED] wrote: On Fri, 6 Jul 2001,[EMAIL PROTECTED] scribbled on the wall in glitter...: -This was my memory as well. I thought separating archive, redo, indexes, data -and so on predated OFA. Also, I read through the comments pretty quickly

RE: OT Bears

A joke that has been going around the office the last couple of days kind of fits with this. Not that bears have anything to do with Oracle but I am just coming off a 36 hour downtime in which I upgraded two Oracle databases, complete reconfigured another one, and getting tired of waiting for

RE: Standby Database Replication

I need to implement the standby database for the Txn. Proc. Prod. system. I have a few doubts. If the failure/disaster happens to prod DB, and can't open the DB, then How to transfer the contents of online logs to standby database? My logs would switch once every hour, and so, I would lose

RE: export in cron

Problem is that when export is stopped it does not return control to the script. Alex Hillman -Original Message- Sent: Friday, July 06, 2001 2:52 PM To: Multiple recipients of list ORACLE-L If I understood what you want clearly, In the same shell script, immediately after export

RE: How to implement and use DBMS_STATS?

He asked about DBMS_STATS - not STATSPACK. I do not know any other source except docs and metalink describing DBMS_STATS. Alex Hillman -Original Message- Sent: Friday, July 06, 2001 1:47 PM To: Multiple recipients of list ORACLE-L Don Burleson just released (via Oracle Press) and

RE: SAP R3 and Locally Managed Tablespaces

Maybe in the versions that they sertified LMT bugs were not fixed yet. What DB version do you use and on what platform? Alex Hillman -Original Message- Sent: Friday, July 06, 2001 2:31 PM To: Multiple recipients of list ORACLE-L In working with our SAP consultant, I've discovered

RE: * Oracle DBA Needed in Phoenix..

Sounds like the kind of thing I would do. Then, months later, you realize that you are the lowest paid person in the department or on the site... Sigh Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: ef 8454 [SMTP:[EMAIL PROTECTED]]

RE: * Oracle DBA Needed in Phoenix..

Your company is either cheap or your new dba has no clue. DC is one of the highest paying locales in the USA. Now if you said 75k was not bad in Florida, I would agree (companies in florida are cheap), unless you were a contractor of course. [EMAIL PROTECTED] 07/06/01 02:41PM $75,000 is

RE: * Oracle DBA Needed in Phoenix..

$60K and OCP. Hmm Can you say 'no experience'? Jared ef 8454

RE: Index Behaviour

Dave, I think is like using the NOT operator, thus an index can not be used. Think about it - your asking the optimizer to find records in the index that are not there - nothing to really search on - so it does a FTS. Now if you did select surnam from basic where membno between 0 and 9

Re: Re[2]: OFA (Optimal Flexible Architecture) in practice

[EMAIL PROTECTED] From: Thater, William [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Re[2]: OFA (Optimal Flexible Architecture) in practice Date: Fri, 06 Jul 2001 10:26:28 -0800 On Fri, 6 Jul 2001,[EMAIL PROTECTED]

Re: export in cron

Alex, Try using 'expect'. Homepage: http://expect.nist.gov/ It's designed for exactly the purpose you have in mind: trapping responses from programs that normally operate interactively and don't easily lend themselves to automation. Expect is also available as a Perl module.

  1   2   >