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 d

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 datafiles..

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)) F

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 buff

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 perf

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 wha

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

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 co

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 ORACLE

RE: ORACLE-L list and latency (???)

(sending: 9:23am west coast usa 20-JUNE-2002) A few minutes ago I got a "hard bounce" from the fatcity server. On 20 Jun 2002 at 7:53, Farnsworth, Dave wrote: Date sent: Thu, 20 Jun 2002 07:53:52 -0800 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

FW: Urgent!!Data lost

Hi, Let me make your task little easy...the procedure is as follows: Assuming your database name is PROD database. Restore the database in development server with the SAME database name. 1. Setup your LISTENER.ORA and TNSNAMES.ORA FILES 2. Restore ALL PROD datafiles to a location.

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 DB

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 n

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 S

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

order by versus order by desc problem ..... probably a simple 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 where col1 like 'ABC_' and col2 > 0 order by col1 desc; returns 0 rows just by putting in the descending clause anybody seen

Re: dedicated sessions

There's also a bug with MTS and JDBC Thin connections in 8i, where the dispatchers hang at random intervals. We experienced this on Solaris with 8.1.5 & 8.1.7, even though it was supposedly patched in 8.1.7. [EMAIL PROTECTED] wrote: > > BP, > > What you are asking falls somewhat into t

Alternative to Crystal Reports

Several times in the past I have seen folks on this list refer people to a reporting product to use as an alternative to Crystal reports. Apparently I didn't think I would need it, cause I usually save posts with information I am likely to forget.(So Yeah, I do save a lot of posts) Well now Crys

RE: RECOVERY QUESTION

Seema, there is no reference to these 3 tablespace and files in v$database or any other system table application is running fine.. Thanks --Harvinder -Original Message- Sent: Thursday, June 20, 2002 2:00 PM To: Multiple recipients of list ORACLE-L Harvinder I think u have to

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 Message

FW: RECOVERY QUESTION

Hi, Check the LATEST STATUS of DATAFILES from V$DATAFILE_HEADER view. Run the following query to find out the status: SQL > SELECT name, status, recover, error FROM v$datafile_header; Muqthar Ahmed DBA -Original Message- Sent: Thursday, June 20, 2002 1:33 PM To: Multiple recipients

Database Creation Problem

List, When I try to run Create database script to create a new database, I get the following error(Oracle 8.1.7.4 on Sun Solaris 8), ORA-01501: CREATE DATABASE failed ORA-01990: error opening password file '/opt/app/oracle/product/8.1.7/dbs/orapw' Disconnected. Is anybody had some simillar prob

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 applicat

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 tot

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 be

RE: PERFORMANCE ISSUE

Well, you don't give us much to go on and I fully agree with the other comment about buying and using a good tuning book. However, there is one experiment you might try the next time your instance gets slow. Try flushing the shared pool (alter system flush shared_pool). If that works, you can

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 whe

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 > AT&T > D

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* procedur

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]@SUNGARD on behalf of Hamid Alavi <[EMAIL PROT

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]@SUNGARD on behalf of "Seema Singh" <[EMAIL PROTECTED]> Sent: Thu 6/20/2002 12:38 PM To: Mult

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 trace)

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 & n

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

Title: PL/SQL proc calls to a remote DB via DB link If you create a synonym   create myPkgR for user.pkgR@dblinkR;   Then you can use   MyValR    MyPkgR.typeR;   This is much cleaner and less confusing ...   Raj __ Rajendra Jamadagni   

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 find

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:2

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 am

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 repor

Re: Training courses

Check on www.orapub.com or www.hotsos.com --- "Schauss, Peter" <[EMAIL PROTECTED]> a écrit : > 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: >

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 f

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! -Or

RE: Replication question

Bill - Thank you very much. This is the type of information I was hoping to receive. I'm one of those DBAs who prefer to see the potholes before I fall in them. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 20, 2002 12:49 PM To: M

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 pro

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 MICROM

RE: PERFORMANCE ISSUE

Seema, See the problem that is arising here on this post ? It could be this and it could be that ... what is the # of cpus ? what o/s ? try this and try that and on and on we go asking question after question until you say "Enough, I am not getting anywhere with this." This is why you gotta dri

RE: DBMS_SYSTEM.KSDWRT question

Title: RE: DBMS_SYSTEM.KSDWRT question We've been using KSDWRT in logon and table triggers (as well as in maintenance jobs for our 24x7 databases that didn't have a UTL_FILE_DIR entry) and have yet to encounter a problem.  I trussed a background process that used the procedure and it wrote to

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 t

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 CAMPNAME,ASGNM

RE: Database Creation Problem

Dennis, When Oracle try create password file failed & get this error, Actualy orapw 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 DBA

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 --- "Schau

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 fo

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 Oracle Support.   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: wha

RE: SMON Using Lots of Memory in 9i

Our application uses Glance. Bill Carle AT&T 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 accompli

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

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. Obviously

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 description

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: Databa

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: Training courses

I concur. I received incorrect information in the beginning DBA classes, but the time spent in the 8i Data Server Internals Seminar with Scott Gossett was incredibly valuable (and I paid for it and the travel to Bethesda myself). For my money, I would rather attend the top notch user group meetin

RE: DBMS_SYSTEM.KSDWRT question

Raj, Here is a trial run with those procedures... will tell you what those do. SQL> alter session set sql_trace=true; Session altered. SQL> exec dbms_system.ksdwrt(1, 'From Kirti'); -- Write to trace file (1=Trace, 2=alert, 3=both). PL/SQL procedure successfully completed. SQL> exec dbms_syste

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 2

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 a

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 total

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: ocp exam/when?

Thanks.  I was scared... I am going to take it a step at the time and become an Associate first.  To me it is a good deal you become an Oracle certified (how sweet the sound) only after two exams. I'll move to a next level after gaining more knowledge and taking a little break from studyi

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 > AT&T > Database Administrator > 81

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 an

RE: MS SQL Server mailing lists ???

Title: RE: MS SQL Server mailing lists ??? Help!!! What were the sites? -Original Message- From: Reddy, Madhusudana [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 12:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: MS SQL Server mailing lists ??? Thank you all

RE: Training courses

Dan, and others It is very useful to see how the top-notch people keep themselves up to speed. But of course, any advice must be suited to the advisee. For example, for some of us a little lower on the food chain, maybe acquiring the OCP might be a first step. Now Peter isn't exactly a nov

RE: MS SQL Server mailing lists ???

Title: RE: MS SQL Server mailing lists ??? As the list suggested me , they are two :   1. [EMAIL PROTECTED]   2. http://intm1.sparklist.com/scripts/lyris.pl?enter=sql2000&text_mode=&lang=english   The above are for SQL 2000 and you can find the lists for SQL 7 on same sites.   --Madhu

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

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, that

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 w

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

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 wi

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 PRO

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 pk_default_schem

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 y

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: http://www.orafaq.com

Re: OT: Viruses

>From the list, or someone subscribed to the list? If it was an attachment, was there actually anything in the attachment? This list does not forward binary attachments. Jared Robertson Lee - lerobe <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/19/2002 01:28 AM Please respond to ORACLE

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 respon

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. Obj

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 siz

  1   2   >