Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Republic of Srpska, Bosnia and Herzegovina
    Posts
    35

    Unanswered: tablespace is missing

    Hi
    I was having 2 datafiles in one tablespace on disk e, and my disk e: is damaged. I haven’ backup. Now i can’t open the database. Can I drop this tablespace or rename it or something else? Thanks for help.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    startup mount
    alter database datafile 'filename' offline drop;
    alter database open;
    drop tablespace <tablespace>;

    -- Of course you can kiss all the data in the missing files "GOODBYE".

Posting Permissions

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