Re: rebuilding indexes - sure to cause a ruckus

Hi Tanel, I recommend a strong cup of coffee and a small nap 1/2 way through ;) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 7:44 AM Ouch, I gotta take a day off to read this one ;) -- Please see the official

Re: rebuilding indexes - sure to cause a ruckus

Hi Paul, The long one includes a discussion on why you should generally coalesce rather than rebuild indexes ;) Cheers Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 8:44 AM somewhat on the longish side???

Re: rebuilding indexes - sure to cause a ruckus

Hi Steve, I agree completely, but the question is would you rebuild it afterwards ? Cheers ;-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 9:29 AM I think it needs an index. ;-) -Original Message-

Re: can't see a SQL generated by Crystal Report

Are you sure that Crystal does not do any local processing on the data? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 12:39 AM Hi all: I'm trying to catch a DDL generated by Crystal report. I'm

Re: Oracle and Novell eDirectory LDAP

IIRC Oracle is going to support only OID as LDAP. You need to set up OID and use a product like DIRXML to propagate updates from Novell to OID. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:34 PM

Antw: CLONE db

on metalink check: Doc ID: 212346.1 kr mr [EMAIL PROTECTED] 12/09 1:04 Hi, I have hotbackup for x date.I want to create clone to another box on Linux(Oracle9i). is it possible to clone with same instance name on diffrent box with diffrent file location?I think yes. Can someone send me

Antw: Re: Oracle and Novell eDirectory LDAP

we use some java plugins for novell to contct ldap for authentication. used more than two years - no problems. BUT: we taylored it to our needs - and do NOT use OID at all. kr mr [EMAIL PROTECTED] 12/09 9:59 IIRC Oracle is going to support only OID as LDAP. You need to set up OID and use a

Oracle Client (9.2.0.4)

Hi, I find the information concerning upgrading to Oracle 9.2.0.4 on the server and upgrading to ODP.NET 9.2.0.4.01 on the client a little confusing. Se readme for patchset nr 3262475 The upgrade on the server to 9.2.0.4 is ok and the upgrade on the client is no problem. But should you install

Antwort: OpenLDAP instead of OID

Hi folks, here is the requested paper. Mit freundlichen Grüßen Andreas Teich dawaConprise GmbH c/o Investitionsbank Berlin Informationstechnologie Spichernstrasse 2 10777 Berlin Tel.: 030/2125-2513 Fax: 030/2125-2534 In UNIX Land On a quiet Night, you can hear the Windows

Re: Re: Oracle and Novell eDirectory LDAP

You are talking about Novell using LDAP. I am talking about Oracle using LDAP, especially with enterprise user. I was told that version 9i or 10g will support only OID as LDAP. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent:

RE: A brief detour....;-)

I am just glad that so many on this read /. too ... that's my homepage ... on my Firebird browser. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any

RE: dc_used_extents ,dc_free_extents and dc_histogram_defs

and what they don't tell you that there are 3000 undocumented parameters because they are undocumented. As one finds all bugs (or should I say easter eggs) in our code, we will tell them one by one to you. Raj

RE: Database management techniques and frameworks

Orr, Steve scribbled on the wall in glitter crayon: I'm not assuming such a tool exists... It indeed does exist because the salesman who happened to be selling it said so and it must be of course it does, and they'll install it for you because they can install and tune it EXACTLY THE SAME WAY

OS calls with java stored procedures

Im playing with the example in tom kytes book. we have alot of korn shell scripts that we use as functions. We 'echo' out values to standard out. is there anyway to catch this echo with a java stored procedure? I thought about redirecting it to a file and reading it in with utl_file, but that

RE: dc_used_extents ,dc_free_extents and dc_histogram_defs

