Skip to navigation Skip to content
sqlforge
  • Home
  • Special Offers
    • Free SQL Health Check
    • More Special Offers…
  • Home
  • Blog
  • Free SQL Health Check
  • Special Offers
  • sqlforge
Posted on 2011-06-292018-02-09 by sqldba — Leave a comment

Drop a corrupt datafile

alter database datafile ‘D:ORACLEORADATAMYPROJDATA01.DBF’ offline drop;

drop tablespace MYPROJDATA including contents and datafiles;

Category: Uncategorized

Post navigation

Previous post: Listener Commands
Next post: Advance Sequence Nextvals to sync with table
Leave a Reply

You must be logged in to post a comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Get Free Stock and Crypto!
Recent Posts
  • Clean up a cluster node
  • Distributed Transaction Coordinator
  • Power Apps – Create an Integer Time Stamp
  • Getting Started with React JS
  • Mount Disk with DISKPART
Archives
  • January 2025
  • September 2024
  • February 2023
  • December 2021
  • September 2021
  • June 2021
  • May 2021
  • April 2021
  • February 2021
  • January 2021
  • August 2020
  • June 2020
  • February 2020
  • June 2019
  • December 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • September 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • January 2017
  • December 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • March 2015
  • February 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • July 2014
  • June 2014
  • February 2014
  • December 2013
  • November 2013
  • September 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • January 2013
  • December 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • June 2011
  • May 2011
  • April 2011
  • February 2011
  • July 2010
  • March 2010
  • October 2009
  • April 2008
© sqlforge 2025
Built with Storefront.