1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

create database xxx

Discussion in 'Server Administration and Options' started by monkey, Jun 2, 2014.

  1. monkey

    monkey Long Term Member

    Messages:
    156
    Likes Received:
    0
    Trophy Points:
    230
    Hello!
    Please, is that order working in oracle?
    What do we get getting a new databasse that way?
    many thanks!!!
     
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Hi.

    Process of installation and creation of base is well described in documentation. If there are problems at base creation, describe what mistakes arose...

    Additional links ,may be help:

    Create DB 11r2
    Create DB 12c

    http://docs.oracle.com/cd/E16655_01/server.121/e17636/cdb_create.htm

    http://docs.oracle.com/cd/E16655_01/server.121/e17643/install.htm#BABEIAID

    http://www.oracle-base.com/articles...te-and-configure-container-database-12cr1.php

     
    monkey likes this.
  3. ocprep

    ocprep Forum Advisor

    Messages:
    277
    Likes Received:
    76
    Trophy Points:
    410
    Location:
    Orlando, Florida
    You mean what do you get in using the CREATE DATABASE statement to create a new databases as opposed to using the Database Creation Assistant (DBCA)?

    The most noticeable thing you get is a process that is more complex, vastly more failure prone and takes a heck of a lot more time even when it is done perfectly.
     
    monkey likes this.
  4. monkey

    monkey Long Term Member

    Messages:
    156
    Likes Received:
    0
    Trophy Points:
    230
    Hello!
    I just ment this, from w3:

    http://www.w3schools.com/sql/sql_create_db.asp

    Is that applicable in oracle, and what is the difference vs the way we do usually by making 3 files(drop, insert values and create tables) + , eventually, the first one (init) which runs all next 3 of them?

    Many thanks!
     
  5. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    That is not applicable to Oracle, even in version 12c. That is used in Sybase and SQL Server to create what they consider a database.
     
    monkey likes this.
  6. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Hi.

    This syntax corresponds to syntax for MS SQL
     
    monkey likes this.