-Original Message-From: Denny Koovakattu [mailto:[EMAIL PROTECTED]Sent: Monday, December 08, 2003 10:14 PMTo: Multiple recipients of list ORACLE-LSubject: Re: dc_used_extents ,dc_free_extents and dc_histogram_defs And how do you join one ?Denny[Shrek] you have to be

two oracle pl/sql programmers needed (50k/yr)

please send an email to me,if you're interested. _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ:

RE: OS calls with java stored procedures

I'm working from memory here, but there is a procedure in a built-in package, I think it is DBMS_JAVA, that redirects standard output from a Java Stored Procedure to the same buffer that DBMS_OUTPUT uses. You call this procedure, then your Java method, and then you can SET SERVEROUTPUT ON to

Antw: Re: Re: Oracle and Novell eDirectory LDAP

what we have is an novell ldap with jave plugins used by oracle IAS to authenticate users. we started once with OID but stayed then with novell. check it for yourself - http://mdwis.mdw.ac.at/ - we had to run a config script that allows us to use the novell ldap instead of OID. I don't know

RE: migrate 8.1.7 to 9.2.0

Hey Bambi - how are ya girl. It is and I changed by oratab to use the 9.2.0 OFA home. I am thinking perhaps that ##$$%% LD_LIBRARY_PATH again. -Original Message- Bellow, Bambi Sent: Monday, December 08, 2003 5:59 PM To: Multiple recipients of list ORACLE-L Make sure your ORACLE_SID

Antw: Antwort: OpenLDAP instead of OID

requires an external link. this one doesn't work. mr [EMAIL PROTECTED] 12/09 1:54 Hi folks, here is the requested paper. Mit freundlichen Grüßen Andreas Teich dawaConprise GmbH c/o Investitionsbank Berlin Informationstechnologie Spichernstrasse 2 10777 Berlin Tel.: 030/2125-2513 Fax:

RE: OS calls with java stored procedures

ummm ... something like system('`my_code`'); --- check there are backticks ... Not sure if it will run, but hey ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly

Re: two oracle pl/sql programmers needed (50k/yr)

System Manager: Where are these positions located geographically? Me - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 7:44 AM please send an email to me,if you're interested.

leaf node 90-10 splits

Hi! I wonder why does statistic leaf node 90-10 splits imply that right-hand index leaf block is split as 90-10, not 100-0 as it really is. (tested on 9.2.0.4 W2k). Historical reasons? Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET:

RE: OpenLDAP instead of OID

Dear All, I have emailed to Jeff and his link is back up. Kind Regards, Hatzistavrou Yannis -Original Message- Sent: Tuesday, December 09, 2003 7:19 AM To: Multiple recipients of list ORACLE-L Stefan Jahnke and Denis Williams have recently posted recipe for replacing OiD with

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

I believe that we should start using Postgres or MySQL, not to infringe on oracle secrets. After all, those secrets must be mighty precious when they're protecting them from their own customers. I believe that the whole thing is about giving consultants time to master oracle 10 before releasing

RE: Antw: Re: Re: Oracle and Novell eDirectory LDAP

Markus - Do you use Novell instead of tnsnames.ora as well as authenticating users? We use MS AD. Any insights as to how your method could be applied to MS AD? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 7:54 AM To: Multiple

Re: OpenLDAP instead of OID

Thanks! I've saved the HTML locally. Thanks again! On 12/09/2003 09:39:25 AM, Hatzistavrou John wrote: Dear All, I have emailed to Jeff and his link is back up. Kind Regards, Hatzistavrou Yannis -Original Message- Sent: Tuesday, December 09, 2003 7:19 AM To: Multiple

RE: rebuilding indexes - sure to cause a ruckus

This message's a keeper! Thanks! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Monday, December 08, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Hi Yong,

RE: OpenLDAP instead of OID

We had some issues here with OpenLDAP. So we went with SunOne instead, which is still free for low usage (100K LDAP entries). AFAIK, perfect uptime and replication in the past year or so... Just another option to consider... Rich Rich Jesse System/Database

RE: OpenLDAP instead of OID

Mladen - Glad your issue is resolved. In the interest of accuracy, this Dennis Williams hasn't looked at OpenLDAP. Our network guys think MS AD is where it's at and I'm hoping someone will figure out how to get Oracle working with MS AD. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED]

RE: Database management techniques and frameworks

Makes me remember the story I was told about damagement running around telling users to log off because the latches are red ;) -- Denny Koovakattu Quoting Thater, William [EMAIL PROTECTED]: Orr, Steve scribbled on the wall in glitter crayon: I'm not assuming such a tool exists... It

RE: A brief detour....;-)

Hate to say this but you are a bit late. I had my students at University and here at Compuware create three to four different versions of the Tower's of Hanoi solution in PL/SQL. Used PL/SQL tables, stack processing, recursion (yes it can be done), and others. I also had (yep had - lost this)

Re: A brief detour....;-)

Is there any for windows command shell? :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 5:24 PM Hate to say this but you are a bit late. I had my students at University and here at Compuware create three to

On Partitions

We have a data warehouse around 850gb. I have a question on procedure. We only keep 2 months data in several groupings by month, with 3 months ready.. So, say Nov is in M1 and Dec is in M2. At the end of December, we will create an empty January which will go back into M1 and we will be

