RE: Help with a truncate command in a procedure

2003-02-07 Thread Bernard, Gilbert
use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bernard, Gilbert INET

RE: To_Number

2002-12-06 Thread Bernard, Gilbert
: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City

RE: Help : X$KSPPI Oracle 8.1.7.2 STATSPACK

2002-10-03 Thread Bernard, Gilbert
to create this view X$KSPPI ? I am trying to install statspack, and it missing this view. ! ! ! Regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network

Help : X$KSPPI Oracle 8.1.7.2 STATSPACK

2002-10-02 Thread Bernard, Gilbert
How to create this view X$KSPPI ? I am trying to install statspack, and it missing this view. ! ! ! Regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: Privileges needed for truncate

2002-09-19 Thread Bernard, Gilbert
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Privileges needed for truncate

2002-09-19 Thread Bernard, Gilbert
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

select count(*) = 0, select /*+ full(a) */ count(*) = 5227 ?

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

RE: IMPORT sloooowwww

2002-08-29 Thread Bernard, Gilbert
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Strange Data issue.....

2002-08-22 Thread Bernard, Gilbert
://www.marshalsoftware.com www.marshalsoftware.com _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: How to insert Special Characters ?

2002-07-31 Thread Bernard, Gilbert
list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Faster Sqlloader Question

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

RE: Faster Sqlloader Question

2002-07-30 Thread Bernard, Gilbert
://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

SQL*LOAD question

2002-06-25 Thread Bernard, Gilbert
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: How to find out the latest object created in DB?

2002-06-13 Thread Bernard, Gilbert
-- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list

RE: Can we find SQL user

2002-06-07 Thread Bernard, Gilbert
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: how can listener list on two ports for the same db?

2002-05-29 Thread Bernard, Gilbert
FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

RE: ORA-01595

2002-05-23 Thread Bernard, Gilbert
)) I got this error when I tryed to shrink the rollback segment system, What can I do to solve this problem, optiman does'nt solve it. thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET

RE: ORA-01595

2002-05-23 Thread Bernard, Gilbert
://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

ORA-01595

2002-05-22 Thread Bernard, Gilbert
ORA-01595 error freeing extent (string) of rollback segment (string)) I got this error when I tryed to shrink the rollback segment system, What can I do to solve this problem, optiman does'nt solve it. thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard

How to translate PL/SQL to C

2002-05-15 Thread Bernard, Gilbert
-- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list

EXP-00010 HELP

2002-04-18 Thread Bernard, Gilbert
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert

data block stockage capacity

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

RE: Send mail from pl/sql

2002-04-05 Thread Bernard, Gilbert
send_email.sql send_email_attch.sql -Message d'origine- De: Abdul Aleem [mailto:[EMAIL PROTECTED]] Date: vendredi 5 avril 2002 11:18 À: Multiple recipients of list ORACLE-L Objet: RE: Send mail from pl/sql Which mail client

Dynamic create and execute procedure

2002-03-29 Thread Bernard, Gilbert
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat

view current sql

2002-03-27 Thread Bernard, Gilbert
How can I see the current sql instruction from a specific user. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: Convertion from Figures to Words

2002-03-27 Thread Bernard, Gilbert
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL

RE: Make first character Versal

2002-03-27 Thread Bernard, Gilbert
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: How to duplicate production database onto development box

2002-03-26 Thread Bernard, Gilbert
clone database by copiyng all datafiles and rebuild the controlfile using a new database name. [Bernard, Gilbert] -Message d'origine- De: Daiminger, Helmut [mailto:[EMAIL PROTECTED]] Date: mardi 26 mars 2002 14:48 À: Multiple recipients of list ORACLE-L Objet: How to duplicate

RE: Customize my SQLPlus login

2002-03-26 Thread Bernard, Gilbert
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Customize my SQLPlus login

2002-03-26 Thread Bernard, Gilbert
in your current directory put a login.sql file as login.sql -Message d'origine- De: Rodd Holman [mailto:[EMAIL PROTECTED]] Date: mardi 26 mars 2002 15:09 À: Multiple recipients of list ORACLE-L Objet: Re: Customize my SQLPlus login

RE: Function to round to the nearest 15

2002-03-26 Thread Bernard, Gilbert
portion rounded to the nearest quarter hour... any SQL (no PLSQL) suggestions would be helpful. 1=.25 48=.75 90=1.5 95=1.5 98=1.75 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL

RE: Revoke alter password frm user

2002-03-21 Thread Bernard, Gilbert
user the right to alter his password? TIA Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] http://www.inplan.de http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network