database create
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: database create

  1. #1
    Join Date
    Jun 2001
    Posts
    316
    Hi,
    I had a local database which i un-installed and then i reinstalled..
    But the old database still xists.....
    how do i drop the old database
    and create a new 1
    Can any1 pls give me step by step routine for this....

    thanx in advance

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    What O/S and version of database ? whats the method you followed to uninstall.....
    Reddy,Sam

  3. #3
    Join Date
    Jun 2001
    Posts
    316
    Its a NT machine.....

    ive removed the old datbase..
    Now how do i cerate a new 1?

    (Even if the question sound a bit stupid,pls answer cause me a novice programmer aspiring to be a DBA... )

  4. #4
    Join Date
    Feb 2000
    Posts
    175
    Hi,

    Run the database assistant in the $ORACLE_HOME/bin directory. It's called dbassist in Unix - I presume it's the same on NT.
    Alternativley run the 'create database' command from within Server Manager on the command line.

    Cheers

    Moff

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Be careful while playing with registry - have a bkup of registry if you are not sure.

    http://www.dbasupport.com/forums/sho...?threadid=6389
    http://www.dbasupport.com/forums/sho...threadid=11174
    Reddy,Sam

  6. #6
    Join Date
    May 2000
    Location
    Budapest
    Posts
    9
    what do you mean on "the database still exists" ? Are there all datafiles and controlfiles being made removed.
    Anyway, have you made a shutdown on the instance? Are backgound processes still alive?

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