comp.databases.oracle newsgroups

Is anyone else having problems with the comp.databases.oracle.* newsgroups? I haven't seen a new message in the last three days. Henry

Re: Free buffer requested

Ramon, I would recommend to use UTLBSTAT.SQL and UTLESTAT.SQL output may show you bottlenecks. May be the application needs to be tuned. Log switches are too often. Should be at least 10 min or more. redo log space requests is probably also high. Looks like LGWR often waits for DBWR to write

Re: RTFM/ SUPPORT, etc WASRe: Index Constraint

- Original Message - i call support usually AFTER 2 weeks of working on an issue my self, they are my last resort, when i've exhausted all of my friends, cohorts and this list for my issue. joe Hello Joe I think that your policy is wrong. If after one or two days you do not

RECOVERY QUESTION

Hi, We have a cold backup of sunday evening and all the archive log since that we lost the hard disk containg files of 3 tablespaces...and moreover we don't need this tablespaces anymore.. 1) we restore the cold backup containg all the datafiles except this 3 tablespace

Query Tuning

Hello Folks, Given an Oracle 7.3.4 database, how would you tune a query as under, other than suggesting a migration to a higher version. This query is currently performing a lot of I/O, obviously doing a full tablescan on CAMPMAIN. SELECT CAMPNAME,ASGNMTTYPE,CAMPRTGNUM, LTRIM(RTRIM(CAMPTYPE))

RE: How to fine free space in an index

Inder - The only way I found was to analyze the index, then look at the LEAF_BLOCKS number. I found that in practice this worked pretty well. There are a few more blocks used beyond the leaf blocks, but not many. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message-

RE: Replication question

Andy, Consider yourself solicited! I am currently using Datamirror for our tandem db2 to unix oracle replication. The product was not chosen for our oracle to oracle replication for 2 reasons. #1 trigger based. #2 if the source transaction failed to be commited at the target, then

Re: Free buffer requested

I executed the process using b/e/stat Statistic Total --- - Per TransactionPer Logon Per Second --- redo blocks written 1169331 146166.38 86617.11 794.92 redo

PERFORMANCE ISSUE

Hi I am having some problem regarding performance.The performance problem get solved after reboot.Whenever the db unix server keep running more than 72 hrs the performance looks like slow.one of cause I found some memory leakage.But the box are having 2 instances and for another instance

Re: Free buffer requested

I'm also dying to know how much of that 1G shared pool is full... --- Anjo Kolk [EMAIL PROTECTED] wrote: I am getting more confused (as per my previous answer on this subject). 200 MB log buffer is HUGE and totally not needed at all. If free buffer requested is too high (and what is too

RE: Replication question

Brian, That is what I wanted to do, but I understood that it would not be *supported* if we ran into issues. Thanks, Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Brian McGraw [EMAIL PROTECTED] Sent: Thursday, June 20,

Re: Free buffer requested

Dennis, 1000% Agree with you, that's my point. tks - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 10:48 AM Ramon Thanks for the clarification. When you say that performance should be better according to the computer

RE: Unable to start database, Oracle 8.16 on Windows NT 4.0 Serv

Daniel, Your solution worked for me. Thanks. -Original Message- Sent: Wednesday, June 19, 2002 5:04 PM To: Multiple recipients of list ORACLE-L Serv Do a startup mount, rename the datafile and open the database. SQL startup mount; SQL alter database rename 'H:\oracle\retail.dbf' to

Re: sequence question

Hello Bp If you use the sequence for unique identifiers only, you do not need to worry about this. At most the numbers will go from 1234 to 11234 and continue from there. So what? Yechiel AdarMehish - Original Message - From: BigP To: Multiple recipients of list

RE: RECOVERY QUESTION

Harvinder - If you select from DBA_DATA_FILES, you will probably see those tablespaces as having a MISSING location. Take them offline if you like. Not a big deal, I have run a lot that way on test databases. Of course, if anyone tries to access the tablespace they get an error. Dennis Williams

RE: Replication question

Conflict resolution also has to be considered for log based replication as well. Same problems exist. If you think about it Oracles AQ approach is pretty much a log. Multi-master replication is still trigger/AQ based in 9i. It's working well for us. Some of the things you can do to reduce (but

Re: RECOVERY QUESTION

Harvinder I think u have to restore complete from cold backup and create controlfile including 3 datafiles also and bring back to database and then u can drop tablespaces. OR at current stage.did u status in check v_$datafile and v_$tablespace dictionary table ? Thx -Seema From: Harvinder

RE: Free buffer requested

also, just a curious question as to why you sized your shared pool at 1GB ? -Original Message- Sent: Tuesday, June 18, 2002 6:33 PM To: Multiple recipients of list ORACLE-L Hi list, Scenario Sun 880 Solaris 8, Oracle 8.1.7.3, 8GB Ram, 4 processors Redo logs 200MB size 4 groups in 1

RE: PERFORMANCE ISSUE

Seema, So what does that tell you about how useful database ratios are in diagnosing your problem ? I would suggest you check out some sites about detecting waits in your system. The information given here gives no one a starting point to help you diagnose the problem. Consider buying Gaja

RE: Replication question

Hmmm. Maybe that's changed, but we were actually advised to move the objects when we set them up in v8. -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -Original

RE: RECOVERY QUESTION

sirry , it should be v$datafile and other table dba_data_files etc.. -Original Message- Sent: Thursday, June 20, 2002 2:17 PM To: Multiple recipients of list ORACLE-L Seema, there is no reference to these 3 tablespace and files in v$database or any other system table

Training courses

My manager has told me that he has budget to send me for a training course of my choice, 4 to 5 days, preferably in the local area (Long Island or NYC). A bit of background on myself: Current position: Oracle DBA, right now, mostly supporting development, including data modeling. 20+ years

Re: production database on aix won't be open, help

Hello Rajesh, I don't know Oracle Corp. has published Deferred Transaction Rollback term externally. But, I know this term is available. Deferred Transaction Rollback was introduced in 7.3. It enables database to be opened after roll forward is completed. The rollback of any uncomitted tx will

RE: order by versus order by desc problem ..... probably a simple

Looks like a bug! -Original Message- Sent: Thursday, June 20, 2002 2:17 PM To: Multiple recipients of list ORACLE-L pro select distinct col1 from table_name where col1 like 'ABC_' and col2 0 order by col1; returns 38 rows .. but select distinct col1 from table_name

Re: SMON Using Lots of Memory in 9i

Hello, how utility/tool said that SMON was using 50M+ ? regards... Carle, William T (Bill), ALCAS wrote: Hi, We recently converted to 9i and the SMON process seems to be using lots of memory. (more than 50 mb) Has anyone else seen this or can explain it? Bill Carle ATT Database

PL/SQL proc calls to a remote DB via DB link

Title: PL/SQL proc calls to a remote DB via DB link Listers: You have 2 DBs, L local, R remote. From within a PL/SQL package or procedure on the *local* DB, is it legal to: declare a local variable using a *remote* type: MyVar_L userR.pkgR.typeR@dblinkR; or call a *remote* procedure:

RE: Database Creation Problem

Title: Database Creation Problem Hamid, What are the permissions on the directory - - - /opt/app/oracle/product/8.1.7/dbs? What is the owner and group id on the above directory? Rao -Original Message- From: [EMAIL PROTECTED]@SUNGARDon behalf ofHamid Alavi [EMAIL

RE: PERFORMANCE ISSUE

Title: PERFORMANCE ISSUE Seema, Questions: 1. On what OS you are running your db? 2. How did u find memory leakage? Regards, Rao -Original Message- From: [EMAIL PROTECTED]@SUNGARDon behalf of"Seema Singh" [EMAIL PROTECTED] Sent: Thu 6/20/2002 12:38 PM To: Multiple

RE: SMON Using Lots of Memory in 9i

I have seen smon going upto 127M at which point it starts dumping trace files (one trace file and a core directory for each connected session) as if it's raining. Then instance crashes. All DBAs and Unix Admins panic and bring up the system, unfortunately most important trace file (the smon

Re: Training courses

If I had that oppurtunity, I would lap up Cary Millsap's Hot clinic to be conducted in NYC around July 9-11. You should be able to get more information from www.hotsos.com. Raj

RE: packages procedures

Charlie, Courtesy of TOAD (I'm too lazy to not use it) try looking at all_arguments which seems to have at least a large part of what you need. Iain Nicoll -Original Message- Sent: Wednesday, June 19, 2002 8:34 PM To: Multiple recipients of list ORACLE-L I'm having a senior moment

The Right Manual

All, I will be more than happy to RTFM if someone could be so kind as to tell me _which_ manual I should look at! We are migrating to new Sun Servers with Veritas and 9i. Our consultants (who are actually pretty good) are recommending we use Oracle Disk Manager w/ Veritas. However I can't

RE: Database Creation Problem

In your init.ora file, check for remote_login_passwordfile = none If you have it set to a different value, either change it or use orapwd utility to create the necessary password file. Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Thursday, June 20, 2002 11:23

RE: PERFORMANCE ISSUE

It could be memory paging problem. Are you using UFS, VFS, etc? If yes, see if there is any options where you can mount them in the direct mode (bypass the fs cache layer) Waleed -Original Message- Sent: Thursday, June 20, 2002 12:39 PM To: Multiple recipients of list ORACLE-L Hi I

Re:Alternative to Crystal Reports

Steve, If you can't convince Oracle Reports to perform in the way we would like don't expect Crystal to be anything but worse. It might be more useful to invest time in looking at what the duhveloper did and tuning the sql statements. With Oracle you can have more than one query per

RE: PL/SQL proc calls to a remote DB via DB link

Title: PL/SQL proc calls to a remote DB via DB link Try it, you might like it. You might also get your answer quicker than asking the list. I can't find a place where I defined a variable using a remote package but I seem to remember doing the same type of thing using remote tables and it

RE: Database Creation Problem

Hamid - Does this password file exist? Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 20, 2002 1:23 PM To: Multiple recipients of list ORACLE-L List, When I try to run Create database script to create a new database, I get the

RE: order by versus order by desc problem ..... probably a simple

You are exactly correct ... it is a bug in an earlier version on Oracle we have on one of our servers See Note:1036394.6 on metalink ! thank you ! Mike -Original Message- Sent: Thursday, June 20, 2002 11:51 AM To: Multiple recipients of list ORACLE-L simple Looks like a bug!

Re: SMON Using Lots of Memory in 9i

Hello, I mean how did you find that SMON is using 50M+ ? regards... Danisment Gazi Unal (ubTools) wrote: Hello, how utility/tool said that SMON was using 50M+ ? regards... Carle, William T (Bill), ALCAS wrote: Hi, We recently converted to 9i and the SMON process seems to be

RE: Database Creation Problem

Not a factor for this error, but what's the ORACLE_SID? maheswara.rao@s

RE: order by versus order by desc problem ..... probably a simple

Run sql trace on each and see the differences in the execution plan. If #2 is using an index, try a rebuild and see if it changes. I have seen indexes be built without data in them (though data is in the table). Checking for a bug is an excellent idea as well. Daniel W. Fink Sr. Oracle DBA

RE: Alternative to Crystal Reports

There is always Excel. ;o) -Original Message- Sent: Thursday, June 20, 2002 2:36 PM To: Multiple recipients of list ORACLE-L Steve, If you can't convince Oracle Reports to perform in the way we would like don't expect Crystal to be anything but worse. It might be more useful to

Re: Query Tuning

[EMAIL PROTECTED] wrote: Hello Folks, Given an Oracle 7.3.4 database, how would you tune a query as under, other than suggesting a migration to a higher version. This query is currently performing a lot of I/O, obviously doing a full tablescan on CAMPMAIN. SELECT

RE: Database Creation Problem

Dennis, When Oracle try create password file failed get this error, Actualy orapwSID is created but is not accessable by Oracle. -Original Message- Sent: Thursday, June 20, 2002 12:36 PM To: Multiple recipients of list ORACLE-L Hamid - Does this password file exist? Dennis Williams

RE: Training courses

I would second these selections below Stay away for the Oracle provided training, It is worthless. fwiw ! Peace and Love Mike -Original Message- Sent: Thursday, June 20, 2002 12:20 PM To: Multiple recipients of list ORACLE-L Check on www.orapub.com or www.hotsos.com ---

RE: Database Creation Problem

in my init file remote_login_passwordfile=exclusive, what do you mean do I have to change it to non as follows: remote_login_passwordfile=non or Thanks, -Original Message- Sent: Thursday, June 20, 2002 12:14 PM To: Multiple recipients of list ORACLE-L In your init.ora file, check for

RE: Training courses

not totally worthless, but the value of the class is directly related to the quality of the instructor. I have had the good fortune to take classes with several of the best of Oracle instructors. I have also had the misfortune to take classes with some of the less best --- Johnson, Michael

RE: what is the latest db that will support ***CLIENT-SERVER***

I would love to join a list were we can post all of the colossal dumb-isms emitted by OracleSupport. Tony Aponte -Original Message-From: Brian McGraw [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 20, 2002 11:29 AMTo: Multiple recipients of list ORACLE-LSubject: RE: what

RE: SMON Using Lots of Memory in 9i

Our application uses Glance. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 20, 2002 1:51 PM To: Multiple recipients of list ORACLE-L Subject:Re: SMON Using Lots of Memory in 9i Hello, how utility/tool said

ocp exam/when?

Does anyone know at what point you need to take that class for $2000? Is it required even before you take your first exam or sometime alone the process? Thank you.

RE: Alternative to Crystal Reports

My exprience with Crystal is responding to problems like I can't get Crystal to do this or that. My usual answer is create a packaged function that returns a REF CURSOR that returns the results in a format that Crystal deal with. The more recent the Oracle version, the easier this is to

RE: DBMS_SYSTEM.KSDWRT question

Title: RE: DBMS_SYSTEM.KSDWRT question Thanks Tony, I have been told not to use standard auditing ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't

RE: Corrupt archive redolog on 7.3.4

Try sending the archive log again, it may have been corrupted in transit. If the redo log that generated this archive log has not been overwritten, make a copy of it and try to apply it to the standby. *Do this quickly if it is not too late... Aside from that, you have a bigger problem.

RE: Training courses

Peter - Do you have a particular objective in mind? For example, would you like to eventually complete the OCP? The normal progression (using Oracle Education classes as a basis) would be: 1. SQL PL/SQL 2. DBA 3. Advanced topics (check education.oracle.com for

RE: Database Creation Problem

Title: RE: Database Creation Problem Hamid, make sure you see this in your init.ora file: remote_login_passwordfile=none -Original Message- From: Hamid Alavi [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 2:23 PM To: Multiple recipients of list ORACLE-L Subject:

RE: DBMS_SYSTEM.KSDWRT question

Addition: DBMS_SYSTEM.KCFRMS - resets counters displayed by MAX_WAIT in V$SESSION_EVENT, and MAXIORTM, MAXIOWTM in V$FILESTAT views. - Kirit -Original Message- Sent: Thursday, June 20, 2002 2:33 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Raj, Here is a trial run with those

RE: Database Creation Problem

Hamid Try reading up on the password file. Here is a link. This will be much faster for you. http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76956/dba.htm#1167 Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June

RE: DBMS_SYSTEM.KSDWRT question

Thanks Kirti ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is

RE: Training courses

I agree with Rachel. I had to ditch one class after the 1st day. But I got re-registered for the same class when Scott Gossett taught it. And it was worth it. Trust me. - Kirti -Original Message- Sent: Thursday, June 20, 2002 3:15 PM To: Multiple recipients of list ORACLE-L not

Re: The Right Manual

John, ODM is a standard created by Oracle for how the database wishes to do I/O. Oracle published a standard for how they would like to do I/O and Veritas created an ODM compliant version for VxFS. ODM also leverages the performance gains implemented in QIO. Veritas has also added some management

RE: Training courses

The Internals classes are not to be missed! I go to user group meetings, attend conferences and hang out on this list to learn these days. Once in a while I take a new features class, but that's rare. Conferences teach me more. Cary is teaching a clinic in NYC in July... I don't think I can get

Re: SMON Using Lots of Memory in 9i

Hi Carle, I'm not sure if shared memory/library segments are not included in SMON's address space in your case? If you are using Sun, please see Note:163763.1 regards... Carle, William T (Bill), ALCAS wrote: Our application uses Glance. Bill Carle ATT Database Administrator

Re: Query Tuning

Thanks for the reply, Stephen. When I had a look at the Batch job performance problems, I vented it out the same way you did. The naive business folks were told The database is slow. Tune it. I created a seperate schema with the culprit tables, updated the column values to trim them, removed

RE: Alternative to Crystal Reports

Title: RE: Alternative to Crystal Reports I have yet to see something that I cannot do in Crystal Reports. However, I don't write the reports off of tables, I use stored procedures to query and process the records and return cursors to the crystal report. That way all the data is massaged and

Re: MS SQL Server mailing lists ???

Title: RE: MS SQL Server mailing lists ??? [EMAIL PROTECTED] http://www.sswug.org/listservers.asp Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, June 20, 2002 5:41 PM

Re: Replication question

Hadn't heard that one. Objects for replication metadata are created in whatever the default tablespace is for SYSTEM. The database create script crdb2.sql changes SYSTEM's default tablespace to TOOLS, so subsequently that's where the objects are created when catrep.sql is run. In my case,

Re[2]: The Right Manual

John, Take a look at http://www.veritas.com/news/press/FeatureArticleDetail.jhtml?NewsId=9457 Dick Goulet Reply Separator Author: Scott [EMAIL PROTECTED] Date: 6/20/2002 1:10 PM John, ODM is a standard created by Oracle for how the database

Re:RE: Alternative to Crystal Reports

Chris, Until some fool gives the general user this tool as a general purpose query tool. Then all hell breaks out. Dick Goulet Reply Separator Author: Bowes; Chris [EMAIL PROTECTED] Date: 6/20/2002 1:33 PM I have yet to see something that I

RE: Training courses

alright ... Ill buy that explanation. -Original Message- Sent: Thursday, June 20, 2002 1:15 PM To: Multiple recipients of list ORACLE-L not totally worthless, but the value of the class is directly related to the quality of the instructor. I have had the good fortune to take classes

RE: Alternative to Crystal Reports

I've never used it, but this may be worth a look at: http://sourceforge.net/projects/datavision/ It looks to be a little rudimentary, judging by screenshots, but you never know. And it appears to be in beta, but there's a lot of activity on the project right now. HTH! GL! Rich Jesse

Re:RE: Alternative to Crystal Reports

Business Objects is good although the learning curve is pretty big. Although it is like anything and you have to watch the SQL statements that are used. We had a client bring there production system to its knees with a few poorly designed reports. From: [EMAIL PROTECTED] Reply-To: [EMAIL

the ora certified masters cert, yet again

I am seriously considering pursuing one, since it can be sold to hiring managers as a sign of professional competence. Look at it from a cost/benefit ratio standpoint. Will someone with this cerifification make $2000 more over her professional life than she would without? So it takes a round

Re: sys corrupted in warehouse, sev1 tar open - resolved

Here's some login trigger code (cloned from Ixora with a few modifications), similar to what Bruce mentions. CREATE TABLE system.default_schema ( user_namevarchar2(30), schema_name varchar2(30) ) TABLESPACE tools ; ALTER TABLE system.default_schema ADD CONSTRAINT

RE: ocp exam/when?

http://www.oracle.com/education/certification/index.html?dba9i_ocp.html The above page shows , Candidates for Oracle9i DBA OCP must pass the following two exams as well as completing at least one Oracle University required hands-on course within the Oracle9i DBA learning path to obtain

How to make SQLLDR to run faster?

I try to insert 14,000 rows into oracle database using SQLLDR and it takes too long to finish (around an hour). Is there a way to improve SQLLDR to make it run faster? For example, if modify parameter file will help? Thanks, David -- Please see the official ORACLE-L FAQ:

RE: Alternative to Crystal Reports

When I have had to rarely deal with report writers, or heck really any ODBC tool I use the approach you describe. Write a stored procedure that returns EXACTLY what you need, then just let the tool format it. In this case however, The problem is we want drill down capability. Now while Oracle

RE: How to remove Lock on a Table

Personally, I always whack 'em first with a great big stick. May not be everyone's cup of tea I suppose, but then again, I *never* have a hung session holding a lock and requiring a database bounce. Jared Ben [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/19/2002 01:28 PM Please respond

Re: Replication question

There is also a note (1037317.6) that documents moving the replication base tables to another tablespace (which Oracle Recommends). Funny how alot of the Oracle Recommendations are in notes instead of the documentation. --- Suzy Vordos [EMAIL PROTECTED] wrote: Hadn't heard that one.

Re: IBM AIX Shark storage?

Having been the person responsible ( on the database side ) for those particular Sharks that Pete is referring to, I can say that I would certainly consider something else. There are a number of built in limitations: * cannot create a volume as large as a LUN * cannot enforce varying stripe

RE: Training courses

Dennis, Excellent point! We discussed Oracle training without asking Peter what he wanted to learn! So...Peter, What would you like to learn? If it is advanced Oracle DBA stuff, I'll stand by my recommendation. Otherwise, I will defer to the list on other areas. Daniel W. Fink

RE: How to remove Lock on a Table

Removing locks from tables? Isn't that what primary keys are for? Of course, if you have misplaced your primary key, I think the foreign key would work. Okay, so it's been a long day...;) Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 -Original Message- Sent: Thursday, June 20,

RMAN: can't allocate auxiliary channel to duplicate db

Using 9iR2, Solaris 8, and Veritas NetBackup, an RMAN duplicate database script fails after restoring the control files when I use a normal allocate channel command. The error tells me I must allocate an auxiliary channel (which matches the Oracle instructions). Allocating an auxiliary

RE: comp.databases.oracle newsgroups

Henry Poras[SMTP:[EMAIL PROTECTED]] wrote: Is anyone else having problems with the comp.databases.oracle.* newsgroups? I haven't seen a new message in the last three days. Henry Nope - I'm getting new traffic - 200+ messages yesterday, another 168 today in c.d.o.server alone. Might be a

Re: How to make SQLLDR to run faster?

David, start shameless self-plug I wrote an article last year about tuning SQL*Loader. It is at http://oracle.oreilly.com/news/oraclesqlload_0401.htmlI experienced a huge improvement in performance and others have told me that they were able to achieve similar improvements. end shameless

RE: RE: Online vs offline backups

-Original Message- Sent: Wednesday, 19 June 2002 5:38 AM To: Multiple recipients of list ORACLE-L Ferenc Mantfeld£¬ The same person that advocated a cold backup did not back up the online redo logs, so what use was it anyway, since the only way they would force open their DB is with a

RE: How to remove Lock on a Table

instead of whack-a-mole it's whack-a-duhveloper? --- [EMAIL PROTECTED] wrote: Personally, I always whack 'em first with a great big stick. May not be everyone's cup of tea I suppose, but then again, I *never* have a hung session holding a lock and requiring a database bounce. Jared

RE: How to make SQLLDR to run faster?

Please check this out : http://oracle.oreilly.com/news/oraclesqlload_0401.html And then the book by Jonathan Gennick and Sanjay Sharma. HTH, - Kirti -Original Message- Sent: Thursday, June 20, 2002 6:20 PM To: Multiple recipients of list ORACLE-L I try to insert 14,000 rows into

RE: Training courses

heck, anything (presentations, classes, books) are all good or bad depending on the knowledge of the person presenting the information and their ability to teach sometimes the ability to teach is more important than how much they know. I've known really smart people who can't make anyone

RE: Training courses

I almost never took an Oracle course. Read docs, went to conferences, spoke with (phone) and wrote to (snail mail) other DBAs asking questions, and what-ifs. TRYING things on my own. How do you think the top-notch people got to BE top-notch? I seriously doubt it was from taking Oracle classes

RE: the ora certified masters cert, yet again

And if you are lucky and 'distinguished' you might receive your OCM diploma in front of 22,000+ attendees at the next OOW conf. Rich N. was the first one to do that. I saw it last December. - Kirti -Original Message- Sent: Thursday, June 20, 2002 5:50 PM To: Multiple recipients of

RE: the ora certified masters cert, yet again

Are you trying to promote it? -Original Message- Sent: Thursday, June 20, 2002 6:50 PM To: Multiple recipients of list ORACLE-L I am seriously considering pursuing one, since it can be sold to hiring managers as a sign of professional competence. Look at it from a cost/benefit ratio

RE: Corrupt archive redolog on 7.3.4

Thanks dan, alter system dump logfile 'xxx' came out with out errors. it created trc file. how to decipher this trace file. i copied the transfered the file to dr could not apply the log. 2. we use raw file system for the redologs. 3. how to make a copy of the redolog which is not overwritten

Re: RE: Online vs offline backups

O, here we go again. I don't care what logic, documentation, oracle support and/or common sense have to say on the matter. Back up those redo logs! Just don't restore them unless you need them. 'shutdown immediate' doesn't always work the way one would hope, especially on

RE: How to remove Lock on a Table

I only engage in that particular activity when there's a good chance it won't involve an attorney and/or judge. Jared Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/20/2002 05:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL

RE: SEQ#, DUAL and Oracle literacy

While you are at it can you fix that name too...? What kinda name is dual...sounds suspicious..;) RS --- Khedr, Waleed [EMAIL PROTECTED] wrote: So did you fix it? -Original Message- Sent: Tuesday, June 18, 2002 3:07 PM To: Multiple recipients of list ORACLE-L Want to have a

RE: How to fine free space in an index

Try this for size. Needs prettying up on the output but all the info is there. Regards: Ferenc Mantfeld Senior Performance Engineer Siebel Performance Engineering Melbourne, 3000, VIC, Australia Only Robinson Crusoe had all his work done by Friday -Original Message- Sent: Thursday,

RE: the ora certified masters cert, yet again

I thought employees were not allowed to write things off as business expenses... Confusedly yours, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, June 20, 2002 10:13 PM To: Multiple recipients of list ORACLE-L Subject:RE: the ora

RE: the ora certified masters cert, yet again

Does anyone know if 9i Release 2 is going to be the terminal release for 9i? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de

will 9i Rel 2 be the terminal release?

Sorry, previously sent with wrong subject line... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Friday, June 21, 2002 1:50 AM To: '[EMAIL PROTECTED]' Subject:RE: the ora certified masters cert, yet again Does anyone know if 9i

Data Types

i wanted to know the exact difference between the following data types - NCHAR NVARCHAR2 VARCHAR2 VARCHAR Thanks and regards,Santosh

  1   2   >