The poster implied he was going to change the
temporary tablespace to locally managed.
> > > > > to some of the other org's, so maybe staying
> > > with
> > > > > dictionary-managed would
> > > > > be
> > > > > best, except for the temporary tablespace.
> > > > >
> > > > > Darren.
All of my production databases are still dictionary
managed. I played around with locally managed
tablespaces a while back on a test server, and when I
ran a generic hot backup script, which attempted to
dynamically put each tablespace in backup mode, it
failed on the temporary tablespace. Of course all
other tablespaces were successful (as you pointed
out).
Hopefully he would be doing this in a test environment
first anyway, but I was just pointing out that he may
want to test backup/recovery after converting.
Rob Pegram
Oracle Certified DBA
- "Koivu, Lisa" <lisa.koivu_at_efairfield.com> wrote:
> That's not a temp tablespace (TEMP_DATA_A). It's a
> place to put temporary
> load tables. My temporary tablespace is TEMP, which
> is dictionary. From
> the research I did on LMT's before I decided to use
> them, it looked like
> there were several bugs associated with temporary
> tablespaces being LMT's so
> I left my temporary ts dictionary.
>
> LK
>
>
> > -----Original Message-----
> > From: Robert Pegram [SMTP:pegramrg_at_yahoo.com]
> > Sent: Wednesday, April 17, 2002 11:34 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Locally managed tablespaces/What a
> DBA can do ?
> >
> > What about your locally managed "temporary"
> > tablespace?
> >
> >
> > --- "Koivu, Lisa" <lisa.koivu_at_efairfield.com>
> wrote:
> > > What? I was just able to do it. 8.1.7, W2K
> > >
> > > (INV-SYSTEM)>@ts
> > >
> > > TS_NAME LMT MB_FREE MB_TOTAL
> > > PCT_USED
> > > --------------- ---------- --------- ---------
> > > ---------
> > > LOAD_DATA_A LOCAL 740 2000
>
> > > 63
> > > LRG_INDEX_A LOCAL 390 2500
>
> > > 84.4
> > > LRG_INDEX_B LOCAL 980 1000
>
> > > 2
> > > LRG_TABLE_A LOCAL 2440 4000
>
> > > 39
> > > LRG_TABLE_B LOCAL 360 1000
>
> > > 64
> > > MED_INDEX_A LOCAL 480 1000
>
> > > 52
> > > MED_TABLE_A LOCAL 680 1000
>
> > > 32
> > > RBS DICTIONARY 299 1000
>
> > > 70.1
> > > SMALL_INDEX_A LOCAL 183 200
>
> > > 8.5
> > > SMALL_TABLE_A LOCAL 169 200
>
> > > 15.5
> > > SYSTEM DICTIONARY 110 200
>
> > > 45
> > > TEMP DICTIONARY 961 1000
>
> > > 3.9
> > > TEMP_DATA_A LOCAL 900 1000
>
> > > 10
> > > TOOLS LOCAL 19 20
>
> > > 5
> > > USERS LOCAL 34 75
>
> > > 54.7
> > >
> > > 15 rows selected.
> > >
> > > (INV-SYSTEM)>alter tablespace load_data_a begin
> > > backup;
> > >
> > > Tablespace altered.
> > >
> > > (INV-SYSTEM)>alter tablespace load_data_a end
> > > backup;
> > >
> > > Tablespace altered.
> > >
> > >
> > >
> > > > -----Original Message-----
> > > > From: Robert Pegram [SMTP:pegramrg_at_yahoo.com]
> > > > Sent: Wednesday, April 17, 2002 9:58 AM
> > > > To: Multiple recipients of list ORACLE-L
> > > > Subject: RE: Locally managed tablespaces/What
> a
> > > DBA can do ?
> > > >
> > > > Darren,
> > > >
> > > > If using a hot backup strategy (other than
> Rman),
> > > > make sure to test your backup/recovery if you
> > > switch
> > > > the temporary tablespace to locally managed.
> You
> > > > can't put a locally managed temporary
> tablespace
> > > in
> > > > backup mode.
> > > >
> > > > Rob Pegram
> > > > Oracle Certified DBA
> > > >
> > > > ----------------
> > > >
> > > > SQL> create tablespace temp_dict
> > > > 2 datafile 'c:oracleoradataorcl
> emp_dict.dbf'
> > > size
> > > > 10M
> > > > 3 default storage (initial 1M next 1M
> > > maxextents
> > > > unlimited pctincrease 0)
> > > > 4* temporary
> > > > SQL> /
> > > >
> > > > Tablespace created.
> > > >
> > > > SQL> create temporary tablespace temp_local
> > > > 2 tempfile 'c:oracleoradataorcl
> emp_local.dbf'
> > > size
> > > > 10M
> > > > 3 extent management local
> > > > 4 uniform size 1M;
> > > >
> > > > Tablespace created.
> > > >
> > > >
> > > > SQL> alter tablespace temp_dict begin backup;
> > > >
> > > > Tablespace altered.
> > > >
> > > > SQL> alter tablespace temp_local begin backup;
> > > > alter tablespace temp_local begin backup
> > > > *
> > > > ERROR at line 1:
> > > > ORA-03217: invalid option for alter of
> TEMPORARY
> > > > TABLESPACE
> > > >
> > > >
> > > > --- "Browett, Darren"
> > > <dbrowett_at_city.coquitlam.bc.ca>
> > > > wrote:
> > > > > Okay, maybe re-org would be a little too
> much,
> > > as
> > > > > you say, I would need
> > > > > to know the application better, and with 8
> > > > > distinctly different apps,
> > > > > including
> > > > > oracle financials, I maybe heading for
> trouble.
> > > > >
> > > > > But what about simply turning the existing
> > > > > dictionary-managed tablespaces
> > > > > into
> > > > > locally managed tablespaces, other then
> > > maintenance,
> > > > > would I gain
> > > > > performance ?
> > > > >
> > > > > From what I read on this list, the growth of
> my
> > > > > tables is very small
> > > > > compared
> > > > > to some of the other org's, so maybe staying
> > > with
> > > > > dictionary-managed would
> > > > > be
> > > > > best, except for the temporary tablespace.
> > > > >
> > > > > Darren.
> > > > >
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > Sent: April 15, 2002 3:58 PM
> > > > > To: Multiple recipients of list ORACLE-L
> > > > >
> > > > >
> > > > > Darren - Do you have to reorganize the
> vendor's
> > > > > files now? The objective of
> > > > > LMT's is to make Oracle more self-managing
> (you
>
=== message truncated ===
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robert Pegram
INET: pegramrg_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Wed Apr 17 2002 - 18:58:37 CDT
