Creating Database Manually
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Creating Database Manually

  1. #1
    Join Date
    Aug 2006
    Posts
    1

    Question Creating Database Manually

    Hi Oracle Professionals,

    Hope you could clarify my basic doubt about creating database manually.

    I have a test oracle database server with a sample database. My objective is to create a new database manually. My questions are:

    1. Each database is handeled by a new instance. How I can create a new instance for this new database before I execute my script for creation of database

    Thanks in advance

    skbn

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    What's your version? It got a lot more simple in 10g, I believe.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    i also believe he getting mixed up in terms of instance and database - in oracle a database = an instance (in its simplest terms)

  4. #4
    Join Date
    Apr 2006
    Posts
    50
    Davey, I can't believe you just said that, you know better than that.

    try this link... http://download-uk.oracle.com/docs/c...t.htm#CNCPT005
    Last edited by graham_o; 08-10-2006 at 10:29 AM. Reason: added info

  5. #5
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Quote Originally Posted by graham_o
    Davey, I can't believe you just said that, you know better than that.
    He said it in "simplest terms"
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  6. #6
    Join Date
    Apr 2006
    Posts
    50
    Just winding him up Thomas, disappointed he didn't bite though.

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    graham, try reading this - more suited at your level I believe

    http://www.amazon.com/gp/product/076...lance&n=283155

    please come back when you wanna play with the big boys

  8. #8
    Join Date
    Apr 2006
    Posts
    50
    Nice one Dave, I knew you wouldn't be able to resist it. Isn't that the book we got you for your leaving do?

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    nah you got me a kite, a christina calendar and some joke golf balls :-)

  10. #10
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    sometimes, it's better to ask questions here humbly like "Patrick the star" does with Squidward.
    ---------------

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