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

Thread: Dropping datafiles

  1. #1
    Join Date
    Feb 2000
    Posts
    142
    Hi,
    How do I drop the datafiles?
    Please let me know.

  2. #2
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    You should not be dropping the datafile. The correct way is to drop the tablespace and then remove the datafiles from the OS.

    Check this thread --

    http://dbasupport.com/forums/showthr...?threadid=6697


    - Rajeev
    Rajeev Suri

  3. #3
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330

    droping the datafile

    First...bring the tablespace offline...
    Alter tablespace tablespace_name offline;
    check the status of the tablespace....
    drop tablespace tablespace_name...
    and at os level...
    rm datafile name.
    it will work.
    good luck.
    Thanigaivasan

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