Re: SQLPLUS with cronjob is giving problem

2003-09-17 Thread H elp_me
Hello Sami, Check the environment variables.. such as ORACLE_HOME, LD_LIBRARY_PATH, and just PATH.. Are they set .. when you execute from CRON ? You will have them when you execute from unix login. Hope this helps. Nikunj From: Oracle DBA <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To:

Re: SQL help needed

2003-09-17 Thread GovindanK
You would require something like this: http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:504432994857 HTH GovindanK Hello Listers, I need some SQL help. Not sure if this is possible in plain SQL or not, but here it is: I have a table with two columns: EMPNBR LINENBR

How to extract data directly from a datafile ?

2003-09-17 Thread Juan Miranda
We need to extract the data of a datafile directly, because we don´t have the rest of the database (other tablespaces, controlfile, etc). Are there some utility like DUL ? What about Unicenter Fast Unload ?. Works it with the datafile directly ? Does it need the database open ? thanks

RE: Re: SQL help needed

2003-09-17 Thread Stephane Faroult
I was thinking along the same lines minus the outer query which is totally unnecessary, but it is the beginning of my day here :-). SF - --- Original Message --- - From: Wolfgang Breitling [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tue,

RE: Nosort parallel dml uses TEMP tablespace

2003-09-17 Thread Turner, Adrian A SITI-ITPSIE
Title: RE: Nosort parallel dml uses TEMP tablespace I'm even more confused now. TEMP ran out of space at 20GB - I'm only inserting 12.2GB! So I kicked it off again with the hint just as /*+ APPEND */ and it completed successfully in 1/6th the time to failure of the parallel insert.

RE: Re: SQL help needed

2003-09-17 Thread Stephane Faroult
- --- Original Message --- - From: Mark Richard [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tue, 16 Sep 2003 19:59:41 I guess I should have added some criteria like: 1) user_objects must have enough rows in it to cover the range (if not

CORRECTION RE: RE: Re: SQL help needed

2003-09-17 Thread Stephane Faroult
create viex xdual as select rownum ID from sys.col$; Cannot have a column named rownum ... Going to be a difficult day. And we are only half-week. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL

Re: Is Cary's new book shipping now?

2003-09-17 Thread Mogens Nørgaard
Lies, all lies. I've heard myself snoring. Pete Sharman wrote: I can guarantee that won't happen, since Cary's singing is pretty much akin to Mogens's snoring! :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that!

RE: Is Cary's new book shipping now?

2003-09-17 Thread Gudmundur Bjarni Josepsson
So have I and to me it sounded pretty much like The hills are alive with the sound of music which is pretty much what I imagine Cary likes to sing. Gudmundur -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mogens Nørgaard Sent: 17. september 2003

Re: CORRECTION RE: RE: Re: SQL help needed

2003-09-17 Thread Guido Konsolke
Hi Stephane, I commiserate with you 8-) Regards, Guido [EMAIL PROTECTED] 17.09.2003 10.44 Uhr create viex xdual as select rownum ID from sys.col$; Cannot have a column named rownum ... Going to be a difficult day. And we are only half-week. Regards, Stephane Faroult Oriole -- Please

Re: Checking RMAN backup results

2003-09-17 Thread Yechiel Adar
We are working with windows servers and we check the error level after Rman finish. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 8:39 AM Posted on behalf of Rich Holland ([EMAIL PROTECTED]):

RE: Nosort parallel dml uses TEMP tablespace

2003-09-17 Thread Turner, Adrian A SITI-ITPSIE
Thanks for the input Praveen, if only it were that easy. The sql is a straight insert into tab1 select * from tab2 but with a parallel dml hint. Remove the parallel and it doesnt use TEMP. Theres no distinct, group by, order by or indexes on the target table (there are 12 or so on the source

Re: ...

2003-09-17 Thread Pete Finnigan
Vrey off tpoic but vrey insreettnig . In article [EMAIL PROTECTED], Sinardy Xing [EMAIL PROTECTED] writes Aoccdrnig to a rscheearch at an Elingsh uinervtisy, it deosn't mttaer in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht frist and lsat

Re: How to extract data directly from a datafile ?

2003-09-17 Thread Pete Finnigan
Hi, There is a tool called jDul on sourceforge but it wasn't available for download last time I looked, you might want to take a look again and see if it is now? hth kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit

RE: SQLPLUS with cronjob is giving problem

2003-09-17 Thread Paula_Stankus
Title: RE: SQLPLUS with cronjob is giving problem Dear Sami, As a matter of fact whatever environ. values are set in your .profile are not in operation through a crontab process. To deal with this issue we do something that I have seen others do as well. We basically create a

Re: ...

2003-09-17 Thread Joe Testa
that must bve cause usually i type that bad and can read it nayways joe Sinardy Xing wrote: Aoccdrnig to a rscheearch at an Elingsh uinervtisy, it deosn't mttaer in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht frist and lsat ltteer is at the rghit pclae. The rset

RE: Checking RMAN backup results

2003-09-17 Thread Paula_Stankus
Title: RE: Checking RMAN backup results Alghough I use the RMAN catalog and so backup success/failure can be seen from there. I find it easiest to write out a log of the entire backup process in my calling script to a specific directory /dblogs/backups All my backup scripts are written

Re: Re: SQL help needed

2003-09-17 Thread Tanel Poder
Hi! This one is a very interesting consideration. The use of 'pivot' tables, as in this case, without being something you meet daily is fairly frequent (completing series like here is one usage, otherwise I commonly use them to generate test data). It should be some standard feature, a kind of

Re: Nosort parallel dml uses TEMP tablespace

2003-09-17 Thread Tanel Poder
Title: RE: Nosort parallel dml uses TEMP tablespace Hi! It could be that parallel slaves are passing intermediate results using TEMP tablespace for some reason. (When table queues are full in some cases or smth like that). It can depend on parallel execution plan as well (whether it's

RE: Oracle licensing

2003-09-17 Thread Boivin, Patrice J
Thanks Dick. I like that last quote in the article... Patrice. -Original Message- Sent: Tuesday, September 16, 2003 5:50 PM To: Multiple recipients of list ORACLE-L Patrice, ANALYSTS: PER-PROCESSOR PRICING TO DIE OUT | SearchOracle.com As Oracle Corp. prepares to release new

Re: RE: RE: Oracle Press OCP exam guide frustrations

2003-09-17 Thread M Rafiq
Jp, No idea as never used. Pretty much happy with STS so far. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 16 Sep 2003 21:09:44 -0800 Rafiq, How about Boson Practice tests compared to STS ? has anyone on this list found Boson

Re: Nosort parallel dml uses TEMP tablespace

2003-09-17 Thread Tanel Poder
Title: RE: Nosort parallel dml uses TEMP tablespace Hi! Btw, I did a little testing with PARALLEL 2, and yes it seems to be a parallel slave communications issue, despite the segments show type "SORT". When i traced sorting with 10032 10033, I saw sort segment allocation, but no real

RE: Nosort parallel dml uses TEMP tablespace

2003-09-17 Thread Turner, Adrian A SITI-ITPSIE
Title: RE: Nosort parallel dml uses TEMP tablespace Thanks for having a look Tanel; that makes great sense. I'll have a quick play to convince myself but I'd say its a lesson learned. BTW did you too experience more temp allocation than you would have expected? Thanks again, Adrian

Re: SQL help needed

2003-09-17 Thread Kirtikumar Deshpande
Hello All, Thanks for your wonderful ideas. I just forwarded those to my dear Developer (my wife, that is :) After posting my question to the list last night, I was told that the query will be run against an Informix database :) Typical Developers !!! ;) Cheers! - Kirti ---

+++Need an urgent info+++

2003-09-17 Thread Ora DBA
Dear Friends, Good day. Hope doing well , sorry for OFF topic. My Friend has got an offer with Oracle India at Hyderabad (as a support engineer in Indian support centre , Hyderabad, India ). I need your suggestions , inputs and valuable thoughts for making a decision. What will be the work

RE: RMAN error - can someone help ?

2003-09-17 Thread Ruth Gramolini
It looks like you don't have your ORACLE_SID specified correctly since, if I read this correctly, the database you are trying to restore is on dick c:. Set you ORACLE_SID which will be the target and try again. HTH, Ruth p.s I do not have any databases on Windows so I am not sure how to set the

Re: +++Need an urgent info+++

2003-09-17 Thread Tanel Poder
Erm... would "42" be a sufficient answer? Tanel. - Original Message - From: Ora DBA To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 17, 2003 4:44 PM Subject: +++Need an urgent info+++ Dear Friends, Good day. Hope doing well ,

RE: exporting synonyms

2003-09-17 Thread Ayhan Haktanir
i think, you have problem permission. -Original Message- [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 5:25 PM To: Multiple recipients of list ORACLE-L While exporting synonyms , export hangs. Help ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

Re: Nosort parallel dml uses TEMP tablespace

2003-09-17 Thread Tanel Poder
Title: RE: Nosort parallel dml uses TEMP tablespace You're welcome, please let me know the results. It was news to me as well, that so much temp space would be used in your type of parallel direct load insert... Btw, you can use nologging hint as well in your DML if you haven't already

RE: Checking RMAN backup results

2003-09-17 Thread Mercadante, Thomas F
Rich, I parse the Rman output using Perl and look for RMAN-00569 in the output file. If I find it, then I send email to myself with a subject line indicating that the backup failed. Pretty simple. And it's been working well for a few years now. The Perl script is available free. Just email

Re: +++Need an urgent info+++

2003-09-17 Thread Kirtikumar Deshpande
Find out what are the job responsibilities of a Support Engineer. If your friend needs a job badly, and if the salary is acceptable, this could be a good opp to learn on the job while helping the Customers. Hyderabad is an interesting but a crowded city (no surprise there, it's India :) with a

Re: RE: RMAN error - can someone help ?

2003-09-17 Thread Prem Khanna J
Ruth, Set you ORACLE_SID which will be the target and try again. c: set ORACLE_SID=AUX92 AUX92 is the name of my auxiliary instance on Host A ( target host ). c: rman target [EMAIL PROTECTED] catalog [EMAIL PROTECTED] auxiliary sys trace=c:\tspitr.log where PE92 is the target on same Host A

RE: RE: Oracle Press OCP exam guide frustrations

2003-09-17 Thread DENNIS WILLIAMS
Melanie The story I got from an Oracle instructor was that somebody was bragging about how they passed the OCP without ever logging into Oracle. I guess this caused some consternation in Redwood Shores. The quickest fix was to require everyone to take one class. When I asked the instructor if

RE: +++Need an urgent info+++

2003-09-17 Thread Stephane Faroult
For what I have heard, Bangalore is a more pleasant place than Hyderabad :-). I personally know neither, but somebody on this list worked for Oracle India in Hyderabad, he might tell you more about this ... SF PS : Please don't have this tragical vision of life (importance of decision etc).

RE: ...

2003-09-17 Thread Orr, Steve
Title: Message Wow! I was atcaully albe to raed taht amolst as fsat as nroaml. I have new funod aprpceaitoin for waht my brian deos for me. -Original Message-From: Sinardy Xing [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 9:50 PMTo: Multiple recipients of

ORA-08103 Error

2003-09-17 Thread DENNIS WILLIAMS
Has anyone had all objects in a schema return ORA-08103 on any select, describe or analyze? I have an instance on Oracle 9.2.0.1.0 on Solaris 5.8 64-bit. With no apparent change, all access to objects in this schema returns ORA-08103. I bounced the instance. I dropped and rebuilt the instance,

invalid ROWID

2003-09-17 Thread ManojKr Jha
Hi All, I am facing one problem explained below: Our application is using a trigger on view a based on some table b. IF :new.IND = 'Y' THEN UPDATE b set IND = NVL(RTRIM(:new.DIND),' ') WHERE ROWID = :old.OROWID;

RE: wait event question

2003-09-17 Thread Cary Millsap
...58 minutes if I've calculated correctly. And yes, you're right: if you have 50 sessions and 49 are waiting for 1 minute each, then you have 49 minutes of waiting. Any system has an infinite capacity for waiting. In case you pick up the book Optimizing Oracle Performance, this phenomenon (what

RE: Is Cary's new book shipping now?

2003-09-17 Thread Cary Millsap
Title: Is Cary's new book shipping now? Toms book, by the way, is spectacular. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic101 in Sydney - Hotsos Symposium 2004 March 710 Dallas - Visit www.hotsos.com for schedule details...

RE: invalid ROWID

2003-09-17 Thread Jamadagni, Rajendra
Title: RE: invalid ROWID use PK ... rowid is not reliable in views ... -Original Message- From: ManojKr Jha [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 17, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Subject: invalid ROWID Hi All, I am facing one problem

RE: RE: Oracle Press OCP exam guide frustrations

2003-09-17 Thread Melanie Caffrey
Dennis, Thank you for this. BTW, I like your signature. :-) I think it sums up quite a number of us. Best regards, Melanie -Original Message- DENNIS WILLIAMS Sent: Wednesday, September 17, 2003 10:45 AM To: Multiple recipients of list ORACLE-L Melanie The story I got from an

Re: invalid ROWID

2003-09-17 Thread Tanel Poder
Is this OROWID a column in your table or is it just a typo? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 5:59 PM Hi All, I am facing one problem explained below: Our application is using a trigger on

Re: RE: wait event question

2003-09-17 Thread rgaffuri
you dont need to hawk your book... of course ill buy it. yeah. i think im screwed. I dont have mount points to multi-plex my redo logs. :( From: Cary Millsap [EMAIL PROTECTED] Date: 2003/09/17 Wed AM 11:09:50 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: wait

tuning a massive delete

2003-09-17 Thread rgaffuri
i have a table with 27 million records that is about 1.2 GB in size. I have a 'staging table' with 18 million records. 16 million records have a 'delete' flag. I have indexed the column in staging with a delete flag. both tables have indexed primary keys. Is the following my fastest option or

RE: Backup controlfile does not include ALTER TABLESPACE ...

2003-09-17 Thread Hemant K Chitale
Dennis, Yes. Sometimes, Oracle doesn't want to do some additional work. Although I can't understand how the backup controlfile is different from the active controlfile in that manner. The last Support Analyst's response was ... the backup binary control file does not store information about

RE: Backup controlfile does not include ALTER TABLESPACE ...

2003-09-17 Thread Mladen Gogala
How is backup controlfile different? It doesn't contain the last SCN. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hemant K Chitale Sent: Wednesday, September 17, 2003 11:45 AM To: Multiple recipients of list

RE: wait event question

2003-09-17 Thread Mladen Gogala
Unfortunately, users do not have infinite capacity for waiting, at least not my users. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cary Millsap Sent: Wednesday, September 17, 2003 11:10 AM To: Multiple recipients

RE: set correct next time after fixing broken job

2003-09-17 Thread Igor Neyman
You could use LAST_SEC (from dba_jobs) specification for broken job, which is time portion of LAST_DATE, when you calculate NEXT_DATE for dbms_job.broken. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On

Re: invalid ROWID

2003-09-17 Thread ManojKr Jha
OROWID is column of view a based on table b. With Regards, Manoj Kumar Jha A transcendentalist engaged in auspicious activities does not meet with destruction either in this world or in the

[Q] ORACLE 9iR2 two ethernet cards, two listeners auestions?

2003-09-17 Thread mike mon
We have SUN ultra Sparc server with two Gigabit Ethernet cards on it. Those two Ethernet card will connect to big IP (firewall/router). The reason we need two Gigabit Ethernet cards is securiyt (in case one card fail). I know I can configure two listener entries on listener.ora like:

RE: tuning a massive delete

2003-09-17 Thread Richard Ji
Try anti hash join. -Original Message- Sent: Wednesday, September 17, 2003 11:45 AM To: Multiple recipients of list ORACLE-L i have a table with 27 million records that is about 1.2 GB in size. I have a 'staging table' with 18 million records. 16 million records have a 'delete' flag. I

RE: translate, replace...?

2003-09-17 Thread Hallas, John, Tech Dev
IA, The following code should be close to what you want select replace(replace(replace(a,chr(13),'R'),chr(10),'')) from table John -Original Message- Sent: 16 September 2003 16:15 To: Multiple recipients of list ORACLE-L Hi, I have a column with carriage returns (chr(13) ) and line

Re: invalid ROWID

2003-09-17 Thread Hemant K Chitale
If OROWID is a column, the WHERE ROWID = :old.OROWID; would certainly fail. If OROWID is expected to be of type ROWID, check the View definition. Are you really getting the right rowid ? Hemant At 07:59 AM 17-09-03 -0800, you wrote: OROWID is column of view a based on table b. With Regards,

RE: Configuring RMAN

2003-09-17 Thread Ramon E. Estevez
Hi list, Recalling the yesterday problem, here is my profile, what arrangement should I do To make RMAN work from the ORACLE_HOME/bin without to specify the path. Kind of new in UNIX/LINUX. TIA, export EDITOR=vi export TERM=xterm #* # Variables de Oracle |

RE: translate, replace...?

2003-09-17 Thread Igor Neyman
Looks like you've got one too many REPLACEs. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Hallas, John, Tech Dev Sent: Wednesday, September 17, 2003 11:00 AM To: Multiple recipients of list ORACLE-L IA, The following code should be close to what you want select

Re: RE: tuning a massive delete

2003-09-17 Thread rgaffuri
i explain planned it and it was much worse than not exists. my understanding is hash_aj is faster when the table in the sub-query returns results that are significantly less than the one in the outer table. ill try it, but i think exists is faster. we dont want to do an index scan here and my

RE: translate, replace...?

2003-09-17 Thread Hallas, John, Tech Dev
Yes, you are correct Igor. It was taken from an example I had which did 3 replaces. I did manage to substitute the 13 and 10 correctly though select replace(replace(a,chr(13),'R'),chr(10),'') from table John -Original Message- Sent: 17 September 2003 17:20 To: Multiple recipients of

RE: RE: tuning a massive delete

2003-09-17 Thread DENNIS WILLIAMS
Ryan - One solution that is often suggested would be to copy the rows you wish to retain to another table, then truncate the table. Oracle is relatively slow at deletes compared to inserts. Would this method work for you? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED]

Re: Configuring RMAN

2003-09-17 Thread Joe Testa
you ALWAYS want to use the path, you dont want to use a different version of binary for rman that does NOT correspond to the database you're backing up. joe Ramon E. Estevez wrote: Hi list, Recalling the yesterday problem, here is my profile, what arrangement should I do To make RMAN work

RE: RE: tuning a massive delete

2003-09-17 Thread Kevin Toepke
When tuning queries, ignore the fact that explain plan shows a cost. The optimizer finds the lowest cost it can. If you mess with hints you will almost certainly get a higher cost. I've tuned queries that ran for hours with a cost of less than 10 -- the tuned versions had costs in the

RE: tuning a massive delete

2003-09-17 Thread Mladen Gogala
How abuout: create table ani_prx_new parallel (degree 5) nologging as ( select * from ani_prx minus select * from from bo_owner.ani_prx where ba_recode='V') / I assume that the description of the bo_owner.ani_prx is identical to the description of the ani_prx. Furthermore, a bitmap index

RE: RE: translate, replace...?

2003-09-17 Thread Stephane Faroult
Syntactically incorrect (one 'replace' too much). IMHO translate() is the one to use here. Probably a negligible performance benefit but I find a single function call easier to read than a function taking another function call as argument. The fewer characters the better (I type slowly and

RE: Re: RE: tuning a massive delete

2003-09-17 Thread Stephane Faroult
Roy, NOT EXISTS is to be avoided when it is the only criterion - the subquery is executed for each row in the outer query. The way the CBO behaves varies wildly between 8.1.7 and 9.x. Richard's suggestion is quite correct and a fairly safe way to get a 'right' behaviour with most versions

Re: RE: tuning a massive delete

2003-09-17 Thread rgaffuri
i tested the minus in the explain plan and the estimate was very large. dont i need a large sort_area_size for that? bitmap index on all columns right? not just one? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/17 Wed PM 12:59:40 EDT To: Multiple recipients of list ORACLE-L [EMAIL

Re: RE: tuning a massive delete

2003-09-17 Thread rgaffuri
16 million of the 18 million records in the staging table have delete records. how would indexing help there? wouldnt a full table scan be better? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/17 Wed PM 12:59:40 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

Re: Is Cary's new book shipping now?

2003-09-17 Thread Dwayne Cox
Why oh why did I not wait? I tracked down and purchased Tom's previous Expert One-on-One Oracle a couple months ago. I even checked to make sure a new edition was not forthcoming. *sigh* Did not check enough I guess. I'll have to compare the two to see if I want to 'upgrade'. I am waiting,

RE: How to extract data directly from a datafile ?

2003-09-17 Thread Richard Ji
Looks like it's still in the planning stage. -Original Message- From: Pete Finnigan [mailto:[EMAIL PROTECTED] Sent: Wed 9/17/2003 6:59 AM To: Multiple recipients of list ORACLE-L Cc: Subject:Re: How to extract data directly from a datafile ? Hi, There is a tool

'Test' Note on Metalink...

2003-09-17 Thread John Kanagaraj
Have a laff! See Note 240863.1 (esp the first sentence). This seems to have been around since 11-Jun-2003 (if the Modified date can be believed) John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services

RE: Database Cloning

2003-09-17 Thread Ikediugwu, Chinedu SITI-ITPSIE
But you still need to do a cold copy of the database files, right? -Original Message- Sent: 15 September 2003 22:30 To: Multiple recipients of list ORACLE-L Your belief was wrong. Actually, the belief was correct for some versions of oracle and some platforms. Case in point was

Demanagement

2003-09-17 Thread Thomas Day
Way off topic, but I just have to vent. I'm working with a guy who really is hot stuff when it comes to project management. He's so good that they brought him in as an outside consultant to manage a priority project that touches on national security. He knows all about the mythical man-month

RE: 'Test' Note on Metalink...

2003-09-17 Thread Goulet, Dick
Just proves, what's TEST today is Production tomorrow. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, September 17, 2003 1:50 PM To: Multiple recipients of list ORACLE-L Have a laff! See Note 240863.1 (esp the first sentence). This seems to

Re: Is Cary's new book shipping now?

2003-09-17 Thread Rachel Carmichael
Tom has a NEW, different book out, from Oracle Press. That is the one Cary is referring to. Which means you'll have to buy a new book. As for Cary's book, I have it on order at Amazon as well, but according to the site today, it's still not released. :( --- Dwayne Cox [EMAIL PROTECTED] wrote:

RE: RE: tuning a massive delete

2003-09-17 Thread Mladen Gogala
Well, large sort area size would certainly help, as well as the parallel hints. As for the bitmap index, I din't know what was the percentage. It probably wouldn't help much. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On

RE: Demanagement

2003-09-17 Thread Mladen Gogala
So, now we're less secure? And the hurricane Isabel is coming fast. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Day Sent: Wednesday, September 17, 2003 2:00 PM To: Multiple recipients of list ORACLE-L

RE: 'Test' Note on Metalink...

2003-09-17 Thread Murray, Margaret
Or that the developers test in production! -Original Message- From: Goulet, Dick [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 2:05 PM To: Multiple recipients of list ORACLE-L Subject: RE: 'Test' Note on Metalink... Just proves, what's TEST today is Production

Re: Is Cary's new book shipping now?

2003-09-17 Thread Oracle DBA
Hi List, Does OCP emembers get any discount on Tom's Effective Oracle by Design (Osborne ORACLE Press Series), since it is coming from Oracle Press. Any idea? TIA Sami --- Rachel Carmichael [EMAIL PROTECTED] wrote: Tom has a NEW, different book out, from Oracle Press. That is the one Cary is

RE: 'Test' Note on Metalink...

2003-09-17 Thread Boivin, Patrice J
I wonder how long it's going to stay in Metalink now... : ) Patrice. -Original Message- Sent: Wednesday, September 17, 2003 2:50 PM To: Multiple recipients of list ORACLE-L Have a laff! See Note 240863.1 (esp the first sentence). This seems to have been around since 11-Jun-2003 (if

RE: Is Cary's new book shipping now?

2003-09-17 Thread Stephen Lee
I got my note from Bookpool last night, that my copy, that I pre-ordered a couple of weeks ago, has been shipped. Now, it remains to be seen if I can get the time to read it. -Original Message- Tom has a NEW, different book out, from Oracle Press. That is the one Cary is referring

Re: Is Cary's new book shipping now?

2003-09-17 Thread Ron Thomas
OK, call me senile, but I've been following this thread for so long I can't remember the titles for Cary's and Tom's books. Anyone wanna lend a hand with the ISBN number or title? Thanks, Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. --

RE: Is Cary's new book shipping now?

2003-09-17 Thread Johnston, Tim
Mine shipped from Bookpool yesterday... It's currently listed as In Stock there if you're in a hurry... http://www.bookpool.com/.x/t9mrg8o9b1/ss/1?qs=059600527X Tim -Original Message- Sent: Wednesday, September 17, 2003 2:15 PM To: Multiple recipients of list ORACLE-L Tom has a NEW,

syntax to remove TEMPORARY Tablespace?

2003-09-17 Thread Guang Mei
Hi: I did RTFM, but I could not find any answer. I created two TEMPORARY Tablespaces (see below) and I moved all users to TEMP. Now I want to drop TEMPLMT. When I tried alter tablespace TEMPLMT offline; I got alter tablespace TEMPLMT offline * ERROR at line 1: ORA-03217: invalid option for

RE: [Q] ORACLE 9iR2 two ethernet cards, two listeners auestions?

2003-09-17 Thread Stephen Lee
I'm not real up on this stuff, but here is an example (I think) of a tnsnames.ora file. It's possible (not sure) you might have to configure listener and/or database for the SERVICE_NAME part. Assuming XYZ1 is the instance name In local tnsnames.ora, have: XYZ.world =

Re: Re: Is Cary's new book shipping now?

2003-09-17 Thread fpayne
I got an email last night from bookpool that my copy of Cary's book had shipped. From: Rachel Carmichael [EMAIL PROTECTED] Date: 2003/09/17 Wed PM 02:14:40 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Is Cary's new book shipping now? Tom has a NEW,

RE: Is Cary's new book shipping now?

2003-09-17 Thread Jamadagni, Rajendra
Title: RE: Is Cary's new book shipping now? Optimizing Oracle Performance Effective Oracle Design -Original Message- From: Ron Thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 17, 2003 2:35 PM To: Multiple recipients of list ORACLE-L Subject: Re: Is Cary's new book

RE: Is Cary's new book shipping now?

2003-09-17 Thread Melanie Caffrey
If you search for Millsap and Kyte on Amazon they should pop right up. -Original Message- Ron Thomas Sent: Wednesday, September 17, 2003 2:35 PM To: Multiple recipients of list ORACLE-L OK, call me senile, but I've been following this thread for so long I can't remember the titles for

RE: drop tablespace temp INCLUDING CONTENTS hang

2003-09-17 Thread Guang Mei
Yes, you are right, I should have looked at ts# = 2. BTW, I tried several ways to resolve this issue by doing these and none of them worked, 1. alter tablespace temp default storage(pctincrease 0); -- a tip from Steve Adam's site 2. alter session set events 'immediate trace name

RE: SQL help needed

2003-09-17 Thread Jacques Kilchoer
I know you said that this was Informix, but I'll post the article below anyway for the benefit of other listers. Oracle Technology Network Oracle Magazine September/October 2002 Turning On Pivot Tables By Jonathan Gennick http://otn.oracle.com/oramag/oracle/02-sep/o52sql.html Describes a method

Re: +++Need an urgent info+++

2003-09-17 Thread M Rafiq
Kirti, Welcome back after a while. Hope you have finisihed your new book. Banglore may be a better choice in terms of better salary and level of living. I think Oracle Corp also hring for Banglore too. Regards Rafiq _ Get 10MB of

RE: RE: tuning a massive delete

2003-09-17 Thread Govindan K
I agree with Dennis Williams. Large deletes do have an overhead on indexes. Try this. - Create table new_table nologging as select * from existing_table where [condition] OR you may use COPY command in lieu of that - get the index definitions - exp grants,constraints,indexes=n ,rows=n for

RE: syntax to remove TEMPORARY Tablespace?

2003-09-17 Thread Rothouse, Michael
DROP TABLESPACE TEMPLMT; I don't think a LM temporary tablespace can be off-lined. -Original Message- Sent: Wednesday, September 17, 2003 2:45 PM To: Multiple recipients of list ORACLE-L Hi: I did RTFM, but I could not find any answer. I created two TEMPORARY Tablespaces (see below)

RE: 'Test' Note on Metalink...

2003-09-17 Thread Loughmiller, Greg
Title: RE: 'Test' Note on Metalink... I'm curious as to who has time to search for such an item these days:-) greg -Original Message- From: John Kanagaraj [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 17, 2003 1:50 PM To: Multiple recipients of list ORACLE-L Subject:

Re: Is Cary's new book shipping now?

2003-09-17 Thread Rachel Carmichael
Oracle Press is not a subsidiary of Oracle but rather of Osborne/McGraw-Hill --- Oracle DBA [EMAIL PROTECTED] wrote: Hi List, Does OCP emembers get any discount on Tom's Effective Oracle by Design (Osborne ORACLE Press Series), since it is coming from Oracle Press. Any idea? TIA Sami

RE: RE: tuning a massive delete

2003-09-17 Thread rgaffuri
create table ani_prx_faster parallel (degree 5) nologging as select b.* from bo_owner_master.ani_prx b, bo_owner_stage.ani_prx a where a.cusip = b.cusip (+) and a.fund_no = b.fund_no (+) and a.add_cymd = b.add_cymd (+) and nvl(b.ba_reccode, 'X')

RE: Is Cary's new book shipping now?

2003-09-17 Thread April Wells
Title: RE: Is Cary's new book shipping now? I believe, per one of the other DBAs here, OCPs get like either a 20% or 30% discount on books. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of

is this a good practice...pl/sql question

2003-09-17 Thread Steve McClure
Allright I am making some changes to some pl/sql code that handles batch inserts into the database. I am making changes to correct an error where our clients are sending us data with invalid state information in their address fields. A constraint prohibits the insert with records with invalid

RE: syntax to remove TEMPORARY Tablespace?

2003-09-17 Thread Guang Mei
Never mind, I found the answer. For those who are interested, here is what I did (tested on dev first, then ran on production against 8173 db). -- login as sys, ran select count(*) from dba_segments where TABLESPACE_NAME ='TEMPLMT'; -- got 0 returned, then ran ALTER DATABASE TEMPFILE

Re: syntax to remove TEMPORARY Tablespace?

2003-09-17 Thread Tanel Poder
You cant take a temporary lmt temporary tablespace offline, just drop it. The drop command will wait until there is no needed temp data left. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 9:44 PM Hi: I did

RE: Is Cary's new book shipping now?

2003-09-17 Thread Jamadagni, Rajendra
Title: RE: Is Cary's new book shipping now? I usually get 100% ... company reimburses ... sometimes. -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 17, 2003 4:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Is Cary's new

RE: backup problem

2003-09-17 Thread Spears, Brian
Good. And I would add... Test on a regular schedule to see if some yahoo has altered the server or environment and invalidated your recover procedure. Brian -Original Message- Sent: Tuesday, September 16, 2003 4:15 PM To: Multiple recipients of list ORACLE-L LeRoy One of my bigger

RE: Is Cary's new book shipping now?

2003-09-17 Thread Cary Millsap
0-596-00527-x Millsap/Holt 2003 0-07-223065-7 Kyte 2003 Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Ron Thomas

  1   2   >