Forgot your password?    
+ Reply to Thread
Results 1 to 1 of 1

Thread: Create Database Script

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427

    Create Database Script

    create database DEV
    logfile group 1 ('/u01/../redo1.log') size 10M,
    group 2 ('/u01/../redo2.log') size 10M,
    group 3 ('/u01/../redo3.log') size 10M
    character set WE8ISO8859P1
    national character set utf8
    datafile '/u01/../system_01.dbf'
    size 50M autoextend on
    next 20M maxsize unlimited
    extent management local
    sysaux datafile '/u01/../sysaux_01.dbf'
    size 10M autoextend on
    next 10M maxsize unlimited
    undo tablespace undotbs1
    datafile '/u01/../undotbs1_01.dbf' size 10M
    default temporary tablespace temp
    tempfile '/u01/../temp_01.dbf' size 10M;

+ Reply to Thread

Similar Threads

  1. Create single instance standby database for RAC Database
    By devesh_ocp in forum DataGuard Setup and Management
    Replies: 0
    Last Post: 04-26-2012, 11:27 AM
  2. Create Database Template Using DBCA.
    By ajaychandi in forum Database Installation,Upgrades,Migration,Patching and Cloning
    Replies: 0
    Last Post: 04-18-2012, 05:49 PM
  3. Replies: 0
    Last Post: 01-10-2012, 06:22 PM
  4. Replies: 0
    Last Post: 01-01-2012, 01:33 PM
  5. Create a Database Manually using Create Database Script
    By Hemant in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 12-26-2011, 08:15 PM

Posting Permissions

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

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics