Re: Replicating a user across DBs

Hi Jesse In 8.1.7, is there a way to easily replicate a user from one DB (e.g. development) to another (e.g. production)? I can export all the objects in the schema, but export/import won't recreate the schema in the import DB. I've been using OEM to create a script (reverse engineered

Re: order by in subquery workaround

Hi I have in the past seen a download for a backported statspack on I believe OTN. This would work on Oracle 8.0.5 Maybe still there Jack

RE: Function based indexes

Hi, I've seen oracle application 11i(11.5.3) setting one parameter _OR_EXPAND_NVL_PREDICATE for queries using nvl(:bind_var, col_name) syntax. Have a look at this parameter on metalink. It is published hidden parameter. It may help you. Regards, Sandeep. -Original Message- Sent:

RE: Why DDL is not allowed in PL/SQL

Yes, But why then we can issue DLL in PL/SQL using DBMS_SQL package. -Original Message- From: Alroy Mascranghe [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 12:33 PM To: Multiple recipients of list ORACLE-L Subject:RE: Why DDL is not allowed in PL/SQL Maybe it

Re: PL/Sql Error Handling Package

I sent such code some 2-3 months ago to this list, cannot find it quickly now. That used autonomous transactions and stored errors in a table. I'm not posting much, therefore You may search in archives using my name ... Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga

RE: larry want to take over your e-mai

I'm currently doing CBTs at my desk as we speak. We have a consultant in at the moment getting things moving, in a months time we will be doing skills transfers from him but I am stealing a march on that. I have DB2 installed on my PC here in the office and will be starting on the lab exercises

RE: killing sessions

I had a similar problem a while ago now and the users in question could see their session from toad but didn't have permissions to kill them. This is what I did (see procedure below). It allows a user to kill a session of theirs but not the current one. Here is the code. All the user needs to

RE: More on the OCP priceing

Utter bollocks. All that means is it will be cash rich companies (or well to do individuals) who can afford to put their employees/themselves through this training. I was attempting to persuade (unsuccessfully) my company to put me through the certification process before all of this. I am

Re: Help me tuning the log file sync wait event

Hi , You encounter log file sync and log file parallel write events . This can be because of a slow device on which redo log files are on . OR your redo log sizing is bad. Bunyamin Karadeniz Oracle DBA Havelsan A.S. Eskisehir yolu 7.km Ankara / Turkey Tel : +90 535 3357729 - Original

Re: Help me tuning the log file sync wait event

Some suggestions a) Check your commit frequency - if you're committing like mad then this is a great way to over stress redo logging operations. b) Check the size of the average redo write. If they're small, you might get some benefit by allocation write cache in the T3 to the redo logs (if

Re: connect as internal

Hello Kavi Connect system/manager as sysdba, do: select user from dual. reply: SYS Your system user become sys when connect as sysdba. The default schema is also sys so be careful when creating objects while connected as sysdba. Yechiel Adar Mehish - Original Message - To: Multiple

Re: 1 Volume of Software RAID 1+0 versus Multiple Volumes of Software Raid 1 ?

I would go with the second option. Better yet, get also three controllers, one for each logical drive. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 3:43 PM Raid 1 ? For performance , Which Option is

Re: larry want to take over your e-mai

It is Friday here already. You do not need 5000 named users license. They will license for all the e-mail address that CAN send you mail. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 7:18 PM THAT DOES

RE: PL/Sql Error Handling Package

Thanks! -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 5:34 PM To: Multiple recipients of list ORACLE-L Subject: Re:PL/Sql Error Handling Package Hanah, This is one procedure out of an entire

Fwd: [Builder.com] Create an SPFILE in 9i

List, Just by coincidence this came in the mail today. Ron ROR mª¿ªm Oracle Tips at Builder.com Online#[EMAIL PROTECTED] 07/12/02 03:05AM Builder http://builder.com.com Presents your ORACLE E-NEWSLETTER for July 12, 2002 ---Advertisement--- THE DATA STORAGE INFO

RE: listener configuration on HP serviceguard clusters

Title: RE: listener configuration on HP serviceguard clusters Do you have a listener.ora file? Which ip address is in it? Matt Adams - GE Appliances - [EMAIL PROTECTED]Enter any 11 digit prime number to continue. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: Oracle 9.2 spfile catch 22

Just a FYI. You can use _any_ 9i instance to recreate the init.ora for the instance from a spfile. It does not need to be the instance that the spfile is for! -Original Message- Sent: Thursday, July 11, 2002 5:54 PM To: Multiple recipients of list ORACLE-L I was migrating a V7.3.4.5 to

Re: order by in subquery workaround

I downloaded it from metalink a while back. It was pretty straight forward to install. The report name was something different like statsrep.sql or statsrep80.sql. Also, there was a view that had to be created. All the information/instructions were in the tar file that I downloaded. If you

RE: Re[2]:killing sessions

Dick, Sooo, you created a little Napolean? :) -Original Message- Sent: Thursday, July 11, 2002 4:53 PM To: Multiple recipients of list ORACLE-L Well, without getting into specifics. We had an individual who had a problem with others in the department. Now you I know that many

RE: RE: larry want to take over your e-mai

I have mixed feelings about this - I think this is pervasive within the high-tech industry, and my gut feeling is that it may help explain why tech stocks are so low. Do you think they (the industry leaders) will get the message? I seriously doubt it. Right now the focus seems to be on cutting

Oracle Licensing to be Transparent?

Evidently Oracle is going to build some web pages to spell out licensing issues and definitions. Wonder how often that web site will need to be updated. And of course everything will be crystal clear when it's done. ;-) Check it out... http://www.eweek.com/article2/0,3959,361471,00.asp Not

Re: Buffer busy waits are 10.96% of non-idle waits

Hi, Your major problems with buffer busy waits are in the Data blocks class: (1), undo block(2), segment header (3) For Data block Class: Solution: 1. Reduce no of rows by changing pctfree/pctused 2. check when the last time your indexes were re-built and rebuild them often

Re: DOS Script for pop up question ?

Thanks for the Oracle list members who responded very promptly for my question. At the moment, I am very satisfied with pause command. I have one more question for the DOS Gurus. Is there a way to change the fond size from the DOS Script ? Thanks, Bob --- James J. Morrow [EMAIL PROTECTED]

RE: DOS Script for pop up question ?

I'm not a windows guy but I think you should quit writing DOS batch files and use VBScript instead. I think if you look in any windows magazine you will see VBScript listings instead of batch file listings. VBScript is powerful like Perl and handles pop up windows well. VBScript doesn't seem

RE: order by in subquery workaround

Rob and Jack: Found it. (165420.1) Thanks for your help. Barb -- From: Robert Pegram[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Friday, July 12, 2002 6:48 AM To: Multiple recipients of list ORACLE-L Subject: Re: order by in subquery

Triggers are getting disabled

We have a DW that gets refreshed each night. Many of the tables are truncated. Several times during the nightly processing dozens of triggers are becoming disabled. Can anyone tell me what causes a trigger to become disabled? Ron Smith -- Please see the official ORACLE-L FAQ:

RE: Buffer busy waits are 10.96% of non-idle waits

Fro my clarity .. What does the extent size has to do with segment header contention. And about index rebuilds.. Why do u say that this will cause a Problem for the waits he is Experencing. Hope to get some clarity on this... Thanks Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext

Re: Triggers are getting disabled

Triggers are disabled via ALTER TABLE...DISABLE TRIGGER... or ...DISABLE ALL TRIGGERS. It may well be that the refresh process issues such statements; reasons to do so might be to speed up the load process or if data populated by a trigger is already included in the data being loaded. If this

Re: Oracle Licensing to be Transparent?

Kimberly Floss, database administrator team leader at Quaker Oats Co., in Chicago, said she hopes the guide helps resolve Oracle's issues. Floss, who manages Oracle databases, has not had licensing problems herself ... She obviously has never been involved in any Oracle licensing discussions.

Re: order by in subquery workaround

For databases 8i you need to run statsrep80.sql Babu Jack van Zanen [EMAIL PROTECTED]@fatcity.com on 07/12/2002 02:53:21 AM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hi I have in the past seen

Re[2]: Oracle Licensing to be Transparent?

I leave licensing discussions to the company CIO Lawyers. Way too complicated for me. Reply Separator Author: Jay Hostetter [EMAIL PROTECTED] Date: 7/12/2002 8:23 AM Kimberly Floss, database administrator team leader at Quaker Oats Co., in

RE: RE: larry want to take over your e-mai

Patrice - I especially agree with your last statement don't believe there is a real solution to this. Remember a technology vendor has 3 constituents, all of whom think they are the most important: stockholders, employees, customers. I have noticed that previous slumps in technology sales

RE: Triggers are getting disabled

Do triggers fire when using direct load? -Original Message- Sent: Friday, July 12, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Triggers are disabled via ALTER TABLE...DISABLE TRIGGER... or ...DISABLE ALL TRIGGERS. It may well be that the refresh process issues such

My TAR button disappeared from MetaLink

I clicked on a URL link in an e-mail from Oracle support, and got an error message telling me I have no privs to view the document. I logged into Metalink, and noticed that there is no TAR section in the right pane, as I usually have. There also is no TAR button in the left pane, I remember

RE: Re[2]: Oracle Licensing to be Transparent?

License,,, license We don't need no stinkin license. -Original Message- Sent: Friday, July 12, 2002 11:59 AM To: Multiple recipients of list ORACLE-L I leave licensing discussions to the company CIO Lawyers. Way too complicated for me. Reply

Re: My TAR button disappeared from MetaLink

This usually happens if you have not paid your support bill. Srini Chavali Oracle DBA Cummins Inc Boivin, Patrice J [EMAIL PROTECTED]@fatcity.com on 07/12/2002 12:24:21 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL

RE: RE: larry want to take over your e-mai

Yes, but once you become dependent on the M$ keep the coffee cup full software, then they force you to upgrade at a significant cost and cause your blood pressure to soar with the new feature that refuses to fill your cup because your blood pressure has gotten too high (damn product liability

Oracle Trace Collection Services

I have a third party app that runs on Oracle 7.3.4 on Windoze. The app is getting some error and the vendor recommends that we uninstall the Oracle Trace Collection services from each client. If this is removed from the client will I lose my ability to run traces on a clients session?? Dave

RE: Why DDL is not allowed in PL/SQL

You can also use execute immediate in PL/SQL, depending on the version of Oracle you are running. RF Robert G. Freeman - Oracle8i OCP Oracle Database Architect CSX Midtier Database Administration Author: Oracle9i RMAN Backup and Recovery (NEW! Oracle Press - Due Oct 2002!!) Oracle9i New

Re: Buffer busy waits are 10.96% of non-idle waits

Hi Ganesh, First of all the problem here is Buffer busy waits When you have determined the Buffer busy waits is one of the top wait events causing problems then 1. You could query v$waitstat to see the breakdown of waits according to 'class' 2. You could query x$KCBFWAIT to find the

RE: Plagiarism?

Not many things in this life are certain, but I'll guarantee you one thing: if there's a script at Ixora with Steve Adams' name on it, then that script was written by Steve Adams. Yea, and Steve is such a nice guy I'm fairly certain all they would have to do is ask and he'd give them

RE: Oracle 9.2 spfile catch 22

I've created SPFiles withe 9.2 on NT with log_archive_start=TRUE and not had this problem. If you have log_archive_start=FALSE and you want to change your spfile, then use alter system log_archive_start=TRUE scope=spfile; Robert G. Freeman - Oracle8i OCP Oracle Database Architect CSX Midtier

RE: Where is Oracle 9.2 init.ora?

Oracle will use the spfile by default, only if there is one. If there isn't and there is an initsid.ora, Oracle will use it. In many cases, you can even start Oracle without an init file at all (for example in a disaster recovery and you want to recover your spfile from an RMAN control file

Re:RE: RE: larry want to take over your e-mai

Kevin, I don't think M$ cares about product liability. If they did Uncle Bill would not be so rich the lawyers would be camped out on his door step. Actually if you look at your license agreement with M$ you've already waived your rights there. Dick Goulet Reply

RE: What you've always wanted to know about Oracle DBAing

When will my Oracle stock go above 40 again? Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i  (Sybex) Clark Griswold: Eddie, 

RE: Where is Oracle 9.2 init.ora?

The creation of the spfile by the DBCA is optional, BTW, in 9iR1 and 9iR2. There is a checkbox where you can disable the use of the SPFILE. Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct

RE: Plagiarism?

It was obviously written by Steve, I just couldn't believe that the guy posting the script literally removed the copywriter, replaced Steve's name with his own then submitted it to a web site, which then went out in their newsletter. Pretty brash I thought and I wonder what could possibly be the

RE: Where is Oracle 9.2 init.ora?

Oracle created the SPFILE which is not humanly readable. Mine is pretty easy to read! Maybe you need to check your character set??? :-)) RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct

RE: Oracle 9i Release 2 RAC on Linux Cluster RH7.3

I know a certain 9i New Features book that could have helped you with that... :-)) Have a nice chapter on 9i and RAC. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New

RE: What you've always wanted to know about Oracle DBAing

How to keep track of everything related to Oracle. Where to find hardware to try new updates, software like the Applications Suite or this Collaboration Suite, whatever that is. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Friday,

RE: More on the OCP priceing

Am I missing something about the OCP program? The new required class is only required for the new 'Oracle Certified Master' Certification. You can still obtain OCP certification without taking any classes direct from Oracle, right? Steve McClure -- Please see the official ORACLE-L FAQ:

RE: Where is Oracle 9.2 init.ora?

It should NOT however, be edited! --- Freeman, Robert [EMAIL PROTECTED] wrote: Oracle created the SPFILE which is not humanly readable. Mine is pretty easy to read! Maybe you need to check your character set??? :-)) RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX

guid related ( repeat)

hi everybody , oracle provides guid function to generate unique ids . My question is should one use that guid for synthetic primary key .So you no longer need a sequence for generating unique values . Is it faster to do a search on number comapred to varchar2 if it is indexed . My just

RE: RMAN Restore problem

Hi Robert, Thanks for your note on the RMAN restore. I finally analyzed(compute statistics) the catalog schema and was able to restore within 10 mts instead of 6 hours. Ashoke -Original Message- Sent: Friday, July 12, 2002 2:13 PM To: Multiple recipients of list ORACLE-L If you are

