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).
