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

Thread: Dropping datafiles

Hybrid View

  1. 05-04-2001, 03:40 PM #1
    lee
    lee is offline Member
    Join Date
    Feb 2000
    Posts
    142
    Hi,
    How do I drop the datafiles?
    Please let me know.
    Reply With Quote Reply With Quote
  2. 05-04-2001, 03:52 PM #2
    rsuri
    rsuri is offline Senior Member
    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
    Reply With Quote Reply With Quote
  3. 05-04-2001, 08:17 PM #3
    thanigai
    thanigai is offline Senior Member
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width