Re: Oracle 8.1.7 can only use the first 15th indexes?

2004-01-21 Thread Kaing, Leng
). Regards Jonathan Lewis -- Leng Kaing Email: [EMAIL PROTECTED] Phone: +61-3-9203-7589 Mobile: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED] Fat City Network

Oracle 8.1.7 can only use the first 15th indexes?

2004-01-20 Thread Kaing, Leng
. -- Leng Kaing Email: [EMAIL PROTECTED] Phone: +61-3-9203-7589 Mobile: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: read-only simple snapshot/materialised view refresh

2004-01-14 Thread Kaing, Leng
: Kaing, Leng Subject: Re: read-only simple snapshot/materialised view refresh Importance: High Leng, You didn't mention the frequency of the refresh. I also don't see mention of which database is generating the ora-1555 errors. Jared Kaing, Leng [EMAIL

read-only simple snapshot/materialised view refresh

2004-01-13 Thread Kaing, Leng
://www.orafaq.net -- Author: Kaing, Leng 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: Importing LOB segments

2003-10-13 Thread Kaing, Leng
to speed up this process... rgds jb -- Leng Kaing Email: [EMAIL PROTECTED] Phone: +61-3-9203-7589 Mobile: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED

Re: Strange Request

2003-10-08 Thread Kaing, Leng
: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Rebuilding/Moving master table, snapshot log and snapshot

2003-10-07 Thread Kaing, Leng
. Then, you have to specify online option. I was moving aound indexes, tables and partitions, without any problems. I even moved a SYS table (AUD$) into another tablespace. No problem whatsoever. On 2003.10.06 22:34, Kaing, Leng wrote: Good morning, everyone

Rebuilding/Moving master table, snapshot log and snapshot

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

Re: Table not reusing deleted space

2003-10-03 Thread Kaing, Leng
(1048576k /20) indicates that your average row length is over 5k. If you have 8k blocks, this means an average of 1 row per block (perhaps less depending on the variance in row length). Daniel Fink Kaing, Leng wrote: Hello everyone, Env: 8.1.7.4, SunOs 5.8 64 Bit We seem to hitting bug

RE: Table not reusing deleted space

2003-10-01 Thread Kaing, Leng
Mobile: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Table not reusing deleted space

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

xx of the year

2003-09-09 Thread Kaing, Leng
. -- Leng Kaing Email: [EMAIL PROTECTED] Phone: +61-3-9203-7589 Mobile: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Logical standby's progress

2003-08-26 Thread Kaing, Leng
: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: OEM 9i - saving/copying reports between repositories

2003-06-30 Thread Kaing, Leng
show up on the webpage. Kaing, Leng [EMAIL PROTECTED] wrote: G'day all, I've create a number of custom reports in one of our OMS and would copy them into another OMS. How does one go about doing this? Where are the reports stored? Is there a file that we can copy around? Or if we look

OEM 9i - saving/copying reports between repositories

2003-06-27 Thread Kaing, Leng
into another. TIA, Leng. -- Leng Kaing Email: [EMAIL PROTECTED] Phone: +61-3-9203-7589 Mobile: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED] Fat City

Re: RAC vs. OPS a comparison

2003-06-22 Thread Kaing, Leng
-9203-7589 Mobile: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

8i: long to clob using export/import

2003-06-06 Thread Kaing, Leng
Oracle 8i documentation on it. TIA, Leng. -- Leng Kaing Email: [EMAIL PROTECTED] Phone: +61-3-9203-7589 Mobile: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED

RE: Teradata banned from IOUG???

2003-02-19 Thread Kaing, Leng
: It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED] Fat City Network Services

Re:Can logminer be used against 7.3 databases?

2003-02-05 Thread Kaing, Leng
-- Leng Kaing Email: [EMAIL PROTECTED] Phone: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: SQL*Plus Worksheet Question

2003-02-03 Thread Kaing, Leng
dual; select global_name from global_name; set sqlprompt A@B. HTH ... Regards JAI Kaing, Leng [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/03/03 11:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject

RE: SQL*Plus Worksheet Question

2003-02-02 Thread Kaing, Leng
-- Author: Kaing, Leng 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

OEM 9.2 - scheduled reports

2003-01-21 Thread Kaing, Leng
a lot of databases running around here. Help! TIA, Leng. -- Leng Kaing Email: [EMAIL PROTECTED] Phone: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED] Fat

OEM 9.2: scheduling a report to run on predefined intervals

2003-01-19 Thread Kaing, Leng
://www.orafaq.net -- Author: Kaing, Leng 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

[no subject]

2003-01-16 Thread Kaing, Leng
-- Author: Kaing, Leng 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

Run obsolete Oracle 7 scripts against Oracle 8i database?

2003-01-14 Thread Kaing, Leng
the OEM reports. TIA, Leng. Email: [EMAIL PROTECTED] Phone: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

OEM 9.2: breaks in reports

2003-01-14 Thread Kaing, Leng
://www.orafaq.net -- Author: Kaing, Leng 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