Re: How long will 8.0.6 be supported?

iling 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: Bill Gentry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 53

Re: Temporarily Renaming the sgadefSID.dbf File

attempting to sign on. After I migrated to 8i, this "file renaming" wasn't required. HTH, Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sen

Re: Where do I find the patch script on the install CD ?

I have never seen a patch set on the Installation CD. I've always had to download it from Metalink. HTH Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTE

Re: Meeting at IOUG

l ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Gentry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Meeting at IOUG

I love a good margarita (or two). Sounds like a good idea. Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 1:53 PM Glad

Re: cdump, bdump, udump

It seems to work different for me. For the last 2 years, I have been deleting the old file and a new one appears with the very next message to be written. Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: Multiple

Re: V$SQLTEXT text length

You can use the piece fields, as in the following script: select a.sid, a.username, s.sql_text from v$session a, v$sqltext s wherea.sql_address = s.address and a.sql_hash_value = s.hash_value order by a.username, a.sid, s.piece; Hope This Helps, Bill Gentry - DBA Allina Health

Re: OT -- training

Other than my initial Oracle training in 1999 [31 days], I have been getting 5 days in 2000 5 days for the current year. HTH ---Bill Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L

Re: How to sign-off this group?

Please read the bottom of any e-mail on this list! Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 20, 2001 3:04 PM Would some one please

Re: Support RANT

To make it worse, Brian, I had a production down issue and Oracle Support STILL make me go through Metalink. Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent

Re: index in data tablespace ???

Just do an 'alter index rebuild ...' to the proper index tablespace. ---Bill Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 06, 2001 1:36 PM

Re: How come I don't get postings

Title: How come I don't get postings I see you! Bill GentryDBAAllina Health SystemMinneapolis, MN 55403612-775-1190[EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, April 25, 2002 7:43 PM

Re: Clone Database

- From: Bill Gentry To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 08, 2002 12:40 PM Subject: Re: Clone Database I also have a 70 Gb production database and have to clone it to several test instances. I just delete all the test files

Re: List users planning to meet during Open world

like 'AP%' and segment_type = 'TABLE' order by segment_name / spool off; Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November

Re: RE: database administration questions

and is incorrect in the first place! Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 27, 2001 12:50 PM A problem with RTFM is when

Re: Binding a process to a CPU .

I thought it meant Hope This Helps ---Bill Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 22, 2001 4:33 PM it means happy to help

Re: Changing the SID of a database

/system01.dbf', . . . . '/db/u04/oradata/lawtst5/index22.dbf', '/db/u04/oradata/lawtst5/index23.dbf', '/db/u04/oradata/lawtst5/index24.dbf' ; ALTER DATABASE OPEN RESETLOGS; ALTER DATABASE RENAME GLOBAL_NAME TO LAWTST5.WORLD; Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190

Re: How TO KNOW TABLE SIZE

/ spool off; Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 04, 2002 1:08 PM Hi How can I know how much

help

help Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! http://login.mail.lycos.com/r/referral?aid=27005 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Gentry INET: [EMAIL