Re: My TAR button disappeared from MetaLink

And your license is all paid up, yes? Boivin, Patrice J To: Multiple recipients of

RE: RE: larry want to take over your e-mai

The model for running a technology based company into the ground is to promote the Director (or VP) of Sales and Marketing to CEO. This sort of makes sense because it is sales and marketing that generates the revenue and all of these companies are in business to make money. The Sales and

Location of tnsnames.ora on client

On a Windows client installation, does anyone know what controls the location of tnsnames.ora? Is it some registry variable? We have a Windows install that can't seem to find its tnsnames.ora. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ:

RE: Oracle 9.2 spfile catch 22

SPFILE concept is good and it is required for reaching the goal of 'no dba required', but it is still far from being 'ready for prime time'. I really don't think the DBA will ever be eliminated. This kind of thing just gives us more time to spend on other aspects of the database. Just

RE: Plagiarism?

Some people lack a little thing called ethics. Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i  (Sybex) Clark Griswold: Eddie, 

RE: Plagiarism?

...what could possibly be the motivation... A) Stupidity B) Incompetence C) Clueless D) Certain students from Piper High School... E) A parent of one those Piper High School students... Please choose one, all or add your own... I was going to add F) A Manager... -Original Message-

RE: Where is Oracle 9.2 init.ora?

always someone to spoil the fun! -Original Message- Sent: Friday, July 12, 2002 4:18 PM To: Multiple recipients of list ORACLE-L It should NOT however, be edited! --- Freeman, Robert [EMAIL PROTECTED] wrote: Oracle created the SPFILE which is not humanly readable. Mine is

Re: Location of tnsnames.ora on client

%ORAHOME\Network\Admin Igor Neyman, OCP DBA [EMAIL PROTECTED] The degree of normality in a database is inversely proportional to that of its DBA. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 12, 2002 4:28 PM On a Windows

WHICH TABLE NEED TO INCREASE FREELISTS

Hi Is any way which tables need to increase more freelists? Thx -Seema _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema

Re: guid related ( repeat)

Just based on the length of the field, I'd prefer sequence generated unique values. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: BigP To: Multiple recipients of list ORACLE-L Sent: Friday, July 12, 2002 4:08 PM Subject: guid related ( repeat)

RE: RE: larry want to take over your e-mai

That's interesting, because I personally know of two people with sales backgrounds that griped about cluesless technical people at various companies. My worse half worked at a software company that made point-of-sales systems. The DOS version has been out for a while and stable. The windows

RE: Plagiarism?

Title: RE: Plagiarism? I COMPLETELY missed this WHOLE thing. They pulled the article before I got there even though I went up right away. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Where is Oracle 9.2 init.ora?