Re: OpenLDAP instead of OID

Then I have to apologize to each and every Dennis Williams for slanderous allegations. It wasn't my intention to hurt any Dennis Williams. On 12/09/2003 10:14:25 AM, DENNIS WILLIAMS wrote: Mladen - Glad your issue is resolved. In the interest of accuracy, this Dennis Williams hasn't looked at

Re: A brief detour....;-)

You are bringing up old memories. I had both PL/1 and assembler (IBM mainframe) in the early 70's. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 5:24 PM Hate to say this but you are a bit late. I

Re: Database management techniques and frameworks

Serves them right for not using mauve database, which, as everybody knows, uses the least RAM. On 12/09/2003 10:24:27 AM, Denny Koovakattu wrote: Makes me remember the story I was told about damagement running around telling users to log off because the latches are red ;) -- Denny

RE: A brief detour....;-)

I used to have a macro for VI but have lost it. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

dropping materialized view

Hi, I have a serious problem in dropping a snapshot/mview I cannot find whatever constraint is blocking this. Any advice is appreciated SQL drop snapshot deca.mediums; drop snapshot deca.mediums * ERROR at line 1: ORA-02449: unique/primary keys in table referenced by foreign

RE: Antw: Re: Re: Oracle and Novell eDirectory LDAP

NO - not instead of tnsnames.ora. We stuck to the tnsnames.ora files. We had it once, but this was rather tricky to get it working at that time. Especially the uploading of certificates thet we made ourselves ... - but we had already a solution to update the OID on a daily/hourly basis for user

RE: dc_used_extents ,dc_free_extents and dc_histogram_defs

8 snip 8 Well, I think part of the problem is a perception (how valid it is I don't think I'm in a position to say, but the perception certainly exists) that allowing access to the code too early simply provides ammunition for competitors to be far more prepared than we'd like them to be. :) 8

RE: rebuilding indexes - sure to cause a ruckus

Richard's explanation and example from c.d.o.s now has a permanent tinyurl link ... http://tinyurl.com/yflq if anyone is interested ... this might be better for bookmarks. Raj Rajendra dot Jamadagni at nospamespn

RE: Antw: Re: Re: Oracle and Novell eDirectory LDAP

Markus - Thanks for your ideas. Basically our issue isn't Oracle logins, but Oracle connections (replacing tnsnames.ora). For us, the user doesn't directly log into Oracle, but the application handles the login for them. However, I was searching for an alternative to maintaining tnsnames.ora on

Re: dropping materialized view

Please try this select table_name, constraint_name from all_constraints where r_constraint_name in ( select constraint_name from all_constraints where table_name = 'MEDIUMS') it should give you the table_name constraint names that are not allowing you to drop your table. You will have to

RE: rebuilding indexes - sure to cause a ruckus

What sort of Oak Table member are you, Richard? Any Oak Table member worth their weight in toilet paper would certainly execute DBMS_POWERNAP part way through, but the strong cup of coffee definitely needs a large shot of whiskey substituted for it! :) Pete Controlling developers is like

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

That perception came into being quite recently. I believe that Oracle Corp. should change that perception and they need our help to do so. As I've said before, if nobody was using oracle, their secrets would be perfectly safe, just as Ingres or dBase IV secrets are. Graveyard is full of

RE: dc_used_extents ,dc_free_extents and dc_histogram_defs

No no. That's the rings of Saturn made of lost airline luggage, discarded accordions, and now secrets. I think microchannel bus is up there. -Original Message- Graveyard is full of companies whose secrets are safe. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

Oracle AS 10g

Has been posted for HP/UX and Solaris on OTN. http://otn.oracle.com/software/products/ias/devuse.html I don't see Windows in their certification matrix, but they mention Red Hat linux 2.1. No SuSE. http://otn.oracle.com/software/products/ias/files/as-certification-904.html Maybe they will

sequences and cursors

hi here are the specs of my db: version 8.1.7 on windows,open_cursors=500 i am facing a certain issue. we have a few sessions running out of cursor(ora-1000) and i used 1000 event to dump trace on these sessions. i found a certain statement select seq.nextval from dual; being repeated more than

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

There was an announcement on the OTN, but nobody replied to email. When reading this list, I get impression that quite a few people were able to get the software so far and that the shroud of secrecy over the whole thing is maintained in order for them to gain advantage over the rest of

Re: A brief detour....;-)

