|
I have my tables, indexes, system, etc. on different mount
points. That was suggested by several of the gurus when I was getting
ready to move to new servers.
Ruth
----- Original Message -----
Sent: Friday, November 01, 2002 2:54
PM
Subject: RE: Dbf Files, Mount Points and
Oracle 7
--So my questions are:
-- 1) Is there any reason to
keep all the tablespaces on one
-- mount
point?
-- 2) I know about keeping table data and indexes in
different
-- tablespaces but can they also be on
different mount points?
-- 3) Any reason for not putting my 1 large
temp-table into its
-- own tablespace?
--
4) If I can do all of this, will anything significantly
change
-- in Oracle 8, 9, 10, ...?
1.
No. In fact, there are all kinds of reasons NOT to keep them on
one
mount point. Everything from Speed to Safety. When I built
our 7.3.4
database I used 64 mount points.
2. Yes. You can split a
tablespace up all over the place. Just put the
different data files
on different mount points.
3. No. In fact, I prefer doing
this. Maintenance is a lot easier.
4. No..... but who knows
about 10 because its not here yet.
-----Original Message-----
Sent:
Friday, November 01, 2002 1:14 PM
To: Multiple recipients of list
ORACLE-L
I am part-time DBA for an Oracle system that for
reasons
beyond our control is frozen at 7.3.4, at least for
the
immediate future. I am having some problems and I think
I know
how to correct them but I am asking the old-timers
to dust off their brains
to tell me if my proposals are
O.K.
It started when I noticed that
one of the tables had gone
into 2 extents. Normally when this
happens, I (in a nutshell),
make a copy of the table with larger storage
parameters.
But for this table, I get the following error
message:
ORA-01658: unable to create INITIAL extent for
segment
in tablespace ORA_DATA1
I also noticed that this system has 3 mount
points. When I
look at the capacity of the disks, the first is
always
89 percent full and the other two are 1 percent. This
is
because all the DBF files for tablespaces were created on
the first
mount point. So all the other two have are small
control and redo-log
files.
So what I would like to do to fix all of this is to move
some
of the tablespaces onto the other 2 mount points. I
would also like
to create a couple of new tablespaces, one
to store two large
application-related tables and another
to store a large table that gets
dropped and recreated
everyday (a local copy of data from an external
system).
So my questions are:
1) Is there any reason to keep
all the tablespaces on one
mount point?
2) I know about keeping table data and indexes in
different
tablespaces but can they also be on
different mount points?
3) Any reason for not putting my 1 large
temp-table into its
own tablespace?
4)
If I can do all of this, will anything significantly
change
in Oracle 8, 9, 10, ...?
I have read
different manuals and references but I have not
seen anything that
indicates that I cannot do what I am proposing.
I have tried this solution
on a test 8.1.6 database and everything
seems to be working.
TIA,
Wayne
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
McGill, Wayne L
INET: [EMAIL PROTECTED]
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: [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: Kevin
Lange
INET: [EMAIL PROTECTED]
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: [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).
|
