| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: LOCALLY MANAGED TABLESPACE
Jay,
I've been going through this for the first time as well. In 8.1.7 you can a LMT as a user's temporary tablespace, but as soon as the process try to create a temp segment, you'll get the ORA- error. So, if you want LMT and temporary segments you'll need the Temporary tablespace / tempfiles. Just created mine on our sandbox, and one other thing I found out; you can't put temporary tablespaces in backup mode, and they are not listed with normal datafiles in a controlfile trace (that 2 things).
Mike Hand
Polaroid Corp.
-----Original Message-----
Sent: Friday, November 01, 2002 3:22 PM
To: Multiple recipients of list ORACLE-L
Jay,
Is your tablespace type "TEMPORARY" or "PERMANENT". I tried to create
a LMT for type temporary and it is not allowed. Oracle 8.1.7 . The
Oracle 8i DBA Handbook also says that Temporary can not be LMT. It may
allow the creation of an LMT for a permanent tablespace that contains
temporary objects.
Ron
ROR mª¿ªm
>>> JayMiller_at_TDWaterhouse.com 11/01/02 02:45PM >>>
Very, very lucky.
I've been trying to get permission to move just my temporary tablespace
to
locally managed for months. My boss' boss refuses to give the okay
until
after our standby database is moved to a new location (if anyone can
explain
why those two things are related in any way I'd be overjoyed).
And yes, I pointed out that every other database (either new or
migrated
before DBA responsibilities got shifted to someone who knows nothing
about
databases) has been using locally managed tablespaces and that our QA
and QC
testing went perfectly.
Jay Miller
-----Original Message-----
Sent: Friday, October 25, 2002 12:14 PM
To: Multiple recipients of list ORACLE-L
You are lucky, very lucky...
-----Original Message-----
Sent: Friday, October 25, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L
Pardon the ignorance, I'm simply trying to understand... What is meant
by
"management" in this context? I'm can't imagine a circumstance under
which
ANY business manager would have a say on what goes on in the black box
called Oracle. Downtime? Cost of hardware/software? Vendor selection? I
can
see the input on those issues. But, all the way down to extent
management??
Or am I simply lucky to not have that level of bureaucracy?
Gary Weber
Senior DBA
Charles Jones, LLC||Superior Information Services, LLC
-----Original Message-----
Sent: Friday, October 25, 2002 10:29 AM
To: Multiple recipients of list ORACLE-L
Same here
Getting management to first understand the extent issue on Dictionary
managed was a interesting exercise. Now trying to break that
understanding
down when wanting to use LMT is like double the work, painful.
Difficult thing trying to educate them enough to understand something
but
not leaving at the same time halve way where you start getting these
interesting architecture decisions or ideas.
George
George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Tel: (+27 11) 575 0573
Fax: (+27 11) 576 0573
E-mail:george.leonard_at_za.didata.com
Web: http://www.didata.co.za <http://www.didata.co.za>
You Have The Obligation to Inform One Honestly of the risk, And As a Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity!
Once Informed & Totally Aware of the Risk, Every Fool Has the Right to
Kill
or Injure Themselves as They See Fit!
-----Original Message-----
Sent: 25 October 2002 13:04 PM
To: Multiple recipients of list ORACLE-L
The only issue we faced was convincing the management that in LMT
having 150
extents is not really a problem.
Raj
QOTD: Any clod can have facts, but having an opinion is an art!
-----Original Message-----
Sent: Thursday, October 24, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L
Hi
I am thinking to change our few dictinary manages tablespace to locally
managed tablespace.Can any one experienced any issues with locally
managed
tablespace?
Do any one experience what gain after changing to locally managed
tablespace?
Thx
-Seema
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: JayMiller_at_TDWaterhouse.com Fat City Network Services -- 858-53 8-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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: RROGERS_at_galottery.org 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: HANDM_at_polaroid.com 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: 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 Fri Nov 01 2002 - 14:59:38 CST
 |
 |