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 lis

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

start the service, then sqlplus /nolog connect sys/password as sysdba startup which will start 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

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

gt; web and email methods and have yet 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

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.o

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

40114204 0264181C 10*mode+namespace 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

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

erveroutput on SQL> insert into t (n, d) values (1, sysdate) ; 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 Kilc

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 p

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

wintercorp survey

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 h

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

RE: ** find whether table or index being accessed

n even if code is covered 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 P

RE: Silly SQL Question

(usr, val) values (usra (m), vala (m)) ; commit ; end if ; end loop ; commit ; end ; / -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PR

RE: Silly SQL Question

swer. If that wasn't the > question, then that won't be the answer; 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 Netwo

RE: granting SELECT privilege on SYS.X$ TABLES

my test > databases and grant select 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-

RE: granting SELECT privilege on SYS.X$ TABLES

RACLE-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 - T

RE: granting SELECT privilege on SYS.X$ TABLES

ailed 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

granting SELECT privilege on SYS.X$ TABLES

viour? -- 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 ser

RE: Silly SQL Question

4 select usr from gab 5 where val=5 6 intersect 7 select 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.fatcit

RE: Silly SQL Question

) > WHERE val IN (1, 5, 7) > AND cnt = 3 > GROUP BY > usr > , cnt > HAVING 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-50

RE: DB Code compilation and library cache lock issue

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 this mailing l

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

ngless. -- 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 lis

RE: modeling year and month for summary data

a before insert/update trigger that sets :new.date := 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: [E

RE: truncate privilege

ere a way to give 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.fat

RE: Silly SQL Question

ave a table with like this: > > > > Usr val > > -- > > GAP 1 > > GAP 5 > > GAP 7 > > JKL 8 > > JKL 5 > > > > I need a query that returns the user (GAP o JKL) that > > has ALL the values in a list. Example: Having the &

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

map index on a column 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 ht

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

with the process which presumably polls 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-

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

e. I have a tendency to go straight 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 Net

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

t;why have two tables when all the columns 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-

RE: Looking for help - sql*loader and truncate

ner > to do the load. -- 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: Re: Stop using SYS, SYSTEM?

them if it's OK to shutdown the database. Telling all the DBAs "sign 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'&q

data modelling question - job vs. job history table

ial 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: SQL*Plus errors... how to hide?

END; > > * > ERROR at line 1: > ORA-01722: invalid number > ORA-06512: at "TRAIN65D.RELEASE_PO_B_H", line 16 > ORA-06512: at line 1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City N

RE: Table partitioning Oracle 9.2

> space earlier used by P_1. -- 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: Help sorting out SQL statement

he 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 Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: ** database configuration assistant scripts

ripts 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

RE: Boolean dates...

240.5 The offset of 0.5 means that MJDs start midnight 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:

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 Service

RE: Analyze - For All option

|| a.column_name as object, case when a.last_analyzed is null then 'NO' else 'YES' end as analyzed, a.last_analyzed, count (b.endpoint_number) as histograms from user_tab_columns a, user_tab_histograms b where a.table_name = '&&table_name'

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

d value too large for column" > INSERT INTO CHAR_TEST (CHAR1) > VALUES (po_out); > > EXCEPTION WHEN OTHERS > THEN > dbms_output.put_line('Error: ' || SQLERRM); > END; -- Please see the official ORACLE-L FAQ: http:

RE: Query question

that? 0010041 12.3412.74 11.99 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, C

RE: Table Size

WHERE OWNER=UPPER('') AND SEGMENT_NAME = UPPER(''); -Original Message- Could somebody help me in finding the actual size of an oracle table in GB. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED]

RE: Table Size

e segment_name = 'TABLE_NAME'; -- 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 service

RE: SUPPRESS SQL STATEMENTS

X # -- 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, Cal

RE: alter session

ible that it gets the user a termination notice. you're in the sys schema for what purpose? testing recovery from dictionary corruption? [EMAIL PROTECTED] wrote: List, what does the following do ? alter session set current_schema=sys; -- Please see the official ORACLE-L FAQ: http://

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

iting use SID/SERIAL# instead 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: > > ---

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

umbers? > > AUDSID is 0 if connecting as internal. Notes 123128.1 and > 122230.1 may help! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-50

RE: data loading

re not > available during the loading that gives us problem for our 24x7 > availability. Therefore, we would like to change our loading > method. Any > ideas would be highly appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [E

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

> select data_length from dba_Tab_columns where table_name='TESTING'; > DATA_LENGTH > --- > 7 > > > select length (timestamp) from abc; > LENGTH(TIMESTAMP) > - > 9 -- Please see the official ORACLE-

sid/serial# vs. audsid: why both?

session-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:

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

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

talled. > > I try and get it back 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-- Ma

locally managed autoallocate (was: Separate Indexes and Data)

t to reuse at some point. -- 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

iated with data in the USERS 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-

RE: OFA myths was Re: BAARF

es that had everything under > $ORACLE_HOME/dbs and > no naming standard for datafiles. Ugh! > > Now if we could only find this "Cary V. Millsap, Oracle Corporation" > character so he could explain himself. ;-) '95 was a > loo

RE: Tuning help required

x27;, 'MMDD'), to_date ('20030926', 'MMDD'), to_date ('20030927', 'MMDD'), to_date ('20030928', 'MMDD'), to_date ('20030929', 'MMDD'), to_date ('20030930', 'Y

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

e 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: Isnumeric question

your own function create function is_number (str in varchar2) 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.orafa

RE: Package Body created with compilation errors-

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 Kilchoer INET: [EMAIL PROTECTED] Fat City Network Service

RE: pct_direct_access for a secondary index on an iot

ht as well analyze the bmp index ( this does no harm right ? ) > SQL> analyze index myindex compute statistics; > Index analyzed. > > SQL> select index_name, pct_direct_access from DBA_indexes > where index > _name = 'MYINDEX' and owner=user; > > INDEX_NAME

RE: Anyone have a copy of DUL ??

ies to extract as much as possible. > > Tanel. -- 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 ho

RE: Anyone have a copy of DUL ??

scans only relevant datablocks. I think 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: [EMAI

RE: tuning a massive delete

> the records > are null > > > > > > what do i need to change? > > > > > > > > Ooops, I have permuted a's and b's in the where clause ... > > > > Otherwise not to sure about the nvl(). Wait a minute ... > we are get

RE: SQL help needed

ow would I find out the missing linenbrs (2,3,5,6,7) if I > was given minlinenbr 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

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

. select sys_context ('userenv', 'db_domain') 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 ; -- Pleas

RE: question for internals experts

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: question for internals experts

e Adams has in his book or on his website? Has 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

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: RAC 9i database - gx$ views ?

the source code for a RAC view 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 Netw

RE: select strings with '_' in it

x27;vclan'. Is it possible > to do that? > > I tried > set escape on > select col1 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

RE: Limits on PL/SQL block?

he database to find out the size of the procedure/package/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, Californ

RE: 9i-OCP Question

he archive log destination. > > That being said, I 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-

RE: 9i-OCP Question

rs) and ARCn (reading the members)." -- 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 servi

RE: ** table triggers

ate on t2 begin p.t2_upd := 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 h

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

RE: logon trigger to start tracing

but then why was I able to get a trace 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?

RE: piece-wise return of records from table

he best solution. > -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 ignor

RE: piece-wise return of records from table

? SQL or PL/SQL any 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 l

RE: logon trigger to start tracing

> ORA-06512: at line 2 > > > When SQL statements are executed in the session, no further trace > information 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:

RE: Job to run first Wednesday

/07 LUNDI 2003/08/06 MERCREDI 2003/07/08 MARDI 2003/08/06 MERCREDI 2003/08/01 VENDREDI 2003/08/06 MERCREDI 2003/08/02 SAMEDI2003/08/06 MERCREDI 2003/08/03 DIMANCHE 2003/08/06 MERCREDI 2003/08/04 LUNDI 2003/08/06 MERCREDI 2003/08/05 MARDI 2003/08/06 MERCREDI 2003/08/06 MER

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

gt; [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]

RE: Who Says Oracle does not listen

statement, dbms_sql.native) ; ignore := dbms_sql.execute (c_dynsql) ; dbms_sql.close_cursor (c_dynsql) ; exception when no_cluster or no_cluster2 or no_dblink or no_dimension or no_index or no_indextype or no_indextype2 or no_java or no_operator or no_outline or no_profile or

RE: Who Says Oracle does not listen

or no_operator or no_outline or no_profile or no_role or no_rbs or no_sequence or no_snapshot or no_snapshot_log or no_object_generic or no_synonym or no_pub_synonym or no_table or no_tablespace or no_trigger or no_user or no_source then if dbms_sql.is_open (c_

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

7;t have a test > > > executable to > > > test it. But have you tried it? > > > > > > Arup Nanda > > > - Original Message - > > > > > > > That's right--I am lookin

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

> been playing > around w/sqlcontinue & 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: [E

RE: RE: help with dynamic pl/sql

. > Steve Fuerstein has an article where he shows you how to do 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

RE: Orbitz issue

that Orbitz is down 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:

RE: Find the table's name that using sequences

unds good to > me, but I would love to hear pros/cons about 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 Sa

RE: installed users

even begin to talk about the fact that just about EVERY user > seems to have "unlimited tablespace" priv. > > This is not going to be pretty, easy or clean. But I will have secure > databases. Except of course, every app has a configuration file in > which they hard-c

RE: Oracle security question

ething > like "connection to > sys should be as sysdba or sysoper". 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 Servi

RE: Restricting access via sqlplus

rk then its better. You > could also > encrypt the network traffic of course. 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

RE: Restricting access via sqlplus

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

RE: Restricting access via sqlplus

plemented inside database as well, through PL/SQL packages 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,

RE: composite primary key versus unique index

y key. > The workaround 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 und

RE: unique constraint violation problem

cord > was inserted > into the table successfully. > > I know Oracle 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

RE: composite primary key versus unique index

or 10i ? -- 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: ER Tools (was: erwin)

ve 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:

RE: unique constraint violation problem

er, the record was inserted into the table successfully. > 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 Kilchoe

RE: grant for package body

ttp://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 fr

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

ven't yet been patched are attractive 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

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

allowed? > > > >No You can not use spl char's. SID name should be in alpha's. > > > >2. What is the maximum size of a SID/Database name in Unix? > > > >8 chars > > > >3. What is the maximum size of a SID/Database name in Windows? >

  1   2   3   4   5   6   >