RE: OCP Exams - What to study out of?

Title: OCP Exams - What to study out of? Thanks to everyone for their input. I am considering the 8i track. a. Because I work mainly with the 8i DB. b. I hear that for the 9i a attendance of a course is a prerequisite.    Regards Denham -Original Message-From: Denham Eva [mailt

/opt/oracle/product/jre/1.1.8/bin/jre

Hi all, Can I set this file to r-xr-xr-x ? rwxrwxrwx /opt/oracle/product/jre/1.1.8/bin/jre Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatci

RE: SQL Brain Teaser Challenge

Steve: Unfortunately, I didn't have time to experiment with this Teaser, but I was glad (real glad) to see that several "great" minds made the attempt. I could use all of you to help teach my students how to use their minds to solve problems like this. Ok. Now back to work folks. See you at

Re: suggestion w/c platforms to choose from...

database will be used for oltp and data mart # of users -- 200 very critical, since order taking , purchase order and accounting module,hr will run on it.. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, November 05, 2002 9:03 PM > As

RE: SQL Brain Teaser Challenge

> I have a solution which doesn't rely on hints, but I am not very > satisfied with it either. Innovative nonetheless. Another cool way to skin this cat. Thanks! Steve -Original Message- Sent: Tuesday, November 05, 2002 5:14 PM To: Multiple recipients of list ORACLE-L Importance: High

Re: SQL Brain Teaser Challenge

"Orr, Steve" wrote: > > > What do I win? > This was stated in the very first post... kudos. :-) > At the moment you and Rich Jesse are tied but I'm still not very pleased > with the solution. But unless somebody comes up with something better I'll > box you up some kudos for shipping. (I afraid to

Oracle9iAS Web Cache Denial of Service (a102802-1)

FYI - Forwarded by Jared Still/Radisys_Corporation/US on 11/05/2002 03:12 PM - "@stake advisories" cc: Subject:Oracle9iAS Web Cache Denial of Service (a102802-1) -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 @stake, Inc.

Oracle iSQL*Plus buffer overflow vulnerability (#NISR04112002)

Alert available at: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=216775.1 - Forwarded by Jared Still/Radisys_Corporation/US on 11/05/2002 03:11 PM - "NGSSoftware Insight Security Research" <[EMAIL PROTECTED]> 11/04/2002 09:48 AM

RE: SQL Brain Teaser Challenge

Steve, I thought kudos was the codename for the latest and greatest Palm Pilot. : -) As I said - it's not a nice solution, it has it's limits, but it works on Oracle 8i (and should work on other versions as well) Regards, Mark. PS: For the sake of completeness - the parentid of node 11 sh

RE: SQL Brain Teaser Challenge

Kevin, Like I said - as long as the table access is via the index then all rows are returned in nodeorder (sorted globally). The connect-by clause then orders the result set hierarchically. When searching for children of a parent it will find them in correct nodeorder order. It works for an inf

RE: SQL Brain Teaser Challenge

> What do I win? This was stated in the very first post... kudos. :-) At the moment you and Rich Jesse are tied but I'm still not very pleased with the solution. But unless somebody comes up with something better I'll box you up some kudos for shipping. (I afraid to ask but what are kudos anyway?)

RE: SQL Brain Teaser Challenge

WOW. This actually works quite well!!! All this business is for generating an HTML tree navigation object using SQL, Perl-CGI, and javascript (from www.treeview.net) and it's critical that everything appear in the right order or the javascript will fail miserably. I hate to be dependent on indexes

Re: Partition Question

I agree... What are you trying to accomplish with partitioning? Partitioning by year / month / day / whatever can make it easy to truncate / archive old data. The only trick is to create new partitions before they are required. Another goal of partitioning may be query execution. You might part

RE: SQL Brain Teaser Challenge

Very good Mark. It worked even with the new subfolders added. I have no idea WHY it worked ... but it did. ID PARENTID NODEORDER DESCRIPTION -- -- -- 1 0 0 top folder 9 1 0 1st subfold

RE: SQL Brain Teaser Challenge

Steve, I've answered this one before (not on this list) for an Oracle 8i database... I guess the truth is that you really can't guarantee it, but it can be tricked with a hint. The trick is to access the table in correct sibling order. Create an index on the nodeorder column and then use an ind

RE: SQL Brain Teaser Challenge

actually - i think you are correct. the "Nested-Set Model of Trees" as Celko calls it would require more maintenance than the traditional parentid column when the tree changes... but the advantages on the query side are interesting. that nodeOrder column takes you on a ride. looks to me like yo

RE: SQL Brain Teaser Challenge

Steve, I'm not sure why as of yet, but I had some success by creating two segmented indexes. One on PARENTID, NODEORDER and the second on NODEORDER, PARENTID: ID PARENTID NODEORDER DESCRIPTION 1 00 top folder 9 10 1st subfolder 2 11 2nd subfolde

RE: OCP Exams - What to study out of?

Ken - Wow, I'm impressed. I took and passed one APICS module years and years ago and I can testify that they aren't easy. And I took the module related to my daily job. Can you share any tips on how to study for the SQL exam? I find I learn MUCH more from someone that was forced to reassess thei

RE: Clone Production Server to Stand by Server on 8.1.7 on Win 2k

Hi Arif, Please read the article Note: 76373.1 on Metalink about Standby database. Regards, Quamrul Polash From: "Arif Khan (GWL)" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Clone Production Server to Stand by Serve

RE: SQL Brain Teaser Challenge

I wondered if someone would try that. :-) The link you provided is interesting but I don't think it fits the needs as regards being able to add and rearrange nodes. (Maybe I got confused with the little worms.) This is because the right column has to be twice the number of rows and this number wou

RE: SQL Brain Teaser Challenge

Other posts should answer most of your questions. Jared's answer assumes only three levels and doesn't work when we add levels or branches to the tree. ID is a system generated key and has no meaning. SQL only, no SQL*Plus stuff. NODEORDER only refers to the sort within a node because you should no

RE: Read Only Login with Source Visibility

Depending on the tool, that may not work. It wouldn't work with SQL Navigator, or MS Access. Jared "Mercadante, Thomas F" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/05/2002 10:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED

RE: Clone Production Server to Stand by Server on 8.1.7 on Win 2k

Hello Jared If I run the database in Standby mode, once my production server fails, can the standby database be opened for users to make changes (i.e. read an write) and how do I accomplish that. Also, once my production server is back on line, how do you suggest I should synchronize the producti

RE: SQL Brain Teaser Challenge

Okay, my answer was almost correct (almost correct = wrong). Jared's answer is right on, given the current data set. What happens when the data is changed? Does ID have meaning or is it the sequence in which the row was added? NODEORDER is 'sequential', but the starting values vary within the pare

RE: SQL Brain Teaser Challenge

I was also able to confirm this works on O9i. -Original Message- Sent: Tuesday, November 05, 2002 11:14 AM To: Multiple recipients of list ORACLE-L I get an error on 8.1.7.2. Is "siblings" new? SQL> l 1 SELECT LEVEL, treenode.* 2FROM treenode 3 START WITH parentid=0 4 C

RE: SQL Brain Teaser Challenge

and i got this to work: SQL> select * from treenode; ID PARENTID NODEORDER DESCRIPTION -- -- -- 1 0 0 top folder 9 1 0 1st subfolder 2 1 1 2nd subfolder

RE: OCP Exams - What to study out of?

Paula - You're losing me on the connection between SQL and GUI. I can see a connection between command-line DBA actions and GUI DBA tools. And some GUI report writing tools create SQL for you, but usually we DBAs are called when it creates bad SQL code and we must straighten it out. So have

RE: SQL Brain Teaser Challenge

Well it works but your query assumes knowledge of the tree- that it will always only have 3 levels. Consider when I add the following 2 rows: insert into treenode values(10,3,1,'nested folder2.2.1'); insert into treenode values(11,10,2,'nested folder2.2.2'); Now it fails. SORRY I wasn't clear on

RE: SQL Brain Teaser Challenge

Hey Raj, Ever paranoid of a ruse I had to see for myself that your query worked on O9i and not O8i. I cranked up my O9i test server and confirmed it does indeed work on 9i and not 8i. (See below.) I'm still looking for a way to get this to work on O8i. In the meantime I'll submit a TAR but I hate

Re: OCP Exams - What to study out of?

I agree that the SQL exam is very difficult. I've taken it twice and missed passing by just a couple of points. But I will persist. Interestingly enough when I got my APICS CPIM certification I took six exams and passed them all on the first try. The passing grade is 90%. Ken Janusz, CPIM ---

Re: ORA-02050

