DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: drop tablespace

  1. #1
    Join Date
    Nov 2000
    by mistaken, data file been deleted from disk.
    how I drop this tablespace.
    (this datafile only contains on tablespace)

  2. #2
    alter database datafile '/fhdj/sdh.dbf' offline drop;
    drop tablespace blabla;
    Hope it works.
    Ramon Caballero, DBA, rcaballe@yahoo.com

  3. #3
    Join Date
    Nov 2000

    thanks it works.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.