DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Dropping a database

  1. #1
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94

    Dropping a database

    Hi all,
    I missed something in the creation of database.
    How can I drop the hole database and recreate again.

    Regards
    Hamhey

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    there is no such drop database command, search the old threads

  3. #3
    Join Date
    Jun 2003
    Location
    India
    Posts
    2
    Originally posted by pando
    there is no such drop database command, search the old threads
    If you are in Windows delete the sid from oradim and if you have created the database manually then you have to delete the folders also that you have created plus you have to delete the Oracle Home from the Registry. That's all. But if you have the files created through OMF then all the above steps are not necessary.

    Hope this will be helpful.

  4. #4
    Join Date
    May 2001
    Posts
    736
    Originally posted by Shreyas Tattu
    if you have created the database manually then you have to delete the folders also that you have created plus you have to delete the Oracle Home from the Registry. That's all.

    Hope this will be helpful.
    which folders and why u need to delete the oraclehome? If u are on windows then u can use database configuration asst. to delete the database.

  5. #5
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by akhadar
    If u are on windows then u can use database configuration asst. to delete the database.
    This holds good for unix too.

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by Shreyas Tattu
    plus you have to delete the Oracle Home from the Registry. That's all.
    This will screw up, if u have multiple DBs.
    Well if you really want to touch REG, delete the entries in Oracle_Home Corresponding to %SID_You_Want_To_Delete% entries.

    I would say, better dont play with REG.

    Use Oracle Utils to do ur job.
    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"

  7. #7
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by abhaysk
    Use Oracle Utils to do ur job.
    Again wrong terminology. Use DBCA(9i) or DBASSIST(8i and below)

    Oracle utilities are
    o SQL*Loader
    o Export/Import
    o External Tables
    o DBNEWID
    o Metadata API
    o DBVerify

    And none of the above has anything to do with create or delete a database.

    At least use proper terminology.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  8. #8
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by adewri
    Again wrong terminology. Use DBCA(9i) or DBASSIST(8i and below)

    Oracle utilities are
    o SQL*Loader
    o Export/Import
    o External Tables
    o DBNEWID
    o Metadata API
    o DBVerify

    And none of the above has anything to do with create or delete a database.

    At least use proper terminology.
    OK Amar..I was always poor in terminology..and so herez one more..
    Last edited by abhaysk; 06-09-2003 at 04:02 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"

  9. #9
    Join Date
    May 2001
    Posts
    736
    Originally posted by adewri
    Use DBCA(9i) or DBASSIST(8i and below)

    I think even in 8i it is DBCA.

  10. #10
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by akhadar
    I think even in 8i it is DBCA.
    Really ? Thats news.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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