On Tue, Nov 05, 2002 at 09:24:04AM -0800, Yechiel Adar wrote: > There is another view, DBA_2PC_NEIGHBORS. > Maybe there is some info there. No, the transaction was rolled back completely, or perhaps it resynced when the remote db recovered and thus covered the tracks. This is a good thing. I am

RE: SQL Brain Teaser Challenge

Nope... SQL> l 1 SELECT * 2FROM (SELECT * FROM treenode ORDER BY parentid, nodeorder) 3 START WITH parentid=0 4* CONNECT BY PRIOR ID = parentid SQL> / FROM (SELECT * FROM treenode ORDER BY parentid, nodeorder) * ERROR at line 2: ORA-01472: cannot use CONNECT B

RE: SQL Brain Teaser Challenge

Nope... (select id, parentid, nodeorder, description from treenode start with parentid=0 connect by prior id = parentid) order by nodeorder; ID PARENTID NODEORDER DESCRIPTION -- -- -- 1 0 0 top folder 9

RE: SQL Brain Teaser Challenge

Title: RE: SQL Brain Teaser Challenge SELECT *   FROM (SELECT * FROM treenode ORDER BY parentid, nodeorder) START WITH parentid=0 CONNECT BY PRIOR ID = parentid Does this work? Also see http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:9212348049 Raj ___

RE: SQL Brain Teaser Challenge

Well it worked but it doesn't follow the rules. The description can change so it should not be sorted on. Consider this: update treenode set description='2nd item, 3rd folder' where id=8; select * from treenode order by translate(description || 0, '0123456789abcdefghijklmnopqrstuvwxyz ', '01

RE: SQL Brain Teaser Challenge

You still haven't answered the challenge... your results are in a different order than the desired results I gave at the bottom. The idea is to have the children appearing immediately after the parents in the correct order. -Original Message- Sent: Tuesday, November 05, 2002 11:57 AM To:

RE: OCP Exams - What to study out of?

The Cloverleaf product I know is from Quovadx. One of its usages it provides an interface between Healthcare systems and Oracle(many other DBMS). For ex. we use to interface with hospitals sending data in standard HL7 format and Cloverleaf interprets HL7 format and data is loaded directly into

RE: SQL Brain Teaser Challenge

Title: RE: SQL Brain Teaser Challenge Whoa... A query that works on 9i but fails on 8i  !!!   -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 05, 2002 12:19 PMTo: Orr, Steve; '[EMAIL PROTECTED]'Subject: RE: SQL Brain Teaser Ch

RE: SQL Brain Teaser Challenge

Title: RE: SQL Brain Teaser Challenge Steve, I did try it ... oraclei@rhea-ACPT1> sys SQL*Plus: Release 9.2.0.1.0 - Production on Tue Nov 5 14:18:02 2002 Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved. Connected. SQL> conn system Enter password: Connected. SQL> SELECT

RE: SQL Brain Teaser Challenge

How about... SELECT t.id , t.parentid , t.nodeorder , t.description FROM treenode t CONNECT BY t.parentid = PRIOR t.id START WITH t.description = 'top folder' ORDER BY NVL ( TRIM ( TRANSLATE ( LOWER (t.descri

RE: SQL Brain Teaser Challenge

Title: RE: SQL Brain Teaser Challenge select * from treenode order by translate(description || 0, '0123456789abcdefghijklmnopqrstuvwxyz ', '0123456789') Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From:   Orr, S

RE: SQL Brain Teaser Challenge

I love a good challenge. Since you cannot sort on a hierarchical query, you have to use an inline query... select id, parentid, nodeorder, description from (select id, parentid, nodeorder, description from treenod start with parentid=0 connect by prior id = parentid) order by parentid, nodeo

Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE

Did I say LGWR trace file? I meant ARCH trace file, sorry. jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/05/2002 10:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: ORA-19502 ON RA

Re: SQL Brain Teaser Challenge

Steve, This works for me. Jared col nodelevel noprint col parent noprint col child noprint select a.nodelevel , a.id id , a.parentid , a.nodeorder , a.description , decode(c.children,null,'N','Y') parent

RE: SQL Brain Teaser Challenge

Title: RE: SQL Brain Teaser Challenge Steve, I'm busted! You caught me cheating. Still you must admit it was an interesting use of TRANSLATE given the data in the DESCRIPTION field. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Me

Re: SQL Brain Teaser Challenge

Steve, This works for me. Jared col nodelevel noprint col parent noprint col child noprint select a.nodelevel , a.id id , a.parentid , a.nodeorder , a.description , decode(c.children,null,'N','Y') parent

RE: OCP Exams - What to study out of?

Title: RE: OCP Exams - What to study out of? I took the SQL exam first and had no problems although I have heard others have.  I think it has to do with how I learned - I forced myself to use SQL before getting hooked into a GUI tool of any kind.  In the long-run that is a good approach as you

RE: Read Only Login with Source Visibility

better yet - create a local copy of it, and place a private synonym in their account to point to it. really sneaky. -Original Message- Sent: Tuesday, November 05, 2002 12:24 PM To: Multiple recipients of list ORACLE-L Rewrite the all_source view, and I believe the all_objects view. It

Re: SQL Brain Teaser Challenge

Does an in-line view do the trick? select * from (select id, parentid, nodeorder, description from treenode start with parentid=0 connect by prior id = parentid) order by nodeorder; Jay >>> [EMAIL PROTECTED] 11/05/02 12:24PM >>> Challenge: present SQL results hierarchically and sort the nodes. Us

Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE

Thanks Jared. I forgot to mention that the SA checked for device errors. None found. A tar has been opened is already on it's way to higher support level. This problem occurred again today, third time in two weeks. Also, the database is up, only the ARCH process is dead. I started the ARCH (arc

Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE

Yechiel, What about those alert log entries? Jared "Yechiel Adar" <[EMAIL PROTECTED]> 11/05/2002 10:38 AM To: "ORACLE-L" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> cc: Subject:Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE

Re: ORA-02050

There is another view, DBA_2PC_NEIGHBORS. Maybe there is some info there. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, November 05, 2002 5:58 PM > On Tue, Nov 05, 2002 at 06:33:44AM -0800, [EMAIL PROTECTED] wrote: >

RE: SQL Brain Teaser Challenge

I get an error on 8.1.7.2. Is "siblings" new? SQL> l 1 SELECT LEVEL, treenode.* 2FROM treenode 3 START WITH parentid=0 4 CONNECT BY PRIOR ID = parentid 5* ORDER SIBLINGS BY PARENTid , nodeorder SQL> / ORDER SIBLINGS BY PARENTid , nodeorder * ERROR at line 5: ORA-00924: miss

Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE

Yechiel, No OS errors here. You may want to look at the LGWR trace file in the BDUMP directory. 2 things 1) Have the SA check for device errors. Something in the IO system is not working. 2) Open a TAR. If you have another location to redirect arch logs to, you may want to do that. The foll

dispatcher timer & virtual circuit status top of wait events/no M

Hi All, Above two events are at the top of my wait events in one of my databases. Does anybody have an idea what would be the reason? Oracle 8.1.6.0.0 Jack -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Se

BMC's dtoarchmon goes to lunch

Hi. We are running Oracle 8172 on Dynix 452 and backing it up via BMC's obacktrac 3.0.0.6. Since we upgraded the OS and obakctrack dtoarchmon started dying. The process either disappears altogether or doesn't wake up to start an archive backup when it should. The dtoachmon -ping shows that everyth

Re: Read Only Login with Source Visibility

Rewrite the all_source view, and I believe the all_objects view. It's a pain in the rear, but it can be done. It also tends to break when you upgrade. I did this once on Oracle 7, there may be some other workaround now on 8i. Jared Bill Buchan <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED

Re: Clone Production Server to Stand by Server on 8.1.7 on Win 2k

First off, your process is doing a lot of unnecessary work. Standby databases are available in 7.3.4. I believe that would be somewhat simpler than your current procedure. I haven't tried it though, so I could be wrong. Even with your current procedure, you don't need to copy all of the files,

RE: SQL Brain Teaser Challenge

Title: RE: SQL Brain Teaser Challenge SELECT LEVEL, treenode.*   FROM treenode  START WITH parentid=0 CONNECT BY PRIOR ID = parentid ORDER SIBLINGS BY PARENTid , nodeorder Raj __ Rajendra Jamadagni      MIS, ESPN Inc. Rajendra dot

Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE

Hello Charlie and Jared Thanks for the reply. As I mentioned in my mail there is a lot of free space on the disk and the database is with auto archive. Our problem is that the ARCH process gives an error message (ora 19502) and stop. There are messages on the console about error trying to write t

Re: suggestion w/c platforms to choose from...

How about a 400 CPU nCube running Oracle 9i RAC? If they still support nCube that is. ( Larry owns nCube ) Seriously though, does your app maintain HR data for 500 people, or is it a 20TB Data Warehouse? These apps may require different HW configurations. Jared "grace" <[EMAIL PROTECTED]

SQL Brain Teaser Challenge

Challenge: present SQL results hierarchically and sort the nodes. Use sort column without changing data. Here's the DDL/DML to start: create table treenode ( id number not null constraint pk_treenode primary key, parentidnumber

Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE

Here is parts of the alert log: Current log# 6 seq# 4153 mem# 0: D:\ORACLE\ORADATA\MUSK135\DATABASE\LOGM1356.ORA Sun Nov 03 11:03:34 2002 ARC0: Beginning to archive log# 5 seq# 4152 ARC0: Completed archiving log# 5 seq# 4152 Sun Nov 03 11:10:33 2002 Thread 1 advanced to log sequence 4154 Curre

Re: ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE

Yechiel, What appears in the archive log? There is very likely to be some OS errors included. Jared "Yechiel Adar" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/05/2002 12:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

Enterprise Manager Console -> Export problem

Hello I run Oracle 8.1.6 on Win 2k (Both standard ed.). I am trying to run the export wizard through the Enterprise Manager Console by doing the following: Under Database folder, I right click the Global Name (say ORCL) -> Data Management -> Export ... and it comes back with the error Either Prefe

RE: OCP Exams - What to study out of?

Eva - Everything I've heard says that all the exam questions come out of the Oracle University class Student Guides. To put it bluntly, your goal is to pass the exam. You could study the Oracle manuals, but there is a lot of material to cover and what strikes you as important might not be covered o

Re: Clone Production Server to Stand by Server on 8.1.7 on Win 2k

Hello You did not write if you bring both databases on every night or the backup is down until needed. If it is down you have no problem. If you bring both up you can change the global name : Alter database rename global_name to backupdb; BTW - I am not sure that 8.1.7 need global_name=true. We a

Re: ORA-02050

On Tue, Nov 05, 2002 at 06:33:44AM -0800, [EMAIL PROTECTED] wrote: > Ray, > I think you need to check DBA_2PC_PENDING on both the local and remote > database to see if anything is still in there. > That gives the osuser, terminal and host name so you may be able to get > something from that. > Of c

RE: OCP Exams - What to study out of?

Title: RE: OCP Exams - What to study out of? Guys, anyone know about an application called Cloverleaf?  Basically, my organization is pursuing using Cloverleaf as the data integration sole application of choice.  To me Unix/SQL*Loader and native tools for the various RDBMS usually are more str

Clone Production Server to Stand by Server on 8.1.7 on Win 2k

Hello We currently have two Identical servers (identical in terms of both Hardware and SW). We run Oracle 7.3.4.0 (Workgroup server) on Win NT 4 on both the servers. We call them as Production Server and Stand by server. The Stand by server is passive in nature (i.e. does not do anything). Every n

RE: Unkillable Background process "SHUTDOWN ABORT LEAVES UNKILLAB

I once used a product like this called First Watch, but I called it automatic failover rather than clustering. The product provided a redundant "heart beat" monitoring; but the user had to set up the configuration files and write and maintain any scripts that controlled the failover. What we dis

RE: MTS process HIGH CPU

That process has an oracle session associated with it. Before killing it, it would be nice to see what that session is doing. You could do it by joining v$process and v$session. The SPID column in v$process is "System PID" and ADDR column corresponds to the PADDR in V$SESSION table. > -Origin

Re: Read Only Login with Source Visibility

Hi Bill > I am trying to create a read-only login, RO_USER which can do the following: > 1. See all tables, views, constraints etc. in one *specific* other schema, > 2. See all the source for PL/SQL objects in APP. Is what you really want is a way for users to be able to see the DDL and PL/SQL w

RE: ORA-02050

Ray, I think you need to check DBA_2PC_PENDING on both the local and remote database to see if anything is still in there. That gives the osuser, terminal and host name so you may be able to get something from that. Of course if there is nothing in that table then the transaction has been rolled ba

RTIF Interface

What is an RTIF interface?  I looked on Acronym Finder and it didn't find it in it's database.   Thanks, Ken Janusz, CPIM

RE: OCP Exams - What to study out of?

Denham, I have just passed my 8i upgrade exam and added some notes to a page about getting OCP certification. It can be accessed on http://www.hcresources.co.uk/ocp.htm Hope you find it interesting John -Original Message- Sent: 05 November 2002

Re: Read Only Login with Source Visibility

How about redefining copies of the relevant data dictionary views for RO_USER to suit your purposes? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, November 05, 2002 5:48 AM > Hi all, > > I am trying to create a read-only login, RO_USER

ORA-02050

ORA-02050: transaction 8.82.26033 rolled back, some remote DBs may be in-doubt The transaction seems to have completely rolled back. My question is, is there any way to relate transaction id 8.82.26033 to an application or table row or something at a higher layer? Thanks. =

RE: OCP Exams - What to study out of?

Title: OCP Exams - What to study out of? I only studied the Coriolius books and done the self-exams (which are harder then the real one) and passed with 85+% each time.  I think the course materials were not as concise as the Cor. books.  I believe you can get some of those books still on Am

RE: suggestion w/c platforms to choose from...

How about considering what OS skills your systems admins already have? Do they have experience with HP/UX, or Solaris, or NT/2000 type systems etc.? How big is the database? How many users will it have? What will the database be used for? How much money do you have to spend? Mark -Original

Re: suggestion w/c platforms to choose from...

As a rule buy the biggest, meanest, fault tolerance, with gigabytes of memory and terabytes of disk storage that you can buy. If you will provide more data about: 1) The size of the database 2) How many users 3) How critical is the system 4) The use of the system - data warehouse, OLTP etc then

Read Only Login with Source Visibility

Hi all, I am trying to create a read-only login, RO_USER which can do the following: 1. See all tables, views, constraints etc. in one *specific* other schema, APP. 2. See all the source for PL/SQL objects in APP. The first bit is easy: GRANT SELECT on tables, views to RO_USER. Not sure abou

suggestion w/c platforms to choose from...

hi, can anyone suggestion w/c platform should i used to run oracle? wat are the things to consider in choosing platform? thanks Best regards, Grace Lim MIS Department Suy Sing Comm'l Corp. T- (632)-2474134 F- (632)-2474160 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Auth

OCP Exams - What to study out of?

Title: OCP Exams - What to study out of? Hello Everyone, 1. I have now made the humungous decision to start studying and to write the OCP exams. 2. Do I study out of the Oracle Manuals? 3. I do have the Sybex Study Guides, would studying these be all that is needed? 4. Or do the questions c

RE: User Log-Machine Name

audsid = SYS_CONTEXT('USERENV', 'SESSIONID') You could have guessed it :-). >- Original Message - >From: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Tue, 05 Nov 2002 00:23:28 > >Hello > >A user log is maintained for a table.I want to log >all u

RE: User Log-Machine Name

Hei... Inside trigger block, using userenv('terminal') you can identify the machine name. One oracle user can have multiple active sessions. (Here in my team, 5 people working on the same oracle username with different machines. The privileges are set for them at application level.) HTH. Nir