I suppose that depends on how you look at it. If you needed to for some reason, you could pull the header and footer records out and make it into just a plain init.ora But you are correct, of course that the SPFILE itself should not be edited if you wish it to remain a usable SPFILE. RF

RE: RE: larry want to take over your e-mai

Can you imagine the (additional) beating that Oracle would take if it's accounting practices showed up inflated revenues such as some of the other companies out there that are having problems I shutter to think... RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier

Re: Location of tnsnames.ora on client - SOLVED

I think it depends on default_domain parameter in client's sqlnet.ora. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 12, 2002 5:03 PM Okay, it turns out that if a tnsnames.ora file has

RE: Plagiarism?

It depends on what your definition of is is. BTW a question to all the ethics guru's... A lot of people have put out lots of papers, articles on their website, which can be downloaded for personal use. Would there be a ethics violation if I were to make a HTML page on my file system and access

RE: Plagiarism?

Probably for a chance to win a lousy T-shirt or a BaseBall Cap to submit the best voted Tip of the Month !! :-) - Kirti -Original Message- From: Post, Ethan [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 2:18 PM To: Multiple recipients of list ORACLE-L Subject:

RE: Oracle 9.2 spfile catch 22

I just like that 'dream' of 'no dba required' ;) 'cause I have heard enough presenters mention it... the new self tuning 9i, the new 'everything dynamic' 9i and such.. - Kirti -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002

RE: Where is Oracle 9.2 init.ora?

I did edit it and had no problems while teting my 9i R1 on HP-UX 11.0 :) - Kirti -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 3:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: Where is Oracle 9.2 init.ora?

RE: RE: larry want to take over your e-mai

Well, if you've got clueless techies then the company's doomed no matter who is in charge. Though I guess that you can always blame upper management for hiring people that are just certified but have no real experience.

RE: Oracle 9.2 spfile catch 22

Everything self tuning yeah it works. I have two identical tables (with different number of rows of course) and separately analyzed. They have identical index. When I run select on both tables after supplying a value for the PK, the query on main table uses the PK index and works fine. The

Re: WHICH TABLE NEED TO INCREASE FREELISTS

You want to do something before you know if it would make sense. If you know the object you know it makes sense. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 12, 2002 10:38 PM Hi Is any way which tables need to increase more

RE: Plagiarism?

Quick answer: If you make it clear that you are not the author of the papers and indicate who the real authors are then you are not guilty of plagarism. What the copywrite issues are is a much longer answer. I'm not sure that a definative answer exists but if there is a copywrite notice

RE: Where is Oracle 9.2 init.ora?

I've also heard that it should not be edited. It can be more'd to see contents. No need to edit it directly since SCOPE can be used. Gerardo -Original Message- Sent: Friday, July 12, 2002 2:54 PM To: Multiple recipients of list ORACLE-L I did edit it and had no problems while teting

Oracle on Linux ... Production Strength ???

Need Input: I would like to solicit real life experiences, educated opinions, accolades and criticisms from those of you who have implemented or are considering implementing Oracle on Linux in a business critical production environment. We are considering both Red Hat and Suse distributions.

RE: Where is Oracle 9.2 init.ora?

You DBA's must be drunk. Spfiles are in binary format and if you open it in a text editor, all you see are weird characters. Man. You guys are actually doing Oracle? Scares me. ltiu Quoting Deshpande, Kirti [EMAIL PROTECTED]: I did edit it and had no problems while teting my 9i R1 on HP-UX

