| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle7.3.4 - Tablespace question
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_at_TFMC.co.za>
Reply-To: oracle-l_at_freelists.org
To: <oracle-l_at_freelists.org>
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mark W. Farnham
Sent: Wednesday, August 04, 2004 11:49 PM
To: oracle-l_at_freelists.org
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Denham Eva
Sent: Wednesday, August 04, 2004 5:26 PM
To: oracle-l_at_freelists.org
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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |