RE: adding columns to system tables

2001-05-18 Thread Cale, Rick T (Richard)
l ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---

RE: DB Link Between Prod and Test?

2001-05-15 Thread Cale, Rick T (Richard)
ACLE-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.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services--

RE: Silver vs. Gold support

2001-05-10 Thread Cale, Rick T (Richard)
ing 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.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Actual size of database

2001-05-01 Thread Cale, Rick T (Richard)
Hi All, Oracle 8.0.5 NT 4 Does anyone have a script they would share that can calculate the ACTUAL size of a database(space_used) not what has been allocated? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED

RE: Datafile needs media recovery

2001-04-20 Thread Cale, Rick T (Richard)
ck online. We cannot drop the tablespace and rebuild. We could maybe export all objects in that tablespace then rebuild. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Datafile needs media recovery

2001-04-20 Thread Cale, Rick T (Richard)
then rebuild. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: tnsnames problem

2001-04-18 Thread Cale, Rick T (Richard)
formation (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Prompt and accept a value inside a procedure

2001-04-18 Thread Cale, Rick T (Richard)
Hi All, Is there a way to prompt a user and accept input from the user inside a procedure. I cannot get the prompt/accept to work inside a procedure. It works it sql*plus. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET

RE: imp - limitation on number of tables?

2001-04-11 Thread Cale, Rick T (Richard)
ame 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.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Ser

Full import from Oracle 7.3.4 on NT to Solaris 8.1.7

2001-04-10 Thread Cale, Rick T (Richard)
the tablespaces then import with ignore=y option? Thanks Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED

RE: inserting into DATE colum

2001-04-09 Thread Cale, Rick T (Richard)
x27;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.orafa

RE: Which CD?

2001-04-02 Thread Cale, Rick T (Richard)
--- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling 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

RE: sqlloader

2001-03-30 Thread Cale, Rick T (Richard)
; 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.oraf

RE: Set transaction does not work

2001-03-29 Thread Cale, Rick T (Richard)
FAQ: http://www.orafaq.com > -- > Author: Tim Sawmiller > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > -

Off Topic Unix question

2001-03-27 Thread Cale, Rick T (Richard)
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

Doc on migrating to Oracle 8.1.6 on Solaris

2001-03-26 Thread Cale, Rick T (Richard)
x27;s Reference Thanks Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services--

RE: Easy Doubt in sql/plus

2001-03-21 Thread Cale, Rick T (Richard)
ng Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L >

RE: Someone changed INTERNAL password URGENT

2001-03-20 Thread Cale, Rick T (Richard)
DY, 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.com -- Author: Cale, Rick T (Richard) INET:

RE: Utl_file question

2001-03-15 Thread Cale, Rick T (Richard)
> To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to

Order of table_name resolution

2001-03-14 Thread Cale, Rick T (Richard)
International Corp. Phone:865-481-2198, fax:865-481-8555 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: where does loadjava store stuff

2001-03-02 Thread Cale, Rick T (Richard)
o 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.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FA

Confusion about what partition a record is stored using hash partitions

2001-03-01 Thread Cale, Rick T (Richard)
. Thanks Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: [Q] SQL statement need help !!

2001-02-23 Thread Cale, Rick T (Richard)
can answer the above question? Forward it to > them! > to unsubscribe, send a blank email to [EMAIL PROTECTED] > to subscribe send a blank email to [EMAIL PROTECTED] > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: What is limit on Search Condition in DBA_CONSTRAINTS table

2001-02-23 Thread Cale, Rick T (Richard)
-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.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Serv

RE: Materialized View Problem

2001-02-22 Thread Cale, Rick T (Richard)
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.com -- Author: Cal

How to install OEM tools

2001-02-22 Thread Cale, Rick T (Richard)
I have the DB. Thanks Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services

Reorganize tablespace

2001-02-20 Thread Cale, Rick T (Richard)
://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

RE: Compilation of Pro*C code on WINNT:-Urgent

2001-02-14 Thread Cale, Rick T (Richard)
Guru') 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:/

RE: drop object question

2001-02-14 Thread Cale, Rick T (Richard)
] (note EXACT spelling 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 ORACL

RE: Renaming a Column

2001-02-14 Thread Cale, Rick T (Richard)
. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Saurabh Sharma > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Li

RE: ORA-04020: deadlock detected while trying to lock object...

2001-02-09 Thread Cale, Rick T (Richard)
ACT spelling 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:

RE: Sql Tuning help

2001-02-07 Thread Cale, Rick T (Richard)
> > > > Matt Southcott > DBA > Starnetsystems > (268) 480 1734 > > << File: Matthew Southcott.vcf >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Servic

RE: NOT COMPLETE LOG

2001-02-07 Thread Cale, Rick T (Richard)
e 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.com -- Author: Cale, Rick T (Richard) INET: [EMAIL P

RE: ORA-12514 TNS names could not resolve service name

2001-02-01 Thread Cale, Rick T (Richard)
s I want to connect using > service name. > Any ideas? > > Thanks > Rick Cale, Science Applications International Corp. > Phone:865-481-2198, fax:865-481-8555 > e-mail: [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > A

ORA-12514 TNS names could not resolve service name

2001-02-01 Thread Cale, Rick T (Richard)
service name. Any ideas? Thanks Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services

imp full=y indexfile=filename does not produce create tablespace ....

2001-02-01 Thread Cale, Rick T (Richard)
commands should be in file.sql Can someone clarify? Thanks Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat

RE: Copying some rows from a table having a long datatype column.

2001-01-31 Thread Cale, Rick T (Richard)
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.com -- Author: Cale, Rick T (Richard)

ORA-12645 parameter does not exist

2001-01-31 Thread Cale, Rick T (Richard)
:865-481-8555 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Off Topic-Forms application question

2001-01-30 Thread Cale, Rick T (Richard)
PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

<    1   2