RE: Starting Database from OEM 9.2 gives ORA-12500 Failed to star

the instance I personally use method 4. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Bye...

It's the end of an era. How long was the list hosted here? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: !!Please Read - Oracle-L is moving!!

to receive a conformation/response. I can see the headlines now, oracle-l slashdots freelists.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: kill session privilage

# = in_serial# ; if row_count 0 then execute immediate 'alter system kill session ''' || to_char (in_sid) || ', ' || to_char (in_serial#) || ; end if ; end ; / -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL

why would enable constraint cause a delete to wait on library cache lock?

21 0015 0 9 WAITING SQL -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

finding the partition for a newly inserted row, from inside a trigger on the table

) ; Row was placed in partition TP2 1 ligne créée. SQL insert into t (n, d) values (2, sysdate) ; Row was placed in partition TP1 1 ligne créée. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: Delete vs. truncate to free up spaces.

spaces. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Delete vs. truncate to free up spaces.

Then you should have the partitioning option. Partition your table if you can. -Original Message- Nguyen, David M It's Oracle8i Enterprise Edition. -Original Message- Jacques Kilchoer This is one of the cases where a partitioned table can be of great use. What

better delete statement to remove duplicate rows from exception table?

!= d.keep_row_id ) ; commit ; alter table orders enable constraint orders_uq1 ; truncate table my_exceptions ; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

wintercorp survey

ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: ** find whether table or index being accessed

there are always ad hoc SQL queries etc. Same for other objects like views etc. Is there a place where oracle stores objects accessed and any other related info. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services

RE: granting SELECT privilege on SYS.X$ TABLES

://www.orafaq.net -- Author: Jacques Kilchoer 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: granting SELECT privilege on SYS.X$ TABLES

to the select_catalog_role. Then I can access the x$tables without having to log on as sys. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Silly SQL Question

; but if it *was* the question, then the query is correct. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: Silly SQL Question

-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: truncate privilege

truncate privilege on particular table to a particular user? (Without using procedure) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: modeling year and month for summary data

:= trunc (:new.date, 'MM') ; If you need an index on year then you can use a function based index on trunc (date, '') -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Re: RE: Re: Stop using SYS, SYSTEM?

ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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 Code compilation and library cache lock issue

a procedure? Can this timeout be changed? If so, how? DB is 9202. -- A: Did you know about this ixora QA? How can I tell if a procedure/package is running? http://www.ixora.com.au/q+a/0110/30141015.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques

RE: Silly SQL Question

COUNT(*) = cnt / -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Silly SQL Question

usr from gab 8 where val=7; USR -- GAP GPA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

granting SELECT privilege on SYS.X$ TABLES

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

RE: granting SELECT privilege on SYS.X$ TABLES

Oracle 9.2 (SunOS): GRANTS 1-3 were successful, GRANT 4 failed Oracle 10.1 beta (Windows 2000): all GRANTS failed Does anyone know the reason for this strange behaviour? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City

RE: Looking for help - sql*loader and truncate

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

RE: data modelling question - job vs. job history table

are the same? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: data modelling question - job vs. job history table

to the physical model anyway. I guess I should look at the Conceptual Data Model option in my design tool. :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: Re: data modelling question - job vs. job history table

the table. My EUR 0.02 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: data modelling question - job vs. job history table

in a table that gets updated frequently? There is no reason to hold this pointer in the jobs table. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: Silly SQL Question

idea? Maybe it's a simple solution, but after several hours I feel blocked. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

data modelling question - job vs. job history table

://www.orafaq.net -- Author: Jacques Kilchoer 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: Re: Stop using SYS, SYSTEM?

on as SYSTEM would be (IMHO) like telling all the programmers You can all sign on as user 'coder' and all users you can all sign on in the database as user 'data_entry_person'. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED

RE: SQL*Plus errors... how to hide?

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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 partitioning Oracle 9.2

be put to free list and used by future inserts? Data is partitioned by date. So, my query is whether Oracle will put future data (which belongs to partition P_7 etc.) in space earlier used by P_1. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer

RE: Help sorting out SQL statement

1209 Normal hourly How is if possible for me to change the script so that my output is a unique rfx_id and only the maximum supplier_id is output (ie supplier_id 1209) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques

RE: ** database configuration assistant scripts

used in the creation? I clicked on the template but do not know where the template goes. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: Boolean dates...

of November 17th, 1858 CE. Modified Julian Days are always based on the Universal Time system, not local time. The Truncated Julian Day (TJD) is obtained by subtracting 2,440,000.5 from the AJD. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL

RE: Can I concatenate several rows without a procedure?

Yes. -Original Message- Jake Johnson I am trying to concatenate several records with simple sql. Is this possible? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: ORA-01401: inserted value too large for column

FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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

RE: Analyze - For All option

on -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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 Size

://www.orafaq.net -- Author: Jacques Kilchoer 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: Table Size

://www.orafaq.net -- Author: Jacques Kilchoer 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: Query question

Put the price of each company on three different fields -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: SUPPRESS SQL STATEMENTS

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

RE: alter session

? [EMAIL PROTECTED] wrote: List, what does the following do ? alter session set current_schema=sys; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: sid/serial# vs. audsid: why both?

of creating a new session identifier? But presumably only an Oracle developer could answer that question. -Original Message- Paul Drake Sent: mardi, 7. octobre 2003 00:54 --- Paul Drake [EMAIL PROTECTED] wrote: --- Jacques Kilchoer [EMAIL PROTECTED] wrote: In what cases

sid/serial# vs. audsid: why both?

-level command would be applied to an incorrect session object if SERIAL# were not available? Why not use AUDSID all the time? Is there a reason why the database keeps track of two session identifying numbers? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques

RE: what's the size of a date field?

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

RE: data loading

would be highly appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: sid/serial# vs. audsid: why both?

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

job announcement for Oracle DBA having experience with RAC (posted with approval of list owner)

with the ability to work well in a team environment . Good organizational and communication skills To apply, send a resume (MS Word compatible format) to [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network

RE: OFA myths was Re: BAARF

tablespace USERS - Miscellaneous user segments ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

locally managed autoallocate (was: Separate Indexes and Data)

-- Author: Jacques Kilchoer 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: OFA myths was Re: BAARF

to the original 8.0 install!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: OFA myths was Re: BAARF

://www.orafaq.net -- Author: Jacques Kilchoer 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: Tuning help required

to read and understand (also for the optimizer : it will know it's filtering on a range instead of distinct values). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: possible to have a primary key with a bitmap indx?

://www.orafaq.net -- Author: Jacques Kilchoer 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: Isnumeric question

) return number is x number ; begin x := to_number (str) ; return 1 ; exception when value_error then return 0 ; when others then raise ; end ; / -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED

RE: Package Body created with compilation errors-

OR REPLACE PACKAGE XYZ_PKG DOCAS DOC-- DOCPROCEDURE UPDATE_TEST(COL1 IN DROP_ME.C1%TYPE); DOCEND XYZ_PKG; DOC DOC*/ Warning: Package Body created with compilation errors. SQL show err No errors. SQL -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques

RE: Anyone have a copy of DUL ??

that in most Oracle databases, along with the software is included an online DUL. If I remember right it's called something like SQL. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Anyone have a copy of DUL ??

-- Author: Jacques Kilchoer 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

RE: pct_direct_access for a secondary index on an iot

-- - MYINDEX --As you can see I get a null value in the pct_dircect_access column. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: SQL help needed

as 1 and maxlinenbr as 10 that would be passed as variables (using ). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: tuning a massive delete

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

RE: how can I see which database I am logged into without v$instance and v$database

') as db_domain, sys_context ('userenv', 'db_name') as db_name, sys_context ('userenv', 'host') as host, sys_context ('userenv', 'instance') as instance from dual ; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City

RE: COBOL to Oracle

: http://www.orafaq.net -- Author: Jacques Kilchoer 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

RE: question for internals experts

anyone else published on this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: question for internals experts

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

RE: RAC 9i database - gx$ views ?

show any gx$ views? for example, what does this show you? select * from v$fixed_view_definition where view_name = 'V$PING' ; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: select strings with '_' in it

from table where col1 like 'v\_lan' / but it doesn't work. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Limits on PL/SQL block?

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

RE: 9i-OCP Question

believe the answer to the question is A: 8 -Original Message- Jacques Kilchoer Sent: Wednesday, July 30, 2003 9:19 PM To: Multiple recipients of list ORACLE-L -Original Message- From: Senthil Kumar [mailto:[EMAIL PROTECTED] What is the correct answer

RE: ** table triggers

:= false ; end ; / -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: 9i-OCP Question

-- Author: Jacques Kilchoer 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

RE: logon trigger to start tracing

file by using DBMS_SUPPORT, creating the trigger as a user that did not have ALTER SESSION privilege? My example was: --- Jacques Kilchoer [EMAIL PROTECTED] wrote: What database version? What is your setting for O7_DICTIONARY_ACCESSIBILITY? I tried the following in an 8.1.7 database

RE: logon trigger to start tracing

Never mind. I see that DBMS_SESSION has AUTHID CURRENT_USER (and of course DBMS_SUPPORT does not.) -Original Message- From: Jacques Kilchoer -Original Message- From: Wolfgang Breitling [mailto:[EMAIL PROTECTED] The logon user needs to have granted alter session

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

: http://www.orafaq.net -- Author: Jacques Kilchoer 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

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

sqlnumber but so far no joy. I'm using sql*plus 8.0.6.0.0 (running against an 8.1.6 db). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Who Says Oracle does not listen

then if dbms_sql.is_open (c_dynsql) then dbms_sql.close_cursor (c_dynsql) ; end if ; raise ; end drop_object ; / -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: Who Says Oracle does not listen

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

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

PROTECTED] from dba_users [EMAIL PROTECTED] where username like '%MC%' ; Which isn't horrible, although I do miss the numbers. But no matter--I'll just live with it... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat

RE: Job to run first Wednesday

2003/11/05 MERCREDI 2003/10/09 JEUDI 2003/11/05 MERCREDI 25 ligne(s) sélectionnée(s). SQL -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: logon trigger to start tracing

is added to the file. Anyone know what's going on here? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: piece-wise return of records from table

for it ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: piece-wise return of records from table

. -Original Message- From: Jacques Kilchoer Tom Kyte to the rescue! getting rows N through M of a result set http://asktom.oracle.com/pls/ask/f?p=4950:8:::NO::F4950_P8_DIS PLAYID,F4950_P8_CRITERIA:127412348064, or http://tinyurl.com/hqsl (You can ignore the little argument on that page where

RE: RE: help with dynamic pl/sql

method 4 dynamic sql with execute immediate instead of dbms_sql. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Orbitz issue

and they are blaming Oracle. Anyone with some inside info on what went wrong? just curious. i know its probably due to someone at Orbitz making a mistake. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network

RE: Find the table's name that using sequences

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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 security question

. So my question is what sys for? Thank you very much! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: installed users

, easy or clean. But I will have secure databases. Except of course, every app has a configuration file in which they hard-code the passwords. Sigh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services

RE: Restricting access via sqlplus

. But as you say there is still a risk from someone discovering the encryption scheme. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: composite primary key versus unique index

is to create a unique index (with and without desc) and create afterwards a primary key constraint on it in oracle. we have oracle 8.1.7.4.10. (including patches) -Original Message- From: Jacques Kilchoer I don't understand how you can have those types of objects created. Let's assume

RE: Restricting access via sqlplus

and no direct access to tables for example). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: Restricting access via sqlplus

FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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

RE: composite primary key versus unique index

!. Anyone with an explanation why a create of a composite unique index with an ascending and descending order works and not with the primary key clause ? Is this triggered in oracle 9i or 10i ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET

RE: unique constraint violation problem

recommends that we do not explicitly define unique indexes on tables. Why? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: unique constraint violation problem

. There are no duplicate records in the table. Could anyone explain why? Any input will be highly appreciated. Thanks in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: ER Tools (was: erwin)

been looking thru past messages found on orafaq.com (better searching than fatcity.com) and this is the majority of what I've been able to find. Anyone have more to add? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat

RE: grant for package body

: Jacques Kilchoer 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

(OT) ISS warns of coordinated hacker attack on July 6

targets for hackers, he said. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

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

I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? No You can not use spl char's. SID name should be in alpha's. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network

  1   2   3   4   5   6   >