OSUSER v 9.2.0.2 on linux

a field DELETED_BY that would contain the osuser performing the deletion. What do I need to query as part of that trigger to capture that single osuser? Thanks much! lc -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lisa R. Clary INET: [EMAIL PROTECTED] Fat City Network

RE: OSUSER v 9.2.0.2 on linux

','OS_USER') from dual; On 01/07/2004 03:14:32 PM, Lisa R. Clary wrote: Hi all, Can anyone point me in the direction on how to isolate the osuser for a single session? (I do know about V$SESSION). What I am trying to accomplish is when a delete is made on a table, I want my trigger to push that old

Updates Through Views DBv9.2.0.2

something. Any ideas? thanks, lc -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lisa R. Clary INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Views Resources (7.3.4 DB)

recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, December 01, 2002 2:18 PM Lisa R. Clary wrote: I have 3 individual views (average #records=76,000) with the exact same variable names and datatypes. There is another view that is the union of the 3 individual views. If I use a count

Views Resources (7.3.4 DB)

I have3 individual views (average #records=76,000) with the exact same variable names and datatypes. There is another view that is the union of the 3 individual views. If I use a count(*) operation (in sqlplus) on the view that is the union (or the individual view), I run out of temp space

RE: Whitepapers on Triggers

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa R. Clary INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Help find pk dependencies 7.3.4 db

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa R. Clary INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Help on Temp Space

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa R. Clary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: undeliverable email - Yo Jared

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa R. Clary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Database Normalization-Outdated?

to discuss the issue with the consultant without totally bashing the idea--maybe even changing the model to a hybrid (if I am lucky). I am always interested in hearing more on this if anyone else cares to share experiences--the more fuel, the better. Thanks again! lc -- Lisa R. Clary Children's

Database Normalization-Outdated?

concrete (aside from the textbooks I used in school) ...it will happen (after all, he is published!) Or maybe someone can tell me where I can take a course in this style of database modeling. thanks for your input lc -- Lisa R. Clary Children's Oncology Group Data Center 104 N. Main Street, Suite

Datafile/Tablespace creation....

delete the datafile (at the OS level) without repercussion? Nothing recognizes the datafile (e.g. select * from dba_data_files, OEM, TOAD). thanks, lc -- Lisa R. Clary 104 N. Main Street, Suite 600 Gainesville, FL 32601 (352) 392-5198 x 312 (352) 392-8162 (fax) -- Please see the official ORACLE-L