Paul,
We kindof use something like that here. Basically when we need to create a
database we have the SA create a high level mount point, like '/PS' for our
PoepleSoft stuff. We then create additional mount points like say '/PS/pstools'
for individual stuff. Disk space is not allocated to '/PS', but to
'/PS/pstools'. It does make it easier to find what datafiles are what, but
still you'd need to look in the data dictionary. Actually it's faster to look
in the data dictionary and you can do it remotely as well.
Dick Goulet
____________________Reply Separator____________________
Author: Paul Baumgartel <[EMAIL PROTECTED]>
Date: 4/1/2002 2:48 PM
Hi everyone.
I'm currently working at a client where the OFA standard has been (as
they put it) "taken to the next level". I disagree with their
approach, and I'd be interested to see what list members think.
The client believes that any DBA (there are about 16 on staff) should
be able to locate data files in any database without querying the data.
To this end, mount points are named both /unnn (e.g., /u001) and /annn
(e.g., /a001). "System" datafiles (system, temp, rollback tablespaces)
go only on the /unnn mount points, and in particular, datafiles for
certain tablespaces must go on certain mount points--for instance
rollback tablespace files always go on /u004.
"User" datafiles are allowed on /a001 and /a002, tables and indexes,
respectively.
To my mind, this standard changes the Optimal Flexible Architecture to
the Sub-optimal Inflexible Architecture, and all just to avoid a data
dictionary query. What do you think?
Thanks,
=====
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]
__________________________________________________
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
http://greetings.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
