Problem solve Get help with specific problems with your technologies, process and projects.

Can I move the tablespace online with missing datafiles in Oracle?

Does your Oracle database have missing datafiles? Learn whether you can stil move the tablspace online when the database is in noarchivelog mode in this trip from an Oracle expert.

We have the following problem: Two of eight datafiles of a tablespace were deleted and the database is in noarchivelog mode. There's not any backup and the version is 9i Release 2.0.8. The database is open but the tablespace is offline. Is there any possibility to move the tablespace online? It doesn't matter about the two missing datafiles. Thanks in advance.
Sorry, but you will not be able to put the tablespace online. When you attempt it, Oracle verifies the datafile headers for all datafiles belonging to the tablespace. Since you do not have all datafiles, the operation will fail.
This was last published in October 2009

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.