Re: Dead locks how ?

2003-09-05 Thread Mladen Gogala
Harvey Deitel: Operating Systems. Andrew Tannenbaum: Modern Operating Systems Avi Silbershatz: Operating System Concepts On 2003.09.06 00:14, Veeraraju_Mareddi wrote: What is a dead lock ? Does oracle manages with a dead lock or DBA has to involve ? What are other locks , latches A DBA has to tak

Re: Off Topic - Norton Internet Security 2003 Software

2003-09-05 Thread KENNETH JANUSZ
Jonathan: Sounds like the same problem I'm having. I have gotten a lot of help from their help desk people, but nothing works. Still the same problems. I have one more suggestion from them to try and then I'll return the CDROM. Do you use anything on your PC's now for internet security? Thank

Re: COBOL to Oracle

2003-09-05 Thread GovindanK
I wonder how the code generator is going to take care of Multiple Record Types , Redefines clauses , Renames clause, GO to statements, Perform Thru , Declaratives? That would be interesting. GovindanK > Hi List, > > Does anyone know of tools, or have had experience using tools, that will > quic

Dead locks how ?

2003-09-05 Thread Veeraraju_Mareddi
What is a dead lock ? Does oracle manages with a dead lock or DBA has to involve ? What are other locks , latches A DBA has to take care of. Any examples, docs, notes will be helpful. Thanks Rajuveera ** This email (including

SGA allocation?

2003-09-05 Thread Veeraraju_Mareddi
Dear Friends, Good Morning, Have just read(in some book) that Oracle allocates SGA in virtual memory of the server. My understanding is that Oracle first try to allocate in real memory because it is relatively faster for accessing. Please clarify, any case studies , scenarios would explain this

Re: Off Topic - Norton Internet Security 2003 Software

2003-09-05 Thread Jonathan Gennick
KJ> I have had this PC with Norton 2002 virus software on it KJ> since I bought it over a year ago. I recently decided to KJ> upgrade to Internet Security 2003 Prof. Ed. Installation KJ> has been a mess. Has anyone attempted to install this on KJ> XP Prof.? If so have you had any problems? If so, a

Re: Offshore threat

2003-09-05 Thread Nuno Souto
- Original Message - > > A - This is social engineering at its finest. > > B - There is no security without PHYSICAL security > > C - If you don't check up on your outsourcer, then you can apparently > get the shirt stolen off your back... > > what scares me is these guys KNEW which

Re: question for internals experts

2003-09-05 Thread Ryan
we publish from the same staging server daily to our master server. So we update our staging server to change the name. Then do the export. We thought about changing the export file, but its in binary and we couldnt make it work. - Original Message - To: "Multiple recipients of list ORACLE-

Re: question for internals experts

2003-09-05 Thread Stephane Faroult
... A stupid solution might be to prefix the name of each tablespace with the name of the database it was created in ... you might have to play with users' quotas to allow them to create tables in the tablespaces you have plugged in but it is infinitely better than updating SYS tables ... I have do

Re: COBOL to Oracle

2003-09-05 Thread Stephane Faroult
[EMAIL PROTECTED] wrote: > > Hi List, > > Does anyone know of tools, or have had experience using tools, that > will quickly convert COBOL code to Oracle. Any information you can > provide would be greatly appreciated. > > Thanks in advance. > > Rick What do you mean by converting Cobol to Or

Re: question for internals experts

2003-09-05 Thread Ryan
nah, we can afford to rebuild the instances. its just for staging anyway. Im now more curious what is going on. I dont think its in the datafile. I think there is more going on in memory than Oracle is releasing. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PRO

RE: question for internals experts

2003-09-05 Thread Jacques Kilchoer
I think this would be the perfect time for you, as DBA, to explain to the Powers That Be that updating SYS.TS$ is a BAD idea and that the transportable tablespace plan has to change. You have damning evidence at this point in time. You will be doing yourself and your successors a big favour. --

RE: question for internals experts

2003-09-05 Thread Jacques Kilchoer
Or unless you have Oracle 10G. rgaffuri, are you still updating TS$, you rascal? You could try the following: set long 100 spool c:\temp\views.log select a.view_name, a.text from dba_views a where a.owner = 'SYS' and a.view_name like 'DBA\_%' escape '\' and exists (select * fro

RE: COBOL to Oracle

2003-09-05 Thread Jacques Kilchoer
Do you mean that the COBOL code would be translated to PL/SQL packages, or that the COBOL I/O would be changed to SQL insert/update/select using Pro*COBOL instead of READ and WRITE? Or do you mean that the COBOL programs would be automagically transformed into an Oracle database? One datafile f

Re: question for internals experts

2003-09-05 Thread Ryan
not my call. i posted this on here before. was done that way before i got here. Its part of the transportable tablespace plan since you cant have multiple tablespaces with the same name in one instance.   I found some interesting(and troublesome things). I think Oracle may not be telling us

Re: No more Oracle development here

2003-09-05 Thread Joe Testa
I agree, mysql is kinda like oracle v6. joe [EMAIL PROTECTED] wrote: So they're getting SQL Server for free? Why not use MySQL or PostreSQL? Jared *Gabriel Aragon <[EMAIL PROTECTED]>* Sent by: [EMAIL PROTECTED] 09/05/2003 03:24 PM Please respond to ORACLE-L To:

Re: question for internals experts

2003-09-05 Thread Jared . Still
Sounds like you want to rename a tablespace. Not recommended without approval from Oracle support. Jared <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  09/05/2003 01:09 PM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>  

Re: No more Oracle development here

2003-09-05 Thread Jared . Still
So they're getting SQL Server for free? Why not use MySQL or PostreSQL? Jared Gabriel Aragon <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  09/05/2003 03:24 PM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:  

COBOL to Oracle

2003-09-05 Thread JRicard982
Hi List, Does anyone know of tools, or have had experience using tools, that will quickly convert COBOL code to Oracle.  Any information you can provide would be greatly appreciated. Thanks in advance. Rick

RE: Oracle World - Listers get together (proposed Tuesday Sep 9)

2003-09-05 Thread Steve McClure
I will try to be there as well. Possibly two of us, Alec Macdonell who lurks about this list as well. Steve McClure -Original Message- John Kanagaraj Sent: Wednesday, September 03, 2003 2:54 PM To: Multiple recipients of list ORACLE-L Hi all, We talked about this earlier and I wanted

offshoring article

2003-09-05 Thread Ryan
Here is a link to an article from McKinsey & Co. My favorite positive is that offshoring IT jobs frees Americans up to do other jobs. Now they dont say 'what' jobs, but we are free to do them. If you dont know these are the guys who payed Chelsea Clinton 100k/year right out of college with no expe

RE: Oracle Masters exam

2003-09-05 Thread Steve McClure
I am getting ready to bite the bullet and do this. I have procured a copy of Linux Advanced server to install at home, I have a couple of machines I am going to set up to handle the RAC portions. This is tough for me, because I am one of the largest RAC skeptics about. Of course I had to be drag

Re: Oracle Masters exam

2003-09-05 Thread Tanel Poder
Hi! I think the "new" certification is Oracle Certified Master, but the old one was just Oracle Master title. I personally spent over $6000 on OCM exam which I took last year (the first public exam). I had to fly to Chicago from other side of the world, because there were no exams available elsewh

Re: No more Oracle development here

2003-09-05 Thread Ryan
what is the difference in cost between sql server and oracle? oracle claims its similiar due to sql server needing more hard ware. now that is probably bull in low end system, but is it accurate in high end systems? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL P

RE: Another great respone from Oracle support (not really Friday

2003-09-05 Thread Mladen Gogala
Title: Message Well, that's obviously Oracle Support version of the old Latin: Idis redibis nunquam in bello peribis.     --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John ShawSent: Friday, September 05, 2003

Another great respone from Oracle support (not really Friday

2003-09-05 Thread John Shaw
I filed a tar to get all the steps needed to do a new install of 9ias and bring up to the current patch release 9.0.2.3. This is their detailed list of instructions: " After applying 9iAS 9.0.2.0.1, you can/should apply 9.0.2.3 directly..There are some things you need to do first.

Re: Oracle Masters exam

2003-09-05 Thread Daniel Fink
Let's just cut the crap and start our own Oracle-L Masters (OLM). Qualifications 1) Willingness to answer questions 2) Willingness to ask questions, after RTFM 3) Willingness to publicly admit mistakes and offer corrections 4) Demonstration of advanced knowledge of Oracle 5) Able to back up commen

RE: DB2 has a foot in the door

2003-09-05 Thread Mladen Gogala
I believe that the answer to Stephane's question is obvious: Oracle 10g will cost 10 grands/ CPU. That's where the letter "g" is coming from. -- Mladen Gogala Oracle DBA -Original Message- DENNIS WILLIAMS Sent: Friday, September 05, 2003 5:30 PM To: Multiple recipients of list ORACLE-

No more Oracle development here

2003-09-05 Thread Gabriel Aragon
My company it's moving all the development efforts to SQL Server because the customers don't want to pay Oracle licenses anymore.. Gabriel __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please s

Re: external procedure as not-oracle on OS

2003-09-05 Thread Jared . Still
You would need to have extproc run as some user other than oracle. The suggested user on unix systems is 'nobody', with rather limited privileges. Setting it to root might prove dangerous. Jared "Henry Poras" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  09/05/2003 01:29 PM  Please res

RE: Oracle Masters exam

2003-09-05 Thread April Wells
Title: RE: Oracle Masters exam Well, at least all of the Oracle employees can eventually claim to be masters... maybe some of them will filter over and improve the analyst stock. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas   /\  /   \ / \ \ /   \/   >\<    

RE: Oracle Masters exam

2003-09-05 Thread Pete Sharman
Don't worry, nor do most Oracle employees. I was asked to be a beta tester of the masters exam, and in return for my review ( we actually spent three days doing the exam because of the amount of time discussing whether questions were valid, how they should be marked and so on), I got to sit the ex

RE: Oracle Masters exam

2003-09-05 Thread DENNIS WILLIAMS
Mladen I'm dubious whether Oracle will make much money from this one. Maybe someone with better connections to the exam can clarify that one. The payoff on anything is the amount of revenue minus the cost to create. If fewer people take the Masters, then the revenue may not offset the cost. I

RE: Oracle Masters exam

2003-09-05 Thread Reginald . W . Bailey
Free? Vat is dis Free? All of us don't work for Oracle (at least not directly) so we don't get that perk. But thanks for sharing. RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD

RE: DB2 has a foot in the door

2003-09-05 Thread DENNIS WILLIAMS
Stephane We've been very excited about Oracle Standard Edition. Helped stave off the interest in MS SQL. Given the budget pressures at many organizations, I'm surprised we don't hear more about this alternative. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Or

RE: Oracle Masters exam

2003-09-05 Thread Mladen Gogala
Well, let's look at it from the purely commercial point of view: 1) Is it likely that my company will ever foot the bill for masters exam? Me thinks not. Even OCP was frowned upon, because it was looked upon as acquiring a technical certification that will make it easier for me to leave t

RE: Oracle Masters exam

2003-09-05 Thread Thater, William
Pete Sharman scribbled on the wall in glitter crayon: > Funny, I found my cost (free) was acceptable ... :) hey, can i help it of Oracle wouldn't hire me?;-) -- Bill "Shrek" Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] ---

DB2 has a foot in the door

2003-09-05 Thread Stephane Paquette
Hi all, We're an Oracle shop, over 140 Oracle instances. Today, architecture has chosen IBM DB2 for BI projects. The next step I guessed will be to choose DB2 for the new transactionnal applications also. IBM offers DB2 at 25% less than Oracle. I wonder if Oracle 10G will come with a new pricing

RE: Oracle Masters exam

2003-09-05 Thread Thater, William
DENNIS WILLIAMS scribbled on the wall in glitter crayon: > Pete, Bill > Just think though. If we'd been smart and acted like it was a > terrific thing and anyone with an Oracle Masters was top notch, then > maybe we wouldn't have to take all these darned tests. damn! NOW you tell me.;-) -- Bi

RE: Oracle Masters exam

2003-09-05 Thread Pete Sharman
Funny, I found my cost (free) was acceptable ... :) Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long term Oracle DBA. -Original Message- Thater, William Sent: Saturday, Septembe

