SAP Tablespace Conventions (WAS: Convert to LMTs)

2004-01-07 Thread Hand, Michael T
-- Author: Hand, Michael T 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

FW: SAP Tablespace Conventions (WAS: Convert to LMTs)

2004-01-07 Thread Hand, Michael T
see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T 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 tablespace offline

2003-12-16 Thread Hand, Michael T
FAQ: http://www.orafaq.net -- Author: Hand, Michael T 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: making me crazy

2003-09-10 Thread Hand, Michael T
Title: RE: making me crazy Paula, Would putting both listeners in one listener.ora file help. You would, of course have to change one or bothto a non-default name. Mike -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 10, 2003

RE: Change based recovery

2003-08-14 Thread Hand, Michael T
Lisa, The 3rd option (besides shuting down source database and using a controlfile trace) is to "alter database backup controlfile to 'filename'; ", use this file, then proceed with the recovery as Venu suggests. I've used this method on a hot backup to roll the database forward. Also,

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

2003-07-23 Thread Hand, Michael T
! -Roy Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Managing Archived Redo Logs

2003-07-23 Thread Hand, Michael T
entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: Production Database stays up; copies will not recover - Resol

2003-07-02 Thread Hand, Michael T
) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T

Production Database stays up; copies will not recover

2003-07-01 Thread Hand, Michael T
. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat

Preparing for Performance test

2003-06-11 Thread Hand, Michael T
the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: dbms_stats broken

2003-05-30 Thread Hand, Michael T
see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T 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 DB Backups on SAN with ALTER SYSTEM SUSPEND

2003-03-27 Thread Hand, Michael T
http://www.speakeasy.net/~jwilton On Wed, 26 Mar 2003, Hand, Michael T wrote: Jeremiah, The only reason I could forsee is if the split is not atomic. This is the case in our (Non-SAN) environment. The split takes several minutes and the control files have been mis-matched when the DB copy

RE: Locking tables in Oracle

2003-03-27 Thread Hand, Michael T
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: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: Oracle DB Backups on SAN with ALTER SYSTEM SUSPEND

2003-03-26 Thread Hand, Michael T
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: switch logfile vs. archive log current

2003-03-19 Thread Hand, Michael T
highly recommended. I normally use a combination of multiple switch logfile, archive log commands and a Unix sleep command and then exclude the last archivelog from the backup just to be safe. Hemant -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET

RE: Order of Redo log use

2003-02-21 Thread Hand, Michael T
the old ones, recreate them, then drop the temp set. I've done this a few times to resize/reorg redo on disk without taking the database down. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services

Order of Redo log use

2003-02-20 Thread Hand, Michael T
FAQ: http://www.orafaq.net -- Author: Hand, Michael T 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: Order of Redo log use

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

Bind variable values

2003-01-16 Thread Hand, Michael T
format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Tru64 Direct I/O

2003-01-10 Thread Hand, Michael T
is anyone using Direct I/O on Tru64 successfully. Oracle V8.1.7.3 EE (non-OPS) Tru64 5.1A on Alpha Servers Mike Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Tru64 Direct I/O

2003-01-09 Thread Hand, Michael T
Title: Message OK, everything I've read so far on using Direct I/O with an Oracle database says it's a bad idea. Either performance problems or block corruption may occur. The notes on metalink (132391.1)refer to Tru64 5.0A and 5.1 but not 5.1A (to which we've recently upgraded). So is

RE: Orawomen or Nursing? [OT]

2003-01-08 Thread Hand, Michael T
Title: RE: Orawomen Lisa, Nursing is no place for a woman; if you thinkDBA'ing is stressful, you ain't seen nothingyet My wife is an RN and, while it may nobe scientific, I attribute our difficulty in conceiving and miscarriage to job stress working on an understaffed hospital floor. That

RE: Help with IMPort

2003-01-06 Thread Hand, Michael T
does not have the ids yet. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: Help with IMPort

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

RE: Happy Holidays

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

RE: Capacity Planning -- Expecting the DB growth !!!

2002-12-18 Thread Hand, Michael T
the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE:

2002-12-06 Thread Hand, Michael T
No, we've turned into a kinder, gentler listduring the Holidays ... (must control my typing fingers of Death..) -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Friday, December 06, 2002 9:19 AMTo: Multiple recipients of list ORACLE-LSubject:

RE: LONG's

2002-11-26 Thread Hand, Michael T
to CLOB and LOB? Jared Hand, Michael T [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/25/2002 07:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:LONG's OK, so you can't CTAS on tables with LONG

RE: Slightly OT - Who would you take with you...

2002-11-26 Thread Hand, Michael T
: Hand, Michael T 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

LONG's

2002-11-25 Thread Hand, Michael T
OK, so you can't CTAS on tables with LONG or LONG RAW columns, and now I find out that the same restriction exists on Alter Table ... Move. So, is there any other option to move these tables from one tablespace to another without exp/imp or converting them to LOB? Thanks, Mike This

RE: Problem doing RMAN backup of Clone?

2002-11-25 Thread Hand, Michael T
this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network

RE: Convert TEMP tablespace from datafiles to tempfiles

2002-11-07 Thread Hand, Michael T
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: Two Q's for SAP DBA's

2002-09-30 Thread Hand, Michael T
, I'll pass it on. Mike -Original Message- Sent: Friday, September 27, 2002 10:57 AM To: [EMAIL PROTECTED]; Hand, Michael T On Wednesday 25 September 2002 12:33, Hand, Michael T wrote: Got a couple of questions for those of you dealing with SAP: 1) Has anyone heard of a timeline as to when

RE: datafile sizing question

2002-09-26 Thread Hand, Michael T
range from 64K to 20Mb John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Two Q's for SAP DBA's

2002-09-25 Thread Hand, Michael T
Archive objects would seem to make this difficult at best? Thanks for any feedback. Mike Hand Polaroid Corp - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: Re: View Locks

2002-09-11 Thread Hand, Michael T
of society. Both are very dangerous. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

SAP default tablespace (WAS: RE: Misinformation Ranting)

2002-09-11 Thread Hand, Michael T
) that maps objects to tablespaces, but haven't found it. Any tips you have would be appreciated. Thanks, Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: Privileges for other's table

2002-09-10 Thread Hand, Michael T
. Of course, attempting to grant select on the view failed with a ORA-1720. May be this is an hidden feature of 8.1.7.3 on Tru64. Unfortunately, I still have the screen dumps so I can't tell my boss that I'm going crazy and need a extended vacation ;) Mike -Original Message- Hand, Michael T

Privileges for other's table

2002-09-09 Thread Hand, Michael T
privileges on the underlying tables. Incidentally, I also found out that you can't use the grant option within roles. I wonder why? Michael Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network

RE: Please need some help on imp

2002-08-30 Thread Hand, Michael T
://www.orafaq.com -- Author: Hand, Michael T 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: drop tablespace including contents

2002-08-21 Thread Hand, Michael T
that a reasonably knowledgeable DBA can't do from his of her favorite toolset. ( vi, Perl and sqlplus for me :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Hot Backup using EMC /BCV splits

2002-08-15 Thread Hand, Michael T
(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: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

FW: Hot Backup using EMC /BCV splits

2002-08-15 Thread Hand, Michael T
that is using EMC/BCV or other Hardware vendor splits mechanism? Thanks. Bing Wong Open Systems Database Administrator x25721 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: Cloning Problems

2002-07-30 Thread Hand, Michael T
: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

RE: BR solutions

2002-07-25 Thread Hand, Michael T
') 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: Hand, Michael T

RE: Copy

2002-07-08 Thread Hand, Michael T
- WHERE JOB='SALESMAN' -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Unix - scheduling

2002-07-02 Thread Hand, Michael T
, Michael T 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 this mailing list, send an E-Mail

Urgent: Prodution database recovery

2002-05-30 Thread Hand, Michael T
://www.orafaq.com -- Author: Hand, Michael T 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: Urgent: Prodution database recovery

2002-05-30 Thread Hand, Michael T
Lord -Original Message- From: Hand, Michael T [mailto:[EMAIL PROTECTED]] Sent: 30 May 2002 10:23 To: Multiple recipients of list ORACLE-L Subject: Urgent: Prodution database recovery Env: 8.1.7.3 Compaq Alpha Tru64 5.1a An apparent hardware problem caused corrupt blocks ora

RE: SMON reports Dead Transactions - Not seen this before

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

RE: 1 Table and its Indexes occupying 30% space of the Database.

2002-05-13 Thread Hand, Michael T
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: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Is DATAFILE order important in CREATE CONTROLFILE?

2002-04-11 Thread Hand, Michael T
, Michael T 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 this mailing list, send an E

RE: Seeking opinions

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

RE: SQL*Loader

2002-04-08 Thread Hand, Michael T
(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: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: Lite: Redo sequence# poll

2002-03-12 Thread Hand, Michael T
: Longest time since last restart (uptime) - 08/30/2001 (v$instance - startup_time) Oldest database - 11/05/1999 (v$database - created) High SCN - 5551718526045 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network

Lite: Redo sequence# poll

2002-03-11 Thread Hand, Michael T
log is full at log switch) Uptime since database creation / resetlog: ~3.5yrs Michael Hand Polaroid Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: Lite: Redo sequence# poll

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

RE: # of datafiles per tablespace

2002-03-05 Thread Hand, Michael T
and mount point size is not a limitation. Space available to me on any one mount point is unlimited. ___ Kimberly Smith Portland, OR [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat

RE: oracle 8.1.7 patch 2 or 3?

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

RE: Import placing data into wrong tablespace

2002-02-27 Thread Hand, Michael T
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: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: Upgrade directly to 8.1.7.3?

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

RE: HP-UX11(32 bit)/8.1.7/Install Question

2002-02-15 Thread Hand, Michael T
ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Unorthodox 8i install/upgrade: FOLLOWUP

2002-02-13 Thread Hand, Michael T
. Thanks, Mike Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Upgrading from 8.0.5 to 8.1.7 - Please help

2002-02-12 Thread Hand, Michael T
, Michael T 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 this mailing list, send an E-Mail

RE: Unorthodox 8i install/upgrade

2002-02-07 Thread Hand, Michael T
than one mount point? Any suggestions would be greatly appreciated. Thanks, Mike Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Unorthodox 8i install/upgrade

2002-02-06 Thread Hand, Michael T
to another directory? Or broken out the ORACLE_HOME subdirectories onto more than one mount point? Any suggestions would be greatly appreciated. Thanks, Mike Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat

RE: Book Club ?

2001-12-14 Thread Hand, Michael T
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: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Wite paper link?

2001-12-14 Thread Hand, Michael T
with trace on to compare the CBO under both versions. Any other suggestions to make this upgrade as seamless as possible? Thanks, Mike Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services

Upgrade 8.0 to 8i - Was RE: Wite paper link?

2001-12-14 Thread Hand, Michael T
-- Author: Hand, Michael T 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 this mailing list

RE: Upgrade 8.0 to 8i

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

RE: which view used ?

2001-12-13 Thread Hand, Michael T
(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: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: Spooling to a flat file via SQL*Plus

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

RE: Password Changes

2001-12-07 Thread Hand, Michael T
-- Author: Hand, Michael T 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 this mailing list

RE: Password Changes

2001-12-07 Thread Hand, Michael T
by persons unknown. This message will not self destruct in 5 seconds, but will probably hang around in various archives for centuries, consuming valuable resources. Now where'd that coffee go to... Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET

RE: Creating a reporting DB

2001-12-07 Thread Hand, Michael T
: Hand, Michael T 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 this mailing list, send

RE: Message at the start of svrmgrl

2001-12-03 Thread Hand, Michael T
Anand, I installed the same(? 8.1.7.2.1) patch about 2 weeks ago on Tru64 5.1 and did not get this result. However, I do remember this kind of result with a earlier upgrade to 8.0.x in the distant past. I believe it is a verbose linking option with no negative impact. Is svrmgrl the only

RE: Import Help

2001-11-15 Thread Hand, Michael T
, Michael T 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 this mailing list, send an E

RE: Another Oracle DBA gets The Bullet WAS: Help!: Job Descrip

2001-11-13 Thread Hand, Michael T
. I haven't decided if this is a good or a bad thing, but at least I'm still employed, and more importantly valued. Mike Hand Polaroid Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: backup of large databases

2001-10-26 Thread Hand, Michael T
Ed, We have a 550Gb database which we backup nightly via a disk mirror set split. The mirror set is then mounted on our failover/reporting hardward and written to tape. Archived redo logs are written to tape twice daily and kept on disk for 3 days. 8063 on Compaq Tru64 Mike Hand

RE: log file size change

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

RE: Create user identified by externally

2001-09-20 Thread Hand, Michael T
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: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: STOP THE PRESS!!

2001-09-11 Thread Hand, Michael T
Polaroid Corp. -Original Message- Sent: Tuesday, September 11, 2001 1:30 PM To: Multiple recipients of list ORACLE-L Time to test all the weapons we have been buying. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED

RE: Interesting News..

2001-09-05 Thread Hand, Michael T
. -Original Message- Sent: Tuesday, September 04, 2001 10:02 AM To: Multiple recipients of list ORACLE-L Thought this would interest you guys.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services

RE: !! *Very* important Oracle-L message !!

2001-08-30 Thread Hand, Michael T
to pay, I look at it as a gift/investment, not a fee-for-service transaction. FWIW. Mike Hand Polaroid Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: checkpoint message

2001-08-22 Thread Hand, Michael T
') 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: Hand, Michael T INET: [EMAIL

RE: Database upgrade w/ standby

2001-08-17 Thread Hand, Michael T
something here? Rachel From: Hand, Michael T [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Database upgrade w/ standby Date: Fri, 17 Aug 2001 07:15:35 -0800 I will be performing an upgrade this weekend of out production database

RE: Import Issue/question

2001-08-01 Thread Hand, Michael T
What about generating statistics? Mike Hand Polaroid Corp -Original Message- Hi, What is the Import utility doing exactly after it says the rows of a table have been imported? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL

RE: moving tables to a different tablespace

2001-07-26 Thread Hand, Michael T
(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: view contents of datafile

2001-07-12 Thread Hand, Michael T
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: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: DB Backup Question

2001-07-11 Thread Hand, Michael T
, 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: Hand, Michael T INET: [EMAIL PROTECTED] Fat

RE: OT::Take a look.

2001-06-29 Thread Hand, Michael T
if that meant having Bush as a VP. Now where's that independent counsel when you need him!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Prompt in Korn shell

2001-06-21 Thread Hand, Michael T
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: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network

RE: OT: Working from home

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

RE: Cursor statistics request

2001-05-03 Thread Hand, Michael T
FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

RESOURCE role

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

RE: Backup for VLDB

2001-04-06 Thread Hand, Michael T
://www.orafaq.com -- Author: Hand, Michael T 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

RE: . . .Compaq Tru64 5.1 Cluster / SAN?

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

RE: Crontab

2001-03-23 Thread Hand, Michael T
-Original Message- crontab -e insert a line with Mi HH24 22-28 * 0 comandline - Hitarth -Original Message- I want to schedule a script to run on the fourth sunday of the month. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET

RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe

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

RE: OT -- Canada Rules! / Chocolate ...

2001-03-20 Thread Hand, Michael T
B 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: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

  1   2   >