ORA-19502 ON RAID 5 DISKS WITH ENOUGH FREE SPACE

Hello All Oracle 8.1.6.3.4 on NT. I got ora-19502 - can not write archive log, and users could not logged on. I can logon only as internal. We had the same problem a few days ago. The technical support people checked the raid 5 disks and did not find any I/O errors. There is a lot of free space o

RE: Relation Between Oracle Sessions

Title: RE: Relation Between Oracle Sessions Hi Justin, We have our application in the form of a menu, with all the different modules written on top in the form of menus. Now with call-form property (which we use now in our application), only one form can be opened as the menu is disappeared

RE: Relation Between Oracle Sessions

Hussain, This is just from the top of my head and therefore requires careful checking, but I presume that if you are not using MTS then the 2nd generation session must be initiated by your shadow process (hope you are under Unix!). V$SESSION holds the OS process id of the program on the 'cli

RE: Unkillable Background process "SHUTDOWN ABORT LEAVES UNKILLAB

Hi Stephen, Sun Clustering basically quite simple (I think) :) an Oracle user dedicated to this software use to monitor (do query for certain system tables) the existence of the db if anything wrong than this so call fault monitoring will do shutdown abort and release the mount points for se

User Log-Machine Name

Hello A user log is maintained for a table.I want to log all updations made to this table. I have written a database trigger (After Update) to log the changes to another table.My requirement is to find the machine name from which the updation has occurred and log the machine name also . How to ge