DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2001
    Is it required to shut down your existing databases while you want to create a new database in the same server where there are existing databases present ?

  2. #2
    Join Date
    Mar 2001

    Red face database creation


    You need not shut down the database before the creation another database on the same system but better take a backup of the existing database so that if you make a mistake when creating the new database you might go and overwrite the existing database in which case you new database might go and overwrite you old datafiles and your old database becomes unusable

    Be carefull when creating a database Plan it well before you create a database

  3. #3
    Join Date
    Oct 2000
    Charlotte, USA

    database creation

    before running the create db script please ensure the datafiles you are planning to create for the new db should not have the same name of earliar db.
    2.create all neccessary directories needed for the new db as you mentioned in files.
    Then you will be allright nothing will happen to your db.
    all the best.

  4. #4
    Join Date
    Mar 2001


    It is at all not necessary to shutdown your existing database while creating new db in the same server, but pl. make sure about the filename (like parameter files, control files etc.) and paths you r going to define for new database.

    All the Best.


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