+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11
  1. 08-09-2006 09:11 PM #1
    skbn136
    skbn136 is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 08-09-2006 09:12 PM #2
    slimdave
    slimdave is offline Foreign Script Kiddie
    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
    Reply With Quote Reply With Quote
  3. 08-10-2006 08:55 AM #3
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    i also believe he getting mixed up in terms of instance and database - in oracle a database = an instance (in its simplest terms)
    Reply With Quote Reply With Quote
  4. 08-10-2006 10:24 AM #4
    graham_o
    graham_o is offline Junior Member
    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
    Reply With Quote Reply With Quote
  5. 08-10-2006 10:28 AM #5
    Thomasps
    Thomasps is offline Advisor
    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/
    Reply With Quote Reply With Quote
  6. 08-10-2006 10:31 AM #6
    graham_o
    graham_o is offline Junior Member
    Join Date
    Apr 2006
    Posts
    50
    Just winding him up Thomas, disappointed he didn't bite though.
    Reply With Quote Reply With Quote
  7. 08-10-2006 10:34 AM #7
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    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
    Reply With Quote Reply With Quote
  8. 08-10-2006 10:38 AM #8
    graham_o
    graham_o is offline Junior Member
    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?
    Reply With Quote Reply With Quote
  9. 08-10-2006 10:43 AM #9
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    nah you got me a kite, a christina calendar and some joke golf balls :-)
    Reply With Quote Reply With Quote
  10. 08-11-2006 03:35 AM #10
    reydp's Avatar
    reydp
    reydp is offline Senior Advisor
    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.
    ---------------
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width