Open cursors

Can we set a limit to the number of open cursors per oracle user? thanks. =) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Programming languages that make DBA's lives easier

spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc

Re: RMAN: I don't trust it

you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. Failure is only postponed success as long as courage 'coaches' ambition. The habit of persistence is the habit

Re: RMAN: I don't trust it

to be removed from). You may also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. Failure is only postponed success as long as courage 'coaches' ambition. The habit of persistence is the habit of victory

Re: RMAN: I don't trust it

scripts I've been using for years. Any comments, or other interesting experiences? Perhaps we can do a list poll of favorite/preferred backup software? -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. "Failure is only postponed success as long as courage 'coaches' amb

Re: Oracle License for Training

the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. Failure is only postponed success as long as courage 'coaches' ambition. The habit of persistence is the habit of victory. -- Please see the official ORACLE-L FAQ

Re: Oracle License for Training

and partnering costs $$. I dare not call Oracle Philippines just yet...If there is a need to purchase, and if we have the money, only then will we contact them. Thanks. =) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maria Aurora VT de la Vega INET: [EMAIL

Oracle Reports: email

This is quite OT in a DBA forum. More of a developer question. How do I configure email in Oracle Reports. I have created the procedure but I need to know where do I place the SMTP host name? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maria Aurora VT

Re: Oracle Reports: email

settings etc. Mails get sent using that account. Shuja -Original Message- From: Maria Aurora VT de la Vega [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 3:24 AM To: Multiple recipients of list ORACLE-L Subject: Oracle Reports: email This is quite OT in a DBA forum. More

Oracle License for Training

-- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

Re: Tricky query question

asc) id, primarykey, status from table) prev where curr.id-1 = prev.id and curr.status prev.status; -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. If you don't risk anything, you risk even more. Mark Richard wrote: Hi All, This is a question for those who like

Re: Tricky query question

asc) id, primarykey, status from table) prev where curr.id-1 = prev.id and curr.status prev.status; -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. If you don't risk anything, you risk even more. Mark Richard wrote: Hi All, This is a question for those who like

Re: Tricky query question (oops)

, (select rank() over (order by dateinserted asc) id, primarykey, status, dateinserted from table) prev where curr.id-1 = prev.id and curr.status prev.status; -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. If you don't risk anything, you risk even more. Mark Richard wrote

Re: RMAN backup - basic Qs

subscribing). -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. If you don't risk anything, you risk even more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services

career questions

-- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

oracle book

Anybody read the book Database Administration: The Complete Guide to Practices and Procedures by Craig Miller? any opinions? i'm planning to buy it...i'd like to know if its worth it. Thanks. =) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la

SunFire v100

anybody's opinion. Will oracle work on this or not? Thanks. =) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: Materialized view selection.

: InterScan_Disclaimer.txt InterScan_Disclaimer.txtType: Plain Text (text/plain) Encoding: 7bit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

E business Suite 11i - for Apps DBA's

Hello Application DBA's I'd like to know where I can get/buy E-business Suite 11i documentation with the ERD and data dictionary of the tables. Thank you so much. -- Maria Aurora VT de la Vega OCP Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ

Financials Client question

for us. Thanks a lot! -- Maria Aurora VT de la Vega OCP Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Re: OT: awk problem

to malice that which can be adequately explained by MAVdlV stupidity. MAVdlV Maria Aurora VT de la Vega OCP MAVdlV Database Specialist MAVdlV Philippine Stock Exchange, Inc. MAVdlV -- MAVdlV Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Best regards, Sergey

OT: awk problem

rs are. help. Thanks. =) -- Maria Aurora VT de la Vega OCP Database Specialist Philippine Stock Exchange, Inc.

OT: awk problem

bute to malice that which can be adequately explained by stupidity." Maria Aurora VT de la Vega OCP Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Ne

Re: OT: awk problem

to do a workaround. thanks. Stephane Faroult wrote: Nothing to do with awk, probably just your terminal which inserts carriage returns. Shouldn't do that if you redirect to a file or set your terminal width to 132. - Original Message - From: Maria Aurora VT de la Vega [EMAIL PROTECTED

interview questions

experience with the use of any Oracle Development tools... And for me, as long as they know how to SQL and PLSQL...and respects their DBA... they're OK. I am not sure if there are other things I should ask.. Inputs Please! thanks. -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine

OAS help

we have a problem with our OAS... in the admin page (OAS node manager ?!) there is a tree where there is list of HTTP listeners... now there is no entry under the HTTP list... 0 experience in using OAS... help! thanks. =) -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock

oracle on linux vs oracle on NT

with NT (very disappointing) Any input will be very much appreciated. =) -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat

using hints on views

i find the ordered hint extremely helpful... so i usually find myself using this hint... what is your opinion on using hints inside views? thanks. -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http

AHA!!! Re: ORA-00904 on a valid view when using count(*)

to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc.

Re: ORA-00904 on a valid view when using count(*)

de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: ORA-00904 on a valid view when using count(*)

ling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc.

Re: ORA-00904 on a valid view when using count(*)

... btw, trade_quotes_vw is valid Maria Aurora VT de la Vega wrote: we have view named gain_view which was created with this sql SELECT co.name, sec.alias, sec.security_name, sec.security_symbol, sq.open, sq.high, sq.low, sq.close, sq.previous, sq.last_trade_price, sq.total_volume

Re: ORA-00904 on a valid view when using count(*)

... btw, trade_quotes_vw is valid Maria Aurora VT de la Vega wrote: we have view named gain_view which was created with this sql SELECT co.name, sec.alias, sec.security_name, sec.security_symbol, sq.open, sq.high, sq.low, sq.close, sq.previous, sq.last_trade_price, sq.total_volume

ORA-00904 on a valid view when using count(*)

ORDER BY perc_change DESC when we do a select * from gain_view we get the correct results but when we use select count(*) from gain_vw we are getting ORA-00904 any ideas? -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L

Re: Generating a SQLLDR Sequence Number

: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http

[Fwd: Oracle DBA/Developer Position]

---BeginMessage--- I am looking for an Oracle DBA/Developer for a position here in Dallas. It is a very difficult req to fill. I have attached a copyof this positions requirements. This is a very specific Designer/2000 PL/SQL Programmer position, utilizing Oracle 6i Web Generation

Re: SQL Query OutPut

from). You may also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL

quick q re: column default

how do i remove a column's default value? thanks. -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services

slightly OT: visual c++ and null values

thanks =) -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: Write to file in XML format

command for other information (like subscribing). -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services

Re: Intermedia question

may also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat

Re: Rash of shared memory errors

to be removed from). You may also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET