RE: Oracle7.3.4 - Tablespace question
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 4 Aug 2004 17:48:44 -0400
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
-----------------------------------------------------------------
Other related posts:
