3 Replies Latest reply: Aug 21, 2013 6:55 AM by EdStevens RSS

    How to create database and tablespace?

    yash_08031983

      Hello experts,

       

      i want to create a database named Influx as well as tablespace influx.

      for this i login in sys account.

      now i am trying to run the following command:


      CREATE DATABASE INFLUX
         LOGFILE GROUP 1 ('G:\app\dhirender\oradata\INFLUX\redo01.log') SIZE 100M,
                 GROUP 2 ('G:\app\dhirender\oradata\INFLUX\redo02.log') SIZE 100M,
                 GROUP 3 ('G:\app\dhirender\oradata\INFLUX\redo03.log') SIZE 100M
         MAXLOGFILES 5
         MAXLOGMEMBERS 5
         MAXLOGHISTORY 1
         MAXDATAFILES 100
         DEFAULT TABLESPACE users
            DATAFILE 'G:\app\dhirender\oradata\INFLUX\INFLUX01.dbf'
            SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
       

       

      FOLLWOING ERROR IS COMMING:

      ora-01501     datbase fialed.

      ora-01100    database already mount

       

      also help me to create tablespace.

      please help me out.

       

      Thanks

      Yash