Constraints with Synonyms?

2001-04-03 Thread Walter K
Hi,   I have a need to create a synonym in a schema (A) for a table that is another schema (B). This is no problem. However, the table in question is a "parent" table and I cannot create the "references" constraint from the "child" to the "parent" when the "parent" is a synonym. When I attemp

Exp/Imp Fromuser/Touser & Security

2001-04-03 Thread Walter K
Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Ca

ANSI SQL Compliance (Oracle vs. SQL Server)

2001-05-03 Thread Walter K
st curious. Maybe I'm crazy. -w __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] F

RMAN Reporting?

2002-12-11 Thread Walter K
? Thanks. -w -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: RMAN Reporting?

2002-12-11 Thread Walter K
>backups for each database? I have pored through the RC >views and can produce such a report at the backup set >level but not at the database level. > >Am I missing something? Any suggestions? > >Thanks. >-w > >-- >Please see the official ORACLE-L FAQ: http://www.

Re: RMAN Reporting?

2002-12-11 Thread Walter K
t; >> Am I missing something? Any suggestions? >> >> Thanks. >> -w >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com >> -- >> Author: Walter K >> INET: [EMAIL PROTEC

RE: RMAN Reporting?

2002-12-11 Thread Walter K
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: Walter K I

Re: RMAN Reporting?

2002-12-17 Thread Walter K
ce a report from the RMAN> >> views/tables that lists the date and duration of the> >> backups for each database? I have pored through the> RC> >> views and can produce such a report at the backup> set> >> level but not at the database level.> >>> &

Staspack Grapher/Viewer ?

2002-09-19 Thread Walter K
Does anyone have or know of any utilities, preferably freeeware or very cheap, that can produce graphs of the data collected by statspack? Thanks VERY much in advance. -walt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat

Library object/cache locks?

2002-09-27 Thread Walter K
ERY much in advance. -Walt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RMAN - Remote vs Local Backups

2003-05-30 Thread Walter K
Hi,   Can anyone think of a reason(s) why one WOULD want to backup a database from a box other than the database box itself? Are there any advantages to this kind of configuration?   For example:   Box-A (production db server) Box-B (rman db server)   A cron job runs on Box-B which backups up the d

RE: RMAN - Remote vs Local Backups

2003-05-30 Thread Walter K
Thanks Tim, Dennis and Ron for your feedback. I appreciate it.   Let me clarify what I'm seeking. In my example, I am using a centralized catalog which is on its own dedicated database/server and backups are to tape. BCV's are not involved.   Normally, in my experience, RMAN backups are initiated f

RE: RMAN - Remote vs Local Backups

2003-05-30 Thread Walter K
In my scenario, target DB to be backed up on box A and rman database/catalog on Box B, I can "run" the backup from A or from B no problem. But, what I'm trying to get at is it better, worse or indifferent to "run" the backup from B or A. I would think there is extra network traffic to "run" the bac

How to keep "root" out?

2003-08-28 Thread Walter K
Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here.   We have a couple people in our Unix admin group that feel the need to "help" by writing their o

v$sort_usage

2002-07-16 Thread Walter K
tiple entries exist for a user with the SAME session_addr. I don't understand how a session could have multiple sort segments. As always, you're feedback is appreciated. Thanks. -w -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL

Import Issue/question

2001-08-01 Thread Walter K
ou Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Di

Indexes Used per Query

2001-08-14 Thread Walter K
! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Disk Names - sdXX vs. cXtXdXsX

2001-08-16 Thread Walter K
Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Delete followed by Select Count(1) - SLOW

2001-08-16 Thread Walter K
Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5

High DML Table - Suggestions??

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

Re: High DML Table - Suggestions??

2001-08-20 Thread Walter K
itrans, freelist of the table. Also if the table > has > foreign keys, talk with Development to leave the > table > without them. I should consider to partition the > tablemaybe a hash one. > > Regards. > > > --- Walter K <[EMAIL PROTECTED]> wrote: > &

High DML Table - I/O Suggestions???

2001-08-21 Thread Walter K
). -w __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Tricky Hierarchical Query

