LogMinor Question

to denormalized tables on reportable database. Has anybody done similar? I found bits and pieces but no real examples how to extract only the data that I need. I am running 8.1.6 on Solaris. Thank you. Sergei. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sergei INET

strange issue with setting transaction

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

RE: Need help Reformatting output. Additional comments

2 a 5 15 b 10 20 Since I doubt that it is impossible to do it using one query, I probably will need to use a procedure returning me results as one, so it will be displayed on the web-page. Thank you. Sergei -Original Message- Alkaakati Sent

Need help Reformatting output

Title: RE: Active sessions chewing up a huge amount of RAM I am looking for a way to display rows as columns. For example: Id name value 1 a 5 1 b 10 2 a 15 2 b 20 I need it as: name 1 2 a 5 15 b 10 20 Thank you in advance Sergei.

Partition Info

Hello everybody. I have a number of tables with range by date partitions. I need to write a script to monitor the latest partitions and send me an e-mail if it's close to a current date. I am just looking for tables or views that will help me find out the date of the last partition. Sergei

RE: Partition Info : thank you

Got it -Original Message- Neyman Sent: Monday, December 02, 2002 1:45 PM To: Multiple recipients of list ORACLE-L Sergei Check HIGH_VALUE column in DBA_TAB_PARTITIONS and compare it to current date. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple

SQL tuning help

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

RE: SQL tuning help

f.subsite_id = tmp.subsite_id and f.fastcash_id = tf.fastcash_id and f.verified = trunc(sysdate-1) and f.verified trunc(sysdate) group by tmp.subsite_id); transaction_fastcash table has 2.5M records fastcash table has 50M record Thank you Sergei -Original Message- From

RE: Oracle taking 100% CPU

free up space unless you reboot the server. Hope this helps. Sergei. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hussain Ahmed Qadri Sent: Tuesday, November 12, 2002 2:19 AM To: Multiple recipients of list ORACLE-L Subject: Oracle taking 100% CPU

clob to text file

Hello everyone, I am trying to offload data from multiple tables into one text file. The problem is couple of the fields are clobs. Any advices how to deal with clobs? Sergei -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergei INET: [EMAIL PROTECTED] Fat

RE: [Q] wield create view error, need help?

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

Porting OAS 4.0.8 application to iAS: please help!

: 1 Can anyone, please, explain what is wrong here. I read that the OWA code should port with practically no problems. Thanks a lot in advance, Sergei -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergei O.Naumov INET: [EMAIL PROTECTED] Fat City Network

mod_plsql in 8.1.7 does not parse XML

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