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 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 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). You may also send the HELP command for other information (like subscribing).
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 System Mpls., MN [EMAIL PROTECTED] -- On Wed, 12 Jun 2002 12:04:37 Jesse, Rich wrote: >While researching some shared_pool problems on an 8.1.6 instance, I >happen to notice that the SQL_TEXT column of the V$SQLAREA view is "only" >1000 bytes. What happens when the statement is longer than that? Does it >just not show all of it in that view? > >Just curious. > >Rich Jesse System/Database Administrator >[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jesse, Rich > 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 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). You may >also send the HELP command for other information (like subscribing). > ___ WIN a first class trip to Hawaii. Live like the King of Rock and Roll on the big Island. Enter Now! http://r.lycos.com/r/sagel_mail/http://www.elvis.lycos.com/sweepstakes -- 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) 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 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).
Re: Clone Database
Ken,
The opening was stated incorrectly. HR
doesn't know the difference between a DBA & a DA. We are looking for
someone to do logical design & data modeling, not to administrator a
database. The platform is Oracle.
Bill GentryDBAAllina Health SystemMinneapolis, MN
55403612-775-1190[EMAIL PROTECTED]
- Original Message -
From:
KENNETH JANUSZ
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, May 08, 2002 3:03
PM
Subject: Re: Clone Database
Bill:
I noticed that you are with Allina. I'm currently
looking for an Oracle DBA (or related) position. I noticed on your web
site that Allina has an opening for a DBA-Intermed. Business Unit:
System Office. Req.#: 046690.
Would you know if this is an Oracle DB or otherwise?
The description doesn't name the DB.
Thanks,
Ken Janusz
- Original Message -----
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, copy all the .dbf files over from a cold backup [or files &
archives from a hot backup], and rebuild the controlfiles/log files.
Takes about 2 hours.
Bill GentryDBAAllina Health SystemMinneapolis, MN
55403612-775-1190[EMAIL PROTECTED]
- Original Message -
From:
Ramon E. Estevez
To: Multiple recipients of list
ORACLE-L
Sent: Tuesday, May 07, 2002 9:28
AM
Subject: Clone Database
I have to
refresh a development database every day with the production DB. The
size of the DB is 70GB and import last like 7 hours. Does
anyone in the list has the steps to clone a
database, not using import.
TIA
Ramon E.
Estevez
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 Subject: How come I don't get postings Guys, Please someone tell me if you can see me on this list. I just subscribed and got the welcome message but no messages from this list. Thanks, Paula
Re: How TO KNOW TABLE SIZE
This is what I use. Hope it helps. spool table_space_usage.log set pagesize 0 set linesize 80 select substr (segment_name,1,20) ,bytes / 1024 kbytes ,extents ,blocks from sys.dba_segments where owner = 'LAWSON' and segment_name like 'AR%' 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, March 04, 2002 1:08 PM > Hi > How can I know how much space a table occupied? > Can BLOCKS columns in dba_tables helps? > Or I have to use dba_extents and dba_segments tables? > Thx > -Seema > > > > _ > MSN Photos is the easiest way to share and print your photos: > http://photos.msn.com/support/worldwide.aspx > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Seema Singh > 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 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). 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) 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 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).
Re: Changing the SID of a database
Rick, here is how I do it. Contact me if there are any questions. Make a copy of 'prod' on LAWDB to 'test' on LAWDB from Cold Backup Introduction The 'prod' Oracle instance sometimes need to be replicated, on demand, for testing and/or training purposes. The replication is done using a 'Cold' backup copy of the 'prod' instance using either the backup directory (/dbkup) or the ADSM backup. The procedure is very much the same for creating either 'test' or 'train'. This section will assume creating a 'test ' database. Procedure ? Take a cold backup of 'prod' ? Shutdown 'test' instance The 'test' instance should be shutdown using 'immediate' option. >ORACLE_SID=test >export ORACLE_SID >svrmgrl SVRMGR> connect / as sysdba; connected; SVRMGR> select name from v$database; NAME - TEST 1 row selected. SVRMGR> oradebug ipc SVRMGR> shutdown immediate; SVRMGR> exit; ? Copy the datafiles files from the cold backup Delete ALL TEST database related files, i.e. *.dbf, *.ctl, *.log Use the cold backup to copy the .dbf files to the "test" instance mountpoints ? Re-create control files & redo logs for the "test" instance. (See example belos) Use the 'make control file' script >ORACLE_SID=test >export ORACLE_SID >cd $HOME/test/admin >svrmgrl SVRMGR> connect / as sysdba SVRMGR> @mkctrl SVRMGR> select name from v$database; Example of creating control files & redo logs: STARTUP NOMOUNT CREATE CONTROLFILE SET DATABASE "lawtst5" RESETLOGS NOARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 200 MAXINSTANCES 8 MAXLOGHISTORY 800 LOGFILE GROUP 1 '/db/u05/oradata/lawtst5/redo01.log' SIZE 64M, GROUP 2 '/db/u06/oradata/lawtst5/redo02.log' SIZE 64M, GROUP 3 '/db/u07/oradata/lawtst5/redo03.log' SIZE 64M DATAFILE '/db/u05/oradata/lawtst5/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 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, March 04, 2002 9:23 AM > I'm going to take the datafiles from a cold backup and use them for a new > database. However, to do this, I need to change the SID of the new db. I've read > that it's possible, but not how to do it. Is this an easy thing to do, or would > it be better to extract the tables and create the new db that way? > > Thanks for any help. > Rick > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > 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 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). 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) 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 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).
Re: SQL*Loader Problem
Where's what note 113211.1 on metalink says about this. I hope it helps.
Problem Description
---
Using SQL*Loader to load data into a database table and rows fail to load
with the message:
Record X: Rejected - Error on table ""."", column "XX".
Field in data file exceeds maximum length
The data to be loaded will be longer than 255 characters and the database
column is set to larger than 255 characters.
Solution Description
In the control file specify the length of the column if the columns in the
database are longer than 255 characters.
eg
LOAD DATA
INFILE *
INTO TABLE "TEST"."TEST1"
APPEND
FIELDS TERMINATED BY ','
("COL1", "COL2" char(4000), "COL3")
BEGINDATA
333, data data data longer than 255 characters data data etc,this will work
Explanation
---
As a default, if the column length is not specified, it will default to a
maximum of 255 characters. If the database column is longer than 255
characters and the data to be loaded exceeds 255 characters, then it exceeds
the maximum length. Specifying the maximum length in the control file
overrides the default setting.
References
--
Oracle8 Server Utilities
Additional Search Words
---
sqlloader loader
.
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: Friday, January 11, 2002 9:55 AM
> 8.1.7 on W2000
>
> I am loading data and keep getting an error. The fields are text about
400+
> characters. The column I am loading into is varchar2(4000). I keep
getting
> rejects with this error: Field in data file exceeds maximum length. Any
> ideas as to why this is happening?
>
> Thanks,
>
> Ken Janusz, CPIM
> Database Conversion Lead
> Sufficient Systems, Inc.
> Minneapolis, MN
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ken Janusz
> 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 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). 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) 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 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).
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 the manual is over 10,000 pages long. > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > > -Original Message- > Sent: Thursday, December 27, 2001 2:15 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: RE: database administration questions > > > Yeah, once they find out this job isn't a cakewalk, they vanish. > > For those that: > > * live for challenge > * are afraid of nothing and not intimidated by complexity > * make that, 'love complexity' ;) > * can't forget about a problem until it's fixed > * willing to RTFM til they drop > * design and execute tests to understand how things work > * RTFM some more > * drive technology. Hey, there's more to a good DBA than databases. > * did I mention RTFM? > * learn from their mistakes > * admit they make mistakes > * RTFM to minimize mistakes > > All others need not apply. > > Jared > > "No guts, no glory" ;) > > > > > > "Kimberly > > Smith"To: Multiple recipients of > list ORACLE-L <[EMAIL PROTECTED]> > > tlink.net>Subject: RE: RE: database > administration questions > Sent by: > > [EMAIL PROTECTED] > > m > > > > > > 12/27/01 09:00 > > AM > > Please respond > > to ORACLE-L > > > > > > > > > > You need to find some new cooks then. > > -Original Message- > [EMAIL PROTECTED] > Sent: Thursday, December 27, 2001 6:50 AM > To: Multiple recipients of list ORACLE-L > > > In our shop we've tried the cross training tact. Problem was that those > who > accepted the challenge could not take the heat, so they left the kitchen. > Damn!!! > > Dick Goulet > > Reply Separator > Author: "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]> > Date: 12/26/2001 4:50 PM > > I quite agree with Kimberly. I used to be a full-fledge Oracle programmer > but wanted to dabble with database administration. I asked my boss whether > I > could be a database administrator. His answer is yes but I still need to > maintain my current systems. Now, I am a database > administrator-cum-programmer. I support turnkey projects, automate > processes for my users, maintain current projects, install/maintain > database > & support Oracle Applications etc. > > Prepare for lots of OT but what the heck, U will get to learn a lots of > interesting things in the process > > New Bees > -Original Message- > From: Kimberly Smith [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 27, 2001 1:40 AM > To: Multiple recipients of list ORACLE-L > Subject:RE: database administration questions > > If you work on a site like I do you could always cross > train. I am always > looking for suckers (um, people) to be my backup. Right > now > I use one from > the Unix team and one from the development team. Its the > only way I get to > take vacations and what no. Check with your current DBA > and > see if they are > willing to train you while you are off doing your 'real' > job. Of course, > there are some folks who are worried about job security (or > are just > assholes) > and they would not give you the time of day. You don't > want > to learn from > those folks anyway. The excuse, "I'm too busy" is not > really valid either. > Training someone allowed me to offload some of my work. > > -Original Message- > [EMAIL PROTECTED] > Sent: Wednesday, December 26, 2001 5:30 AM > To: Multiple recipients of list ORACLE-L > > > With your current background, your more likely to land a > job > as a network > administrator LONG before you'll end up in a databa
Re: List users planning to meet during Open world
Something like this will do the job: = spool table_space_usage.log set pagesize 0 set linesize 80 select substr (segment_name,1,20) ,bytes / 1024 kbytes ,extents ,blocks from sys.dba_segments where owner = 'LAWSON' and segment_name 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 26, 2001 8:05 AM > Hi, > is there a way to get the size in MB of a particular table in my > database ? > > > Thank You, > > Gavin > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gavin D'mello > 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 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). 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) 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 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).
Re: ok..this is funny.. how do you pronounce "tuple"
The only way I ever heard is "tuh-pul" - must be a Minnesota thing, like "hot dish" instead of "casserole" :>) 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: Wednesday, November 14, 2001 12:25 PM > I say to-may-to, You say to-mah-to; > I say po-tay-to, You say po-tah-to; > > I say too-pul, You say tuh-pul > > There are N-1 ways to pronounce it. > > :^) > > > -Original Message- > Sent: Wednesday, November 14, 2001 12:26 PM > To: Multiple recipients of list ORACLE-L > > > Tuple. Like Tupplewear. > > Bambi. > > -Original Message- > Sent: Wednesday, November 14, 2001 10:15 AM > To: Multiple recipients of list ORACLE-L > > Hi, > > it's just like "Tulip", just kind of different... > > cheers, > Stefan > > "Thomas, Kevin" schrieb: > > > Kindof like "tooyoupull" only different...! > > > > ;o) > > > > -Original Message- > > Sent: 14 November 2001 11:05 > > To: Multiple recipients of list ORACLE-L > > > > Yeah - kind of like "too-you-pull" but a lot quicker.. > > > > -Original Message- > > Lee - lerobe > > Sent: 14 November 2001 08:30 > > To: Multiple recipients of list ORACLE-L > > > > Hmm, dilemma - neither > > > > tyu pul > > > > Mainly because thats what my Ingres Course Instructor used in class, many, > > many years ago. > > > > Lee > > > > -Original Message- > > Sent: 14 November 2001 04:55 > > To: Multiple recipients of list ORACLE-L > > > > Write out of good old relational theory.. > > So is it (too pul). or (tuh pall).. > > > > Thanks, > > D. > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Doug C > > 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 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). You may > > also send the HELP command for other information (like subscribing). > > > > The information contained in this communication is > > confidential, is intended only for the use of the recipient > > named above, and may be legally privileged. If the reader > > of this message is not the intended recipient, you are > > hereby notified that any dissemination, distribution or > > copying of this communication is strictly prohibited. > > If you have received this communication in error, please > > re-send this communication to the sender and delete the > > original message or any copy of it from your computer > > system. > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Robertson Lee - lerobe > > 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 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). You may > > also send the HELP command for other information (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Mark Leith > > 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 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). You may > >
Re: Another Oracle DBA gets "The Bullet" WAS: Help!: Job Descrip
or "Tequila + habaneros = Death Wish" 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, November 13, 2001 1:25 PM > That's why if you ever see a sick Texan - he/she/it is on its deathbed. > Tequila + habaneros = health. > > --S > > > "Gogala, Mladen" wrote: > > > > Habanero salsa as a cure for heat Well, I suppose you're using > > kill or cure method down there in TX. > > > > -Original Message- > > Sent: Tuesday, November 13, 2001 1:25 PM > > To: Multiple recipients of list ORACLE-L > > Descrip > > > > You adapt quickly. And the Gods invented air conditioning, margaritas, > > and habanero salsa for just such environments. > > > > --S > > > > Rachel Carmichael wrote: > > > > > > 'cause there ain't enough money in the world to bail you out? > > > > > > The only problem I have with Texas is the heat. I have good friends > > > down there (you guys all know who you are and if you don't, WAKE UP)... > > > but I went down over Memorial Day weekend to SA and nearly melted from > > > the humidity. This does nothing to induce me to move South. > > > > > > --- Jeffery Stevenson <[EMAIL PROTECTED]> wrote: > > > > Bail money??? Why wasn't I invited? :) > > > > > > > > Yeah, like was mentioned, there's some positions available in Austin, > > > > but > > > > not as prevalent as it used to be. VC money has been tightened up so > > > > a lot > > > > of these companies looking to grow have been hit hard (and the bigger > > > > companies are just cutting back to save money). The problem I see > > > > though is > > > > that companies seem to be trimming back too much. I'm starting to > > > > hear > > > > little rumours here and there of companies going, "Maybe we shouldn't > > > > have > > > > gotten rid of most of our support/operations people?" It's not bad > > > > here > > > > though...it'll pick back up again...and I agree it's a great place to > > > > live. > > > > > > > > Guvm'nt jobs? Eep! Yeah Scott, I noticed that SA had about 4 times > > > > as many > > > > Oracle/DBA positions listed than Austin when I scouting the market > > > > for a > > > > friend who's looking at this area. That scared me... > > > > > > > > Jeffery Stevenson > > > > Databeast Slayer > > > > Medical Present Value, Inc. > > > > Austin, TX > > > > > > > > > > > > -Original Message- > > > > Sent: Monday, November 12, 2001 9:30 PM > > > > To: Multiple recipients of list ORACLE-L > > > > Description for > > > > > > > > > > > > David, > > > > > > > > Yes you should drive down/me drive up to meet. Just let me get past > > > > some > > > > current difficulties. We could leave bail money with the wives! > > > > Hehehe... > > > > > > > > San Antonio (SA) has been hit, but definitely not as hard as > > > > Austin/Dallas/Houston. I'll probably regret this (if I end up > > > > competing for > > > > a job), but anyone looking for a job could do a lot worse than > > > > looking in > > > > SA. Most of the tech jobs here are government, gov/private > > > > consulting, or > > > > big company IT (USAA, MCI, SBC, etc). The largest industry however > > > > is > > > > tourism, which has been hammered. This doesn't affect techies much > > > > though. > > > > > > > > If one has no qualms about managing databases of bigger and better > > > > ways to > > > > "break things and kill people", then DOD contracting is the way to go > > > > in > > > > Central Texas. Cost of living is very low, and SA is the 8th largest > > > > city > > > > in the US. Upsides: steady work, excellent food, mild winters, lots > > > > of > > > > recreational activities. Downsides: Inept city government, yearly > > > > drought, > > > > HOT for 9 months of the year. > > > > > > > >
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 > Hi all, > > I got bunch of indice reside in data tablespace. > What's an easy, safy way to move them into index > tablespace? > > Thank you. > > Janet > > __ > 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: Janet Linsy > 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 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). 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) 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 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).
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: Friday, August 31, 2001 12:18 PM > I haven't called support lately. Probably since there hasn't been a > need - knock on wood. So I called today. > > > So now I understand that I have to go through a routing center? The > person taking my call said that they *could* log the TAR for me over the > phone, but that it was really just adding another step to the process, > and I should have logged it myself. And if they did log the TAR for me, > an analyst would have to call me back. > > Has Oracle support really gone to this? Am I going to have to start > classifying everything as production-down just to actually speak to > someone? > > All this, just to get a patch for a bug that I apparently do not have > access to on Metalink. > > > I'm so irritated that I could pull my hair out, but I like all 5 that > are left... > -- > -- > | Brian McGraw -- Oracle DBA | > | Central Alabama Oracle Users Group | > || > | mailto:[EMAIL PROTECTED] | > | http://bmcgraw.home.mindspring.com | > -- > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Brian McGraw > 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 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). 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) 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 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).
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 tell me how to sign-off this group. It was a > pleasure to be in this excellent group in the past years. Thank you. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ben Le > 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 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). 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) 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 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).
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" <[EMAIL PROTECTED]> Sent: Monday, August 13, 2001 10:46 AM Just out of curiosity, how many days / weeks of real training did your employer provide you with in the last couple of years? "real" is in quotes, I don't mean the little 1 - 3 day seminars given by CareerTrack and other "training" companies, or management-related stuff like little MBA-flavoured certificates from universities. Oh, and did the amount of training you received match what you were told during your job interview? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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 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). 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) 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 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).
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" Christopher > > Brian. > > > > > > Christopher Spence <[EMAIL PROTECTED]>@fatcity.com on 05/22/2001 > 04:21:12 PM > > Please respond to [EMAIL PROTECTED] > > Sent by: [EMAIL PROTECTED] > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > > > > What does > > hth, > > Mean? > > -Original Message- > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Christopher Spence > 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 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). You may > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > 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 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). 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) 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 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).
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 recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, April 25, 2001 9:39 AM Team, Correct me if I am wrong, please.. If you delete the alert.log file with the database up and running, the oracle still thinks the file exists and writes to a non existant file that you can't "see". The proper method of reducing the file size is to copy the file to a backup location, and edit the original and delete rows from the file. OR if you do not need to keep the original log for analysis you could copu /dev/null > alert.log. Just a house keeping note. ROR mª¿ªm >>> [EMAIL PROTECTED] 04/24/01 09:21AM >>> Sinardy, First, I suggest you find some time and sit down and READ the Oracle documentation. Otherwise you are going to get a large number of "RTFM" emails, and some flaming as well. Now.. the alert log is created (if it does not already exist) or written to every time Oracle wants to record an event that has happened in the database/instance. So log switches will be in there, database shutdown and startup messages, errors dealing with the infrastructure of the database (failure to extend a rollback segment, failure to get space in the temp segment, disasterous database errors etc) There are other messages as well, I'm not going to list every one. Bdump contains trace files that relate to the Oracle background process -- anything generated by smon, pmon, etc Udump contains trace files that relate to specific user Oracle processes Cdump contains core dumps, associated with one or another trace files in the bdump directory. Rachel >From: "Sinardy Xing" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: cdump, bdump, udump >Date: Tue, 24 Apr 2001 03:40:27 -0800 > >Hi all, > >When those logs will created ? > >Thank you > >Sinardy > > >-Original Message- >Sent: Tuesday, 24 April 2001 9:41 AM >To: LazyDBA mailing list > > >Hi DBAs and SAs, > >I had a task to do housekeep ...\bdump\alertSID.log >What logs usually Oracle system need to housekeep, and what are these >directory > cdump, > bdump and > udump >for ? > > >Thank you for your time > >Sinardy > > > > >Think you know someone who 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 >Tell yer mates about http://www.farAwayJobs.com > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Sinardy Xing > 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 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). You may >also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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 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). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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 message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
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 to see so many people wanting to get together. I would like to > propose a time and place... > > Tuesday night is the "big bash", and Wednesday night is a "Pleasure > Island" event. There is a Monday night welcome reception in the exhibit > hall until 7:45. > > So, I think the best time is Monday at 8pm, somewhere in the Swan > and Dolphin complex (not knowing the Orlando area personally). > http://www.swandolphin.com/restaur.htm lists the 15 restaurants (with 3D > views). My vote is Juan & Only's - "A perfect place to enjoy moderately > priced southwestern cuisine. Stop by the bar for the best margaritas in > town! Open for dinner." for its bar and not super-loud setting so we can > talk. > > - Ari Kaplan > > On Tue, 17 Apr 2001, Stephen Andert wrote: > > > I'll be there and would like to meet as many of you as possible. If anyone who knows the ropes can suggest a time/place, that would be great. As this is my first IOUG event, I don't have any ideas on where/when, so it's up to all you "veterans". > > > > Keep this thread going. > > > > > > Stephen Andert > > > > > > >>> [EMAIL PROTECTED] 04/16 8:15 PM >>> > > don't know that any meeting has been scheduled, I do know that a number of > > the members of the list are presenting and I intend to be at most of those > > sessions :) > > > > on the other hand, Gaja's sessions tend to draw EVERYONE so you can be sure > > of meeting others on the list there > > > > > > >From: "Murali Vallath" <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >Subject: Meeting at IOUG > > >Date: Mon, 16 Apr 2001 18:30:43 -0800 > > > > > > > > >Are any of the floks from the list meeting during the IOUG-A live in > > >Florida. > > > > > >I am attending and would like to join the meeting. > > > > > >Murali Vallath > > >_ > > >Get your FREE download of MSN Explorer at http://explorer.msn.com > > > > > >-- > > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > > >-- > > >Author: Murali Vallath > > > 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 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). You may > > >also send the HELP command for other information (like subscribing). > > > > _ > > Get your FREE download of MSN Explorer at http://explorer.msn.com > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rachel Carmichael > > 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 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). You may > > also send the HELP command for other information (like subscribing). > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Stephen Andert > > 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'll be there too! It will be my first visit to IOUG and I'm looking forward to meeting the many folks who have contributed to my knowledge [and amusement] through this List. Even though I don't often post questions, your advise to others have been very useful. Keep up the good work. 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 9:15 AM I will be there also. Sandra Arnold DBA Strategic Staffing Solutions -Original Message- Sent: Tuesday, April 17, 2001 7:55 AM To: Multiple recipients of list ORACLE-L Me too, Me too!!! ROR mª¿ªm Ron Rogers DBA OCP Georgia Lottery Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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 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). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arnold, Sandra 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 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). 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) 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 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).
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 PROTECTED]> Sent: Monday, April 16, 2001 1:25 PM > I just finished installing Oracle8.0.6 on a SUN SPARC ULTRA 5. > The install cd is : Oracle8 Enterprise Edition Release 8.0.6.0.1 > After the install I query v$version and I notice that I have version > 8.0.6.0.0 > > Where do I find the patch on the CD (or the local Oracle Home Directory) > to bring it from 8.0.6.0.0 to 8.0.6.0.1 ? > > Thanks in advance ! > > _ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Pat & Brenda Howe > 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 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). 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) 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 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).
Re: Temporarily Renaming the sgadefSID.dbf File
Steve, When I was on 7.3.4, I used this procedure every time I cloned, which was at least weekly. I never had a problem with Production while doing this. After I cloned the files, I would rename the file, bring up the cloned instances, and then name the file back to the original name. The file was only with the new name for just a few minutes. I was told by those around me that users on the production database could still process, just those signing on had to retry in a few minutes. Since usually cloned the test database farily early in the morning [around 6:30 am] , there were very few 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]> Sent: Tuesday, April 10, 2001 3:35 PM > Hi All, > > Trying to clone our PROD to a test database on the same machine for testing > our 734-->8i upgrade, and of course we're encountering the > "can't-start-the-new-without-shutting-down-the-old" database problem (ie, > ORA-9782 on the CREATE CONTROLFILE command). We've worked around this in > the past by scheduling a time to bring down PROD. > > I know that this is the safest, most reliable way (besides NOT doing this on > a production box...but I have no choice), but believe it or not, I actually > saw a reference on a Metalink forum to rename the sgadefSID.dbf file, start > up the new database, then rename the file to its original name. Obviously > sgadef gets created at instance startup as a memory map, but it doesn't look > like it's used for anything after that (it's certainly doesn't seem to be > written to). I do know that you can get an octal dump of the file to > determine the shared memory ID for whatever reason. > > Everything else I've heard/seen about this file has pretty much said DON'T > TOUCH IT!!! But if the instance only uses it at instance startup, is there > any harm in renaming it temporarily to get the other database up? If > so...why? > > And have any of you tried renaming or deleting the file in your cloning (or > other) efforts? Did it blow up, or work? > > TIA, > Steve > _ > Steve Morrow > IT/Tech Support > University of South Florida > phone: 813-974-5519 > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Morrow, Steve > 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 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). 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) 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 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).
Re: How long will 8.0.6 be supported?
09/30/2001 unless you have Extended Support, then it's 09/30/2004 - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, March 20, 2001 10:36 AM > I can't get into Metalink. Can anyone tell me how long 8.0.6 will be > supported? > > Ron Smith > Database Administration > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Smith, Ron L. > 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 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). 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) 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 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).
