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

Thread: dropping data file

  1. #1
    Join Date
    Nov 1999
    Location
    Saint Charles, MO, US
    Posts
    3
    I have dropped a datafile by,

    -- deleting the file physically.
    -- alter database datafile 'e:\...\...\x.prd' offline drop.

    now the database is working fine but v$datafile still lists the datafile.

    how can i get this cleared.


  2. #2
    Join Date
    Apr 2000
    Posts
    126

    Wink dropping data file

    You need to drop the tablespace associated with the datafile and then physically remove the file.

  3. #3
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    on next shutdown & start your datafile will bee tracered as missing (you can not remove from there "dba_data_files" - until you don't make drop and create tablespace)

  4. #4
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Talking whoops


    Yeah, the order is important.

    What I do:
    1. Drop TableSpace
    2. Delete Datafile from Server
    3. Remove the user associated with that tablespace (normally I have 1 user/connection per Schema/Tablespace, may not be best thing to do tho)

    - Magnus


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