| 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
If you are tyring to use a LM temporary tablespace how about creating a
second tablespace, temporary that is lcoally managed and then slowly alter
the user, maybe even try and doa little test with a queryt hat will sue
temporary space, run the query with one user on the normal dict man
tablespace and the second user on the LM nd see if you can convince your
boss now as the best time,
They like to see that it works. If it does then they will sya yes sooner.
George
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: 01 November 2002 19:46 PM
To: Multiple recipients of list ORACLE-L
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-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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 08 2002 - 14:34:05 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |