Datafile has been removed already , But I still can find its information in V$datafil
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 4 123 ... LastLast
Results 1 to 10 of 39

Thread: Datafile has been removed already , But I still can find its information in V$datafil

Hybrid View

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    Datafile has been removed already , But I still can find its information in V$datafile
    why?
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Unless you offline and remove the datafile with a drop command the entry will remain in the data dictionary. Simply removing the datafile will not remove it association with the Oracle database.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    would you please tell us how did you remove the datafile...means using what command??
    "Greatest Rewards come only with Greatest Commitments!"

  4. #4
    Join Date
    May 2002
    Location
    USA
    Posts
    462

    Talking

    as per my knowledge .
    once created datafile cannot be dropped through normal sql syntax . tablespace associated with the datafile can be dropped, which removes the datafile from v$datafile.

  5. #5
    Join Date
    Jul 2002
    Posts
    132
    alter database datafile 'xxx' offline drop;

    Or if it is the only datafile in the tablespace,
    Drop tablespace name including contents;

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    offlince drop a datafile will force you to drop entire tablespace

  7. #7
    Join Date
    Jul 2002
    Posts
    132
    Pando, what do u mean by 'force to drop entire tablespace'? I agree that offline a datafile means that u may drop the tablespace at a later time and not that U will be forced to drop it.

  8. #8
    Join Date
    May 2002
    Location
    USA
    Posts
    462

    Wink


    after droping the datafile . i believe we cannot make it online
    with a similar syntax . only option it leaves is to recover the database if it is in archivelog mode .
    is this syntax valid prior to version 8 .

  9. #9
    Join Date
    Jul 2002
    Posts
    132
    I think we moved from the actual question posed. The one line reply is:

    "References to the dropped datafiles are not eliminated from views unless the tablespace in which they exist is recreated or dropped. "



  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Originally posted by soniaarora
    Pando, what do u mean by 'force to drop entire tablespace'? I agree that offline a datafile means that u may drop the tablespace at a later time and not that U will be forced to drop it.

    may?

    no, you are forced to, you cant never ever remove a datafile from a tablespace

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