RE: Where is Oracle 9.2 init.ora?

Yes I usually do Oracle after I'm done driving my cab :) I did edit the spfile in 9iR1 on Solaris using vi and had no problem! The header and tail were binaries but all the rest is text. Regards, Waleed -Original Message- Sent: Friday, July 12, 2002 7:28 PM To: Multiple recipients of

Re: listener configuration on HP serviceguard clusters

Title: RE: listener configuration on HP serviceguard clusters Yes, I do. IP of the node on which listener is running. Like I sad, listener belongs to the none, not package. Alex. - Original Message - From: Adams, Matthew (GEA, MABG, 088130) To: Multiple recipients of

RE: Where is Oracle 9.2 init.ora?

I guess your are right.. I am sincerely sorry about my earlier post. I must be drunk at that time as I could not replicate my test. I was mistaken (happens as I get old... ;) However, let me state the following: SPFILE is in ASCII format (on AIX and HP that I checked) And can be edited via

RE: Where is Oracle 9.2 init.ora?

Some of us have been around the block a few times. :) Editing binary files is no big deal. You neophytes are all the same. Jared ltiu [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/12/2002 04:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL

Re: PL/Sql Error Handling Package

We have package for logging diferent errors like 1. user error -- for user defined exception 2. system error -- for system exception 3. other error -- for other error 4. debug -- for debug logging every time an exception is caught , based on type a satus is returned to calling program at the

Re: Why DDL is not allowed in PL/SQL

I would guess because it's not part of PL/SQL. The DBMS_SQL package and 'EXECUTE IMMEDIATE' both send your SQL to the database engine. You may recall the the engine running PL/SQL is separate from the DBMS engine, at least through 8i. Jared sam d [EMAIL PROTECTED] Sent by: [EMAIL

RE: Where is Oracle 9.2 init.ora?

Man, it scares the heck out of me too that Jared and Kirti are actually doing Oracle -- I can't believe companies actually pay them ;-) And you two guys, and I'm talking to you Kirti and Jared, probably dig in and do things you shouldn't on test boxes just to see how things work and to learn.

Re: WHICH TABLE NEED TO INCREASE FREELISTS

One suggestion to suggest which table(s) might need increased FREELISTS is to run the following query against V$SQLAREA: select substr(upper(sql_text),1,30), sum(executions) from v$sqlarea where command_type = 2 /* insert */ group by substr(upper(sql_text),1,30) order by 2

RE: Where is Oracle 9.2 init.ora?

I could have SWORN there were problems when manually editing the spfile file.. if not, why bother creating it when you can just as easily use the init.ora file? --- Deshpande, Kirti [EMAIL PROTECTED] wrote: I did edit it and had no problems while teting my 9i R1 on HP-UX 11.0 :) - Kirti

RE: Oracle 9.2 spfile catch 22

I want no DBA required so I can retire and relax for a while :) --- Deshpande, Kirti [EMAIL PROTECTED] wrote: I just like that 'dream' of 'no dba required' ;) 'cause I have heard enough presenters mention it... the new self tuning 9i, the new 'everything dynamic' 9i and such.. -

Re: More on the OCP priceing

Steve, yes, now a/o sep 15, if you wait to start down the OCP path, you must take a ILT(instructor led training) before you can get OCP. You can still get OCA w/o it. http://education.oracle.com joe Steve McClure wrote: Am I missing something about the OCP program? The new required class

RE: Where is Oracle 9.2 init.ora?

After reading this, I ran to verify what happens when I edited the spfile. Surprisingly I had the same situation (9.0.1 Solaris). Edited the file and started the database without a single error and nothing reported in the alert or bdump. But Oracle used init.ora since non of the settings in

Re: Plagiarism?

Asking the author to publish it on your website should also be part of it. That has some CYA function also ;-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, July 13, 2002 12:08 AM Quick answer: If you make it clear that you are not

SQL query

I am using an Oracle database running in Linux. I would like to view the description of a table. For ex., if there is a table called 'person'. I would like to see the names of the columns in this table, their datatypes and such other details. In other dbmss like mysql a command