Re: external procedure as not-oracle on OS

2003-09-05 Thread rgaffuri
you can do this all easily with a java stored procedure. alot less code. also, it will run as the DBA group on unix. there is an example in tom kytes book. Really short code. You can call any OS script with it. Might be on his website too. you then create a chmod script in unix that oracle has

RE: Oracle Masters exam

2003-09-05 Thread DENNIS WILLIAMS
Pete, Bill Just think though. If we'd been smart and acted like it was a terrific thing and anyone with an Oracle Masters was top notch, then maybe we wouldn't have to take all these darned tests. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message-

RE: question for internals experts

2003-09-05 Thread Mladen Gogala
There are many references to TS# all over the place. If I were you, I wouldn't try renaming it, without being in reallly dire straits. -- Mladen Gogala Oracle DBA -Original Message- [EMAIL PROTECTED] Sent: Friday, September 05, 2003 4:09 PM To: Multiple recipients of list ORACLE-L D

RE: Oracle Script Documentation

2003-09-05 Thread Jay Wade
Sounds like a project, I'll see if I can try to get each files brief definiation and then what it's calling scripts are. Should be interesting to see that the dependencies are. From: DENNIS WILLIAMS <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAI

external procedure as not-oracle on OS

2003-09-05 Thread Henry Poras
In order to run some OS commands from within the database we have set up a few external procedures. One of the functions we need to accomplish is to change the permissions of a file owned by a user other than oracle. As the external procedure is executed by Oracle, this is a problem. I tried changi

