Re: This is just wrong

Tim, Oracle has even produced a "developer's release" of Oracle9.2 for Mac OS X, downloadable from OTN. that was released in Sept 2002. releases of 8.1.6 and 8.1.7 were supposed to be released for production usage, according to articles floated by Bob Shrimpi. Those never happened. What do you

Re: How do you genrate primary keys?

I'm a bit surprised no one's mentioned it, but there's an article about the use of surrogate keys at Ixora : http://www.ixora.com.au/tips/design/synthetic_keys.htm mvg/regards Jo Jonathan Gennick [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/05/2003 14:19 Please respond to ORACLE-L

Oracle Warehouse Builder (OWB) mailing list

Hi! Does anybody out there know of a mailing list / newsgroup / user group concerning Oracle Warehouse Builder? Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

New member / outer join problem

Hi All, I'm a new member on this list. I'm not too familiar with ORA, but I have some experience in other RDBMS's. I had run into the following problem. My task is to write a query, which returns with an empty (full of NULLs) row, if the condition is false. I'm thinking in outer joins. I

Re: shareplex: datatype unsupported

- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 06, 2003 9:34 AM You know, from a logistics perspective I'm interested in something here that maybe those that use SharePlex can cast some light on. The only Oracle supported

RE: New member / outer join problem

Attila, Review your logic. A row full of NULLs has no signification. If your statement is embedded into either some PL/SQL code or a 3rd generation language, Oracle will generate a 'no data found' error, and this is what you need to trap. For instance in PL/SQL begin select c1, c2,

Re: IMP using the same DMP file

On the subject of export/import, has anyone exported a 1 TB db and imported it into another db? The largest I have done is 300gb w/out problems. [EMAIL PROTECTED] 11/05/03 05:04PM You can import the same file into two instances simultaneously, because"imp" doesn't lock the import file,

RE: shareplex: datatype unsupported

The semi official shtick from Quest is that Oracle changes the log file format rarely because the change ripples through much of the rest of the server code. Log file format affects archiving and recovery at a pretty basic level. As a financials shop, I don't worry too much about keeping up with

RE: New member / outer join problem

Hi Stephane, Review your logic. A row full of NULLs has no signification. If your statement is embedded into either some PL/SQL code or a 3rd generation language, Oracle will generate a 'no data found' error, and this is what you need to trap. I want to run it in SQL, not in PL/SQL. I

Point-In-Time recovery question, Non-RMAN solution

Hi DBAs, Oracle 8i, ArchiveLog, No RMAN Testing Point-In-Time Recovery I am confused on what time to substitute in the RECOVER DATABASE UNTIL TIME 'timestamp'; For example 2 days ago 11/04/2003 approximately 17:00 I drop a table. Today I decide I want that table back. I want to do an

oracle events...

Does anyone know what these oracle events are and how the wait times can be reduced. This is an extract from statspack output on 9.2.0.4 on HP 11.11 Top 5 Timed Events~~ % TotalEvent Waits Time (s) Ela Time ---

Re: This is just wrong

I doubt it too. I don¹t see MAC as a serious server, and it would probably be a mistake for Apple to go in that direction... However, I hope that Oracle releases a 10g ³developer¹s release² for OS X, so I can keep up by having it on my laptop. What they did with 9.2 is just fine with me... on

Re[2]: How do you genrate primary keys?

Wednesday, November 5, 2003, 8:39:24 AM, Mercadante, Thomas F ([EMAIL PROTECTED]) wrote: MTF First, to me, a primary key should not be something that a user would ever MTF see or use. I'm not sure that's always practical. I once worked on a system that arbitrarily assigned ID numbers to vending

Re: Bitmap join indexes

I am running EE. In what sense are they expensive? On 11/05/2003 04:54:25 PM, Paul Drake wrote: Mladen, If you are not currently running Enterprise Edition, they are indeed very expensive indexes. :D Pd Mladen Gogala Oracle DBA Note: This message is for the named person's use only.

Re[2]: How do you genrate primary keys?

Wednesday, November 5, 2003, 9:24:41 AM, Hemant K Chitale ([EMAIL PROTECTED]) wrote: HKC 1. Hit a table that keeps a counter. HKC Used to be a mechanism in the Oracle5 days [If I remember correctly, HKC Sequences came in Oracle6]. Issues were with locking the single HKC record used as the

Re: Point-In-Time recovery question, Non-RMAN solution

Rick unless i'm missing something you need to restore ALL datafiles and then roll forward to the point in time, since all of the SCN have to match before you can get the db open. the timestamp format for step 5 is: RECOVER DATABASE UNTIL TIME '1998-11-23:12:47:30' hth, joe [EMAIL

Re[2]: ORDER -- was Re[2]: Sequences in OPS/RAC

Wednesday, November 5, 2003, 9:14:34 AM, Hemant K Chitale ([EMAIL PROTECTED]) wrote: HKC There are times when you cannot afford to lose CACHed values, as John HKC Kanagaraj has pointed out HKC in Oracle Applications when generating Cheque numbers. Such sequences HKC required a patch in HKC

Re[3]: How do you generate primary keys?

Wednesday, November 5, 2003, 1:14:26 PM, Jamadagni, Rajendra ([EMAIL PROTECTED]) wrote: JR hypothetically, When you have a requirement that no gaps allowed in a sequence no matter what, JR would you still use sequences? Ah! This is a good question. If no gaps are acceptable, period, end of

XDB XLMSCHEMA

List, There doesn't seem to be any cool tools to generate XMLSchemas for XDB that I could find. Here is a simple sql script to pull a table out of the data dictionary and generate a basic XMLSCHEMA to register in Oracle XDB. I'm trying to figure out what the conversion is for Oracle datatypes

Re[2]: How do you genrate primary keys?

Yes, now I understand your concurrency issue. There would have been better ways but it was wiser not to spend time trying to improve going down the wrong path. Good that you convinced the managers there to go for Sequences early. Regards Hemant At 05:59 AM 06-11-03 -0800, you wrote: Wednesday,

