SQL Reports

hi, When I generate SQL report in Unix OS, while printing it skips a page each time. How can i overcome that. Thanx, Sudhakar ___ Odomos - the only mosquito protection outside 4 walls - Click here to know more!

Re: Inband and Outband Net8 question

Inband breaks are (were) not supported by all protocols and not all implementations of the same protocol on each platform (especially in the early days of SQL*Net). It was clear to the developers that OBB was the most optimal way of implementing break handling but not every platform did

RE: Inband and Outband Net8 question

Hi, Or may be because IBB is in the queue, that why it seems like not working. Just my speculation Sinardy -Original Message- Sent: 18 March 2003 17:09 To: Multiple recipients of list ORACLE-L Inband breaks are (were) not supported by all protocols and not all implementations of

RE: how to get metalink user name ??

Scott, 1. Contact the Oracle Sales rep. that sold Oracle product to the company. Usually, he would have the details on whether there is a free support available (generally during the first three months). Also, he could coordinate with Oracle support to get a CSI #. 2. If the sales rep says you

RE: ORacle Applications mailing list

I find these lists pretty useful [EMAIL PROTECTED] (For Apps DBA) [EMAIL PROTECTED] (Covers functional aspects) Regards Naveen -Original Message- Sent: Tuesday, March 18, 2003 12:34 PM To: Multiple recipients of list ORACLE-L Hi all, Can any one tell about the Oracle

Usage of mySQL in enterprise environments

I've been asked to consider whether we can use mySQL for non-critical, but probably, enterprise-wide databases [e.g. information stores]. How good is the feedback on mySQL handling Queries, Transactions, ConcurrentUserCounts and DatabaseSize ? Hemant K Chitale http://hkchital.tripod.com --

Re: ORacle Applications mailing list

Thanks - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 4:03 PM I find these lists pretty useful [EMAIL PROTECTED] (For Apps DBA) [EMAIL PROTECTED] (Covers functional aspects) Regards Naveen -Original Message-

Re: From Microsoft Access to Oracle

The easiest way is to ODBC link the tables and develop like it is an MS Access project. This is not the best way due to security and a host of other issues. I have seenusing ADO oo4o through VBA to make the connection. This seems to work ok, but does require alittle more coding then the

Re: optimizer_mode=FIRST_ROWS

Which version of Oracle is this ? The views have changed over time, and I can't spot why your first query needs a join to dba_tables - all the relevant columns seem to exist in dba_tab_columns in my version of 8.1 As a general rule, when there is no obvious quick and clean way of joining catalog

RE: ORacle Applications mailing list