Bobak, Mark wrote: Nice solution! I had first briefly considered a SQL solution, but it didn't I like simple ones. immediately come to mind, and the PL/SQL recursive solution was pretty straightforward, so, I went that direction. I wasn't really too concerned about expense, in this case;-)

Re: can't see a SQL generated by Crystal Report

I'm not sure. I'm talking to the application team to see what exactly is being done behind the scene. I do know that I can't capture queries running via ColdFusion server and thought that there may be something like that with Crystal. Gene --- Yechiel Adar [EMAIL PROTECTED] wrote: Are you sure

Re: rebuilding indexes - sure to cause a ruckus

Thanks, Richard. I'll read your long message more carefully later. I like your statement that rebuilding an index or not is not rocket science. One needs to measure the performance before and after the rebuild and make a conclusion himself. Many times we discuss performance issues and get very

RE: dropping materialized view

select table_name, constraint_name from all_constraints where r_constraint_name in ( select constraint_name from all_constraints where table_name = 'SNAP$_MEDIUMS') -Oorspronkelijk bericht- Mohammed, Thanks for your reaction but this doesn't help. I think table must be snap$_mediums

RE: A brief detour....;-)

My memories of PL/1 are more unusual - I programmed a pre-CPM Z80 based machine in its own dialect of PL/1 in the late 70s early 80s. -Original Message- Sent: Tuesday, December 09, 2003 10:49 AM To: Multiple recipients of list ORACLE-L You are bringing up old memories. I had both PL/1

RE: dc_used_extents ,dc_free_extents and dc_histogram_defs

Well, as you'd suspect I don't have any control over these sorts of decisions! I didn't actually see the announcement on OTN, so I'm not sure who the email would have gone to. There was a way Oracle employees could invite customers to be part of the beta program, sp presumably your sales rep

RE: PERL?

I don't think any UNIX shell has some package or module written for any database. So the only way to talk to Oracle is using shell as a wrapper around sqlplus (or any application you developed). In sqlplus, you can use bind variables easily. In this sense, we can say shell does allow you to use

RE: can't see a SQL generated by Crystal Report

I happen to know that you have to work hard to keep Crystal from doing a SELECT * and doing its own filtering and grouping. It can be done, but you have to KNOW that that is what you want to do, i.e. novices will let Crystal do what it wants. -Original Message- Sent: Tuesday, December

Re: Oracle Data Guard

Jumbo frames are new to me. The Ethernet Definitive Guide book says it was proposed by one vendor and adopted by several, so may not have good interoperability. But I wonder how much performance improvement there is by going from MTU 1500 with SDU 8k to MTU 8k with SDU 8k. I assume the lower the

RE: dropping materialized view

Disabling constraint (when you want to drop the parent table) will not help. This should help: Alter table DEBTOR_CLAIM_COMPONENTS drop constraint FK_DCC_MEDIUMS. After this you should be able to drop MV. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Jeroen van Sluisdam

Re: sequences and cursors

What tool are you using? HAve you considered putting select from the sequence in an explicit cursor, open it, fetch it and close it again? What Have in mind is something like this: declare cursor csr is select sai.nextval from dual; num integer :=0; ind integer :=10; begin while (ind=0) loop open

Windows clustering???

I'm guessing they're not running Oracle on this VMS cluster. I really liked the part about the most difficult part was explaining to managers why it was unnecessary to shut systems down, even during the physical relocation. http://www.theinquirer.net/?article=13002 Imagine if DEC had any

RE: Oracle Data Guard

Hi All, I am working on a similar project here. I am wondering if anyone in the list ever compared Oracle Data Guard with iReflect from Data Mirror. Please share your experience with us. Thanks, Kitty -Original Message- Sent: Monday, December 08, 2003 6:54 PM To: Multiple

RE: dropping materialized view

