Darren - Let me try to clarify my answer.
1. Yes, 800-meg is not really large with today's disk systems, so that
consolidation should be no problem.
2. If you are doing this type of consolidation, I think it would be a good
time for you to take as step back for broader perspective. Specifically,
Our SAN has been setup as RAID5, so the use of single large
datafiles is probably the method I will go with, using the added
option of resizing once I read up on it some more :)
Darren
-Original Message-
Sent: Wednesday, September 25, 2002 8:13 PM
To: Multiple recipients of list
that is something I didn't consider, I will look into it further.
Thanks
Darren
-Original Message-
Sent: Wednesday, September 25, 2002 5:48 PM
To: Multiple recipients of list ORACLE-L
Is there a reason you can't just resize the existing file?
-Original Message-
Sent:
Thanks Dennis
I was going to use LMT's, I didn't mention it in my email as I thought
it would be irrelevant to the question I was asking.
The first database in question to move is oracle financials 11.5.7 which
requires you to move to LMT's
Darren
-Original Message-
Sent: Thursday,
Is the requirement that all datafiles be the same size a business
requirement?
I guess that having all datafiles the same size would be useful if you need
to move them to other platters. Do you have multiple physical devices to
move your datafiles around in?
If you only have a single RAID
Is there a reason you can't just resize the existing file?
-Original Message-
Sent: Wednesday, September 25, 2002 7:43 PM
To: Multiple recipients of list ORACLE-L
I am in the process of upgrading our databases from 8.0.5 to 8.1.7,
possibly 9i depending on application
certifications.
Darren - My advice would be to read up on Locally Managed Tablespaces (LMT)
and uniform extents. This is a new feature that will ease your management
work.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, September 25, 2002 6:43 PM
To: Multiple
It's late at night maybe that's why I do not
understand your answer but I do not see the link
between LMT and the number/size of datafiles.
One reason of multiple datafiles id to spread IO but
since nowadays a majority of sites goes on huge disk
box using raid 5 (that's what we have, the unix