RE: Locally managed tablespace

From: Kathy Duret <KathyD_at_belkin.com>
Date: Fri, 14 Sep 2001 10:24:09 -0700
Message-ID: <F001.0038EF79.20010914101040@fatcity.com>

!! Please do not post Off Topic to this List !!

How are you to create the rollback segments? Is this the same or different from the other LMT tablespaces. I see where the Temporary Tablespaces are different.

Any other good LMT articles besides the one below? I want to change our database into LMT and can you believe this was a brand new 8.1.6 database created in April and they used LONG datatypes and other old architecture.

Kathy

-----Original Message-----
Sent: Thursday, September 13, 2001 4:05 PM To: Multiple recipients of list ORACLE-L

!! Please do not post Off Topic to this List !!

!! tsiL siht ot cipoT ffO tsop ton od esaelP !!

You can read this article to get some info: http://www.oracle.com/oramag/oracle/00-nov/index.html?o60o8i.html

-----Original Message-----
Sent: Thursday, September 13, 2001 6:15 PM To: Multiple recipients of list ORACLE-L

!! Please do not post Off Topic to this List !!

Anyone here tried to use those locally managed tablespace? Some DBA here persuade me to use the locally managed TS for the
rollback segment,tables, indexes, temp tablespace

Can you tell me what are the benefits of using the locally managed tablespace, any disadvantages?

Thanks in advance.

Chris Harvest.
Creative Consulting.

Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: CC Harvest
INET: ccharvest_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).

* * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sherman, Edward INET: shermanej_at_eccic.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Confidential
This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kathy Duret
INET: KathyD_at_belkin.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------