2001-08-31 Thread Walter K
ng returned except for 8, 11 and 12. Thanks in advance! -w __ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Au

RE: Tricky Hierarchical Query

2001-08-31 Thread Walter K
6 >9 5 6 > > > > -Original Message- > > From: Walter K [mailto:[EMAIL PROTECTED]] > > > > I am stumped on how to do a particular > hierarchical > > query. The query needs to be written entirely in > SQL. >

LogMiner - Null Username

2002-05-14 Thread Walter K
hat DELETE operations always have a null Username. Any ideas? Thanks. -w -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Inter

ITL Deadlock Example?

2002-05-21 Thread Walter K
o cause a deadlock to occur. Thanks. -w -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

RE: ITL Deadlock Example?

2002-05-22 Thread Walter K
row in each >block from each session in turn. > > > >Jonathan Lewis >http://www.jlcomp.demon.co.uk > |Walter K wrote: | |> Can someone post an example of how to trigger a |> deadlock (ORA-0060) due to ITL shortage? This is for |> informational/fact-finding purposes. |> |

Re: ITL Deadlock Example?

2002-05-22 Thread Walter K
-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists >-- -- >To REMOVE yourself from this mailing list, send an E- Mail message >to: [EMAIL PROTECTED] (note EXA

Mysterious Deadlock

2002-06-06 Thread Walter K
ed on: Session 95: no row -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Re: Mysterious Deadlock

2002-06-06 Thread Walter K
rans or >pctfree setting on that table > > >--- Walter K <[EMAIL PROTECTED]> wrote: >> We have an application that is periodically >> encountering what appears to be a self-deadlock. Only >> one session is listed and it holds an exclusive (X) >> lock

Re: Mysterious Deadlock

2002-06-06 Thread Walter K
>trying to insert/delete/update it at once? are ALL >dying, or just some? > > >jack silvey > >> --- Walter K <[EMAIL PROTECTED]> wrote: >> > We have an application that is periodically >> > encountering what appears to be a self-deadlock. >> Only

Re: Mysterious Deadlock

2002-06-06 Thread Walter K
ear the end of the article, but they talk about a deadlock >> with no rows and say it appears to be a problem with the initrans or >> pctfree setting on that table >> >> >> --- Walter K <[EMAIL PROTECTED]> wrote: >> > We have an application that i

Re: Mysterious Deadlock

2002-06-06 Thread Walter K
All indexes on the table involved have INI_TRANS=2 and PCT_FREE=10. --- Original Message --- To: Multiple recipients of list ORACLE-L >What's the initrans for the indexes involved ? > >Anjo. > > >Walter K wrote: > >> We have an application that is periodically

Varrays as Lobs & Tablespace Changing

2002-06-13 Thread Walter K
LTER TABLE...MOVE...? What I've read so far says I can't change the LOB storage parameters in this case. Thanks! -w -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

Blocking "illegal" connections

2001-12-12 Thread Walter K
ou Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services

Re: Blocking "illegal" connections

2001-12-12 Thread Walter K
so if > anyone comes in not via an app, all they can do is > login and nothing else... > > C > > --- Walter K <[EMAIL PROTECTED]> wrote: > Hi, > > > > We're trying to prevent users from connecting to our > > production database via "illegal"

Deadlock Graphs

2001-12-27 Thread Walter K
cipher the trace file. Thanks. -w __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Networ

How to Trace PL/SQL

2002-01-07 Thread Walter K
s. -w __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Calif

EMC Not Releasing Space

2002-01-08 Thread Walter K
/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet ac

dbms_stats.gather... (method_opt)

2002-01-11 Thread Walter K
Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

dbms_stats.gather... (method_opt)

2002-01-14 Thread Walter K
__ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RMAN - restoring archive logs

2002-01-18 Thread Walter K
on a development box. Any suggestions would be appreciated. Thanks. -w __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K IN

LogMiner and ORA-03113

2002-01-18 Thread Walter K
Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Cali

Re: LogMiner and ORA-03113

2002-01-18 Thread Walter K
Block size is 8k. Interesting, how is the block size related? --- Joe Testa <[EMAIL PROTECTED]> wrote: > whats your blocksize, anything other than 2K has > been know to cause all > kinds of problems. > > joe > > > Walter K wrote: > > > I'm trying

ORA-01555 Mystery (Help)

2002-01-25 Thread Walter K
? Thanks!!! -w __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: ORA-01555 Mystery (Help)

2002-01-25 Thread Walter K
e > > to overwrite the original rollback segments rather > than extend if it > > thinks > > it doesn't need those segments any more.) > > > > I'd strongly suggest you get the stuff from Steve > Adams' ixora site > > that > > places an unc

RE: ORA-01555 Mystery (Help)

2002-01-25 Thread Walter K
s been > overwritten. (Oddly > > enough, > > even when there's plenty of space to extend the > rollback, Oracle will > > decide > > to overwrite the original rollback segments rather > than extend if it > > thinks > > it doesn't need those

RE: ORA-01555 Mystery (Help)

2002-01-25 Thread Walter K
gt; But it can't hurt. > > select TO_CHAR(SYSDATE,'DD-MON-:HH24:MI:SS'), >osuser o, username u, >segment_name s, substr(sa.sql_text,1,500) txt > from v$session s, > v$transaction t, > dba_rollback_segs r, > v$sqlarea

ORA-01555 - Delayed Block Cleanout

2002-01-28 Thread Walter K
ttp://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Li

Email --> DB (export/parse)

2002-02-19 Thread Walter K
s. -w __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

Where's Chris these days?

2002-03-01 Thread Walter K
e the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --

Sqlplus Auto-trim Whitespace???

2002-04-05 Thread Walter K
e book? Thanks again! -w __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

RE: Sqlplus Auto-trim Whitespace???

2002-04-05 Thread Walter K
r > the command). > Margaret > > > -Original Message- > > From: Walter K [mailto:[EMAIL PROTECTED]] > > Sent: Friday, April 05, 2002 2:37 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Sqlplus Auto-trim Whitespace??? > > > > > >

DBMS_STATS.gather_database_stats

2002-04-25 Thread Walter K
Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: DBMS_STATS.gather_database_stats

2002-04-25 Thread Walter K
-- -- >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

PK - Character vs. Numeric

2002-05-07 Thread Walter K
hanks. -W -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

LogMiner - Null Username

2002-05-13 Thread Walter K
hat DELETE operations always have a null Username. Thanks. -w -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

Alter Table Move

2001-06-26 Thread Walter K
ER TABLE...MOVE... usable with LONGS? Thanks! -w __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL

Sqlplus--how to suppress "Connected."

2001-06-26 Thread Walter K
ql contains the text "CONNECT / AS SYSDBA". Any suggestions? Thanks again! -w __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq

Exp/Imp - suppress screen output?

2001-07-20 Thread Walter K
ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To

ODBC bad?

2001-05-10 Thread Walter K
tting the database? Thanks again for the assistance! -w __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [

ODBC Connections Bad?

2001-05-10 Thread Walter K
tting the database? Thanks again for the assistance! -w __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [

Space Estimation & Performance (numbers)

2001-05-21 Thread Walter K
. TIA! -wk __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-

RE: Space Estimation (numbers)

2001-05-21 Thread Walter K
_ > Do You Yahoo!? > Yahoo! Auctions - buy the things you want at great > prices > http://auctions.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Wal

RE: Space Estimation (numbers)

2001-05-21 Thread Walter K
of physical space > > required for storing a number? (i.e. NUMBER, > > NUMBER(5), NUMBER(10,5), etc.) I believe Oracle > uses > > "2's compliment" for storing numbers. A value of > > 1 > > does not seem to take up the same amount of space > as >

RE: Space Estimation (numbers)

2001-05-21 Thread Walter K
can be calculated using: length = floor [(p+1)/2] + 1 add +1 byte (only for negative numbers where the number of significant digits is less than 38). > --- Walter K <[EMAIL PROTECTED]> wrote: > > Thanks, but the table doesn't exist yet.

RE: Space Estimation (numbers)

2001-05-21 Thread Walter K
ted using: length = floor [(p+1)/2] + 1 add +1 byte (only for negative numbers where the number of significant digits is less than 38). --- Walter K <[EMAIL PROTECTED]> wrote: > Thanks, but the table doesn't exist yet. Also, I > need >

Standby vs. Adv. Replication (Multi-master)

2001-05-25 Thread Walter K
oo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Publi

RE: Standby vs. Adv. Replication (Multi-master)

2001-05-25 Thread Walter K
gt; Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an >

Working with a BLOB

2001-05-30 Thread Walter K
sonalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--

RE: Working with a BLOB

2001-05-31 Thread Walter K
> Would someone help me out? Thanks! > -w > > __ > Do You Yahoo!? > Get personalized email addresses from Yahoo! Mail - > only $35 > a year! http://personal.mail.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: >

Tablespace Allocation Type & Extent Management

2001-05-31 Thread Walter K
ted. -w __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network S

Re: Tablespace Allocation Type & Extent Management

2001-06-01 Thread Walter K
to be careful when converting that you > have a reasonable size for common denominator of all > extents. If you had (for example) some 128k and > some > 136k extents, then the local tspace conversion would > need it bitmaps based on 8k - not probably what you > had in mind. >

DBMS_LOB.INSTR( ) ????

2001-06-01 Thread Walter K
, prior to the above query. Thanks again! -w __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wal

No Subject

2001-06-03 Thread Walter K
, prior to the above query. Thanks again! -w __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wal

DBMS_LOB.INSTR( ) ???

2001-06-04 Thread Walter K
, prior to the above query. Thanks again! -w __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wal

SID on sqlplus prompt?

2001-06-08 Thread Walter K
ail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

Licensing

2001-09-07 Thread Walter K
dback is appreciated! -w __ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROT

Licensing??

2001-09-10 Thread Walter K
___ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-

Spatial included w/9i ????

2001-09-14 Thread Walter K
_ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Good/Cheap Backup Agent?

2001-09-18 Thread Walter K
e official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Good/Cheap Backup Agent?

2001-09-18 Thread Walter K
; > __ > > Terrorist Attacks on U.S. - How can you help? > > Donate cash, emergency relief information > > > http://dailynews.yahoo.com/fc/US/Emergency_Information/ > > -- > > Please see the official ORA

Optimal Disk Layout??

2001-09-21 Thread Walter K
appreciated. Thanks again for the feedback. -w __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.ora

RE: Optimal Disk Layout??

2001-09-21 Thread Walter K
orse I/O > performance with the new array because it has so > fewer > physical drives, thus eliminating the benefit of not > having to write the parity info. > > Do you concur? Knowing the two arrays I have to work > with, which would be the better configuration? > > An

Oravle vs. Informix

2001-10-02 Thread Walter K
Thanks. -w __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services--

Checkpoint Duration

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

Sar Loader Script?

2001-02-03 Thread Walter K
By chance, does anyone have a script that will reparse a collection of sar statistics, that came from "sar -d", into a file that can be used by SQL*Loader?My problem is that the timestamp, which is just that--no date, is only on the first record of each sample rather than every record and I

Sar Loader Script?

2001-02-05 Thread Walter K
By chance, does anyone have a script that will reparse a collection of sar statistics, that came from "sar -d", into a file that can be used by SQL*Loader?My problem is that the timestamp, which is just that--no date, is only on the first record of each sample rather than every record and I d

Re: Sar Loader Script?

2001-02-05 Thread Walter K
e name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the offici

Bstat/Estat File -> Table?

2001-02-07 Thread Walter K
Hi,   Just curious if anyone has a script(s) that will take the contents of the report.txt file and turn it into loadable files or something along those lines. I know about 'statspack' but many companies are hesitant to permit the creation of  tables for storing statistics on their productio