This discussion is archived
3 Replies Latest reply: Aug 21, 2013 4:55 AM by EdStevens RSS

How to create database and tablespace?

yash_08031983 Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points