RE: OS calls with java stored procedures

2003-12-09 Thread Richard Ji
Yes, it's exec dbms_java.set_output(2000); Richard Ji -Original Message- Sent: Tuesday, December 09, 2003 8:50 AM To: Multiple recipients of list ORACLE-L I'm working from memory here, but there is a procedure in a built-in package, I think it is DBMS_JAVA, that redirects standard

RE: Anyone run into this strange ORA-00904 error ??

2003-12-03 Thread Richard Ji
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: Richard Ji INET: [EMAIL PROTECTED] Fat City

RE: Oracle and JMeter configuration

2003-12-03 Thread Richard Ji
, 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: Richard Ji INET: [EMAIL PROTECTED] Fat

RE: Parse Vs Execute

2003-11-29 Thread Richard Ji
://www.orafaq.net -- Author: Richard Ji 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: alter system reset

2003-10-30 Thread Richard Ji
On a Unix system, you can "tput reset" to clear up that mess after viewing a binary file by accident. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 02, 2003 3:39 PMTo: Multiple recipients of list ORACLE-LSubject: Re: alter

RE: encrypt traffic across internet?

2003-10-08 Thread Richard Ji
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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network

RE: Solaris /etc/system values for Oracle8i

2003-09-27 Thread Richard Ji
That's what I said. :) I gotta go check my database I ran under Linux under VMware on my laptop. Maybe it didn't get created at all, I dreamed it all up! -Original Message- From: Tanel Poder [mailto:[EMAIL PROTECTED] Sent: Sat 9/27/2003 10:54 AM To: Multiple recipients of list

RE: Google's architecture -- was Re: paging and google.com

2003-09-26 Thread Richard Ji
Title: Message There you go. That's how we (DBAs) gonna make money in the future. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Friday, September 26, 2003 12:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Google's architecture -- was Re:

RE: Anyone have a copy of DUL ??

2003-09-18 Thread Richard Ji
Indeed, the row directory is in the block header. And like Raj said, there is a length value to tell you how far to read. The values are encoded in Oracle's internal format, such as the 7 bytes coding for Date type. Richard Ji -Original Message- From: Joe Testa [mailto:[EMAIL

RE: Anyone have a copy of DUL ??

2003-09-18 Thread Richard Ji
for other tools, ethereal, kismet etc. I do believe the benefit of such a tool available out weights the risk of it. I'd like to hear other list members opnion on it. Yours turely Richard Ji -Original Message- Sent: Thursday, September 18, 2003 12:35 PM To: Multiple recipients of list ORACLE-L

RE: Anyone have a copy of DUL ??

2003-09-18 Thread Richard Ji
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Anyone have a copy of DUL ??

2003-09-18 Thread Richard Ji
). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Anyone have a copy of DUL ??

2003-09-18 Thread Richard Ji
:) www.fors.com/velpuri2 -Original Message- Sent: Thursday, September 18, 2003 5:55 PM To: Multiple recipients of list ORACLE-L Okay, okay, I'll check the archives. --Walt shuffling around his office trying to find his web browser -Original Message- From: Richard Ji [mailto

RE: tuning a massive delete

2003-09-17 Thread Richard Ji
') 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 -- Author: Richard Ji INET: [EMAIL

RE: How to extract data directly from a datafile ?

2003-09-17 Thread Richard Ji
Looks like it's still in the planning stage. -Original Message- From: Pete Finnigan [mailto:[EMAIL PROTECTED] Sent: Wed 9/17/2003 6:59 AM To: Multiple recipients of list ORACLE-L Cc: Subject:Re: How to extract data directly from a datafile ? Hi, There is a tool

RE: How to extract data directly from a datafile ?

2003-09-17 Thread Richard Ji
. So maybe we can combine efforts. Richard Ji -Original Message- Sent: Wednesday, September 17, 2003 5:50 PM To: Multiple recipients of list ORACLE-L Shame, maybe you could email the guy who is writing it and ask for details of where he is with it? kind regards Pete -- Pete Finnigan

RE: How to extract data directly from a datafile ?

2003-09-17 Thread Richard Ji
(for future?) versions we have dropped that idea as we don't want to compete with Oracle :D I would be interested in knwoing abt your tool too .. KG --- Richard Ji [EMAIL PROTECTED] wrote: Good idea. I am actually planning on write something like that myself. I have wrote on a smaller

RE: How to extract data directly from a datafile ?

2003-09-17 Thread Richard Ji
.. KG --- Richard Ji [EMAIL PROTECTED] wrote: Good idea. I am actually planning on write something like that myself. I have wrote on a smaller scale one just to extract data for our company's database (8.1.7.4) and it was extremely handy in one of our recovery situation where

RE: How to extract data directly from a datafile ?

2003-09-17 Thread Richard Ji
of enhancements needed to be able to use it in anyone's environment. And yes, it's in Java. Richard Ji -Original Message- Sent: Wednesday, September 17, 2003 10:00 PM To: Multiple recipients of list ORACLE-L I am aware its called DUL. And you have written the equivalent of DUL in Java

RE: Offshore threat

2003-09-07 Thread Richard Ji
Maybe the thieves are running Oracle on HP and they need to add two more CPU to their server. -Original Message- From: Mogens Nrgaard [mailto:[EMAIL PROTECTED] Sent: Sun 9/7/2003 4:49 AM To: Multiple recipients of list ORACLE-L Cc: Subject:Re: Offshore threat While I

RE: c based external procedures vs. Java Stored Procedures

2003-09-04 Thread Richard Ji
such a thing, very little. In general though, you can do most of the stuff in Java Stored Procedures. Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: How to keep root out?

2003-08-31 Thread Richard Ji
... on 8/29/03 9:29 AM, Richard Ji at [EMAIL PROTECTED] wrote: We assume the SA don't know much about Oracle. But if some one is particularly interested in getting into the database, he might be on this list as well learning all our defense mechanisms. :) Or doesn't have to be subscribed

RE: How to keep root out?

2003-08-29 Thread Richard Ji
friend. I think the bottom line is, if you absolutely don't want the data to be seen, encrypt it. My 2 cents. Richard Ji -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]Sent: Friday, August 29, 2003 10:31 AMTo: Multiple recipients of list ORACLE-LSubject

RE: How to keep root out?

2003-08-29 Thread Richard Ji
the data to be seen, encrypt it. My 2 cents. Richard Ji -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]Sent: Friday, August 29, 2003 10:31 AMTo: Multiple recipients of list ORACLE-LSubject: RE: How to ke

RE: International Language Support Experiences?

2003-08-27 Thread Richard Ji
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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services

RE: Text file from store procedure

2003-08-20 Thread Richard Ji
You can also use Java Stored Procedures. -Original Message- From: Steve McClure [mailto:[EMAIL PROTECTED] Sent: Wed 8/20/2003 8:44 PM To: Multiple recipients of list ORACLE-L Cc: Subject:RE: Text file from store procedure You can spool output to the location of your

RE: BLOB question/JDBC

2003-08-18 Thread Richard Ji
Thin driver supports LOBs. -Original Message- From: Vordos, Suzy [mailto:[EMAIL PROTECTED] Sent: Mon 8/18/2003 2:19 PM To: Multiple recipients of list ORACLE-L Cc: Subject:RE: BLOB question/JDBC IIRC, the thin driver doesn't support LOBs -Original Message-

RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR

2003-08-14 Thread Richard Ji
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR

2003-08-07 Thread Richard Ji
track for unparsed dynamic cursors so it some times doesn't show all cursors that count toward the max open cursor parameter. Richard Ji -Original Message- Sent: Thursday, August 07, 2003 4:14 PM To: Multiple recipients of list ORACLE-L No takers on this from the perf tuning gurus? Please

RE: Update through a DBLink

2003-07-24 Thread Richard Ji
: http://www.orafaq.net -- Author: Richard Ji 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

RE: possible to set continuation prompt in sql*plus?

2003-07-22 Thread Richard Ji
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Different Platform

2003-07-20 Thread Richard Ji
://www.orafaq.net -- Author: Richard Ji 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: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in

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

RE: x server

2003-07-17 Thread Richard Ji
check out cygwin. -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 12:49 PMTo: Multiple recipients of list ORACLE-LSubject: x server is there any free x server (unlimited ) software for windows 2000? -ak

RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in

2003-07-17 Thread Richard Ji
it. To see the data structure gives me idea of how things work. And it might come in handy some day in a recovery situation. Best regards Richard Ji -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Thursday, July 17, 2003 12:19 PMTo: Multiple recipients

RE: RE: utl_file on Redhat Linux Oracle 9 standard engine

2003-07-09 Thread Richard Ji
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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: java permissions

2003-07-08 Thread Richard Ji
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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Microsoft VS Oracle (again)

2003-07-07 Thread Richard Ji
can run SQL Server from a virtual machine. Richard Ji -Original Message- Sent: Tuesday, July 01, 2003 3:00 PM To: Multiple recipients of list ORACLE-L On which unix boxes does SQL Server work? I don't want to replace all of my AIX, HP-UX and Solaris boxes with NT. I'll consider SQL

RE: Oracle DBA 9i Books ever needed.

2003-07-02 Thread Richard Ji
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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Microsoft VS Oracle (again)

2003-07-01 Thread Richard Ji
None. Hmmm, maybe if you run VMware on Linux then you can run SQL Server from a virtual machine. Richard Ji -Original Message- Sent: Tuesday, July 01, 2003 3:00 PM To: Multiple recipients of list ORACLE-L On which unix boxes does SQL Server work? I don't want to replace all of my AIX

RE: Microsoft VS Oracle (again)

2003-07-01 Thread Richard Ji
Message- Sent: Tuesday, July 01, 2003 4:15 PM To: Multiple recipients of list ORACLE-L None. Hmmm, maybe if you run VMware on Linux then you can run SQL Server from a virtual machine. Richard Ji -Original Message- Sent: Tuesday, July 01, 2003 3:00 PM To: Multiple recipients of list

RE: What are the restrictions in naming an Oracle SID/Database?

2003-06-30 Thread Richard Ji
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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Register vs. Load of JDBC driver

2003-06-27 Thread Richard Ji
mutiple drivers, when using DriverManager it will load the property jdbc.driver from say ~/.hotjava/properties if there is one. Also, one creates a new instances of the JDBC driver to register with DriverManager where Class.forName doesn't. Richard Ji -Original Message- Sent: Thursday, June

RE: SHMMAX setting on Sun 4800 box

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

RE: RE: SHMMAX setting on Sun 4800 box

2003-06-26 Thread Richard Ji
utility to determine whether ISM is used. There is also an article on Steve Adam's web site on how to prove it. Regards, Richard Ji -Original Message- Sent: Thursday, June 26, 2003 2:17 PM To: Multiple recipients of list ORACLE-L Richard Ji,ÄúºÃ£¡ Hi £¬ how do you know

RE: Register vs. Load of JDBC driver

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

RE: Oracle 9.2 RAC on Win2K?

2003-06-25 Thread Richard Ji
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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: LOCALLY MANAGED TABLESPACE

2003-06-24 Thread Richard Ji
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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services

RE: What are the type#'s in obj$ ?

2003-06-23 Thread Richard Ji
, */ /* 35 = INDEX SUBPARTITION */ Richard Ji -Original Message- From: Barbara Baker [mailto:[EMAIL PROTECTED] Sent: Mon 6/23/2003 7:49 PM To: Multiple recipients of list ORACLE-L Cc: Subject:What are the type#'s in obj$ ? Can anyone tell me in which fine manual I find

RE: MySQL in the future?

2003-06-20 Thread Richard Ji
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: oracle docs do say # of extents effect performance

2003-06-20 Thread Richard Ji
Even without stripping you can't gaurantee it will be a contiguous section of disk space. The file could be scattered across the file system. Richard Ji -Original Message- Sent: Friday, June 20, 2003 1:12 PM To: Multiple recipients of list ORACLE-L My favorite part is and all

RE: oracle docs do say # of extents effect performance

2003-06-20 Thread Richard Ji
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: (OT) RE: Look's like Larry's at it again...

2003-06-20 Thread Richard Ji
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://www.orafaq.net -- Author: Richard Ji

RE: copy a datafile to a raw device

2003-06-19 Thread Richard Ji
Well, this oracle file system is the logical storage structure of tablespace, segment, extent, db blocks which is the same on File System or raw device. Richard Ji -Original Message- Sent: Thursday, June 19, 2003 5:20 PM To: Multiple recipients of list ORACLE-L I might expand

RE: copy a datafile to a raw device

2003-06-19 Thread Richard Ji
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: copy a datafile to a raw device

2003-06-19 Thread Richard Ji
, 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: Richard Ji INET: [EMAIL PROTECTED] Fat City

RE: MySQL in the future?

2003-06-18 Thread Richard Ji
Glad to see another PostGresql like here. I always wonder why is MySql bigger than PostGreSql when it was inferior. My guess is that it was widely used as Web logging, site logging as an alternative to file based logging where people don't care much about transaction 'n such. Richard Ji

RE: MySQL in the future?

2003-06-18 Thread Richard Ji
why is MySql bigger than PostGreSql when it was inferior. My guess is that it was widely used as Web logging, site logging as an alternative to file based logging where people don't care much about transaction 'n such. Richard Ji -Original Message- Sent: Wednesday, June 18, 2003 9:50 AM

RE: MySQL in the future?

2003-06-18 Thread Richard Ji
Glad to see another PostGresql like here. I always wonder why is MySql bigger than PostGreSql when it was inferior. My guess is that it was widely used as Web logging, site logging as an alternative to file based logging where people don't care much about transaction 'n such. Richard Ji

RE: MySQL in the future?

2003-06-18 Thread Richard Ji
why is MySql bigger than PostGreSql when it was inferior. My guess is that it was widely used as Web logging, site logging as an alternative to file based logging where people don't care much about transaction 'n such. Richard Ji -Original Message- Sent: Wednesday, June 18, 2003 9

RE: MySQL in the future?

2003-06-18 Thread Richard Ji
such. Richard Ji -Original Message- Sent: Wednesday, June 18, 2003 9:50 AM To: Multiple recipients of list ORACLE-L Jesse, In the Open Source world I'm becoming a PostGreSql bigot. While there are a lot of folks out there using MySql I believe they acquired an inferior product. Dick

RE: MySQL in the future?

2003-06-18 Thread Richard Ji
as Web logging, site logging as an alternative to file based logging where people don't care much about transaction 'n such. Richard Ji -Original Message- Sent: Wednesday, June 18, 2003 9:50 AM To: Multiple recipients of list ORACLE-L Jesse, In the Open Source world I'm

RE: JDBC and MTS

2003-06-17 Thread Richard Ji
running on an Application Server? Richard Ji -Original Message- Sent: Monday, June 16, 2003 11:25 PM To: Multiple recipients of list ORACLE-L I'm not a Java expert so please forgive me my ignorance. JDBC application is facing very strange performance problems during connect. Every

RE: JDBC and MTS

2003-06-16 Thread Richard Ji
I used to seen problems with JDBC Thin with MTS on Linux and switching to a dedicated connection seemed to fix the problem. But JDBC Thin and MTS worked fine on my Solaris box. Not sure with HP-UX. Is the Java application running on an Application Server? Richard Ji -Original Message

RE: Want to BAARF - Recommendations for 10 36G Drive config

2003-06-13 Thread Richard Ji
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: db file sequential read [WAS:wait event puzzler]

2003-06-12 Thread Richard Ji
') 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 -- Author: Richard Ji INET

RE: Oracle Names

2003-06-12 Thread Richard Ji
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji 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 problem ??!!

2003-06-12 Thread Richard Ji
') 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 -- Author: Richard Ji INET: [EMAIL

RE: Isolation Level to get Phantom Read

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

RE: International User Community

2003-06-09 Thread Richard Ji
Title: International User Community I thought Iran registered it first. -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]Sent: Monday, June 09, 2003 12:35 PMTo: Multiple recipients of list ORACLE-LSubject: RE: International User Community IOUG? Is that an

RE: International User Community

2003-06-09 Thread Richard Ji
nusz, CPIM - Original Message - From: Richard Ji To: Multiple recipients of list ORACLE-L Sent: Monday, June 09, 2003 12:50 PM Subject: RE: International User Community I thought Iran registered it first. ---

RE: Setting database owner to sid

2003-06-07 Thread Richard Ji
command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

ora 1017

2003-06-06 Thread Richard Ji
the synonym and create a real table locally, everything works. I also tried to do a PL/SQL stack trace and got an ora-600. Any ideas? Thanks Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858

FW: ora 1017 -solved

2003-06-06 Thread Richard Ji
Never mind, I solved. Man, that error message is misleading. :) -Original Message- From: Richard Ji Sent: Thursday, June 05, 2003 4:46 PM To: Multiple recipients of list ORACLE-L (E-mail) Subject: ora 1017 Hi, I am accessing a table over database link, which

RE: Oracle ambushes Peoplesoft with $5.1bn bid

2003-06-06 Thread Richard Ji
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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: ORA-03113 After Pathc 8.1.7.4

2003-06-06 Thread Richard Ji
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: FW: ora 1017 -solved

2003-06-05 Thread Richard Ji
sequence that I forgot to create a synonym for. If the PL/SQL stack trace didn't bomb with ora-600 [17090], I would probably found it sooner. Richard Ji -Original Message- Sent: Thursday, June 05, 2003 5:26 PM To: [EMAIL PROTECTED] Cc: Richard Ji Importance: High and what did you do

RE: When will long datatype no longer be supported

2003-06-03 Thread Richard Ji
More against LONG: (1) Only one LONG column per table, not LOBs. (2) It's easier to manipulate LOBs than LONG, such as you can modify a piece of LOB etc. So this means easier to code. Richard Ji -Original Message- Sent: Monday, June 02, 2003 10:55 PM To: Multiple recipients of list

RE: ORA-27101: shared memory realm does not exist

2003-06-03 Thread Richard Ji
o Database is down. oWrong ORACLE_SID. o If your database processes is indeed up and you have the right ORACLE_SID, then you database might be in trouble. You can try to shut it down and restart it. Or you may choose to reboot oruse ipcs, ipcrm to clean it up. Because as not to mess other

RE: Oracle OCI JDBC Driver Not Recommended for Multiprocessor Mac

2003-04-03 Thread Richard Ji
. Richard Ji -Original Message-From: Jeremy Pulcifer [mailto:[EMAIL PROTECTED]Sent: Wednesday, April 02, 2003 12:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle OCI JDBC Driver Not Recommended for Multiprocessor Mac I've gone to using the thin driver

RE: backup the tablespace

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

RE: Is async IO configured on HP-UX?

2003-03-13 Thread Richard Ji
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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: can't create database

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

RE: POLL: Database to DBA ratio

2003-03-11 Thread Richard Ji
. But you can't just say I have NNN number of databases and therefore need NN number of DBAs. Richard Ji -Original Message- Sent: Tuesday, March 11, 2003 6:59 AM To: Multiple recipients of list ORACLE-L I'm trying to build a case for management that we need additional DBAs so I'd like to take

RE: sql query: to_date() :ORA-01830: date format picture ends bef

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

RE: Tablespaces - datafiles

2003-03-11 Thread Richard Ji
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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: How Reliable is Explain Plan in 9.2

2003-03-05 Thread Richard Ji
). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: Import Problem

2003-03-03 Thread Richard Ji
For GUI, you can use VNC. Or screen utility. Both are freely avaible. Or script it and nohup the job on Unix. Richard Ji -Original Message- Sent: Monday, March 03, 2003 9:09 AM To: Multiple recipients of list ORACLE-L I ran into a problem yesterday afternoon. I had exported

RE: Re[2]: How to start with Oracle Financial?

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

RE: update 30mil rows

2003-02-25 Thread Richard Ji
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Top 10 DBA Do's and Don'ts anyone

2003-02-23 Thread Richard Ji
(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Error pinning PKS in shared pool

2003-02-23 Thread Richard Ji
Title: Message remove exec immediate. Richard -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]Sent: Sunday, February 23, 2003 2:59 PMTo: Multiple recipients of list ORACLE-LSubject: Error pinning PKS in shared pool Sorry, new DB and hadn't

RE: storing credit card numbers in a database

2003-02-21 Thread Richard Ji
Title: storing credit card numbers in a database Besides the DBMS_OBFUSCATION_TOOLKIT, Application Security Inc also has a product to encrypt data in the database. Check out their web site www.appsecinc.com. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: 8.1.7 Instance not creating an SGADEF file

2003-02-20 Thread Richard Ji
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Richard Ji
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://www.orafaq.net -- Author: Richard Ji

RE: Setting up RAC environment on Linux - single node

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

RE: Know 1 database, know them all?

2003-02-17 Thread Richard Ji
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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Unix research source ???

2003-02-14 Thread Richard Ji
OH yea, thanks for point that out. Forgot aobut the GNOME stuff. Guess which one I like between GNOME and KDE? (hint, hint). :) -Original Message- Sent: Thursday, February 13, 2003 6:43 PM To: Multiple recipients of list ORACLE-L Quoting Richard Ji [EMAIL PROTECTED]: Very detailed

RE: Database naming conventions

2003-02-14 Thread Richard Ji
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: 10046 trace - weird library misses

2003-02-13 Thread Richard Ji
') 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 -- Author: Richard Ji INET

  1   2   3   4   >