RE: Oracle Masters exam

2003-09-05 Thread Thater, William
Pete Sharman scribbled on the wall in glitter crayon: > Just to clarify, the "old" Oracle Masters was only an indication that > you had attended a series of relevant training courses. There was no > test, no measure of how well you could perform the role of a DBA. The > "new" Oracle Masters def

question for internals experts

2003-09-05 Thread rgaffuri
Does oracle store the tablespace_name or any data about a tablespace anywhere else accept TS$? Im looking for base data dictionary tables. Not views. Are there any documents out there about how oracle stores information in the data dictionary tables other than what Steve Adams has in his book

RE: Oracle Masters exam

2003-09-05 Thread Pete Sharman
Just to clarify, the "old" Oracle Masters was only an indication that you had attended a series of relevant training courses. There was no test, no measure of how well you could perform the role of a DBA. The "new" Oracle Masters definitely addresses that issue. Pete "Controlling developers is

RE: Net App Filer

2003-09-05 Thread DENNIS WILLIAMS
Binley - Yes, I probably didn't phrase that too well. My understanding is that when you create an index on a table, Oracle has to scan the table at least once, then write to the index. My point was that if both the table and the index are on the NetApp, your performance might be lower. Thanks for t

RE: Urgent INFO needed.

2003-09-05 Thread DENNIS WILLIAMS
Maria I just wanted to thank you for posting your views on the DBA situation from your perspective. I always feel better informed when I have an opportunity to hear opinions from people whose situation is different from mine. And I agree with you that this is a valuable forum where people with a

Teenie Tiny 9iR2 Install Client Wanted

2003-09-05 Thread Odland, Brad
I want to get a 9iR2 client configured that trims all the flab Oracle is mum on the subject and are quite satisfied at installing a gig of client. Even the min of 300MB is too much when it come to pushing several hundered clients out... ANyone have any thoughts, feelings, documents, links to

Re: Oracle Script Documentation

2003-09-05 Thread Joe Testa
wish i still have some of that stuff but i did receive a patch set for oracle 7 on hpux that the developer forgot to turn off debugging for, something in it core dumped and the .trc file had C source code in it, back in my days of doing ALOT of C, i spoke to a developer and pointed out where a

Re: RE: Oracle Script Documentation

2003-09-05 Thread rgaffuri
SQL.BSQ file that creates the data dictionary is neat. Its good for getting into arguments. Since alot of DBAs like to correct you when you say 'v$ view', they insist 'v$ table', you open sql.bsq and its 'create or replace view v_$' There is alot of neat stuff in sql.bsq. Notes that were placed

RE: How to get the source code of the trigger without using

2003-09-05 Thread Mladen Gogala
Title: Message Or, you can set event 10046, level 12 and look into the trace file. All SQL statements in the trigger should be in there, which should give you a pretty good idea about what's in the trigger itself.   Or, you could do a systemdump level 10 and extract the trigger text from th

RE: Offshore threat

2003-09-05 Thread Wolfe Stephen S GS-11 6 MDSS/SGSI
Very insightful and I agree. Note that my title is "Data Services Mgr." and in that role I do some DBAing, need to learn a lot More Oracle 'basic' keep it in the middle of the road stuff, but where I make my biggest impact And consistently win annual awards (I get coins (organizational coins -- bi

RE: How to get the source code of the trigger without using

2003-09-05 Thread raju pa
You can ofcourse use enterprise manager. You would have to get the body and other things like triggering event etc.   To use the "Show SQL" option :  one trick to use is a space some place (basically non-change) and hit "Show SQL". That should give you the whole trigger sql. Good luck.   * Jared :

RE: Oracle9iR2 - temporary tablespace usage error

2003-09-05 Thread Mladen Gogala
Title: Message 12913, 0, "Cannot create dictionary managed tablespace"// *Cause: Attemp to create dictionary managed tablespace in database// which has system tablespace as locally managed// *Action: Create a locally managed tablespace. It's a feature, not a bug. Why would anyon

RE: How to get the source code of the trigger without using

2003-09-05 Thread Mladen Gogala
Just kidding. -- Mladen Gogala Oracle DBA -Original Message- Wolfgang Breitling Sent: Friday, September 05, 2003 12:34 PM To: Multiple recipients of list ORACLE-L Why is it "far fetched and unnatural" ? In my view that is the only way to be sure to get the correct source. At 08:09

RE: How to get the source code of the trigger without using any t

2003-09-05 Thread Rudy Zung
Select from DBA/ALL/USER_SOURCE; if the source code looks like a bunch of garbage, then it means the source code has been "wrapped", which is Oracle's facility of obfuscate it so that you can't read it. -Original Message- Sent: Friday, September 05, 2003 11:35 AM To: Multiple recipients

Re: Net App Filer

2003-09-05 Thread Binley Lim
That is a misconception - you do not reduce bidirectional traffic because you are still reading/writing from the Filer. However, you are mostly like to be seeing the effects of the different levels of caching on the Filer itself, which translates through to a better performance from your perspecti

RE: Oracle9iR2 - temporary tablespace usage error

2003-09-05 Thread srini . chavali
Mladen, It's not buggy - I have used it without any side effects on 8.1.6 and 8.1.7. Works as advertised - for a change ! Srini Chavali Oracle DBA Cummins Inc Mladen Gogala <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 09/05/2003 10:34 AM Please respond to ORACLE-L                 To:  

RE: How to get the source code of the trigger without using

2003-09-05 Thread Wolfgang Breitling
Why is it "far fetched and unnatural" ? In my view that is the only way to be sure to get the correct source. At 08:09 AM 9/5/2003 -0800, you wrote: Well, the idea of extracting it from user_triggers or dba_triggers is a little far fetched and unnatural, but should work. Wolfgang Breitling Oracle

Re: Net App Filer

2003-09-05 Thread Binley Lim
There are a number of gotchas, but if you are aware of them and configure your system appropriately, Net App is a cost-effective proposition. Unlike DAS, it does require DBA/Sysadmins to address issues they did not have to before, especially MB/s, packets, jumbo frames, trunking, auto-negotiate,

RE: Net App Filer

2003-09-05 Thread Spears, Brian
I have TAKEN THE PLUNGE and using it for PRODUCTION... ENRON used for all their production databases (100+ ) and they were several hundred gig. We are using a special Disaster recovery product of Netapps as well. Brian -Original Message- Sent: Friday, September 05, 2003 11:39 AM To: M

RE: How to get the source code of the trigger without using any third party tools?

2003-09-05 Thread Mladen Gogala
Well, the idea of extracting it from user_triggers or dba_triggers is a little far fetched and unnatural, but should work. -- Mladen Gogala Oracle DBA -Original Message- Oracle DBA Sent: Friday, September 05, 2003 11:35 AM To: Multiple recipients of list ORACLE-L party tools? Hi List

Re: How to get the source code of the trigger without using any third party tools?

2003-09-05 Thread raju pa
You can use view all_triggers or user_triggers to get the entire text. trigger_body has the trigger text. triggering_event, trigger_type   , REFERENCING_NAMES etc have other details. You can also use enterprise manager to get it. One trick in enterprise manager is to add some spaces somewhere (a no

Re: Oracle Standby Database Backups.

2003-09-05 Thread Arup Nanda
Vivek,   The origianl poster inquired on Physical Standby (in 8i and 9i) as opposed to logical standby (only in 9i).   In physical standby, you don't have a choice of running the standby in noarchivelog mode. The control file is created from the primary as "standby controlfile" which is then

Re: How to get the source code of the trigger without using

2003-09-05 Thread Wolfgang Breitling
set long 32656 col trigger_body for a80 word select trigger_body from dba_triggers where owner='xxx' and trigger_name = 'yyy'; At 07:34 AM 9/5/2003 -0800, you wrote: Hi List, Could you please help me to get the source code of the trigger without using any third party tools? Thanks in advance, R

RE: Offshore threat

2003-09-05 Thread Mladen Gogala
Two IBM mainframes stolen? Boy, the times are changing! To steal only a single 3090 600J, one would need a whole infantry division, not just two guys with a dolly. I bet they'll end up running Linux and having a ton of Jared's perl scripts on them. -- Mladen Gogala Oracle DBA -Original Me

RE: RE: URGENT : sql*loader performance problem on partionned tab

2003-09-05 Thread NGUYEN Philippe (Cetelem)
Title: RE: RE: URGENT : sql*loader performance problem on partionned tab here the trace : SELECT STATEMENT, GOAL = CHOOSE         2   72  1368     FOR UPDATE                       FILTER                           PARTITION RANG

RE: How to get the source code of the trigger without using any third party tools?

2003-09-05 Thread Goulet, Dick
User_source or DBA_source for procedures and USER_TRIGGERS or DBA_TRIGGERS for triggers. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, September 05, 2003 11:35 AM To: Multiple recipients of list ORACLE-L third party tools? Hi List, Could you pl

RE: Oracle9iR2 - temporary tablespace usage error

2003-09-05 Thread Mladen Gogala
Title: Message You can always try DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL. I've never tried it, it might be buggy, but in theory, the procedure would go like this: 1) Create locally managed tablespace 2) Read the manual/ 3) Migrate the tablespace local -> dictionary. 4) Start won

RE: Net App Filer

2003-09-05 Thread DENNIS WILLIAMS
Daniel That was close to my experience. Very useful for test databases where throughput isn't that important. We find it very useful to clone 100-gig production databases so the users have a complete data set to perform staging tests. The NetApp provides a lot of inexpensive storage. But I found

How to get the source code of the trigger without using any third party tools?

2003-09-05 Thread Oracle DBA
Hi List, Could you please help me to get the source code of the trigger without using any third party tools? Thanks in advance, Raj __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the o

RE: Oracle Script Documentation

2003-09-05 Thread DENNIS WILLIAMS
Jay Here is your chance to join the big league and become an expert in your own area. One thing I've noticed in tracing the scripts is that many of the scripts call each other. Something like catproc must call dozens of the other scripts. Not that much need to understand every low-level script.

RE: Net App Filer

2003-09-05 Thread Rachel Carmichael
NetApp Filer is a "special case" of NFS and is, in fact, supported by Oracle --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > I thought that Oracle datafiles over NFS was neither recommended nor > supported. Has this changed? > > Rich > > Rich Jesse System/Database Admi

RE: Offshore threat

2003-09-05 Thread Wolfe Stephen S GS-11 6 MDSS/SGSI
http://www.smh.com.au/articles/2003/09/04/1062548967124.html A - This is social engineering at its finest. B - There is no security without PHYSICAL security C - If you don't check up on your outsourcer, then you can apparently get the shirt stolen off your back... v/r Stephen S. Wolfe, GS-

RE: Net App Filer

2003-09-05 Thread Daniel Harron
We use the net apps for a number of instances as well. I'm would not recommend them for an IO intensive application. If you are using a 100 Mb connection your max aggregate throughput will be about 6MB per second, which is very bad. Try performing backups over this. If you do use them, gigabit

RE: Oracle9iR2 - temporary tablespace usage error

2003-09-05 Thread Hitchman, Peter
Hi, There are a couple of issues here. Firstly you need to know that when you get the error about the "temp" segment when building the index, the segment in question is the index. It is just that when building the index Oracle creates a temp segment to sort the data in and to create the inde

RE: Oracle9iR2 - temporary tablespace usage error

2003-09-05 Thread laura pena
Thanks, Yes I have 200,000 millions row table ... I belive my tempoary tablespace is way too small.   -lizzApril Wells <[EMAIL PROTECTED]> wrote: you can't have any dictionary managed tablespaces that are open for write operations... dictionary managed read only tablespaces will still work.   I t

Re: Oracle Script Documentation

2003-09-05 Thread Pete Finnigan
Hi Jay, I know this is obvious but each script generally has a short description at the top of each file. Some of these are pretty short one liners bear in mind but it is a start!. If you do find a complete list let us know it sounds like it could be useful to know where a list for the future. h

RE: Net App Filer

2003-09-05 Thread Jesse, Rich
I thought that Oracle datafiles over NFS was neither recommended nor supported. Has this changed? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -Original Message- > From: Brian Dunbar [mailto:[

RE: Oracle9iR2 - temporary tablespace usage error

2003-09-05 Thread April Wells
you can't have any dictionary managed tablespaces that are open for write operations... dictionary managed read only tablespaces will still work.   I think you're right, temp isn't being freed up... or is something else using it, or is the index creation just that huge?   April Wells Oracle D

Re: Offshore threat

2003-09-05 Thread Nuno Souto
- Original Message - > forever. Now it's time to wake up and see that IT is becoming a job like > another where you most hold to your job instead of going to job interview > just for fun. > A lot of people don't believe this when I say it, but when I started in IT in 1975 what we got now

RE: Problem querying remote table through a synonym

2003-09-05 Thread Ruth Gramolini
Try creating the synonym as a public synonym. That will give everyone privileges to it without granting them explicitly. Ruth > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > GovindanK > Sent: Friday, September 05, 2003 4:10 AM > To: Multiple recipient

RE: latch free wait event

2003-09-05 Thread Cary Millsap
Yes. Even with TIMED_STATISTICS=TRUE, relying on *any* statistic with system-wide scope can waste your time. For a 34-page introduction to the rationale behind this proposition, see: http://www.oreilly.com/catalog/optoraclep/chapter/ch01.pdf Cary Millsap Hotsos Enterprises, Ltd. http://

RE: How can I measure my DB performance.

2003-09-05 Thread Stephane Paquette
15 minutes ! All our production db are set up at 1 hour interval. A summary of the stats are centralized in 1 db and we keep that 2 months. We go down to 10-15 minues to investigate problems. I find a 15 minutes interval very short. Thanks for the link to yapppack. We do a similar thing using a

RE: Oracle Masters exam

2003-09-05 Thread Thater, William
Nuno Souto scribbled on the wall in glitter crayon: >> If the OCP Masters credentials >> are worth the money, then spend it. If they are not, don't spend it. >> If enough people don't spend the money, then something will happen. >> Thats how a market driven economy works. >> > > Exactly. Anot

RE: Offshore threat

2003-09-05 Thread Stephane Paquette
By business as usual, I meant that executives always try to save money and will always do. Now, IT is targeted. And pepople in IT find that very difficult because the pay has been very good since 5-7 years and most people thought it would last forever. Now it's time to wake up and see that IT is b

Oracle9iR2 - temporary tablespace usage error

2003-09-05 Thread laura pena
HI all,   I'm getting the following error when using temporary tablespace on a locally managed system tablespace. Seems if my system tablespace is locally managed I can not create a dictionary managed tablespace.   Can anyone let me know if it is a bad idea to have system tablespace locally manage

Re: Wel it appears the 10g world is coming soon

2003-09-05 Thread John Shaw
I'd love to see what you come up with on this one. >>> [EMAIL PROTECTED] 9/4/2003 11:59:31 AM >>> During my free time(ha, between developing pages for kid's soccer association, redcross instructor and board member, family, work), are you all interested in my discoveries when i start trudging

Re: Offshore threat

2003-09-05 Thread Nuno Souto
Well, you could find a job in Canada, no? Can you find one in India too? I don't think so. So it's not business as usual. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - > When working at International Air Transport Association (IATA), the company > moved around 60 jobs from Genev

Re: 600-[25012] on delete of IOT table

2003-09-05 Thread GovindanK
Earlier post did not reach. Hence Reposting. > Take a look at the Metalink Note:125149.1 > ALERT: ONLINE Index Rebuild or IOT Table Move can Produce Corrupt Index > As per the note it affects 8.1.(5/6/7).x > > It has the relevant info. > > Also take a look at the Docid: 287936.999. > > HTH > Govin

Oracle Script Documentation

2003-09-05 Thread Jay
Hello: I was wondering if anyone knew of a source that listed what each of the scripts in RDBMS (catproc, etc) functionality. So far I have only been able to find a small listing (10 common scripts), and was hoping someone might have a more complete list. I know that they are different version to

Re: Re: "Application DBA"

2003-09-05 Thread Nuno Souto
- Original Message - > > Degree/OCP achievement doesn't teach f all - in my opinion - though it > does prove your memory isn't shot. I can think of much cheaper and much more reliable and credible ways of checking my memory... :) > lot. The reason, for example, that I personally pre

RE: Net App Filer

2003-09-05 Thread Brian Dunbar
Gunnar Berglund [mailto:[EMAIL PROTECTED] on Friday, September 05, 2003 5:24 AM said; > is anyone using Net App Filer -products with Oracle environment. Yup. Hosts a horde of databases for a medium sized outfit - pehaps 3000 employees, 24/7 manufacturing. > What do you think? I like it but I'm

Re: Offshore threat

2003-09-05 Thread Nuno Souto
- Original Message - > It doesn't work in only one direction. While jobs are bieng lost to cheaper > labor markets, Indian companies now have to compete with frighteningly > efficient > giants like Nike, Coca Cola, IBM, Microsoft, GM, Union Carbide and others. On IT? I thought we wer

Re: Listener problem on one client computer

2003-09-05 Thread GovindanK
Damien Your gesture is appreciated. It is a must that such solutions are shared with the list members. GovindanK > Thank you very mutch for your replys, > > Today I finally found the problem. The traceroute shows the good route, > but a Ms Proxy Client installed on the server blocked the request

RE: Oracle Masters exam

2003-09-05 Thread Chris Stephens
Well, personally, I'm a bit of a scatter brain and enjoy things to work towards. When I was just starting out, the OCP stuff was a challenge and I used it to 'learn' Oracle. For each test I ended up learning way more than necessary and got a lot of practical experience. The Masters exam would pr

Re: Oracle Masters exam

2003-09-05 Thread Ron Rogers
I have a certificate suitable for framing that states that I am a "Database Administrator Oracle 7 Oracle Master". Does this new Oracle Master negate my current "Oracle Master" certification? Is there and upgrade path available? Does it really matter? Every thing that I have accomplished I have do

  1   2   >