RE: Oracle7.3.4 - Tablespace question
- From: "M Rafiq" <rafiq9857@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 04 Aug 2004 21:20:23 -0400
Those newly created datafiles are not reachable by this instance as it
exceeded the limit. Try to recreate control files with all those datafiles
created as new. Change also db_files in initSID.ora.
Alternately exp_full database. create a new one and import it there.
I have gone through this issue almost 6 years back. I exported full
database, created a new database , removed old one and imported there. Don't
forget to increase db_files to 1022(max size)
HTH,
Regards
Rafiq
From: "Denham Eva" <EVAD@xxxxxxxxxx>
Reply-To: oracle-l@xxxxxxxxxxxxx
To: <oracle-l@xxxxxxxxxxxxx>
Subject: RE: Oracle7.3.4 - Tablespace question
Date: Thu, 5 Aug 2004 00:04:18 +0200
Mark,
Thanks for the answer, OK db_files set at 30.
However I don't think I may have explained correctly.
I created the tablespace with a number of datafiles, everything went
fine I observed the physical files being created. However I guess on the
finalization on the last file the database gave the error DB_FILES
exceeded. OK, I thought, so I had a look if the Tablespace existed,
which it at present does not.
So I had a look, the physical files still do, and the control files
appear to be newer. My question is does the tablespace exist? Just
waiting for me to change the DB_FILES parameter, but is just not
available. Or it does not exist and hence should I restart the database
there will be no tablespace.
Would you know?
Many Thanks
Denham
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mark W. Farnham
Sent: Wednesday, August 04, 2004 11:49 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle7.3.4 - Tablespace question
Well, it really depends on whether there is any contents in the
tablespaces
that you want. If you just want to get rid of the tablespaces in
question,
then startup nomount and alter those datafiles and tablespaces offline.
Then
you will be able to drop them offline including contents.
What is your db_files value?
mwf
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Denham Eva
Sent: Wednesday, August 04, 2004 5:26 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Oracle7.3.4 - Tablespace question
Hello Folks,
Here goes, I have now added this tablespace, however it errored out with
DB_FILES exceeded.
So this tablespace does not exist on the database, even though the files
were created.
What will happen if I restart the database? Because the control files
appear to have been changed.
I have now discovered that the database is infact still busy cleaning
out the original tablespaces, so a bit of a wait.
So please advise on the above, it would be nice if the new tablespace is
not part of the database.
Regards
Denham
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
_________________________________________________________________
Don?t just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
