Re: exp from 9.2.1 to 9.0.1

I intend to export my user in database 9.2.1 into my notebook which is running at 9.0.1 anyone successfull import ? Did i need to xcopy the catexp file from 9.2.1 into my notebook and execute it ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Raymond Lee Meng

Re: Samba , Write Access , Linux

to the folder either to delete/write/copy/paste, it will be very dangers for my application to sit on that. Is there any place I can refer to learn more abt the samba -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City

re: java compiler error

(prtString); } } Raymond Lee Infopro Sdn Bhd Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET

Ora 817 diff Ora816

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

FW: ODTUG-DEV2K-L Digest -- Volume 2001, Number 301

appreciated. Thanks in advanced karim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: performance issue on this sql ???

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

Re: Installation of conflict on personal oracle/ora8.1.6 OEM in w

: Raymond Lee Meng Hong 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: Sga

in for Oracle 8.1.6 ? to increase the speed of execution . Best Regard Raymond Lee ' If you are given an open-book exam, you will forget your book.' -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network

Re: reduce SQL*NET byte transfer

will forget your book.' -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

No Subject

Raymond Lee ' If you are given an open-book exam, you will forget your book.' -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: Compiling package

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

Re: read and insert

Lee Meng Hong 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, send

RE: Apps Login Error

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: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: Advanced Queues

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

No Subject

SET ORACLE-L DIGEST Raymond fall asleep in waiting for the Q. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: [Q] does Personal ORACLE 8.1.7 support Win98?

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

RE: Oracle db missing

the OEM can't detect it -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re :Ms Proxy Client

to ping the server , error is return , I check through he's proxy configuration and it found to be identical with my one. I'm running win98se . Is it because of registry problem or win2k installation error ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng

Oracle db missing

sqlplus scot/tiger@test ,why the OEM can't detect it -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

form 4.5 bug ?

resist in and it will automatic call out the old format instead of the latest format ?? I'm running in Oracle 7.3.2 , Form 4.5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

DB2 via Oracle

Hello Guru. I plan to compare IBM DB2 Db with Oracle 8i, anyone of you know did they actually give out their database on the web for us to download ? any site can refer ? Raymond Lee Infopro Sdn Bhd Block B3 Level 8, Leisure Commerce Square No. 9, Jalan PJS 8/9 46150 Petaling Jaya

RE: sql-query

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

Hello

Hello , Is there anyone use Oracle Intermedia Text . What is the usage of this product ? As a banking solution ,we only use Report, Form ,Database for our customer , what kind of other oracle product can we integrate into our solution ? Raymond Lee Infopro Sdn Bhd Block B3 Level 8, Leisure

RE: DBMS_JOB

may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Why are my indexes being ignored?

Lee Meng Hong 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, send

RE: Odd Access/ColdFusion/SQLPluss access problem

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

RE: trigger on user logoff session

: 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: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services

trigger on user logoff session

Hello , Can I know whether is it possible for me to set up a trigger to activate if any user active this in-house logoff function to kick off any user who is activate this script ? ALTER TRIGGER CFLOG DISABLE / UPDATE CFsecurity SET LOGON = 'N' WHERE STFID = UPPER('STFID') / UPDATE CF88LOG

RE: Tracing PL/SQL-Calls

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

RE: Use sql*loader

Yes..you might need to set the buffer to some more higher ?? but did you check on your log file or is there any bad file produce ?? They might be data error while loading it.. -Original Message-From: Ngo BaDu [mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 3:50 PMTo:

Hi ,ask permission

Hello Guru on the list. Can I ask permission to cut and paste the link which is usefull for later on enquiry ?? Becoz sometime some question ask from you might be important for me later on, if there is a solution on the which is given on a URL , can I just cut and paste the URL and save it

RE: OCI : 32 bit - 64 bit

Hei ..Rayaj. can I know what is OCI ? what the function of it ?? As a developer I did't come across these TERM before . -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Saturday, June 23, 2001 6:34 AMTo: Multiple recipients of list ORACLE-LSubject:

RE: TRUNCATE IN PL/SQL

get the errors lc -Original Message- [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 8:47 AM To: Multiple recipients of list ORACLE-L Not 100% sure but I think only the table owner can use TRUNCATE Witold Raymond Lee Meng Hong [EMAIL PROTECTED] on 06/21/2001 01:10:52 Please

RE: TRUNCATE IN PL/SQL

') 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.com -- Author: Raymond Lee Meng Hong INET

RE: TRUNCATE IN PL/SQL

can use TRUNCATE Witold Raymond Lee Meng Hong [EMAIL PROTECTED] on 06/21/2001 01:10:52 Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Witold Iwaniec/ATL_BLUECROSS_CA) Got these error ? may be my DBA restrict these ? ORA

missing link

Hello , currently I have install TOAD, when I click the sqlnet-help , it highlight the error l:\oracle\dev16\ is not in system path ? But it did work ok .I manage to connect to my db server , but why this error come up ??? Actually I 'm network connect with my oracle server locate in other

TRUNCATE IN PL/SQL

Hello guru , how can I execute a truncate table in PL/SQL ?? It only work for delete DML only ? why ? Raymond Lee Infopro Sdn Bhd Block B3 Level 8, Leisure Commerce Square No. 9, Jalan PJS 8/9 46150 Petaling Jaya Selangor , Malaysia Tel : 603-7876 ext : 266 Fax :

RE: TRUNCATE IN PL/SQL

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: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Sql*Loader and assign a ROLLBACK segment

the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

explain plan

= d.acno and b.chkdgt = d.chkdgt and a.cifkey = '40' and cd ='PNBMEMBERNO' AND acsts in ('A','R','L','2') and fldchar is not null order by a.cifkey can it be optimizer ??? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat

RE: LoadRunner

: Raymond Lee Meng Hong 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

the conversion is from Mainframe flat file to Unix Flat file - b

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

RE: SQL/PL

me an error on my two cursors. Thank you in advance for any help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: the conversion is from Mainframe flat file to Unix Flat file

: Raymond Lee Meng Hong [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 15, 2001 9:40 PM To: Multiple recipients of list ORACLE-L Subject: the conversion is from Mainframe flat file to Unix Flat file - b what is EBCDIC format I have a customer from IBM DB2 mainframe going to pass data

sqlldr ver 8 can't load v7 database

??? Raymond fall asleep in waiting for the Q. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: Removing Older version of Oracle on NT

(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong 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 send SMS message from Oracle

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: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network

Sqlloader on VSAM file

fall asleep in waiting for the Q. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: decoding rowids

Nope..not in my 7.3.2. ... -Original Message-From: Rajesh Dayal [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 07, 2001 5:28 PMTo: Multiple recipients of list ORACLE-LSubject: decoding rowids Hi all, I was just wondering if there is any alternative method of

Toad w/o debug option ?

understand we must have a Oracle Probe API v2.0 and DBMS_DEBUG in the SYS schema. ? Where can I find it ? Raymond fall asleep in waiting for the Q. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network

RE: What next ?

pratical or tutorial on this ? Or taking the OCP exam and exam cram to study will help ? Raymond fall asleep in waiting for the Q. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services

RE: how to run procedure containig REF CURSOR as datatype

://www.orafaq.com -- Author: Raymond Lee Meng Hong 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

What next ?

? Is there any pratical or tutorial on this ? Or taking the OCP exam and exam cram to study will help ? Raymond fall asleep in waiting for the Q. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services

RE: Database Links

(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: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: ORACLE NAMES /LDAP

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: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Testing tools

? Becoz we intend to setup up a ISO 9001 standard on testing environment and testing technique. Anyone go through this before ? or any white paper about this ? Raymond fall asleep in waiting for the Q. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng

user-define exception handle

: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Database slowdown after 100 days uptime

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: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Multiple home

here , but I search through the oracle package CD, still can't find it. ??Can any guru point to me ? Raymond fall asleep in waiting for the Q. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services

RE: redo copy latch low??

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: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Oracle Development Tool

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: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network

RE: Developer, C/C++, Java lists

-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: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: import oddity

://www.orafaq.com -- Author: Raymond Lee Meng Hong 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

Hard parse /soft parse

the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Hei

off But when I issue a set markup html on spool on .. the error markup not recognise come out ???Why it happen like this ? Did I miss run any script or service ??? Raymond is clawing in the intranet. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee

RE: OT - Books Covering Partitioning in 8i

the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: unhandled user-defined exception

Title: unhandled user-defined exception You do a DMBS-OUTPUT the SQLMM , SQLCODE to check on what might be the coz of error...in you PL/SQL. -Original Message-From: Venugopal, R (GEP, Contractor) [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 17, 2001 7:25 PMTo: Multiple