Dropping Tablespaces with missing datafiles - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 26

Thread: Dropping Tablespaces with missing datafiles

  1. #11
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405

    Re: Re: Dropping Tablespaces with missing datafiles

    Originally posted by abhaysk
    This sounds almost impossible.....

    When the tablespace is online it would have obiviously locked all its datafiles....& when file is locked at OS level you just cant delete/rename/move the file.

    I wonder how on earth ( may it be any OS ) lets you delete file when locked?


    Can any one tell how this can be done...Tried to simulate the problem but it seems almost impossible.

    Abhay.
    U R on windows OS I guess
    -nagarjuna

  2. #12
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: Re: Re: Dropping Tablespaces with missing datafiles

    Originally posted by nagarjuna
    U R on windows OS I guess
    wass big deal...and y r u so amused?
    making all such faces?????
    i dont see any point....

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #13
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405

    Re: Re: Re: Re: Dropping Tablespaces with missing datafiles

    Originally posted by abhaysk
    wass big deal...and y r u so amused?
    making all such faces?????
    i dont see any point....

    Abhay.


    Originally posted by abhaysk
    This sounds almost impossible.....

    When the tablespace is online it would have obiviously locked all its datafiles....& when file is locked at OS level you just cant delete/rename/move the file.

    I wonder how on earth ( may it be any OS ) lets you delete file when locked


    If you dont know, learn it.. Dont make sentences. Good DBAs should have patience. You dont have a bit of it. In UNIX, Oracle does not lock the files at OS level.
    Last edited by nagarjuna; 03-29-2003 at 04:49 AM.
    -nagarjuna

  4. #14
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: Re: Re: Re: Re: Dropping Tablespaces with missing datafiles

    Originally posted by nagarjuna






    If you dont know, learn it.. Dont make sentences. Good DBAs should have patience. You dont have a bit of it. In UNIX, Oracle does not lock the files at OS level.
    i do have patientence.....


    now unix dosent lock the file even though its in use??

    thats rediculous....i dont have knowledge in unix but wass the point in not locking a file even if it is in use....


    If this is the case then I would better reley on Windows...

    Abhay.
    Last edited by abhaysk; 03-29-2003 at 05:20 AM.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  5. #15
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well unix does not lock files, that's not new

    windows does and as some of us might noticed there are some threads saying they cannot start database in windowz after taking backup because the datafile is locked by the backup software, this for example does not happen in unix.

    it can be bad or good but I still prefer *NIX, *BSD platforms to run Oracle

  6. #16
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    lol.. this Abhay is SQL server kinda DBA I guess

    UNIX is for gurus. We need proper plan before implementing it. Then, it's worth, it lasts longer. We have more options regarding security in unix. Windows does not give much choices. It does everything itself. Windows is good for home made, home use database. Not for bigger ones..
    -nagarjuna

  7. #17
    Join Date
    May 2001
    Posts
    736
    Don't take it so easily. In my environment we have millions cost servers based n Windows.May be they have different behaviour to Other OS. A DBA is a DBA don't make a joke of it u must be precise with your words.

  8. #18
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Originally posted by akhadar
    Don't take it so easily. In my environment we have millions cost servers based n Windows.May be they have different behaviour to Other OS. A DBA is a DBA don't make a joke of it u must be precise with your words.
    24*7

    Is it possible with windows based databases????? Dont you reboot your windows servers once in every week?????

    Can you imagine an OLTP of 300GB on any windows?????
    -nagarjuna

  9. #19
    Join Date
    May 2001
    Posts
    736
    ---------------------
    24*7

    Is it possible with windows based databases?????
    ----------------------

    Sure why not?.

    -------------------------
    Dont you reboot your windows servers once in every week?????
    -------------------------

    Why ?.Since iam in Clustered environment.May be u didnot travelled world wide.
    dont thing that iam a supporter of Bill gates.

    Stop accusing others and other platforms.Since it is a professional site be professional.

    -------

    Great minds discuss ideas.Average minds discuss events.Small minds discuss people.

    regards
    akhadar

  10. #20
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Originally posted by akhadar
    ---------------------
    24*7

    Is it possible with windows based databases?????
    ----------------------

    Sure why not?.

    -------------------------
    Dont you reboot your windows servers once in every week?????
    -------------------------

    Why ?.Since iam in Clustered environment.May be u didnot travelled world wide.
    dont thing that iam a supporter of Bill gates.

    Stop accusing others and other platforms.Since it is a professional site be professional.

    -------

    Great minds discuss ideas.Average minds discuss events.Small minds discuss people.

    regards
    akhadar
    Okay.. I beg your pardon. Mistake regretted.

    I did the same mistake Abhay did. Being rude in replies.

    And, I still believe that paging is a problem with windows OS.. Mebbe, I am wrong.
    -nagarjuna

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