Which storage solution is good or you will recommend

2003-12-02 Thread Liu, Jack
Hi, We need storage solution for Oracle database because we store a lot of tiff images and pdf files with the database, which storage solution are you using or which one you will recommend? Thanks, Jack -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Liu, Jack INET

ORA-00600 with Bind variable. Please help!

2003-08-07 Thread Liu, Jack
-- Author: Liu, Jack 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 this mailing list, send

Change nuber.+# to number

2003-07-31 Thread Liu, Jack
Hi,I want to get rid or those special char in a number string to a pure number, for an instance, from 89_. or 99,9 to 89 and 999.Which function should I use in SqlPlus?Thanks a lot, Jack Change nuber.+# to number

Emergent: ORA-06520: PL/SQL: Error loading external library

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

ORA-01691: unable to extend lob segment ELI.SYS_LOB0000025110C000

2003-07-22 Thread Liu, Jack
-- Author: Liu, Jack 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 this mailing list

RE: ORA-01691: unable to extend lob segment ELI.SYS_LOB0000025110

2003-07-22 Thread Liu, Jack
200 Thanks. Jack -Original Message- Sent: Tuesday, July 22, 2003 2:50 PM To: Multiple recipients of list ORACLE-L ELI.SYS_LOB025110C000 Assuming an 8k block size, that's 781 meg or so. Did you allocate enough space for that? Jared Liu, Jack [EMAIL PROTECTED] Sent

Increase tablespace, which way is better?

2003-07-18 Thread Liu, Jack
Title: Message Hi, I want to increase tablespace, just want to know which way is better:1. ALTER TABLESPACE SYSTEMADD DATAFILE '/u01/oradata/orcl/users02.dbf'SIZE 1MAUTOEXTEND ONNEXT 1MMAXSIZE 100M; 2.alter tablespace system add datafile '/u01/oradata/orcl/users02.dbf' size 100m; Thanks,

RE: Increase tablespace, which way is better?

2003-07-18 Thread Liu, Jack
is better? what are u gaining in #1 . -ak - Original Message - From: Liu, Jack To: Multiple recipients of list ORACLE-L Sent: Friday, July 18, 2003 1:29 PM Subject: Increase tablespace, which way is better

Log oracle error to Apache log instead of web page

2003-07-17 Thread Liu, Jack
Hi,How can I make those error messages display in the Apache error log instead of displaying them in the end user web. Which config file should I change?Thanks, Jack

alert_sid.log file: Performance statistics empty: data overflow

2003-07-17 Thread Liu, Jack
Hi, I often see this in my alert_sid.log file: Performance statistics empty: data overflow What does this mean, is there anything wrong with the Oracle DB? Thanks, Jack -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Liu, Jack INET: [EMAIL PROTECTED] Fat City

Store and retrieve image from bfile in Oracle 8.1.7.4

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