RE: Oracle Reports!

2003-02-21 Thread Sony kristanto
t; 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony krist

RE: slow update and db trigger

2003-02-19 Thread Sony kristanto
-- > To REMOVE yourself from this mailing list, send an E-Mail message > 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 wan

RE: Service startup on Windows 2000 fails

2003-02-19 Thread Sony kristanto
te 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). -- Please see the official

RE: Reconfiguring datafiles

2003-02-18 Thread Sony kristanto
atafile x2 > including all data in datafile x1. > 3. If it is possible how to do it. > > Many thanks for respons and all comments would be appreciated. > > Kind rgrds, > > Sony > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author:

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Sony kristanto
that make DBA's lives easier > > On top of learning Oracle, which programming languages would also benefit > some1 learning Oracle? Perl? Java? How would these languages be used? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL

Reconfiguring datafiles

2003-02-17 Thread Sony kristanto
ments would be appreciated. Kind rgrds, Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting ser

ORA-00106

2003-02-17 Thread Sony kristanto
Hi Listers, I try to shutdown my database via Oracle Instance Manager but I get ORA-10106 error. Could someone on the list help me how to solve it. Rgrds, Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network

RE: Please help with ORA-12571 TNS:Packet Writer Failure.

2003-02-17 Thread Sony kristanto
CTED] (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). > -- Please see the offici

RE: INSERT ... RETURNING ROWIDTOCHAR(ROWID) INTO problem on 9.2.0

2003-02-12 Thread Sony kristanto
REMOVE yourself from this mailing list, send an E-Mail message > 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 lis

RE: Ewrin question ??

2003-02-12 Thread Sony kristanto
gt; To REMOVE yourself from this mailing list, send an E-Mail message > 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 > als

RE: Backup and Recovery

2003-02-12 Thread Sony kristanto
am implementing a software in Oracle 8.1.7. > > The client wants to have the backup and recovery procedure. As of > > now, they are using EXPORT utility. > > Could any one of you tell me any other utility which the client will > > be able to use for Backup of their data ? >

RE: Questions for Oracle list

2003-02-10 Thread Sony kristanto
- > To REMOVE yourself from this mailing list, send an E-Mail message > 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

RE: Bind variables

2003-02-10 Thread Sony kristanto
gt; 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 subscribi

RE: Backup and Recovery

2003-02-10 Thread Sony kristanto
other utility which the client will > be able to use for Backup of their data ? > > Thanks and Regards, > Santosh Varma > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network

RE: ORA-04031 error

2003-02-07 Thread Sony kristanto
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.net -

RE: ORA-1000 - How to trace culprit

2003-02-07 Thread Sony kristanto
;>>>>>>>>>>>>>>>>>>> > >>>>>> > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mark Richard > INET: [EMAIL PROTECTED] > > Fat City Network Services--

RE: Freeware reverse engineer ER diagram from ODBC connection

2003-02-07 Thread Sony kristanto
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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET:

RE: SQL

2003-02-06 Thread Sony kristanto
/www.fatcity.com > San Diego, California-- Mailing list and web hosting services > ----- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGur

RE: Barcode Generation in Forms/Reports

2003-02-05 Thread Sony kristanto
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.net -- Author: Sony kristanto INET: [EMAIL PROTECTE

RE: Sql query

2003-02-05 Thread Sony kristanto
- > To REMOVE yourself from this mailing list, send an E-Mail message > 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

RE: Drop datafile.

2003-02-05 Thread Sony kristanto
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.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcit

RE: Full table scan

2003-02-04 Thread Sony kristanto
;< File: InterScan_Disclaimer.txt >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting servi

RE: How to create a new oracle database from SVRMGRL??

2003-02-04 Thread Sony kristanto
w.orafaq.net > -- > Author: majid > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > ---

RE: Strange Behavior - forms6i

2003-02-04 Thread Sony kristanto
m this mailing list, send an E-Mail message > 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 f

[no subject]

2003-02-04 Thread Sony kristanto
help. Every comments and clues would be very appreciated. Rgrds, Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: Off Topic Posts

2003-01-30 Thread Sony kristanto
d an E-Mail message > 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 subscrib

RE: comparing null values

2003-01-30 Thread Sony kristanto
-- > To REMOVE yourself from this mailing list, send an E-Mail message > 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)

RE: Creating a simple stored procedure

2003-01-30 Thread Sony kristanto
ge > 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). &g

RE: ORA-04098 Problem - Any Ideas??

2003-01-30 Thread Sony kristanto
age states otherwise and the sender is authorized to > state them to be views of any such entity. > _ > > > _ > > This e-mail message has been scanned for Viruses and Content and cleared > by MailMarshal - For more information please visit www.marshalsoft

RE: forms6i question

2003-01-30 Thread Sony kristanto
'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). > -- Please see the official ORACLE-L FAQ: http://w

RE: Return the first row only

2003-01-29 Thread Sony kristanto
t; To REMOVE yourself from this mailing list, send an E-Mail message > 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 b

RE: Problem on P4 intel servers

2003-01-29 Thread Sony kristanto
he official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Naveen Nahata > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting servi

RE: strange behaviour of sequence

2003-01-29 Thread Sony kristanto
> To REMOVE yourself from this mailing list, send an E-Mail message > 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

RE: Problem on P4 intel servers

2003-01-29 Thread Sony kristanto
-- > To REMOVE yourself from this mailing list, send an E-Mail message > 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

RE: to much time to execute query

2003-01-28 Thread Sony kristanto
this mailing list, send an E-Mail message > 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 othe

RE: Configuring back up in Oracle 9i

2003-01-26 Thread Sony kristanto
'target > type=database' but you also have to have the proper password set for > 'target type=node' (machine where your database is. > > chris > > -Original Message- > From: Sony kristanto [ <mailto:[EMAIL PROTECTED]>] &

Configuring back up in Oracle 9i

2003-01-24 Thread Sony kristanto
#x27;. Pls show me clues how to solve this error. All comments and instructions would be very appreciated. Rgrds, Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatci

RE: changing Home directory?

2003-01-24 Thread Sony kristanto
uru') 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Au

RE: Sequences in 8.1.7 vs 9i

2003-01-23 Thread Sony kristanto
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.net -- Author: Sony kristanto INET: [EMAIL PROTECTED]

RE: same sql: different db block gets in different oracle version

2003-01-22 Thread Sony kristanto
> To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mail

RE: create tablespace problem

2003-01-22 Thread Sony kristanto
--- > To REMOVE yourself from this mailing list, send an E-Mail message > 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 >

RE: Where are the scripts located to create the SCOTT test object

2003-01-21 Thread Sony kristanto
t; also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--

RE: SqlServer and Oracle on the Same NT Box

2003-01-21 Thread Sony kristanto
--- > To REMOVE yourself from this mailing list, send an E-Mail message > 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

RE: Help with procedure

2003-01-21 Thread Sony kristanto
t; 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 f

RE: SQLplus question unusual behavior

2003-01-20 Thread Sony kristanto
eatures/junkmail > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Arup Nanda > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosti

RE: Americas Cup

2003-01-20 Thread Sony kristanto
gt; > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containi

RE: OT: HOTSOS Symposium

2003-01-19 Thread Sony kristanto
; Hope you can attend. > > - Kirti > > PS: No, I do not work for Hotsos. > > PS: Wish I did ;>) > > > > -Original Message- > From: Sony kristanto [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 17, 2003 8:29 PM > To: Multiple recipients of

RE: OT: HOTSOS Symposium

2003-01-17 Thread Sony kristanto
ailing list, send an E-Mail message > 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 o

RE: v$Views and d$Tables

2003-01-17 Thread Sony kristanto
can find them.. > > Thanks and Regards, > Santosh > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Di

RE: Blank username in v$session

2003-01-16 Thread Sony kristanto
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.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Service

RE: Date data type

2003-01-15 Thread Sony kristanto
/09/02 1202 > > 4 rows selected. > > 09:18:49 SQL> > 09:18:49 SQL>select * from d where d between '12/01/02' and '12/31/02'; > > D > > 12/09/02 > > 1 row selected. > > 09:18:49 SQL> > 09:18:49 SQL>select * fro

RE: Comparing between two tables

2003-01-15 Thread Sony kristanto
NSUB 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.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network

RE: oracle locking question

2003-01-15 Thread Sony kristanto
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). > -- Please see the official ORACLE-L FAQ: http://ww

Date data type

2003-01-14 Thread Sony kristanto
ed SQL > Select * from test where to_char(dt,'mmrr')='1202' - it returns 26 rows selected Why the last query return more rows selected than first query ? All comment would be appreciated. TIA, Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author:

RE: encrypted user/passwd connection

2003-01-13 Thread Sony kristanto
ted format. > Atleast, until 8.1.7. To avoid which, ORA_ENCRYPT_LOGIN variable and > DBLINK_ENCRYPT_LOGIN parameter (for retried attempts across database link) > should be set to TRUE. > > I could stand corrected though. > > Raj > > > > > > >

RE: fnd_global user_id

2003-01-09 Thread Sony kristanto
pelling 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). > -- Please see the official ORACLE-L FA

RE: encrypted user/passwd connection

2003-01-06 Thread Sony kristanto
- > To REMOVE yourself from this mailing list, send an E-Mail message > 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

RE: strange issue with setting transaction

2003-01-05 Thread Sony kristanto
> 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto

RE: Automatic backup on Oracle 9i

2002-12-27 Thread Sony kristanto
Sent: Saturday, December 28, 2002 9:40 AM > To: Sony kristanto; [EMAIL PROTECTED] > Subject: Re: Automatic backup on Oracle 9i > > > Hmm > > A lot of folks on this liststudiously avoid OEM. I know I do, > and I'm not going to be much help on this. > &g

OAS

2002-12-27 Thread Sony kristanto
Does OAS already include in Oracle 9i ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Automatic backup on Oracle 9i

2002-12-27 Thread Sony kristanto
L PROTECTED]] > Sent: Friday, December 27, 2002 10:06 AM > To: [EMAIL PROTECTED]; Sony kristanto > Subject: Re: Automatic backup on Oracle 9i > > > Sony, > > What is an 'automatic' backup? > > Is this something supplied by that 'Oracle Enterprise

Automatic backup on Oracle 9i

2002-12-26 Thread Sony kristanto
in and again but the results are the same. Could someone out there tell me why it can't runs. For your note I use 'SYS' as my user. I will really appreciate your help. Rgrds, Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET:

Oracle Application Server Installation

2002-12-23 Thread Sony kristanto
ng it, how the best solution to solve this problems. Rgrds, Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and w

RE: Happy Holidays!!

2002-12-20 Thread Sony kristanto
gt; > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego,

RE: Undelete Record

2002-12-20 Thread Sony kristanto
d web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line cont

Undelete Record

2002-12-19 Thread Sony kristanto
Hi Listers, I have little problem : how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 85

RE: Open the password

2002-12-19 Thread Sony kristanto
> 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 yo

RE: Open the password

2002-12-18 Thread Sony kristanto
AL' because I forget > the > password. Please inform me how to open it again perhaps you have tips and > tricks how to solve it. > > Thanks > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sony kristanto > INET:

RE: Open the password

2002-12-18 Thread Sony kristanto
it again perhaps you have tips > and > tricks how to solve it. > > Thanks > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sony kristanto > INET: [EMAIL PROTECTED] >

Open the password

2002-12-17 Thread Sony kristanto
open it again perhaps you have tips and tricks how to solve it. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mai