Oops I feel very stupid, thanks a lot Igor this did the tric. Regards Jeroen -Oorspronkelijk bericht- Van: Igor Neyman [mailto:[EMAIL PROTECTED] Verzonden: dinsdag 9 december 2003 21:09 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: dropping materialized view Disabling

Creating the Java System

All, I am attempting to install the Java system in a 9.2 database on Sun Solaris. This is a db that I migrated up to 9.2 from 8.1.7. I am getting the following: SQL create or replace java system 2 / create or replace java system * ERROR at line 1: ORA-00604: error occurred at recursive SQL

RE: Oracle Data Guard

I have never worked on Network stuff. But is there any easy parameters we could set in sqlnet.ora so that we could increase the DB performance by increase the network transfer rate (without doing anything else)? BTW my sqlnet.ora (on a Sun Box) has only two lines: -- bash-2.03$ more

RE: dropping materialized view

Don't (feel stupid) :) It happens to all of us... Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Jeroen van Sluisdam Sent: Tuesday, December 09, 2003 3:39 PM To: Multiple recipients of list ORACLE-L Oops I feel very stupid, thanks a lot Igor this did the tric. Regards

Re: Creating the Java System

I would advise full export and then executing create database controlfile reuse datafile.logfile... command before initjvm and everything will work. On 12/09/2003 03:44:26 PM, Mercadante, Thomas F wrote: All, I am attempting to install the Java system in a 9.2 database on Sun Solaris.

RE: Creating the Java System

gee thanks. where do you live? I'll meet you at your car. I'll be the one with the baseball bat. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 09, 2003 4:09 PM To: Multiple recipients of list ORACLE-L I would advise full export and then

RE: PERL?

On Tue, 9 Dec 2003, Yong Huang wrote: Speaking of Perl versus shell, Perl may still be quite primitive in supporting two-way communication with an external program e.g. sqlplus. (I have an example at www.stormloader.com/yonghuang/computer/OracleAndPerl.html#2waytosqlplus using IPC::Open2).

Re: Database management techniques and frameworks

Mladen Gogala wrote: Serves them right for not using mauve database, which, as everybody knows, uses the least RAM. According to my source(taped up in my cubicle), mauve has the most ram. ;) -Brian -- / * Brian Haas

RE: Creating the Java System

Try these metalink notes: Oracle Notes 209870.1 149393 pay particular attention to sys_trig_enabled=false HTH, Mike

RE: Creating the Java System

Thomas, This error seems to vaguely ring a bell. You may try: http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOTp_id=209870.1 Hope that's helpful. -Mark -Original Message- Sent: Tuesday, December 09, 2003 4:19 PM To: Multiple recipients of

Re: Creating the Java System

Well, if you cannot create or replace Java system, then you have a problem with the data dictionary. The table that is returning too many records is, quite likely, a SYS-owned table. You may beat me to the pulp but I still think that it will probably be necessary to re-create your database.

RE: dc_used_extents ,dc_free_extents and dc_histogram_defs

Pete, Is Mladen bigger than you??? Carel-Jan At 16:44 8-12-03 -0800, you wrote: Well, I think part of the problem is a perception (how valid it is I don't think I'm in a position to say, but the perception certainly exists) that allowing access to the code too early simply provides ammunition

Re: Oracle Data Guard

Hi Vi, Rows NEED unique identification. So, if there are bunches of raw data with no unique identifier whatsoever (remember, rowid is not allowed) LSB can't generate a where-clause what row to update or delete on the SB database. It's generating SQL based on redolog info, and has to come up with

RE: A brief detour....;-)

Back in the early 80's at school we had a towers of hanoi running in PL/1 On Nixdorf 8820, a teletype with matrix printer, printing out the full configuration after every move you made Regards, Carel-Jan -- There will always be another 10 last bugs -- At 07:24 9-12-03 -0800, you wrote:

RE: PERL?

All *SQL* commands will work work with the DBI. 'SHUTDOWN' is not a SQL command, it is a sqlplus command, and therefor will not work with the DBI. This has been checked into, and Oracle does not make this functionality available via OCI, so shutting down and starting a database on *nix

Re: rebuilding indexes - sure to cause a ruckus

And in case you miss it in Richard's terse message, one of the big reasons that it is not 'rocket science' is that you can perform operations that modify the index(es), and perform block dumps of the index as you go. You can see exactly what Oracle is doing with the index. Jared Yong

Oracle8i and oracle9i in the same machine

Hi everybody I have been running oracle817 since long time on WindowsNTNow I installed Oracle9i on the same machine and I cannot use both at the same time. How can I resolve this problem regards, Mauricio Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing

RE: rebuilding indexes - sure to cause a ruckus

Science is the belief in the ignorance of experts. --Richard Feynman Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas

RE: Oracle Client (9.2.0.4)

-Original Message- From: Anders Bengtsson [mailto:[EMAIL PROTECTED] Sent: Tuesday, 9 December 2003 23:24 To: Multiple recipients of list ORACLE-L Subject: Oracle Client (9.2.0.4) Hi, I find the information concerning upgrading to Oracle 9.2.0.4 on the server and upgrading

RE: rebuilding indexes - sure to cause a ruckus

Shh!! Nonsense! It's all black magic and conjecture! How else are we going to be highly paid Oracle consultants, if everyone knows all this stuff is provable and demonstrable?? ;-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, December 09,

RE: PERL?

I've written one shell script using the coprocess. I don't like using it. But that's just me. I think one way of describing ksh (for the male readers out there, anyway) is that ksh is like the legally blonde girlfriend: There are times when you wish there was more intelligence there. But she

Documenting databases

Recently our database manager has asked us to do the unthinkable document our databases! To make matters worse, and without our input, he went ahead and created a schema and put it in an Access database (using tables to make it look like a speadsheet). Either we use his idea or come

RE: Oracle Data Guard

Hi Kitty, Never heard of that, but I'm interested in your experiences, and the architecture of iReflect. The only advantage of Data Guard I can tell you is that it comes for free with your Oracle licences. Regards, Carel-Jan -- There will allways be another 10 last bugs -- At 12:14

Re: sequences and cursors

thanks mladen. will give this a shot...again thanks a bunch sai --- Mladen Gogala [EMAIL PROTECTED] wrote: What tool are you using? HAve you considered putting select from the sequence in an explicit cursor, open it, fetch it and close it again? What Have in mind is something like this:

RE: dc_used_extents ,dc_free_extents and dc_histogram_defs

From what I understand, hes even bigger than you! J 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- From: [EMAIL PROTECTED]

Re: sequences and cursors

thanks mlade..i will surely give this a shot. can you please tell me whether a sequence creates such issues. as mentioned earlier, the developers claim that no code has changed. im am not able to give any kind of reason for this though the trace shows this statement being called more than 350

Re: Documenting databases

On Tue, 9 Dec 2003 [EMAIL PROTECTED] wrote: Recently our database manager has asked us to do the unthinkable document our databases! To make matters worse, and without our input, he went ahead and created a schema and put it in an Access database (using tables to make it look like a

Re: Oracle8i and oracle9i in the same machine

Some reading. Note:73963.1 on Metalink, which ends with: Further reading --- The Oracle platform specific Windows documentation contains more information on configuring multiple Oracle homes. Please refer to the following manuals: 8i Oracle8i Administrator's Guide for Windows NT

RE: dc_used_extents ,dc_free_extents and dc_histogram_defs

Good heavens. Carel-Jan At 14:59 9-12-03 -0800, you wrote: From what I understand, hes even bigger than you! J 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

RE: OS calls with java stored procedures

Yes, it's exec dbms_java.set_output(2000); Richard Ji -Original Message- Sent: Tuesday, December 09, 2003 8:50 AM To: Multiple recipients of list ORACLE-L I'm working from memory here, but there is a procedure in a built-in package, I think it is DBMS_JAVA, that redirects standard

Re: Documenting databases

Dan, That's a good idea for documenting structures inside the database. However, my database manager wants more high level info: database name / host, oracle version, listeners, applications that use it, cron job descriptions and times, main schemas and what they are used for, lists of

Re: Documenting databases

I think you can download a software called DataPublisher from AgileInfoSoftware, it will automatically document the database for you. http://www.agileinfosoftware.com/download/products.asp. The output is very impressive. Eric - Original Message - To: Multiple recipients of list ORACLE-L

Re: Oracle8i and oracle9i in the same machine

This is rather vague. What does I cannot use both at the same time actually mean? I use both on NT 4 sp 6 without a problem. Jared Mauricio V?lez [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/09/2003 02:29 PM Please respond to ORACLE-L To:Multiple recipients of list

Re: Creating the Java System

I have been in this situation a couple times. You *can* fix your system so that java can be built successfully. It requires perusal of a few articles on MetaLink, and some persistance. Jared Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/09/2003 01:49 PM Please respond

Re: Documenting databases

The internal stuff can be documented with OraSnap. Just google for it. It's free, detailed, and easy to setup and automate. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/09/2003 03:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL

RE: PERL?

I agree. I once wrote a whole set of functions to run sql and sqlplus scripts directly from the command line. I didn't find it useful enough to continue. And it's rather tricky to program. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/09/2003 02:29 PM Please respond to ORACLE-L

Re: Documenting databases

Don't know if this has been mentioned or if it does enough of what you're looking for but you can pick up something called RDA (remote diagnostic agent) from Oracle that'll give you an overview of OS setup, Network, performance (very high level), and RDBMS info. And the result is web-a-fied

  1   2   >