Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle7.3.4 - Tablespace question

RE: Oracle7.3.4 - Tablespace question

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Wed, 04 Aug 2004 21:20:23 -0400
Message-ID: <BAY2-F11lPn4e56kvt200063c45@hotmail.com>


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



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Wed Aug 04 2004 - 20:17:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US