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