| 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 Tablespaces
FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - lastnameinitial_at_logica.com eg SMITHK_at_logica.com. Emails using the old format will continue to be delivered until 30th June 2001.
I have noted a very minor issue on our AIX 4.3 systems running 8.1.6.0.0
when creating a LMT.
We get the error message ORA-01543 tablespace XXX already exists but it then
goes on to create the tablespace.
This is repeatable on several systems all at the same version. On an 8.1.6.3 system it does not happen. There is nothing on Metalink.
The command I am using is create tablespace john datafile 'xxxxxxxx' size 100M extent management local uniform size 1M;
Anybody getting this on an 8.1.6.0 system?
John
-----Original Message-----
From: Stephen Andert
[mailto:StephenAndert_at_firsthealth.com]
Sent: 18 April 2001 01:03
To: Multiple recipients of list ORACLE-L
Subject: Re: Locally Managed Tablespaces
Patricia,
FWIW, We have been using them for several months now and
have not seen anything negative as a result. We decided to start using them
for all new tablespaces and we add a new set of tablespaces every month to
accomodate our partitioning strategy.
Our biggest databases that we are doing this with are over200MB on Compaq Tru64. Database version was 8.1.6.0 and we have moved to 8.1.6.2 with no noted problems.
Good luck.
Stephen
>>> pashe_at_TRUELINK.com 04/17 4:35 PM >>>
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.
PA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Patricia Ashe
INET: pashe_at_TRUELINK.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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Andert
INET: StephenAndert_at_firsthealth.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).
This e-mail and any files transmitted with it, are confidential to Logica and are intended solely for the use of the individual or entity to whom they are addressed.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hallas, John INET: HallasJ_at_logicae.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 18 2001 - 04:02:26 CDT
 |
 |