Reraising exceptions

Hi, I am currently writing some pretty complex triggers. In some cases I would need catch all exceptions occuring in a procedure call, make some processing (set a package variable) and then reraise the exception. Can this be done? Every hint will be highly appreciated. Tamas Szecsy

AW: Reraising exceptions

Tamas, you could usethe "RAISE" statement as last statement in the execption handler to re-reaise the exception. e.g. begin null; exception null; raise end; regards, Michael -Ursprüngliche Nachricht-Von: Szecsy Tamas [mailto:[EMAIL PROTECTED]]Gesendet am: Mittwoch,

Re: High DML Table - Suggestions??

Partition. Even on 7, obvious in this case would be partition views with maybe some changes in the app. Or maybe not depending the app. Stripping. Oracle stripping and OS stripping. Freelists. It seems that the app insert and query. Because of the inserts it is a perfect case of freelists. If

Re: What is in archive log...

...AND SHARE PLEX from QUEST. --- Traci Rebman [EMAIL PROTECTED] wrote: Aldi, You can use LogMiner to view activity in the archive logs. See Note:111886.1 for how to set it up. Traci Rebman Database Administrator DE Communications, Inc. -- Please see the official

RE: Reraising exceptions

Michael, Thank you for the help! Tamas -Original Message-From: [EMAIL PROTECTED] [mailto:[Szecsy Tamas]]Sent: Wednesday, August 22, 2001 10:06 AMTo: Multiple recipients of list ORACLE-LSubject: AW: Reraising exceptions Tamas, you could usethe "RAISE"

Re: Performance analysis (enqueue and buffer busy waits)

Hello, It's Unal Bilisim. Ethan mentioned about itrprof SQL Analyzer, which is superior to tkprof. web: http://www.unal-bilisim.com/products/itrprof/itrprof.html Thank Ethan. regards... Babette Turner-Underwood wrote: What is unil-bialism ?? - Original Message - To: Multiple

RE: What is in archive log...

Title: Message Better than no log too!! :^P -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Christopher SpenceSent: Tuesday, August 21, 2001 20:13To: Multiple recipients of list ORACLE-LSubject: RE: What is in archive log... better than

Re: Archived logs

On Tue, Aug 21, 2001 at 01:53:07PM -0800, Aldi Barco wrote: Hi, My database generated so many archived log now, let say 20 archived log per minute. The application and the number of rows in the database is not too much different with few days ago. How did you determine this to be true?

Re: 8.1.7/HP-UX 11/PRODUCT_USER_PROFILE

The behavior you describe is normal for PRODUCT_USER_PROFILE. Once you understand how it works, it all becomes clear ;-) This is my understanding of it, hopefully someone will correct me if I'm wrong... When a user connects to the database via ORACLE's SQL+, the *application* checks the

Users Schema's

Help!!, Can anyone shed some light on this or am I just going mad!!. We have a situation whereby multiple users need to access (both selects and dml) tables belonging to 1 specific schema, this must also be achieved without prefixing the tables with the userid as the SQL is driven by the

Re: User access within/outside of app

One of the ways round this is to have the priv's needed for anything other than select granted to a role, rather than the generic userid. Make the role non-default, and require a password to enable it - that way, using the ODBC connection won't give users any godlike powers. The issue is how

RE: Oracle for Solaris (on Intel)

Hi ! My previous employer has several DBs (8.1.5 8.1.7) on Solaris for Intel. It's pretty stable and i enjoyed working with it. Although the trend is to install Linux instead of Solaris on Intel. Unfortunately , i did not see any comparisons of Oracle on Solaris-Intel , on Linux on NT on the

RE: Users Schema's

You can do this with ALTER SESSION SET CURRENT_SCHEMA = USERB; You can find it in Oracle 8i SQL Reference, Volume 1. Best regards, Marco -Oorspronkelijk bericht- Van: Dave Leach [mailto:[EMAIL PROTECTED]] Verzonden: woensdag 22 augustus 2001 12:02 Aan: Multiple recipients of list

RE: Users Schema's

are we talking about alter user set current_schema = new schema ? you require a BECOME USER priv for this -- From: Dave Leach[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Wednesday, August 22, 2001 5:01 PM To: Multiple recipients of list

RE: Users Schema's

Dave, You can use the following : alter session set current_schema = USERB Check out the SQL Reference manual - Chapter 7 SQL Statements, ALTER SESSION (page 387) HTH Mark -Original Message- Sent: Wednesday, August 22, 2001 11:02 To: Multiple recipients of list ORACLE-L Help!!,

RE: How do they get the answer?

I thing that the answer should be E) At leasttwo teachers will receive a 10% salary increase. Think if there are the same 2 teachers for class 102,105 Ivo From: Stephen Andert [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 21, 2001 06:57 PMTo: Multiple recipients of list

DBVERIFY on system ts

Hi all If I run dbverify on the system ts (or rbs ts AND on different dbs) I get the following: DBVERIFY - Verification starting : FILE = /dpp/test01/HOUR/HOURsystem01.dbf Block Checking: DBA = 67108867, Block Type = Undo data block ERROR: Undo Block Corrupted. Error Code = 2005 ktu4ubck: Undo

FW: Users Schema's

-Original Message- Sent: 22 August 2001 10:42 To: 'Rahul' Fantastic, what a relief!! I have just looked this up on Metalink and have read a note saying this is an undocumented parameter, I'm now in 2 minds as to whether to use it, although it sounds exactly what we want. Many thanks

Re: Users Schema's

You may be thinking of the 'proxy user' feature: alter user xxx grant connect through yyy with role rrr; However, the features that this enables are currently available only through OCI programming at present. The other thing you may be thinking of is alter session set current_schema =

Re: SGA sizing

Yosi, here is the output from v$parameter and v$system_parameter. As far as I was aware, ismodified will be non-false if an alter session or alter system command has been carried out. isadjusted will be non-false if Oracle has dynamically adjusted the parameter. Show SGA has the following

URGENT PLEASE ! tns service deletion and recreation

OS: NT 4.0 I need to delete the TNS Listener service . and create a new one . How can I do that ? TIA Bunyamin

Re: linux Oracle -- best combination

I've not really checked out Suse, you have to buy it versus being able to get RH for free? joe Scott wrote: I believe that Oracle has decided that when porting to linux all products will be ported to SuSE and then perform post release certifications on Redhat. I believe stability and

Re: FW: Users Schema's

It *used* to be undocumented because it used to have a nasty memory leak (8.0 and below). When they fixed this (in 8i), it appeared in the doco. It may have been fixed in patches for earlier releases - but I dunno. hth connor --- Dave Leach [EMAIL PROTECTED] wrote: -Original

Re: User access within/outside of app

we had a solution for home-grown powerbuilder apps using set_client_info, that triggers verified that info from v$session before any dml happened. if you're interested in that solution, drop me a line and i'll explain it. joe Larry Hahn wrote: Jon, This is one of the options we have

RE: Users Schema's

Many thanks for all the replies on this, it is indeed a documented parameter under the ALTER SESSION command. I can't believe I missed this bearing in mind the time I spent searching. My sanity is restored for now!! Dave Leach -Original Message- Sent: 22 August 2001 11:32 To:

Re: RMAN Copies

There is a way. Check Metalink for document 73974.1. It has the complete instructions. I do this for a report database copy of production. If you need anymore info let me know, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 21,

OT: Unix - performance tuning (vmstat 5)

Hi Unix Gurus, I submit a job to monitor the CPU utilization etc every 15 mins using the command vmstat 5. How do I kill the submitted unix process of the batch job ? I tried to kill the submitted process using a batch job using the following command : var_pid=`echo $var_grep_vmstat | (read u

sql query

Hi One table has following information userid superid 14 -1 4 0 8 2 9 2 15 2 24 4 16 4 25 4 6 5 7 5 26 5 2 16 18 16 10 18 11 18 1 24 5 24 13 24 I want the output in following format userid superid

OT RE: Performance analysis (enqueue and buffer busy waits)

possibly the world's most unfortunate name for an application? I see it posted alot. seriously, I think it's a web server or a name for an application? -Original Message- Sent: Wednesday, August 22, 2001 1:06 AM To: Multiple recipients of list ORACLE-L What is unil-bialism ??

Re: URGENT PLEASE ! tns service deletion and recreation

With 8i you could use the net 8 assistant, or manually edit the listener.ora file to make the changes HTH Peter At 09:45 PM 22/08/2001, you wrote: OS: NT 4.0 I need to delete the TNS Listener service . and create a new one . How can I do that ? TIA Bunyamin

RE: linux Oracle -- best combination

Now Caldera is opening up original unix code under GPL (or a modifed version of that), there will be even more fun in various versions that are available freely. Cheers Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot

Re: URGENT PLEASE ! tns service deletion and recreation

Selam Bunyamin, If you don't want to remove them by installer, you can remove by manually. to remove( as I remember ), go to registry: - HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services - HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services - HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services to

SQL*LOADER question.

List, OS Novell 4.2 Oracle 7.3.4.5 I have a table test desc as fld1 number(5,3), fld2 varchar2(1). The control file has ,(comma) delimited, optionally enclosed in (quotes). The data file contains 99.999,C It fails with an ORA-01401: inserted value to large for column. Question. Why did

RE: linux Oracle -- best combination

PostGresSQL has been out for years, and is not RedHat specific, all distributions have included it. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978)

Re: OT: Unix - performance tuning (vmstat 5)

the STIME is always earlier for the command then for the grep, unless I haven't had any coffee. On Wed, Aug 22, 2001 at 04:05:24AM -0800, CHAN Chor Ling Catherine (CSC) wrote: Hi Unix Gurus, I submit a job to monitor the CPU utilization etc every 15 mins using the command vmstat 5.

RE: Unix - performance tuning (vmstat 5)

Can't you just change your grep to additionally pipe into a grep -v grep to exclude the grep vmstat. I'm sure all the unix gurus will give you a much better way but this should work -Original Message- Sent: 22 August 2001 13:05 To: Multiple recipients of list ORACLE-L Hi Unix Gurus,

Re: OT: Unix - performance tuning (vmstat 5)

Hi Have a look at setting the second value with the vmstat command so you use something like vmstat 5 5 instead. This runs vmstat 5 times with a 5 second interval Try it on the command line and see if that is the result you require HTH Peter At 10:05 PM 22/08/2001, you wrote: Hi Unix

tns service error

I am getting the below error where I run STAT or STOP command of LSNRCTL on 8.1.7 on NT. Content of listener.ora is also below. Why is that ? Note : I can remotely connect to this database from client. Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))TNS-12541: TNS:no listenerTNS-12560:

RE: linux Oracle -- best combination

You can download Suse, but you have over 6,000 files to download. It's all in a specific directory on there FTP server. On the other hand, for RH you can just download a few ISO files and burn them into CDs. Easy. I believe that Suse Personal, with CD and manuals, is 30 bucks. I am assuming

RE: Please help me to become DBA

http://technet.oracle.com/index.html Also get the book Oracle DBA 101 by Marlene Theriault, Rachel Carmichael, and James Viscusi. It is an excellent book to start with! Dave -Original Message-From: Ha Duy Thien [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 21, 2001 9:06

OCP Test timeframe

Hello, does anyone know if there is a time limit on exams taken for the OCP DBA 8i track? More specifically, from when the first test is taken, do you have to complete the others in a specified amount of time, say within 1 year? Thanks Traci -- Please see the official ORACLE-L FAQ:

RE: High DML Table - Suggestions??

Partitioning, Parallel Query. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North,

RE: linux Oracle -- best combination

Yeah, the other thing, 6000 files which consist of 500Mb is about 10x slower to download than 1 file which is 600Mb The TCP protocol, ramps, which means, it gets up to speed within the first few seconds of delivery, when your downloading many small files, your bandwidth is cut down by 10 fold if

Freeable memory Chunks

Hi all, When querying the view X$KSMSP can anyone tell me whether memory chunks with a value in KSMCHCLS of 'freeabl' can be used immediately. We currently have an application running against our database which is causing the ORA-4031 error. The app does not make use of shared sql and after

RE: Unix - performance tuning (vmstat 5)

Hi Jaouich, The command kill `ps -ef | grep vmstat |awk '{print $2}'` works. Thanks a million. Peter has also solved the problem for me by advising me to use vmstat 5 5 instead. Regds, New Bee in Unix -Original Message- To: Multiple recipients of list ORACLE-L Sent: 08/22/2001 10:21

RE: sql query

select t1.userid, t1.superid, nvl(t2.count, 0) AS COUNT from onetable t1, (select superid, count(*) as count from onetable group by superid) t2 where t1.userid = t2.superid(+) order by superid; Best regards, Marco -Oorspronkelijk bericht- Van: Seema Singh

RE: OT: Unix - performance tuning (vmstat 5)

Thanks, Peter. U've just solved my problem. Regds, New Bee in Unix -Original Message- To: Multiple recipients of list ORACLE-L Sent: 08/22/2001 9:51 PM Hi Have a look at setting the second value with the vmstat command so you use something like vmstat 5 5 instead. This runs vmstat 5

RE: Performance analysis (enqueue and buffer busy waits)

To keep the rollback segments in buffer, so that rolling around the rollback segments happens before blocks are written to disk. Which will increase snapshot to old, but increase performance. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you

RE: Unix - performance tuning (vmstat 5)

Title: RE: Unix - performance tuning (vmstat 5) I am not sure I understand you question correctly, but here is what I use when I want to kill some jobs ($BATCHJOB = name of the job to kill): kill -9 `ps -ef|grep $BATCHJOB|awk '{print $2}'` If I want to kill all of one user's jobs: su -

OK I HAVE DONE IT.........Re: URGENT PLEASE ! tns service deletion and recreation

OK IU have done it . THANK YOU SO MUCH GURUS. Bunyamin . - Original Message - From: Danisment Gazi Unal (Unal Bilisim)

RE: How do they get the answer?

I want to thank everyone who gave me input on this question. It was most helpful. Ken Janusz, CPIM um, I can see possible answers to this question being 2 teachers, 3 teachers or 4 teachers. however, since that isn't one of the multiple choice answers, then it has to be at least 4

RE: Unix - performance tuning (vmstat 5)

Thats certainly the way I would do it Iain. Lee -Original Message- Sent: 22 August 2001 14:51 To: Multiple recipients of list ORACLE-L Can't you just change your grep to additionally pipe into a grep -v grep to exclude the grep vmstat. I'm sure all the unix gurus will give you a

Re: DBVERIFY on system ts

Mark Marsden wrote: Hi all If I run dbverify on the system ts (or rbs ts AND on different dbs) I get the following: DBVERIFY - Verification starting : FILE = /dpp/test01/HOUR/HOURsystem01.dbf Block Checking: DBA = 67108867, Block Type = Undo data block ERROR: Undo Block Corrupted.

RE: OCP Test timeframe

Hi Traci, There is no time frame from start to finish and as of yet Oracle has no plans in retiring the Oracle 8i track. Rick -Original Message- Sent: Wednesday, August 22, 2001 10:22 AM To: Multiple recipients of list ORACLE-L Hello, does anyone know if there is a time limit on

Re: sql query

Seema: Here's my crack at it: select x.userid , x.superid , nvl(y.count, 0) as count from mytable x , (select a.userid , a.superid , count(*) as count from mytable a , mytable b where

RE: linux Oracle -- best combination

6000 files, what a pita, guess i'll stay with hacking rh to run oracle :) joe [EMAIL PROTECTED] 08/22/01 10:16AM You can download Suse, but you have over 6,000 files to download. It's allin a specific directory on there FTP server.On the other hand, for RH you can just download a few ISO

RE: database upgrade policy?

Highly depends. I tend to stay back from the latest versions for some time. I also tend to upgrade for functionality, and upgrade when I have existing problems that are told to be fixed. Sometimes if I start falling back versions and have no reason either way, I will upgrade my development

RE: checkpoint message

Which as we all know courtesy of Mike Hately, stands for redo trace file manager, now a discontinued feature ... greg -Original Message- Sent: Wednesday, 22 August 2001 03:50 To: Multiple recipients of list ORACLE-L Or just be like me and spend most of the time saying rtfm :) joe

Re: tns service error

Try to add this entry to DESCRIPTION_LIST in your listener configuration file: (ADDRESS = (PROTOCOL = IPC)(KEY = PLNT)) So: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = bunyamin)(PORT = 1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =

Re: Recovering WITHOUT tablespaces - 2001-08-16

SYSTEM objects don't matter, but I wonder how the SYS objects ended up in the TOOLS tablespace. Audit tables perhaps? Jared On Tuesday 21 August 2001 09:16, Kumanan Balasundaram wrote: I was bitten but this badly and thanks to all those people who helped me. This may some of you, so I'm

database upgrade policy?

Hi Listers I'm on 8.1.6.0.0 and wondering about upgrading to 8.1.6.3.1(?) as I get the occasional ORA-600/ORA-7445. Do you upgrade to the latest subversion as a matter of policy (and not test very much) to prevent possible errors or only upgrade if you have problems? Do you upgrade to major

Re: OCP Test timeframe

I have not seen anything of a time frame for the OCP exams. The only time frame is when the next release comes out and the previous release becomes obscolete. I am APICS CPIM certified and APICS has a time limit of about 3 years (?). Ken Janusz, CPIM Hello, does anyone know if there is a

A Trigger question

Dear gurus ! sorry for this RTFMable question , just don't have the docs in front of me here . Assume i have a trigger my_trig that performs an insert into tableB after an insert into tableA . The question is : what happens if the trigger gets broken (either disabled , invalid or unable to do

RE: Index question ???

Title: Message Also a lock will be established on deletes. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73

HELP - How can I limit what program users use to connect?

List, Does anyone know of a method by which I can prohibit users from connecting into my Oracle 8.0.6.0.0 database by any product other than the application's executable program? (i.e. - I don't want anyone connecting through TOAD, etc.) But, I do want to allow anyone with DBA role to be

Oracle 8.1.7 installation and running on RedHet7.0

Hi! I am an Oracle products user (in fact JDBC applications that use Oracle as a backend) but I used them only under Windows platforms. The installation on that kind of platform is pretty simple, but I am not so satisfied with the performances. I have been told that Oracle products

Re: linux Oracle -- best combination

Joe, It's cheap. $60-70 for the pro version. Even though I've been a long time RH user, I prefer SuSE simply for the documentation and admin utils. Jared On Wednesday 22 August 2001 04:50, Joe Testa wrote: I've not really checked out Suse, you have to buy it versus being able to get RH

RE: TNSPING Test Script for NT

Tom, Thanks!! Ed -Original Message- Sent: Tuesday, August 21, 2001 3:13 PM To: Multiple recipients of list ORACLE-L Ed, how about: tnsping {sid} 1000 ping.lis will tnsping the {sid} 1000 times, with the result being placed in a file created named ping.lis changing it to ***

RE: OCP Test timeframe

I think only restriction is you have to wait for sometime(30 days?) before you can re-take a failed exam. Surendra -Original Message- Sent: Wednesday, August 22, 2001 11:11 AM To: Multiple recipients of list ORACLE-L Hi Traci, There is no time frame from start to finish and as of yet

Re: OT: Unix - performance tuning (vmstat 5)

Try this: var_pid=`echo $var_grep_vmstat | grep -v grep | (read u v w x y z; echo ${v} )`kill $var_pid the grep -v grep will remove any lines with the word grep. HTH Stephen [EMAIL PROTECTED] 08/22/01 05:05AM Hi Unix Gurus,I submit a job to monitor the CPU utilization etc every 15 mins

Re: database upgrade policy?

On Wed, Aug 22, 2001 at 07:45:27AM -0800, Mark Marsden wrote: Hi Listers I'm on 8.1.6.0.0 and wondering about upgrading to 8.1.6.3.1(?) as I get the occasional ORA-600/ORA-7445. Doc ID: Note:123178.1 Product / Platform: Oracle8i, Release 2 (8.1.6) Error Correction Support ends on:

RE: checkpoint message

I still think it's redo block address! -Original Message- Sent: Wednesday, August 22, 2001 12:50 AM To: Multiple recipients of list ORACLE-L Kevin, Thanksclarity is always preferable. As for the acronym inflationI guess when I wrote block instead of byte, I simply hadn't

Re: linux Oracle -- best combination

and its only 2.3K :) guess i'm spoiled being able to grab darn near anything that oracle has from technet. joe [EMAIL PROTECTED] 08/22/01 11:00AM True, but now RedHat pushes it as the 'Red Hat Database'...http://www.redhat.com/products/software/database/Christopher Spence wrote:

RE: checkpoint message

These messages will show up in your 8.0.x database if you have set log_checkpoints_to_alert=TRUE. This gives you an easy way of seeing how long it takes to complete a checkpoint and if any are happening between log switches. Mike Hand Polaroid Corp -Original Message- Sent: Tuesday,

RE: Disaster recovery

I need to do some documenting too. Person probably driving the bus ;-) (That person thats been stalking you) Oracle Versions Patches installed File system layout Instances mapped to Oracle Homes log files (methods for checking/trimming) scripts/tools (what/where/when/why) listener info

Re: Recovering WITHOUT tablespaces - 2001-08-16

how about this as a solution: alter user sys default tablespace tools; @?/rdbms/admin/Put SCRIPT HERE :) joe [EMAIL PROTECTED] 08/22/01 12:02PM SYSTEM objects don't matter, but I wonder how the SYSobjects ended up in the TOOLS tablespace.Audit tables perhaps?JaredOn Tuesday 21 August

RE: database upgrade policy?

Title: RE: database upgrade policy? Don't upgrade unless there is a very good reason. All of these are candidates 1. current oracle version is unstable 2. specific bug addressed by an upgrade/patch, as identified by support 3. need to utilize new feature 4. desupport date coming up. If

RE: linux Oracle -- best combination

Title: RE: linux Oracle -- best combination Have you tried an index hint on the first query yet? Have you tried NVL(cmm_id,101) = 101, NVL(cust_id,101) = 101 NVL(Friendly_session_id,100) = 100 loc_to_utc(NVL(creation_date,21-jun-2001')) between your dates? -Original Message-

Re: linux Oracle -- best combination

granted $60 is not much but its A LOT more than free :) joe [EMAIL PROTECTED] 08/22/01 11:56AM Joe,It's cheap. $60-70 for the pro version.Even though I've been a long time RH user, I prefer SuSEsimply for the documentation and admin utils.JaredOn Wednesday 22 August 2001 04:50, Joe Testa

HDD crashed

Hi, my hdd (c:) on server running NT4.0 has been corrupted. Is it possible to move Oracle db files on other server running linux(!!!), create instance and mount - open all db files (not only system)?. Thanks Jan Pruner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Drill-thru question

Hi, I am a newbie to this OLAP area. I have this table (company_dimension) where every company has a parent, which in turn can be a child to another parent and so on. It is about 10 levels deep. TEST@D0MARS desc company_dimension NameNull?Type

Re: A Trigger question (LENGTHY!)

Yes. I was curious, so I did a little test: Create 3 tables. Note the different datatypes. SQL create table dbm_1 2 (a varchar2(5) not null); Table created. SQL create table dbm_2 2 (a number not null); Table created. SQL create table dbm_3 2 (a varchar2(5) not

RE: linux Oracle -- best combination

We're trying to re-write some SQL such that the index on columns in the where clause is used.Logically ,the query is as below .But this query does not use the Index .However ,if we re-write it as below(see 2nd query) - the index is used :but the query returns incorrect results .Can you suggest

Automating or scheduling backups from OEM on NT 4.0

Hi DBA's, I've recently completed several SQL*Plus scripts and Batch files to do Hot backups of our production Oracle 8.0.5 database at 8am, 12pm, and 5pm daily. Currently, I have to double click the batch file icon which calls SQL*Plus and executes the backup script. I tried unsuccessfully to

RE: database upgrade policy?

We were running 8.1.6.0.0 and just recently encountered the ORA-7445 errors, which caused core dumps and invalidated the referential integrity of our database. Oracle recommended the 8.1.6.3 patchset. We decided to skip that and go for 8.1.7 but for some reason Oracle mailed us the 9i CDs. I

RE: User access within/outside of app

Title: RE: User access within/outside of app What version are you working with? -Original Message- From: Larry Hahn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 21, 2001 11:21 AM To: Multiple recipients of list ORACLE-L Subject: User access within/outside of app List,

Delete Alertlog on NT

Is there any problem deleting the alert log on NT while the instance is up and running? V7.3.4 - 8.1.6 Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Re: A Trigger question

Tsk, tsk Andrey, this doesn't even require RTFM. :) create table a; ( insert your columns here) create table b; ( insert your columns here) create trigger a_insert_b; ( your trigger code here ) alter trigger a_insert_b disable. insert into a(columns) values(your values). And, the docs are

Re:HDD crashed

Jan, Only if you have a full export of the database. Moving just the files to Linux will not work since NT and Linux use different ways of writting to disk. Dick Goulet Reply Separator Author: Jan Pruner [EMAIL PROTECTED] Date: 8/22/2001 8:51 AM

Re: HDD crashed

You can not move db files between different OSs. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 22, 2001 12:51 PM Hi, my hdd (c:) on server running NT4.0

Re: HELP - How can I limit what program users use to connect?

I don't think you can do it in 8.0.6. Starting with 8.1.5 you could use db logon triggers. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 22, 2001 12:16 PM

RE: database upgrade policy?

a a glutton for punishment. Dev, sure why not, just dont let the developers get to attached to the new features, prod?, i wouldnt update any prod database(unless forced to by oracle corp) until 9.1 at earliest, yes there are some kewl things, but heck the latest 8.1.7 patchset has 22

RE: Delete Alertlog on NT

No you can delete it anytime and Oracle will recreate it. Rick -Original Message- Sent: Wednesday, August 22, 2001 1:27 PM To: Multiple recipients of list ORACLE-L Is there any problem deleting the alert log on NT while the instance is up and running? V7.3.4 - 8.1.6 Ron Smith --

data modeling processes

Hi, I am looking for some examples of DFD(data flow diagram), BPM(business process module), and SOW(statement of work); some web-pages with examples would be great. If someone can point those I would appreciate it. Thanks. Lyuda Hoska -- Please see the official ORACLE-L FAQ:

Re: HELP - How can I limit what program users use to connect?

You can use a password protected role which is only enabled in the executable using a stored package that executes dbms_session.set_role. The package checks which program name invoked it be querying v$session.program. If the role is not enabled, users not granted the role do not have access to

Locking Issue

Back to the experts We have an application that, litterally overnight, developed locking issues. Our users start working just fine. Then, right now cause unknown, our inserts start being blocked. Usually there are so many so fast that we do not even know what is

Re: Locking Issue

check out $ORACLE_HOME/rdbms/admin/utlockt.sql joe [EMAIL PROTECTED] 08/22/01 02:46PM Back to the experts We have an application that, litterally overnight, developed locking issues. Our users start working just fine. Then, right now cause unknown, our inserts start

RE: database upgrade policy?

Lisa, You need some work to do Certifiable Gimp Monkey?? Stub you toe while swinging on the trapeze? ROR mô¿ôm [EMAIL PROTECTED] 08/22/01 12:45PM Don't upgrade unless there is a very good reason. All of these are candidates 1. current oracle version is unstable 2. specific bug

re: win2k scripting

lk- sorry no specifics, but here are some pointers you might find useful: http://www.ultratech-llc.com/KB/?File=TaskSched.TXT - http://www.ultratech-llc.com/KB/Scripts/?File=!Contents.TXT - http://www.ultratech-llc.com/KB/?File=Scripting.TXT Also, general info:

Re: HELP - How can I limit what program users use to connect?

Hi Ken, AFAIR you can limit connections via SQL*+ not sure though it'll work for TOAD and other 3d party products. Try to find pubbl.sql(?) (sorry don't remember the exact name). It's one of the standart scripts you're supposed to run while db creation. It creates a couple of profile tables and

  1   2   >