How about list for IDS (forms, reports, ???0? Thanks. --- Naveen Nahata [EMAIL PROTECTED] wrote: I find these lists pretty useful [EMAIL PROTECTED] (For Apps DBA) [EMAIL PROTECTED] (Covers functional aspects) Regards Naveen -Original Message- Sent: Tuesday, March 18,

RE: From Microsoft Access to Oracle

Santosh - Hopefully someone with more Access experience will reply, but from what I understand you want to create the Oracle table first. Access can create Oracle tables but it tends to use goofy data types. Then Access can connect to that table. Dennis Williams DBA, 40%OCP, 100% DBA

Re: insert stmt disk reads

Let's follow the transaction and see what happens. I am sure there are some errors and omissions, so please take with a grain of salt and add other steps/clarifications. 1) Object resolution. If the object definition does not already exist in the dictionary cache, it must be read from the data

RE: Usage of mySQL in enterprise environments

Hemant - We have been using mySQL for some applications. It seems to work well for some situations, especially mostly queries. It might work well for your information stores. Can you start on mySQL but plan on switching to Oracle as a contingency. Since mySQL is free, you wouldn't be out a lot of

AW: From Microsoft Access to Oracle

Hi We extensively used OO4O with Access 2000. It works fine, gives you all the Oracle specific stuff, but ... it's more work, since you have to code more things. I personally think it's worth it, eventhough I wouldn't go with Access in the first place. If it has to be VB, why not use VB

AW: Usage of mySQL in enterprise environments

Hi I think mySQL is ok, as long as you just use it to dump data into it (like firewall logs etc.) and run reports on the data using simple SQL. But mySQL really s$%cks when it comes to things like subselects, inline views, stored procedure (and I think the last time, a developer asked me

10046 Trace file waits

We are having some performance problems at a client. I ran a 10046 trace, level 8 on the DB for about 5 minutes of test operations. From the trace files generated I find someting of the following: SELECT Tm_trade_in_error.trade_id, Tm_trade_in_error.account_number, Tm_trade_in_error.aps_groupid,

RE: how to get metalink user name ??

I love this stuff! It used to be a part of quite a few error messages: Call your local Oracle customer support representative! -Original Message- Sent: Monday, March 17, 2003 11:24 PM To: Multiple recipients of list ORACLE-L Hello, my client has oracle v8.1.6 and v9.0.1. we need to

RE: migration

An ora 1452 error says there are duplicate keys, hence you can't create a unique key. If it is a known, death be unto me if I am wrong, 100% fact that the unique key was valid in the original data, the first question I would ask is: Was this an import that is being run with commit=y ignore=y,

RE: Inband and Outband Net8 question

Out of band breaks are pimarily used to cancel a query or transaction. In the new OCCI, out of band breaks corresponds to the cancel method in the ResultSet class or terminateStatement in the Connection class. I sort of hate this stuff. Those things used to be called ocan and obreak and OCCI

Re: AW: From Microsoft Access to Oracle

Santosh: Would this project require any type of reporting which is highly formatted? If not I would Stefan recommended and us VB6 (or VB.Net, if so use the MS Oracel Data Provider). This will give you all the functionality you will need. If basic reports are required you could always use the

Re: ORacle Applications mailing list

Rukmini this list is good: SUB ODTUG-WEBDEV-L and Sue Harper is active on this list. (If you don't know who Sue Harper is, find out. She's a wonderful technical resource.) Barb --- Rukmini Devi N [EMAIL PROTECTED] wrote: Hi all, Can any one tell about the Oracle

Re:Inband and Outband Net8 question

Sinardy, Wish my favorite network GURU was in today as he could really explain this, but regrettably he's on the road. Anyway, what their talking about is how you interrupt the server side process that your client is talking to. Here is an example/walk through: You start a SQL*Plus

re: ORA-27100: shared memory realm already exists - status

Thanks for all of the replies. I discovered that ipcs -mo will give me the number of current processes connected to the memory segment. The dead segments left by the instance which was giving me problems all had 0 in that column. The segment for the live instance had about 14 processes

Re: can't create database

Am Mon, 2003-03-17 um 18.32 schrieb Ray Stell: On Mon, Mar 17, 2003 at 07:03:43AM -0800, Joe Johnson wrote: Hi, This site has a good description of how to use the ipcs and ipcrm commands to clean up these left-over memory segments following the shutdown. I've found that using the

Re: optimizer_mode=FIRST_ROWS

The version is 8.1.6 and 8.1.7. The reason why the first query has dba_tables in it at all is that without it, columns that are no longer there keep showing up. In other words, there are columns in dba_tab_columns with no corresponding table row in dba_tables. The link to dba_tables was to

RE: 10046 Trace file waits

No, I don't think you're reading this wrong. May be you've had a network problem or a NIC acting up? -Original Message- Sent: Tuesday, March 18, 2003 9:09 AM To: Multiple recipients of list ORACLE-L We are having some performance problems at a client. I ran a 10046 trace, level 8 on the

RMAN framework scripts, etc

A bunch of you asked for it, its not quite done but the majority of the stuff should work just fine, they were originally written for 8i database but latest development has been on 9.2.0.3, although I've tried to NOT use any 9i specific stuff in them. yes they are free and you can use to your

9i - Which Patchset

Any opinions on which patchset of 9.2 is most stable: 9.2.0.1, 9.2.0.2, 9.2.0.3? We're running HP Tru64. Thanks! Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or

RE: Usage of mySQL in enterprise environments

Speaking of the amphibians, there is also a TOAD-like tool for MySQL. It's called tora (http://www.globecom.se/tora) and it's free on Linux. -Original Message- Sent: Tuesday, March 18, 2003 9:14 AM To: Multiple recipients of list ORACLE-L Hemant, MySql is akin to M$ Access. Use it

Re: AW: Problem with netasst dbastudio

per Doc ID: 225324.996 adding -nojit to edited netasst fixed this problem for me on 8.1.7.4 on rh7.1. Your milege will vary like a Saudi Utility Vehicle (SUV). $./jre -? (SUV)va(tm) Runtime Loader Version 1.1.8 Usage: jre [-options] classname [arguments] Options: -dprint

Re: ODBC access to Oracle db

Well..there's always the sneaky way Depending on which ODBC driver is in use, it will query data dictionary views so that the front-end tool (i.e. MS-Access, MS-Excel, etc) can display a list of objects. I recall that the Oracle-supplied ODBC drivers tend to start with ALL_OBJECTS while

Re: Inband and Outband Net8 question

The main difference between INB OOB breaks is that the Oracle kernel will get notified directly when OOB is received (a bit is set to indicate that an interrupt happened and the Oracle kernel will check this bit every now and then). With in band breaks the connections has to be tested (real

Amt of Training to be considered up to date

Title: RE: access to oracle $ tables in 9.2.0 I am fishing for a standard from an official source -- is there a set number of weeks per year of IT training one requires to "stay up to date" in our field? In IT in general? This is Canadian Income Tax phraseology, maybe the same thing exists

RE: 9i - Which Patchset

Given my experience here, stable and Tru64 don't go together. As to the patch number, Oracle support usually requires that you be at the latest patch level. -Original Message- Any opinions on which patchset of 9.2 is most stable: 9.2.0.1, 9.2.0.2, 9.2.0.3? We're running HP

How to calculate the working hours?

Hi, I haven't got too many response to my working hour question, probably because I sent it out late Friday night. Let me send that question again, really appreciate your help! -- We have open Time for every order, ef: Open Time -- 03/12/03

RE: 9i - Which Patchset

Title: RE: 9i - Which Patchset There are some serious security bugs that you have to either apply patches individually or use 9.2.0.3. Also, I can't help thinking that the older releases (for the most part) contain everything in the previous patchsets plus more fixes. Therefore, if I am going

RE: 9i - Which Patchset

9.2.03? I just see Oracle9i Release 2 (9.2.0.2) on Oracle's download page. Where do you get it? Am Die, 2003-03-18 um 17.03 schrieb [EMAIL PROTECTED]: 9.2.0.3 -Original Message- From: Jay Hostetter [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 9:59 AM To: Multiple

Re: 9i - Which Patchset

Jay, We are running 9.2.0.3 On Tru64. Downloaded and applied just three days ago (it came out in March 14th). Took care of two bugs I opened up with respect to subpartition splitting and moving the index subpartition to a separate tablespace. Although it's too early to pass a verdict; it seems

Re: Amt of Training to be considered up to date

Title: Re: Amt of Training to be considered up to date 52 I am not joking. I consider staying up-to-date a full time process, not just something you do a few weeks a year. Perusing this newsgroup IS one part of staying up-to-date. At 07:49 AM 3/18/2003 -0800, you wrote: I am fishing for

Re: 9i - Which Patchset

Stephan, I am wondering why would you not rate Tru64 as a stable platform. We are using it for all our OLTP and datawarehouse needs; and it has been quite stable. It's rather unfortunate that HP is retiring it in 3 years. Arup Nanda - Original Message - To: Multiple recipients of list

RE: 10046 Trace file waits

This is trace data from 9.2.0.2+ (you can tell because of the new STAT data). Therefore the timings are expressed in microseconds (0.01-second units). Technically, to answer your question, you have to know whether or not the application invokes the fetch immediately after the execute. It

RE: 9i - Which Patchset

I can only relate personal experience. Like the umpire says: I call 'em like I see 'em. The older, slower Alphas do fine. However, it has been my private, somewhat biased opinion that Compaq, lacking the advanced technical knowledge to push the platform further, resorted to something similar

RE: 9i - Which Patchset

Ah yes, but they've promised that all the Tru64 capabilities will be in HP-UX by then. And of course, we always believe vendors' promises, don't we? :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce

RE: Amt of Training to be considered up to date

Title: Re: Amt of Training to be considered "up to date" I understand from your response that your employee doesn't send you on any Oracle,UNIX or MScourses. Regards, Pat. -Original Message-From: Wolfgang Breitling [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 18, 2003 12:39

RE: How to calculate the working hours?

Andrea, Will the following work? table business_hours( system_date date, business_day_flag varchar2(1), -- Y/N to indicate a holiday start_hour varchar2(10), end_hour varchar2(10)) -- If Dec 31st is a working day but half-day, this column can help you with that This table will have an entry

Job Needed

Greetings! I hope Jared doesn't kick me off the list for this, but I was just layed off this morning and am now in the need of a job. I have over 10 years of experience with Oracle, mostly using SQL and PL/SQL as a developer, but the last 2 years have been as a development support DBA. I am

Re: Inband and Outband Net8 question

Nope, This will just cancel the current query *AFTER* a fetch. What you describe means that you need to run with non-blocking oci. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 3:44 PM Out of band breaks are

RE: Job Needed

I hear the job of Prime Minister in England will probably be open soon. Any political ambitions ? -Original Message- Sent: Tuesday, March 18, 2003 12:09 PM To: Multiple recipients of list ORACLE-L Greetings! I hope Jared doesn't kick me off the list for this, but I was just layed off

Veritas Software

Hi All, Anybody using Veritas Database Edition for Oracle on a Sun Cluster? Any comments or things to consider? I am being asked for opinions for our new Sun cluster (planning on failover capabilities). Any comments, good or bad, would be appreciated. thanks Tom Mercadante Oracle Certified

Re: Autoallocate (was Re: LMT monitoring)

Money, sex and power. No exceptions to my knowledge (read: so far in my life). Connor McDonald wrote: Stepping back into reality briefly: With great power comes great licensing fees, great amounts of advertising literature, great demands from superiors to reduce costs by migrating to SQL

Re: 9i - Which Patchset

I know that one is still wet behind the ears. I was debating whether or not to stay on 9.2.0.1 until 9.2.0.3 has been out there a few weeks. I'd hate to see them withdraw a patchset after I've applied it (like 8.1.6.3 or 8.1.7.2.0). Thanks for the replies. Jay [EMAIL PROTECTED] 03/18/03

Re: ORA-27100: shared memory realm already exists - status

How did Oracle know that the shared memory realm already exists? Oracle knows this because it attaches to a segment based on the hash value of $ORACLE_HOME and $ORACLE_SID. In that segment the $ORACLE_HOME and $ORACLE_SID are stored, so that oracle can see to which instance they belong. Anjo.

OT: 11i Autoupgrade and IPC protocol

Has anyone successfully run Autoupgrade with IPC? We've been completed upgrading test cases of our HR Application (11.5.7, 8.0.6/8.1.7, HPUX 11.0) successfully until this last test where I configured the workers to use the IPC protocol. Autoupgrade runs for several hours okay and then bombs

RE: Amt of Training to be considered up to date

Title: Re: Amt of Training to be considered "up to date" Hi Patrice I've never seen an official number of weeks for training in Canada. I know that Oracle Canada is providing 4 weeks to their consultants. You can have more if you're in sales ... For sure, going to training is fun but I

RE: Job Needed

Where can I apply for being a Khalif of Bagdad? There is going to be a vacancy fairly soon. -Original Message- Sent: Tuesday, March 18, 2003 1:44 PM To: Multiple recipients of list ORACLE-L I hear the job of Prime Minister in England will probably be open soon. Any political ambitions

RE: 9i - Which Patchset

That means that it's going to achieve the ultimate stability in 3 years? The same stability that was achieved by VMS and RSX? -Original Message- Sent: Tuesday, March 18, 2003 11:49 AM To: Multiple recipients of list ORACLE-L Stephan, I am wondering why would you not rate Tru64 as a

RE: Job Needed

He's down Jared quick kick him! Kick Him! Seriously Kevin I wish you the best of luck in your job search. Hope it all works out. Alec -Original Message- Toepke Sent: Tuesday, March 18, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Greetings! I hope Jared doesn't kick me off

RE: Amt of Training to be considered up to date

Title: Re: Amt of Training to be considered "up to date" That should read: "employer" not "employee" Pat. -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 18, 2003 1:45 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Amt of

ERWIN vs Designer

I have been tasked with the responsibility of reverse engineering over 2500 small Access databases to get a picture of all the information that our users are capturing (schemas, data models etc) to see if we can incorporate their requirements into our production systems and stop them from creating

RE: Amt of Training to be considered up to date

Patrice, You actually get your employer to send you to training?? Lucky you.. If you consider the amount of training that Oracle offers when a new release of the database occurs I would think that you can get a solid idea of the training needed to be up-to-date. Add into that the OCP training

Re: SQL Reports

When I generate SQL report in Unix OS, while printing it skips a page each time. How can i overcome that. Don't print it. But seriously, some more details are needed for anyone to help. Reply to the list, not me. I know nearly nothing about SQL Reports, and I like it that way. Jared

RE: ERWIN vs Designer

Title: RE: ERWIN vs Designer Assuming you can't just use the Access Relationships editor to do this (if all you're doing is drawing the diagrams, I'd use the diagram that's already there), ERWin has a much easier learning curve. It's bloated, but it works. -Original Message- From:

memory for 9i

I am going to start some experiments soon but any prior input from the field will be helpful. In order to set up a test 9i RDBMS/9i ifs/ 9iAS environment on Solaris Sparc hardware, how much RAM is the minimum required? Oracle docs apparently suggest 1 GB. I suspect Java will be the killer here,

RE: ORA-27100: shared memory realm already exists - status

Well Anjo, what sort of hash? I've been working to develop the stuff that Hailey talked about(direct SGA access) at Hotsos seminar but the best I've come up with so far has me sorting through all the shared memory segements seeing which one I can attach to. This is not good. I can get the id's

RE: 9i - Which Patchset

Please note that there is still a bug for null wait event with 9.2.0.3.0. Oracle promised that it will be fixed with 9.2.0.3.0 but it has not. The bad news is that it has no ETA for it. Hopefully it will be fixed with 10i or 11i. Without fixing this bug, it is very hard to identify the

Unix tip for oracle

Working on an wrapper for Oracle functionality. Any of the Unix guru's know if you can highlight or set text blinking in the korn shell in unix? Brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Spears, Brian INET: [EMAIL PROTECTED] Fat City Network Services

Re: ORA-27100: shared memory realm already exists - status

I found the hash function, but that is only one bit. The next problem is to find the segments. Come to Copenhagen in October and you will see ;-) Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 11:18 PM Well Anjo,

RE: Amt of Training to be considered up to date

Patrice Ron just gave me an idea that might provide the answer you need. Oracle tries to have a major release every 18 months. Estimate the amount of training you would need to become proficient in the new release, then spread that over 18 months. Just an idea. Dennis Williams DBA, 40%OCP,

Re: Unix tip for oracle

You might want to read up on tput. Jared Spears, Brian [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/18/2003 02:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Unix tip for oracle Working

Re: Unix tip for oracle

I'm no unix guru; but I know this. Place the text to be highlighted inside the strings ^[[7m and ^[[0m. the ^[ character is typed by a Control-V followed by a Control-[. for instance place the text to be highligted Oracle as ^[[7mOracle^[[0m HTH. Arup - Original Message - To: Multiple

RE: Oracle in the news

ODTUG is not Oracle. It's an independent user group. But you'd still think Oracle would give them a sweet deal. :-) Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 1:41 PM To: Multiple recipients of list ORACLE-L Subject: Re:

RE: Unix tip for oracle

-Original Message- Sent: Tuesday, March 18, 2003 4:34 PM To: Multiple recipients of list ORACLE-L Working on an wrapper for Oracle functionality. Any of the Unix guru's know if you can highlight or set text blinking in the korn shell in unix? Brian - It'd be an abomination!

error configuration database oracle 9.2.0 on Redhat

hi all,I need your help, I have a problem while configuration database progress.while progress until 46% I got a error message like this :"ORA-12705: invalid or unknown NLS parameter value specified"after that I can continue the configuration.could anybodyhelp me?Thank youRegards,pomin

Re: Unix tip for oracle

To setup your environment add the following to your .profile or script.ksh export BELL=`tput bel 2/dev/null` export BOLD=`tput bold 2/dev/null` export BLINK=`tput blink 2/dev/null` export PLAIN=`tput sgr0 2/dev/null` export UNDERLINE_ON=`tput smul 2/dev/null`

RE: How to calculate the working hours?

Title: RE: How to calculate the working hours? see answer below -Original Message- From: Andrea Oracle [mailto:[EMAIL PROTECTED]] We have open Time for every order, ef: Open Time -- 03/12/03 11:08:07 How to calculate the working hours (8am - 5pm, no

Fixed Assets maybe?

My Financials person is out, what might the following imply? "I am currently working on a new tax book to the current Oracle fixed assets and I would like to copy the data from production to the test environment. I would like to add some major changes to these assets in the test region

Oracle Expert Fails

Hi all, I noticed an interesting error, I tried to use Oracle Expert in order to tune my database but it won't go further after noticing some temporary tables, and actually Expert asked to delete those objects. Is that normal behaviour or a bug. Rgds, JoshuaGå före i kön och få din sajt värderad

RE: From Microsoft Access to Oracle

Thanks to all who replied... santosh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Stefan JahnkeSent: Tuesday, March 18, 2003 6:54 PMTo: Multiple recipients of list ORACLE-LSubject: AW: From Microsoft Access to Oracle Hi We

RE: AW: From Microsoft Access to Oracle

i just need to create a data capture program...which does not require any validation...just like forms..and the data i need to put in oracle table... santosh -Original Message- Sent: Tuesday, March 18, 2003 8:09 PM To: Multiple recipients of list ORACLE-L Santosh: Would this project

Re: Thanx: how to get metalink user name

Thanx guys. my next call is to Oracle Customer Support. _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plusref=lmtplus -- Please see the official ORACLE-L FAQ:

Re: Thanx: how to get metalink user name

Thanx guys. my next call is to Oracle Customer Support. _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plusref=lmtplus -- Please see the official ORACLE-L FAQ: