RE: Locally Managed Tablespaces

I remember ssing somebody suggestion to create normal file in advance and then create temporary tablespace with reuse.

Alex Hillman

-----Original Message-----
[mailto:gregory.t.norris_at_mail.sprint.com] Sent: Wednesday, April 18, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L

I'm using LMTs with the UNIFORM EXTENT option on 8.1.6[.2], with great results. Two caveats I've noticed:

1. If you want to use LMTs for rollback segments, you MUST create at least one rollback segment in a dictionary managed tablespace first (in addition to the ever-present "system" RBS). This is bug#1176609, which you can lookup on Metalink... assuming that the palm pilot they're using as a webserver is up, of course. (-:
2. If you want to make your TEMP tablespace locally managed (i.e. created using TEMPFILE instead of DATAFILE), it will be created sparse on Unix systems. This means that (for example) you *won't* get an error if you inadvertently attempt to create a file larger than it's host filesystem... not up front, anyway. If that non-existent tempfile space is ever needed, you'll certainly get errors at that point (especially nasty if one of your control files is in the same filesystem). So make absolutely certain that the file size is entered correctly.

According to Oracle Support, #2 is a documentation error which will be corrected in 9i. I've been meaning to submit an enhancement request, asking that file > filesystem be treated as an error, but haven't actually done it yet.

Cheers!

> -----Original Message-----
> From: pashe [mailto:pashe_at_TRUELINK.com]
> Sent: Tuesday, April 17, 2001 6:36 PM
> To: ORACLE-L
> Cc: pashe
> Subject: Locally Managed Tablespaces
>
>
>
> I am interested in some statistics on Oracle locally managed
> tablespaces. I
> have been looking for any bugs or negative info about them.
> Are they in use
> at alot of sites? Seems like all the information I have come
> across is
> positive. Which is great! But maybe they aren't being used at alot of
> sites. Can I hear about experiences from others on this
> list? how many
> sites are actually using them?
> I have several databases that I am getting ready to go
> production soon and
> would like to create the tablespaces as locally managed, but need more
> statistics.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hillman, Alex
  INET: Alex.Hillman_at_usmint.treas.gov

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).