DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Database creation

  1. #1
    Join Date
    Mar 2001
    Posts
    13
    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
    Posts
    635

    Red face database creation

    No

    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
    Santosh

  3. #3
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330

    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
    Posts
    131

    NO

    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.

    Upesh

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