Results 1 to 3 of 3

Thread: Create

  1. #1
    Join Date
    Jan 2009
    Posts
    4

    Unanswered: Create

    I need to create a UAT environment. Only one server is available to me and I already have the development database on it (say Mydb), so I have to create the UAT database with another name (say Mydb_UAT).

    What is the simplest way to do it ?
    Can I do it using 'load database' command ? In the manual I cannot find the syntax to load a database with a different name.

    Thanks for the help in advance.

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    You can load using a dump from any db of the same size

  3. #3
    Join Date
    Jun 2009
    Posts
    25
    Hi,
    U can create a database by using the create database with load option and when u create a database check Mydb size and create one "Mydb_UAT" with similar size and load the database mydb in mydb_UAT.
    suppose if your database name dump name is /backup/mydb.dmp then u can load as
    1>load database mydb_UAT from "backup/mydb.dmp" 2>go

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •