Semaphore problem

2003-08-14 Thread Smith, Ron L.
Has anyone ever seen an error like: ERROR: rbusy(SEMOP) (13; Permission denied) There is no Oracle error associated with it. Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services--

RE: Off Topic Question - Update.inf file

2003-08-14 Thread Thater, William
Joe Testa scribbled on the wall in glitter crayon: Good point, i'm such a bigot as i used linux back when it was minix and have been doing unix admin work for 20 years now ;) joe well, unlike you there are now starting to be a number of linux users that are just windows users in

possible to set max_extents for lobs at tablespace level?

2003-08-14 Thread rgaffuri
my max_extents for my tablespace is set to 505, yet all my lob segments default to a max_extent of 121. is it possible to have them use the tablespace default? or set up a default for all lob segments to use? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL

streams comments

2003-08-14 Thread becker . bill
Hello, env: Oracle 9.2.0.3 on Solaris. I am looking for any comments, good or bad, regarding Oracle Streams. We are considering using this to transfer data between some 9.2 databases on multiple Sun machines, and hope that someone would share their experience with us. Our rationale for using

RE: Raid 1 vs Raid 5 for tablespaces

2003-08-14 Thread Cary Millsap
Problem with head-to-head price comparisons is that software RAID level 0 has hidden costs that a lot of folk might not understand before purchasing. For example, I would argue that software RAID level 0 costs a heck of a lot more than the list price, because it robs CPU capacity from your

re corrupted online redo logs and archivelogs -- was RE: PTC

2003-08-14 Thread Hemant K Chitale
Oh yes, do please inform people of the need to keep multiple backup sets ! I did see that the online redo log file and the last two archive logs plus two datafiles in the last online backup set were bad -- this happened as the I/O controller had errors while the Hot Backup to disk was running.

RE: OT -- Boston Globe job listings

2003-08-14 Thread DENNIS WILLIAMS
Ken - Since you've recently changed jobs, your upbeat attitude is encouraging. I think you've made a good point that jobs aren't always advertised. Another point is that when there are more jobs than available candidates, companies have to advertise strongly to fill their positions. When there are

RE: RMAN Script Question

2003-08-14 Thread David Wagoner
Title: RMAN Script Question Thanks Samir, but I already tried that one too and it didn't work either. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions-Original Message-From: SARKAR, Samir [mailto:[EMAIL PROTECTED]Sent: Wednesday, August 06, 2003

A real newbie DBA question on setting up a 9i client

2003-08-14 Thread Wolfe Stephen S GS-11 6 MDSS/SGSI
When I configure an 8i client to attach to an Oracle database, I always have the The service name which has always been the database/instance name -- I assume these don't necessarily have to be the same, but it appears to be that way for single database applications. I also have the host name

RE: OCP Question

2003-08-14 Thread Mercadante, Thomas F
Jay, I would guess B and E. I see no reason for a redo-log switch. Looks like a trick question. B is one correct answer. The other correct is either E or A. I would go for E. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, August 05, 2003 11:59 AM

Re: ora 1575?

2003-08-14 Thread Tim Gorman
Tanel hit the nail on the head. In the past, ORA-01575 was usually associated with temporary tablespaces that were DMT and not tablespace type TEMPORARY (which started in Oracle7.3). First and foremost, please make sure you are using a TEMPORARY tablespace which is locally-managed and uses

RE: HELP! Index Debate!

2003-08-14 Thread Henry Poras
Interesting analysis. Thanks. Henry -Original Message- Wolfgang Breitling Sent: Monday, August 04, 2003 11:49 PM To: Multiple recipients of list ORACLE-L Yes, the index can be used, but only the portion up to the first missing column, or a column where the predicate is not an equal

RE: Re: OT -- Boston Globe job listings

2003-08-14 Thread Stephane Faroult
When I worked for Oracle's custom development group I worked on a large conversion project that employed about 350 consultants (150 from Oracle). They had a number of foreign consultants on the project. About 1 in 10 had technical skills that were above mediocre, but they worked cheap. The code

Cisco security notice mentions the blaster worm possibly affectin

2003-08-14 Thread Rodrigues, Bryan
://www.cisco.com/warp/public/707/cisco-sn-20030814-blaster.shtml. In addition to worldwide web posting, a text version of this notice is clear-signed with the Cisco PSIRT PGP key and is posted to the following e-mail and Usenet news recipients: * [EMAIL PROTECTED] Future updates of this notice

HP-UX

2003-08-14 Thread Seema Singh
Hi, Can someone send me system administration document on OS HP-UX 11.0 if have ? thx -Seema _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official

RE: HP-UX

2003-08-14 Thread Nelson, Allan
The standard manual set is quite large. You might try HP-UX 11.x System Administration by Poniatowsky. A really short quide capable of being sent to you in email might exist. If so it will only suffice to make you extremely dangerous and will almost certainly get you into a lot of trouble. At

Re: OT -- Boston Globe job listings

2003-08-14 Thread KENNETH JANUSZ
When I worked for Oracle's custom development group I worked on a large conversion project that employed about 350 consultants (150 from Oracle). They had a number of foreign consultants on the project. About 1 in 10 had technical skills that were above mediocre, but they worked cheap. The code

RE: Executing Oracle stored proc. over SQL Server linked services

2003-08-14 Thread Paula_Stankus
Title: RE: Executing Oracle stored proc. over SQL Server linked services We have installed 9i client and 9i ole db provider and are trying to execute a procedure with input/output variables over a linked service in SQL Server database. We keep getting an error about undefined column. Has

Re: streams comments

2003-08-14 Thread Tanel Poder
Stephen, Did you write all the parameters by hand or used a script? ;) analyze table have exec DBMS_STATS.ONE_OF_273_POSSIBLE_CALLS(arg1, arg2, arg3, arg4, arg5, arg6, arg7, arg8, arg9, arg10, arg11, arg12, arg13, arg14, arg15, arg16, arg17, arg18, arg19, arg20, arg21, arg22, arg23,

RE: OT -- Boston Globe job listings

2003-08-14 Thread Pardee, Roy E
Companies will wake up--or as likely--the offshore techies' skills will grow with experience their work product will get better. Hopefully they'll also raise their prices at that point, tho they'll still have to entice companies to deal with the geographic/time/cultural differences so I'd

RE: HP-UX

2003-08-14 Thread Jesse, Rich
How's about a link instead? http://www.bookpool.com/.x/6oqxxyd9k4/sm/0130125156 Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Seema Singh [mailto:[EMAIL PROTECTED]

RE: OT -- Boston Globe job listings

2003-08-14 Thread Stephen Lee
But lower paying jobs mean lower tax revenues. Uh oh! -Original Message- Regrettably that average collection of greedy, stupid executives are also the politicians we have to deal with as well. Just take a look at King George his greedy deputy Chaney. -- Please see the

RE: OT -- Boston Globe job listings

2003-08-14 Thread Stephen Lee
Back in the days when I used to do configuration management (among other things), I saw which programmers were producing what code and found that a good programmer would average about 10 - 20 times the amount of a typical programmer. And a kick ass programmer would produce about 100 times the

OT -- Boston Globe job listings

2003-08-14 Thread Boivin, Patrice J
I've been keeping an eye on the Boston Globe's Oracle DBA job postings, two years ago it wasn't uncommon to see eight or more per week, now I tend to see one or two, or none. For a while they also announced big IT job fairs, I don't know if they still do that or how successful they now are. The

RE: SQL*Loader - append to a table while checking column against another table

2003-08-14 Thread Stephane Faroult
If you load your data into a table with an enable foreign key, it will be checked on the fly by SQL*Loader with the conventional path. In direct mode it disables constraints, and I am unsure whether it checks them when reenabling them (something which you can optionally get); any way it would

RE: OT -- Boston Globe job listings

2003-08-14 Thread Goulet, Dick
Considering the defecits theur running up, that sure does not seem to bother them, or is that just the stupid part, as in we will not burden our childern part of last years State of the Union. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday,

RE: OT -- Boston Globe job listings

2003-08-14 Thread Nelson, Allan
At least some parts were. We use OPM here and it was a conversion of GEMMS done in India. Allan -Original Message- Sent: Thursday, August 14, 2003 11:05 AM To: Multiple recipients of list ORACLE-L Wasn't Oracle 11i developed outside the USA? The initial implementations were a real

RE: OT -- Boston Globe job listings

2003-08-14 Thread Boivin, Patrice J
Didn't the UK outsource their IT function to EDS? Patrice. -Original Message- Sent: Thursday, August 14, 2003 1:45 PM To: Multiple recipients of list ORACLE-L You should try the UK. The government seems to be actively encouraging this sort of thing. I think they see short term gains

RE: Off Topic Question - Update.inf file

2003-08-14 Thread Orr, Steve
Hey Shrek, that could go both ways... Regarding... ...linux users that are just windows users in disguise. And... someone had installed linux... and he couldn't tell the difference. It depends on your perspective. The above could also be interpreted to mean, There are a lot windoze user that

RE: How to tell Oracle the directories of script files

2003-08-14 Thread Martin, Alan (Contractor) (DLIS)
Title: RE: How to tell Oracle the directories of script files Use SQLPATH. Alan Martin Defense Logistics Info Service Battle Creek, MI -Original Message- From: Reuben D. Budiardja [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 14, 2003 2:09 PM To: Multiple recipients of list

ORACLE CLIENTon linux

2003-08-14 Thread Seema Singh
Hi, Does anyone know oracle client(8.1.6) available on linux(Red hat EE) ? If not can I run l higher client with old version of database(oracle 8.1.6)? thx -Seema _ The new MSN 8: advanced junk mail protection and 2 months FREE*

RE: RE: OT -- Boston Globe job listings

2003-08-14 Thread Stephane Faroult
Ken - Since you've recently changed jobs, your upbeat attitude is encouraging. I think you've made a good point that jobs aren't always advertised. Another point is that when there are more jobs than available candidates, companies have to advertise strongly to fill their positions. When there are

RE: Off Topic Question - Update.inf file

2003-08-14 Thread Nelson, Allan
Actually there is a Linux clone of MechWarriors Allan -Original Message- Sent: Wednesday, August 13, 2003 12:54 PM To: Multiple recipients of list ORACLE-L How could they not tell the difference? Windows runs MechWarriors; Linux doesn't. What more is there to know? -Original

is lazydba list server down

2003-08-14 Thread Jeffrey Beckstrom
I have not received mail from it in several days...is it down? Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204

Re: OT -- Boston Globe job listings

2003-08-14 Thread Joe Testa
Steve taking that a bit further, you're important enough to be doing wireless email in caribbean, remind me to NOT be that way IF i ever grow up :) joe Orr, Steve wrote: I'm ideologically opposed to almost anything that obstructs free trade, even if it directly affects my personal economy,

RE: OT -- Boston Globe job listings

2003-08-14 Thread Chelur, Jayadas {PBSG}
Scott Adams has said it all ... http://www.dilbert.com/comics/dilbert/archive/dilbert-20030803.html -Original Message- Sent: Thursday, August 14, 2003 2:20 PM To: Multiple recipients of list ORACLE-L I'm ideologically opposed to almost anything that obstructs free trade, even if it

RE: OT -- Boston Globe job listings

2003-08-14 Thread Goulet, Dick
Allan, Regrettably that average collection of greedy, stupid executives are also the politicians we have to deal with as well. Just take a look at King George his greedy deputy Chaney. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday,

Re: OT -- Boston Globe job listings

2003-08-14 Thread Joe Testa
Steve now thats one of the funnier things i've read for a while, that will probably work. joe Orr, Steve wrote: Usually these kind of customers don't actually meet the live DBA's in person so there's gotta be a hack work-around solution to this. Here's what I propose: Setup a domain name with

RE: Off Topic Question - Update.inf file

2003-08-14 Thread Mark Leith
Check this out: http://www.annoyances.org/exec/forum/winxp/t1032598735 HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED]

you can take the user off windows, but... (was RE: Off Topic Question - Update.inf file)

2003-08-14 Thread Pardee, Roy E
This is an excellent point. Anybody remember when there was (is?) a stigma associated with being an AOL user, as opposed to using a real ISP? AOL made things easy enough that the less adept could 'get on the internet', where they were generally reviled by the old-hands, who were more of a

How to tell Oracle the directories of script files

2003-08-14 Thread Reuben D. Budiardja
Hello, Suppose I have some SQL scripts in my /home/user directories, /usr/local/bin directories, etc. If I start 'sqlplus' from console in /home/user directories, I can load/execute the script by doing: SQL @scriptname But what if I don't start sqlplus from that directories? How do I tell

RE: HP-UX

2003-08-14 Thread Jesse, Rich
Doh! I should've gone to bestbookbuys, like someone had posted last week or so: http://www.bestwebbuys.com/books/compare/isbn/0130125156/isrc/b-home-search Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA

Re: OT -- Boston Globe job listings

2003-08-14 Thread KENNETH JANUSZ
I don't think it has as much to do with no available positions (although that is part of the answer) as most medium to large companies don't use newspaper ads anymore. They are using the internet (especially for technical jobs) and are signed up with Monster, BrassRing, etc. to do their

RE: OT -- Boston Globe job listings

2003-08-14 Thread Mladen Gogala
Let me guess: MCI-Worldcom, Global Crossing or Enron? -- Mladen Gogala Oracle DBA -Original Message- Jesse, Rich Sent: Thursday, August 14, 2003 12:05 PM To: Multiple recipients of list ORACLE-L I know of one Fortune 50 company (US) that has a local division that has fired all of

RE: Question on views

2003-08-14 Thread Pardee, Roy E
I think that's a fair characterization. What makes them cool (and dangerous) is that you can set Oracle up to automatically treat queries like SELECT * from MyTable as if they said SELECT * FROM MyMaterializedView instead. That's the query rewrite feature. If the MV is based on a query that

RE: Raid 1 vs Raid 5 for tablespaces

2003-08-14 Thread Jared . Still
Yes, it isn't quite the same as actually growing a RAID device, but it kind of looks like that in the end. It certainly requires some good management skills, or you can create quite a mess. With power comes complexity. Jared Matthew Zito [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]

RE: OT -- Boston Globe job listings

2003-08-14 Thread Stephen Lee
I'm a senior DBA (whatever that means), and I do lot of ad hoc scripting for other people, and I don't get no 75K. But then, I'm not working for 35K to 40K either -- except when I was at WorldCom four years ago where I worked for 44K. They figured out how to get the best of both worlds: Work

RE: OT -- Boston Globe job listings

2003-08-14 Thread Odland, Brad
RANT The problem is that companies are scrambling to cut costs to keep that quarterly report looking good. Sometime ago some CEO found that if the quarterly report looked good he justified getting paid more. So the emphasis has been year after year to plan for the next quarter. Now that the

RE: TNS errors

2003-08-14 Thread Ken Hitchcox
I just wanted to report progress. It was @tns:name that solved this problem. Next step is resolving all the print problems that citrix is know for. Ken -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Saturday, August

Re: Semaphore problem

2003-08-14 Thread Stephane Faroult
Fermin Bernaus wrote: Did you have a look to the alert file? what does it say? error 13 means some kind of permission has been violated at the OS level (at least under UNIX) probably trying to access a file (for cration, reading or whatever) Fermin. -Mensaje original-

Re: ora 1575?

2003-08-14 Thread Gurelei
Tim, thanks for the info. We do have a number of DMTS in the database. Three of them have pct_increase of 50%, the rest - 0. Should I consider changing the pct_increase to 0 in all tablespaces in order to get rid of this ora 1575? Wouldn't I want to have an automatic coalesce process for the DMTS

RE: How do I find out the size of a index

2003-08-14 Thread Jared . Still
... or even the actual size of the data use dbms_space for that DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/13/2003 10:39 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I find

RE: Raid 1 vs Raid 5 for tablespaces

2003-08-14 Thread Mladen Gogala
It robs of CPU power, that's true, but I've never seen a place where CPU consumption would go above 30% on average. If it does, then it's time to upgrade, or to quote the Taco Bell dog, you need a bigger box. With approximately 70% left idle, companies usually have a few percent of the CPU power

RE: OT -- Boston Globe job listings

2003-08-14 Thread Stephen Lee
No no! Not EDS. That was Ed's. As in: Ed's plumbing, welding, and database admin ( and professional dancing) -Original Message- Didn't the UK outsource their IT function to EDS? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL

Re: Oracle and Windows 2000 SP4 - any experiences to share

2003-08-14 Thread Jared . Still
I'm sure many of us would love to know how to disable that thing. I know I would. Jared Tanel Poder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/08/2003 04:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:

RMAN Backup piece being placed in wrong directory

2003-08-14 Thread Stefick Ronald S Contr ESC/HRIDD
Title: Message OS: Win2K DB: 8.1.7.4 All, Here is what I am running: run{set archivelog destination to 'D:\backup\oracle\Hotbackup';set controlfile autobackup format for device type disk to 'D:\backup\oracle\Hotbackup\cf_%F.bak';backup database

RE: Oracle Name Server

2003-08-14 Thread Jesse, Rich
It can't -- unless you haven't tried replication in OiD. H doggy. It's a hacked implementation of AR and works like it. Then again, this was 9.0.1 on Linux. Perhaps things have changed, but I don't have the time nor the hair to figure that out. Rich Rich Jesse

Re: Take an Oracle 8.1 export file back to an Oracle 7.1 database.

2003-08-14 Thread Tanel Poder
Title: Message Hi! You just set compatible and optimizer_features_enable to 8.1.7 ;) Tanel. - Original Message - From: Mladen Gogala To: Multiple recipients of list ORACLE-L Sent: Thursday, August 07, 2003 8:29 PM Subject: RE: Take an Oracle 8.1 export

RE: Change based recovery

2003-08-14 Thread Fermin Bernaus
Thank you all for your suggestions. I really have no time for downtime during the week, but we have space to keep the archived logs on disk but not a backup (even a partial hot backup) of the database unless I move it to a tape, which is too much time and resource consuming, so here is

Re: RE: how to turn off ODBC auto-commit?

2003-08-14 Thread rgaffuri
it says it is in tom kytes book. he says its there because ODBC is written by microsoft and sql server needs to commit often because reads blocks writes and you run into concurrency issues. From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/08/11 Mon AM 10:44:29 EDT To: Multiple recipients

RE: tables and views

2003-08-14 Thread Igor Neyman
Views arent in all_tables, they are in all_views. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of AK Sent: Friday, August 08, 2003 1:19 PM To: Multiple recipients of list ORACLE-L Subject: tables

RE: How do I create a temp table with no logging?

2003-08-14 Thread DENNIS WILLIAMS
Jake - The syntax is create table test2 nologging as select * from test; Taking the advice of the experts on this list, I decided to confirm this, I ran the query Mike Hatley posted a few days ago: select s.sid,s.value from v$sesstat s where s.statistic#=99 and s.value!=0 I found some

Re: Can't insert into partition

2003-08-14 Thread Tanel Poder
Btw, have you noticed that you have a dot instead of comma in your hash hint: SELECT /*+ use_hash(cjs, ps. md, a, o, x, wv, apc, wv1) */ How big are your tables - why do you want to have hash join on all of them? Hash joins aren't fast if you got huge datasets and little hash_area_size...

RE: HP-UX

2003-08-14 Thread Nelson, Allan
It's out of stock, Allan -Original Message- Sent: Thursday, August 14, 2003 12:14 PM To: Multiple recipients of list ORACLE-L How's about a link instead? http://www.bookpool.com/.x/6oqxxyd9k4/sm/0130125156 Rich Rich Jesse System/Database Administrator

RE: RMAN Backup piece being placed in wrong directory

2003-08-14 Thread Freeman Robert - IL
Good point Tom RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/7/2003 1:29 PM Ronald, It looks like just the archivelog was not going into the correct directory, right? But then you did *not* include a format clause for the archivelog. Looking at the

RE: [stupid] vi question

2003-08-14 Thread Mladen Gogala
:1,$s/^v^M$/^v^G/ -- Mladen Gogala Oracle DBA -Original Message- Saira Somani-Mendelin Sent: Wednesday, August 06, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Suddenly my vi editor is showing ^M at the end of each line. How do I get rid of it? Thanks in advance, Saira

RE: More On 10G

2003-08-14 Thread Mladen Gogala
You are definitely reading writings of Hans Christian Andersen. -- Mladen Gogala Oracle DBA -Original Message- Boivin, Patrice J Sent: Wednesday, August 06, 2003 1:34 PM To: Multiple recipients of list ORACLE-L I think 10G is supposed to be faster than 9i Release 2. I read too much

Re: what is BAARF? --- OFA

2003-08-14 Thread Tanel Poder
Hi! 4) I think the /u01, /u02, etc. MP naming is a pain. They mean nothing. In a disaster recovery, the last thing you want is to have someone forget what /u01 is. This is the 21st century, people! We have the power to NAME DIRECTORIES something meaningful! I still like to use concept

Re: ora 1575?

2003-08-14 Thread Tanel Poder
Check that the less than 1% of sorts aren't huge ones and not done by user whose temporary_tablespace is pointed to permanent one.. system for example. (Just a note that you can get temporary segments to non-temporary tablespaces due failed index (re)creations, and create table as select) Tanel.

RE: Raid 1 vs Raid 5 for tablespaces

2003-08-14 Thread Matthew Zito
The _only_ even theoretical advantage to software RAID-0 is that software RAID implementations tend to have more flexibility than the hardware ones. For example, there are a number of software RAID implementations that allow you to grow RAID-0 volumes, something that is generally not allowed in

RE: View question

2003-08-14 Thread Teresita Castro
Thanks for answer me. The problem that I have is the next, I have to calculate from a item transaction table the stock on hand to determinate date, (to made different reports). To do this I made the next query: SELECT DISTINCT ITEM, SOH_QTY, UPDATE_DATE, UPDATE_TIMEFROM ICTRANS b1WHERE

RE: oracle 9 IAS

2003-08-14 Thread April Wells
none out yet. Don Burleson is supposed to have one out on Oracle Press in November... don't know how beginner it will be, but I think it is on Amazon. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam

RE: It's an Oracle Fun Friday!

2003-08-14 Thread Stephane Faroult
Just looking at netcraft.com to see what Oracle's running these days, when I noticed their netblock is owned by Oracle Datenbanksysteme GmbH. German Oracle First move before the SAP AG hostile takeover bid? Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ:

RE: quick suggestions for tuning ?

2003-08-14 Thread DENNIS WILLIAMS
Prem Head for http://www.hotsos.com and study their documents. Cary Millsap, who is kind enough to participate on this list, has identified LIO as a key performance issue. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, August

Re: What books recommended for Data Modeling ?

2003-08-14 Thread Dilip Patel
Hi All, Need some suggestions/Input. My application database is 8.1.7, NOARCHIVELOG, WIN200, total size 4 GB, more of single user OLTP client-server application. Now the customer wants to give training on this application to hundred trainees at a time. For this he wants to install hundred

RE: Can't insert into partition

2003-08-14 Thread DENNIS WILLIAMS
Wolfgang Thank you so much! You spotted something that we had overlooked! The dot/comma was indeed the problem. And thanks to you and everyone else for the help that helped narrow the problem down to this point. It seems that as you pointed out, the hint had a syntax error all along, but CBO

RE: [stupid] vi question

2003-08-14 Thread Cary Millsap
If you're using Vim, it's ^q instead of ^v: :%s/^v^M//g -- vi :%s/^q^M//g -- Vim Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Denver, Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for

RE: Downloading patchests from Metalink

2003-08-14 Thread Willett, Mark
Title: Message I just downloaded a patch a few minutes ago from oracle-updates-west.conxion.com - no problem. Mark Mark Willett Corporate Database Administrator - The statements and opinions expressed

RE: URGENT: Trying to duplicate database from cold backup - auxi

2003-08-14 Thread Jack van Zanen
Title: Message Hi Paula Another issue you may encounter is that duplicate in 8.1.7may not work w/o a "set until" clause see bug 2329702 Jack -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 11:09 PMTo: Multiple recipients of

Re: How to tell Oracle the directories of script files

2003-08-14 Thread Reginald . W . Bailey
Yes there is a way. In UNIX environments (I think this works in NT/2000 as well) you can set the environment variable SQLPATH to a list of directories that contain SQL files. SQLPlus will search this path if the file is not found in the current directory. RWB

RE: Downloading patchests from Metalink

2003-08-14 Thread Nelson, Allan
Title: Message yep, ftp to update.oracle.com. Login with your metalink credentials and cd to the patch directory using the number with no p on the prefix. That has worked for me today. Allan -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Tuesday,

RE: 100 instances on same server !!!

2003-08-14 Thread Jamadagni, Rajendra
We have about 35 instances on each node of RAC they are of course DEVL/ACPT types. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can

RE: Off Topic Question - Update.inf file

2003-08-14 Thread Stephen Lee
How could they not tell the difference? Windows runs MechWarriors; Linux doesn't. What more is there to know? -Original Message- someone had installed linux on the laptop with dual boot defaulted to linux running gnome. and he couldn't tell the difference. boot into windows

Re: quick suggestions for tuning ?

2003-08-14 Thread M Rafiq
Yes, I agree. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 12 Aug 2003 22:19:23 -0800 quote You poor guy. Try to bring some guy with you who can speak English and Japanese to resolve ths communication problem. in 1993 when I was

RE: Referencing other schemas' tables in PL/SQL procedure

2003-08-14 Thread Paul Vincent
Naveen - many thanks! I had a vague recollection that this may be the case, rattling around in the back of my mind, but I couldn't find confirmation in the manuals. Thanks for the definitive answer! It's an annoying restriction, but now we can cope with it! Paul -Original Message-

RE: URGENT: Trying to duplicate database from cold backup - auxi

2003-08-14 Thread Jared . Still
I would be interested how other sites that rely on RMAN handle this issue. I for one, don't use RMAN for that. It's too much work. There's a separate project for verifying backups. The databases I'm called on to duplicate have lately been 400-500 gigs, more than I want to pull from tape

Re: More On 10G

2003-08-14 Thread Nuno Souto
no please! Do NOT light a match Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Sure smells like an IBM SP2 environment to mesomeone light a match or open a windowplease -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto

ORA-3113

2003-08-14 Thread Avnish.Rastogi
Applied 250 OS patches on HP-UX 11.11 server and after that getting ORA-3113 error message every time I do svrmgrl or sqlplus /nolog connect /as sysdba. This database holds RMAN catalog for more than 30 databases and really very critical. Please share your ideas. I already tried to relink and

RE: last column in a table is added with a DEFAULT

2003-08-14 Thread Guang Mei
Title: RE: last column in a table is added with a DEFAULT See the test below: [EMAIL PROTECTED] create table t1 (c1 number);Table created.[EMAIL PROTECTED] insert into t1 (c1) values (1);1 row created.[EMAIL PROTECTED] insert into t1 (c1) values (2);1 row created. [EMAIL PROTECTED]

RE: OT -- Boston Globe job listings

2003-08-14 Thread Mladen Gogala
-- Mladen Gogala Oracle DBA -Original Message- KENNETH JANUSZ Sent: Thursday, August 14, 2003 11:45 AM To: Multiple recipients of list ORACLE-L Dennis: With respect to sending production DBA positions to India, et al. I don't think companies are very included to do this

RE: URGENT: Trying to duplicate database from cold backup - auxi

2003-08-14 Thread Freeman Robert - IL
We have top men working on that right now Mr. Jones. Who? Top Men. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/5/2003 5:29 PM Jared Okay, I'll bite. What do you mean about a separate project for verifying backups. It reminds me of the ending to the

Re: RE: why does block cleanout incur redo?

2003-08-14 Thread rgaffuri
thanks... I have jonathan lewis's book on my list to read. The transaction table is what is modified with the initrans and maxtrans setting. I get it now. when you perform block clean out you modify the block and state that it is no longer being used in this transaction. when the blocks are

RE: RMAN recovery

2003-08-14 Thread Anne Yu
Dennis, I have been admiring you from far. Thank you so much to reply to my email. The renamed data file has been tested and there is no corruption of any kind. The nightly physical and logical backups were successful completed with no error. However, I got an ora-19502 error when I

OCP Question

2003-08-14 Thread Jay Wade
Hello: I was going through some OCP questions and wanted to make sure that my answers where correct. This question comes from a 3rd party testing site, I have been checking each question against my study guides to make sure they are correct. I've done some testing and think that my answers

Antw: OT: Anybody want a job in Tampa FL

2003-08-14 Thread Guido Konsolke
Hi Stephen, I could not scream louder: I WANT. The NFL (or is it NVL) season about to start and the Bucs around the corner. Lucky you in Tampa, poor me in real hot Germany. Today: C:36, F: 96.8. Not the hottest place in Germany today. Greetings to all listers, Guido -- Please see the official

Re: High availability and real time data warehosuing

2003-08-14 Thread hrishy
Hi Alex Thanks for your inputs.I was just wundering when you use tibco do you use it for DR purpose or for feeding the DataWarehouse regards Hrishy --- Alex [EMAIL PROTECTED] wrote: Where I work we use TIBCO rendez-vous messaging software for trading feeds and transactions. On Wed, 6

RE: DECODE or not to DECODE

2003-08-14 Thread Denham Eva
Thanks To all for the support! I managed to use a combination of thesuggestions which worked great! Denham -Original Message- Sent: Monday, August 04, 2003 4:24 PM To: Multiple recipients of list ORACLE-L Hello Listers, I need some help please, I am trying to create a DECODE

Oracle Name Server

2003-08-14 Thread Avnish.Rastogi
We are using Oracle Name Server in our environment. In the past I heard rumors that Oracle Name Server is going away. Is it true if yes what other solution Oracle is providing to replace Name Server. Is it LDAP. Thanks DISCLAIMER: This message is intended for the sole use of the individual to

Using external Authentication with LDAP

2003-08-14 Thread Munish Bajaj
Hi Listers, I am presently working on Oracle 9iR2 latest patchset. I'd like to configure user authentication using external LDAP server. Do I need to Install Oracle9iAS to achive this??? Any Resources/Documentation/Links for reference Any kind of help will be appreciated. Thanks to

Re: It's an Oracle Fun Friday!

2003-08-14 Thread Joe Testa
he's really dead and being cloned from his DNA? joe [EMAIL PROTECTED] wrote: or Stephen - something even worse -Original Message- From: Karniotis, Stephen [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 12:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: It's an

  1   2   3   4   5   6   7   >