[slightly OT[ infiniband

Title: [slightly OT[ infiniband does any one know any good pointers to find more info about infiniband? The infamous googlecached 10g new features doc mentions support for infiniband and Sockets direct protocol. Hence my interest ... TIA Raj

datamodelling question: updating foreign keys

I remember seeing this question asked on another forum some time back. I dont like the solution the guy had and Im wondering how some of you might solve problem. Im giving a low level generic example. Lets say you have a parent-child relationship. The parent table is 'TRUCKS' and the child

RE: Re[2]: ORDER -- was Re[2]: Sequences in OPS/RAC

Jonathan Gennick scribbled on the wall in glitter crayon: Would NOCACHE really prevent loss of sequence values? It seems to me that you could still find yourself in a situation where you grab NEXTVAL from a sequence, causing it to increment, and then you rollback your transaction. The

Metalink: Pwd Problems?

Walked in to major problems this morning, and I cannot log into metalink. I keep getting invalid password errors. (We have 3 CSI's and I cannot get in on any of them) Anyone else having problems? Thanks! Barb __ Do you Yahoo!? Protect your identity with Yahoo!

Datatypes

Hallo, I have a table, A: IMPEXCEL_EANNR which contains the field IMP_PRIS(= price) It looks like this: 12 1,50 11 This is a varchar2 field in this table. I want that field values to be inserted(or rather update the other table ) in other table called VARUKORGEANREL, but field in which

RE: Metalink: Pwd Problems?

I was on this morning checking out an ora-600. It was slow, but I got there. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, November 06, 2003 9:50 AM To: Multiple recipients of list ORACLE-L Walked in to major problems this morning, and I cannot log

RE: SQL*Plus question - a bit urgent - Can we suppress 'Connected

My reply was probably a bit too brief. The most robust way for doing this would be to use pattern matching utilities such as sed and awk (Perl? What's Perl?) to parse that output for stuff like ORA- (N is a digit of a number) TNS- SP- etc. But for a quick and dirty approach, select

RE: [slightly OT[ infiniband

http://www.catc.com/conntech/infiniband.html I too was interested in it after reading the 10g article in Oracle Magazine ;) Regards Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool

RE: Metalink: Pwd Problems?

Same here. Regards Pawan -Original Message- Sent: Thursday, November 06, 2003 8:20 PM To: Multiple recipients of list ORACLE-L Walked in to major problems this morning, and I cannot log into metalink. I keep getting invalid password errors. (We have 3 CSI's and I cannot get in on

RE: Metalink: Pwd Problems?

Title: RE: Metalink: Pwd Problems? so far not this morning, but have had this problem several times over the last few days. Keep trying, it will eventually let you in... but I would get on the phone on the support number while you keep trying. I think they are having server troubles... kind

RE: [slightly OT[ infiniband

Thanks. Not with 10g, but has anyone ever used this technology at work? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts,

RE: Point-In-Time recovery question, Non-RMAN solution

Have you looked into using logminer? Even if it can't restore your table, it can give you the exact time that it was dropped. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message-

RE: Metalink: Pwd Problems?

I'm not experiencing any problems logging in. -Original Message- Sent: Thursday, November 06, 2003 9:50 AM To: Multiple recipients of list ORACLE-L Walked in to major problems this morning, and I cannot log into metalink. I keep getting invalid password errors. (We have 3 CSI's and I

Re: RE: Index behavior

Actually, it has nothing to do with any of the table or index statistics. OK, almost nothing. I suppose if Jonathan (Lewis) can get the optimizer to do a FTS on an umpteen billion row table to retrieve a single row by its prime key, one can concoct a scenario of statistics values, aided by init

Re: Metalink: Pwd Problems?

I'm in. Are you sure that your support contract has not expired? On 11/06/2003 10:04:25 AM, Satav, Pawan wrote: Same here. Regards Pawan -Original Message- Sent: Thursday, November 06, 2003 8:20 PM To: Multiple recipients of list ORACLE-L Walked in to major problems this

RE: This is just wrong

Erm, a fourth option can ride on top of any of those is my beloved (albeit DEAD) Amiga: http://www.freiburg.linux.de/~uae/ It runs on Intel, Alpha, PPC, and ARM with Linux, Unix, BeOS, MacOS, Windohs, DOS, Acorn, etc. Hell, they even have a version of the Amiga emulator for, well, the

RE: Re[2]: How do you genrate primary keys?

What about doing it in one step? Declare lCounter int; Begin UPDATE counter_table SET counter := counter+1 WHERE counter_name = 'table name' RETURNING counter INTO lCounter; End; / Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Jonathan Gennick Sent: Thursday, November 06,

Re: Bitmap join indexes

Probably meaning that they are not available in standard edition and upgrade to EE is a lot of dinneros. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 06, 2003 3:54 PM I am running EE. In what sense are they

RE: [slightly OT[ infiniband

250MB/s up to 2GB/s transfers? Beats GigEth handily! What kind of bus for the HBAs do you need to be able to take advantage of these speeds? And what kind of a 10g Grid would you need to make this feasible over GigEth? Where's SLAC Ian? He'd probably have a need for this kind of stuff...

RE: Metalink: Pwd Problems?

Our disaster recovery doc says to call (800)223-1711 Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Barbara Baker [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06,

Re: query taking a long time to run via sqlnet

I have included the following in my sqlnet.ora trace_file_client = osstrace_timestamp_client = truetrace_level_client = 16 Am no expert on interpreting the trace file and Oracle are not being very helpful at the moment. "M.Godlewski" [EMAIL PROTECTED] wrote: Zabair, Have you tried trace?

Re: Metalink: Pwd Problems?

I'm in. Are you sure that your support contract has not expired? On 11/06/2003 10:04:25 AM, Satav, Pawan wrote: Same here. Regards Pawan -Original Message- Sent: Thursday, November 06, 2003 8:20 PM To: Multiple recipients of list ORACLE-L Walked in to major problems this

RE: Point-In-Time recovery question, Non-RMAN solution

How was the timestamp derived prior to logminer as Point-In-Time recovery has been around a long time? Thanks Rick Scott Canaan

RE: Point-In-Time recovery question, Non-RMAN solution

Rick, In a perfect world, we would be tracking major changes to the database (even updates) by time. In your case, you are stuck with taking a WAG, or more better, and educated WAG. You said that you think you dropped the table at about 1700. You can choose a point-in-time recovery to be 1630,

RE: How do you genrate primary keys?

Bambi - Actually, the government is moving to enforcement of the use of SSAN for miscellaneous purposes. We've had to quit sending SSAN to health insurance companies. I believe this is the new HIPPA law. Just another reason to not use SSAN as a primary key. Dennis Williams DBA Lifetouch, Inc.

RE: Point-In-Time recovery question, Non-RMAN solution

Rick - Being very conservative with the time you select ;-) Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 06, 2003 9:44 AM To: Multiple recipients of list ORACLE-L How was the timestamp derived prior to logminer as Point-In-Time

RE: Point-In-Time recovery question, Non-RMAN solution

You guessed and hoped you were close enough. If you were wrong, you repeated the exercise until you found the point in time before the drop I'm not sure logminer will show you the drop table in any case. At least not explicitly as drop table is NOT a logged operation. You might see the effect of

RE: Re[2]: ORDER -- was Re[2]: Sequences in OPS/RAC

How about removing any holes via some sort of batch process, ie: Insert into staging tables using any old sequence, don't worry about gaps. Then, periodically upload this to the main tables using either a sequence or a local pl/sql counter. I can think of a number of variations on this theme.

Datatype conversion

Hallo, I have a table, A: IMPEXCEL_EANNR which contains the field IMP_PRIS(= price) It looks like this: 12 1,50 11 This is a varchar2 field in this table. I want that field values to be inserted(or rather update the other table ) in other table called VARUKORGEANREL, but field in which

Re: query taking a long time to run via sqlnet

Zabair, Have you tried trace? Did you check trace route to see how many hops it makes to the database server?Zabair Ahmed [EMAIL PROTECTED] wrote: I've got the follwing piece of code which takes almost 3 seconds to run when I execute it on the server itself using sqlplus. DECLARE p_xml_in

Re: Re: RE: Index behavior

Hi Wolfgang Thanks for your valuable information. But still I could not understand how the cardinality will be calculated in EXPLAIN PLAN? In my query (1)AB% returns (220 rows selected) but (card=2) (2)ABC% returns (207 rows selected) but (card=12607 ) Could someone please explain to me?

RE: RE: Index behavior

OK, I can follow that, but why the change between ABC% and AB% ? Henry -Original Message- Wolfgang Breitling Sent: Thursday, November 06, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Actually, it has nothing to do with any of the table or index statistics. OK, almost nothing.

Re: Re[3]: How do you generate primary keys?

The only reliable solution in this case is to serialize which of course means forget about scaling. On Thu, 2003-11-06 at 09:14, Jonathan Gennick wrote: Wednesday, November 5, 2003, 1:14:26 PM, Jamadagni, Rajendra ([EMAIL PROTECTED]) wrote: JR hypothetically, When you have a requirement that

RE: XDB XLMSCHEMA

Hi, I do not have a tool for what you want. But I did experiment with XDB during the Summer of 2002. There is a XML IDE called XML Spy that integrates with Oracle XDB (http://www.altova.com/) and I suggest that you go to the XDB forum on Technet to ask your questions, I do not think that

RE: datamodelling question: updating foreign keys

Yes. There is a better way to model that. Oh, you wanted a suggestion. How about including a LOADS table that has (at least) 3 colums truck_id cargo_id active_flag That way when cargo is moved to a different truck you add a new record to the LOADS table and update the

RE: Point-In-Time recovery question, Non-RMAN solution

Rick You are getting some good replies on your problem. Since you say that you are recovering the table from two days ago, I'm assuming you are recovering to a test server. On the precision of the recovery time, a lot depends on just how much precision you need. As Scott says, you can use

RE: RE: Index behavior

I don't know. I'm just reporting what I found. It was new to me too. At 09:39 AM 11/6/2003, you wrote: OK, I can follow that, but why the change between ABC% and AB% ? Henry Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the

RE: datamodelling question: updating foreign keys

Title: RE: datamodelling question: updating foreign keys Ryan, You'll probably like my solution less, but it worked for me. You don't have a parent-child relationship as a Truck can have more than one Cargo and Cargo can be loaded on more than one Truck. Rather you have a many to many

Re: datamodelling question: updating foreign keys

I don't know if this is a better model at all. In fact, all this accomplishes is leaving behind tons of useless records. I'd only recommend this model if (for any reason) the trail of the truck history for this cargo. This way of marking records also leaves you open for the obvious future

Re: Metalink: Pwd Problems?

Call (800) 223-1711, open a new TAR, enter your CSI, mention [EXPLETIVE DELETED] Metalink and a bunch of [EXPLETIVE DELETED] idiots who seem to be unable to maintain so important resource. Also ask to talk to the [EXPLETIVE DELETED] on duty manager. Depending on your tone of voice, the quality of

Re: datamodelling question: updating foreign keys

Well , How about cargo as table with primary key say cargo_id which unqiely identifies cargo and weight . Now you should have a cargo detail table that will have cargo_id , load , truck_id . So Cargo - cargo_id total_load date blah blah cargo_detail - cargo_id

Re: ** SQL WHERE clause order

Wolfgang, I think you understand by now : I want a certain predicate evaluated first because it has a program variable :select_sen_emp_chk_firstand I want it checked before going to the check dept or salary since that will need a table access. Thank You.Wolfgang Breitling [EMAIL PROTECTED] wrote:

RE: Metalink: Pwd Problems?

I think it had nothing to do with support contract ... this morning it looks like (from reports so far) there was probably a hiccup at metablink ... I experienced the same, but was back in, in about 10 seconds. Raj

Re: Wow, Man, Flashbacks!

Bambi, Are you using automatic undo management or manual? I think that flashback can only be used with auto. Stephen [EMAIL PROTECTED] 11/06/03 10:04AM Hi Folks! I got waylaid(?) when I got in this morning and these user dudes were talking about using flashbacks, and I was like Woah! Dudes!

Re: Wow, Man, Flashbacks!

Hi Bambi, I hate to sound repetitive, but, it depends. :-) It depends on how far you want to flash back to. One of my clients was being audited last year by their parent company. I put in a retention period of about a week at a time. Without divulging much from my confidentiality agreement

Re: datamodelling question: updating foreign keys

Have a table SHIPMENTS. When a CARGO moves to another TRUCK it becomes a new SHIPMENT. SHIPMENTS has foreign keys to TRUCKS and CARGOES.

RE: Re[2]: How do you genrate primary keys?

The implementations I've seen all did SELECT...FOR UPDATE. Works. Doesn't scale. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit

Re: Wow, Man, Flashbacks!

Yes, this is correct. Rollback segments cannot be used. --- Stephen Andert [EMAIL PROTECTED] wrote: Bambi, Are you using automatic undo management or manual? I think that flashback can only be used with auto. Stephen [EMAIL PROTECTED] 11/06/03 10:04AM Hi Folks! I got

Re: Datatype conversion

Hi , instr(pbk.impexcel_eannr.IMP_PRIS,',') returns a zero when ',' does not exist in the field. And that gives wrong result. You do not need to do anything if there is no ','. So youwant set PRIS to : decode(instr(pbk.impexcel_eannr.IMP_PRIS,','),0,pbk.impexcel_eannr.IMP_PRIS,

Re: Metalink: Pwd Problems?

Well how about calling (900) HOT-BCKP? That would be a good 900 number to establish.? On 11/06/2003 10:29:33 AM, Jesse, Rich wrote: Our disaster recovery doc says to call (800)223-1711 Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED]

Re: Re: datamodelling question: updating foreign keys

i like that. you then have a table that lists 'available trucks' and you have a key constraint from the cargo_detail to the truck table. you can also archive when changes happen for history data. I like that one. From: AK [EMAIL PROTECTED] Date: 2003/11/06 Thu PM 12:19:26 EST To: Multiple

Re: ** SQL WHERE clause order

Then put it in procedural logic instead of into the SQL. SQL is a set (or more precisely bag) oriented language. You describe the set by its attributes, NOT by the steps to create it. At 10:24 AM 11/6/2003, you wrote: Wolfgang, I think you understand by now : I want a certain predicate

Re: datamodelling question: updating foreign keys

Seems to me that the proper solution is to create a new record, and use a status indicator to determine where the cargo is currently. Updating the FK causes you to lose any history of where the cargo has been. ie. no cargo tracking possible. This is my off the cuff, didn't spend a great deal

Re: any problem rebuilding indexes used for replication

I'm curious, how have you identified the fragmentation? What benefits do you expect from the rebuild of the indexes? Are you targeting certain indexes that have been identified as benefiting from a rebuild, or just planning to rebuild all indexes? Jared renu r [EMAIL PROTECTED] Sent

RE: datamodelling question: updating foreign keys

Yes, that's what I (hope) I would have thought of with a couple more minutes deliberation. An associative or 'bridging' entity. *sigh* don't get to do real DM anymore, or at least, rarely. Jared Whittle Jerome Contr NCI [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/06/2003 09:04 AM

Re: ** SQL WHERE clause order

BAG OK, is there a bag of all bags? On 11/06/2003 01:19:25 PM, Wolfgang Breitling wrote: Then put it in procedural logic instead of into the SQL. SQL is a set (or more precisely bag) oriented language. You describe the set by its attributes, NOT by the steps to create it. At 10:24 AM

RE: Metalink: Pwd Problems?

When I called them and asked about how they'd propose to keep our system up, they replied with a host of colloquialisms I thought to be most unprofessional. And I've never heard of a support line that charges by the minute. Interesting music on hold however. Sort of a 1970's guitar twang.

RE: This is just wrong

Title: Message Who really wants to run the server software on a Tier 3 platform, anyways? Apple is not only a Tier 3 platform: http://www.apple.com/uk/xserve/ http://www.macdevcenter.com/pub/a/mac/2003/10/29/osxcon_g5cluster.html Personally I made the switch to a PowerBook 16 months ago.

Re: Wow, Man, Flashbacks!

Actually, flashback is available regardless of the undo management configuration. Flashback requires use of the smon_scn_time table, which is populated with an scn - time relationship every five minutes the instance is up. The table is restricted to a certain size (14400 entries IIRC) by the

Re: ** SQL WHERE clause order

Of course there is. The difference between sets and bags is that sets do not allow duplicates. At 11:29 AM 11/6/2003, you wrote: BAG OK, is there a bag of all bags? On 11/06/2003 01:19:25 PM, Wolfgang Breitling wrote: Then put it in procedural logic instead of into the SQL. SQL is a set

Re: oracle events...

It appears that you are using AQ, as that is what 'unread message' waits are for. Apparently also DBMS_PIPE, as per the 'pipe put'. I don't know if AQ makes any use of DBMS_PIPE. The numbers provided aren't enough to tell if this might be a problem. Your database has spent almost 2 hours

partitioning in an NAS or SAN environment

most of the oracle docs state that when you partition a table you will get the most performance benefits by splitting the datafiles for each partition onto seperate storage devices. Im on an NAS and all I see are logical mount points. What are your recommendations for this? -- Please see

Oracle 11i post installation failed in DSC JSP check

Hi, In my home pc (windows 2000 server(SP2), P4, 768MB RAM, Network), i'm tring to install oracle 11i applications (11.5.5). In post installation check failed in DSC check and JSP check. What could be the problem. Basically i want to know whether i can install oracle11i in a standalone PC, if

Re: Wow, Man, Flashbacks!

There are several errors in this article. 1) AUM is not a requirement for Flashback Query (FBQ) 2) UNDO_RETENTION is not the max age for an FBQ, it is a guideline for how long to retain undo before reusing blocks (note...this is NOT a guarantee). Max age for an FBQ is coverned by the entries in

(un)intelligent agent

Ok i'm getting pushback from unix SA about it being SUID root. Does anyone use it for purposes of dataguard monitoring(via OEM) and not to run jobs, etc? thanks, joe -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the

SQL Navigator

Title: SQL Navigator Anyone ever been able to install the SQLab Expert Tuning server side objects (primarily the quest_sl_user_manager)? April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of

Re: Wow, Man, Flashbacks!

Just spoke with someone off the list. Let me clarify something. It is recommended that rollback segments not be used. But I didn't actually try to use them, so I'm not sure. I used the recommended AUM. --- Melanie Caffrey [EMAIL PROTECTED] wrote: Yes, this is correct. Rollback segments

Re: Re[2]: How do you genrate primary keys?

Well, if the commit is not too frequent, one natural way of generating primary key would be select max(last_change#) from v$datafile; These numbers are guaranteed to be unique. As DBWR wakes up every 3 seconds, the intervals between commit should be at least 3 seconds. As you're very well aware,

OT - Re: Bitmap join indexes

YES, for once Mladen got caught flat-footed. ;-) Even I got this one. At 06:54 AM 11/6/2003, you wrote: I am running EE. In what sense are they expensive? On 11/05/2003 04:54:25 PM, Paul Drake wrote: Mladen, If you are not currently running Enterprise Edition, they are indeed very expensive

Re: Point-In-Time recovery question, Non-RMAN solution

you kinda/sorta had to know when it happened and hope for the best. joe [EMAIL PROTECTED] wrote: How was the timestamp derived prior to logminer as Point-In-Time recovery has been around a long time? Thanks Rick

Re: partitioning in an NAS or SAN environment

To paraphrase Pythia, an early leader on the DSS market, my advice would be Partition not create monolythic. Partitioning is done for performance reasons, that much is clear. To really answer your question in any other way then speaking quixotically on laurel (SQL for short), I'd need to know

Re: Point-In-Time recovery question, Non-RMAN solution

although it is logged in 9i. joe Rachel Carmichael wrote: You guessed and hoped you were close enough. If you were wrong, you repeated the exercise until you found the point in time before the drop I'm not sure logminer will show you the drop table in any case. At least not explicitly as drop

RE: Metalink: Pwd Problems?

Title: RE: Metalink: Pwd Problems? That's what I did. By the time I proved out that all of us here were having the same trouble, called into support, and had sat on hold for 15 min, the trouble with the userid and password had cleared itself up. April Wells Oracle DBA/Oracle Apps DBA

Re: Re[2]: How do you genrate primary keys?

Jonathan Gennick [EMAIL PROTECTED] wrote: My concurrency issues probably boil down to the locking business. Purrcisely. because they would both issue the SELECT before either one got around to the UPDATE. I couldn't screw things up There you go. You are supposed to LOCK the row on the

RE: RE: Index behavior

The threshold has to be somewhere, and you found it. Try building your own histogram on the data if you really want to dig into it, it may become obvious. That's not an *oracle* histogram, but a curious DBA histgram that may help you understand why the threshold is there. Think excel

Re: partitioning in an NAS or SAN environment

At the site of one of my customers, in a not too big (100GB) database environment, using NAS over NFS on RS/6000 with AIX gave us far from enough throughput. It turned out that much more mountpoints (20 i.s.o. 2) were necessary to get a more-or-less satisfactory throughput. At 10:54 6-11-03

RE: How do you genrate primary keys?

What I mean't was, and maybe this is different in different countries, if we have an employee who leaves us, realizes just what a nice guy I was to work with :(, and returns then one of two things will happen. If they return in a different tax year, they get the same empno, but for a different

SQL*Plus errors... how to hide?

List, I have a shell script that executes a sql*plus script (which executes a procedure) based on user input. But what if the user inputs an invalid datatype? The exception section handles the error and displays a user-friendly message but I still get an error stack. I want to hide this from

RE: ** SQL WHERE clause order

Mladen Gogala scribbled on the wall in glitter crayon: BAG OK, is there a bag of all bags? is that anything like a boss of all bosses?;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED]

RE: How do you genrate primary keys?

This discusson seems to converge with the update-forigin-key topic. load - shipment - truck vs employee - employment - company. DBA!ert, Independent Oracle Consultancy Kastanjelaan 61C 2743 BX Waddinxveen The Netherlands tel.+31 (0) 182 640 428 fax +31 (0) 182 640 429 mobile +31 (0)

  1   2   >