How to Create Table Space on DataBase 11g.

Hi Friends.

How to Create Table Space on  DataBase 11g.

Goto Window and Click All Program 
Open Sql Plus Connect User  enter User name and Password.

User name  sys as sysdba
Password  welcome1

Run Command Create  Table Space 

 Sample Oracle create table space script

-- *** Make a copy of this script and change <<WEBLOGIC>> to the                   desired tablespace name prefix.

-- *** CHANGE D:\ and E:\ to valid disk locations for your environment.

-- ***Adjust file sizes as needed.

--        Create additional copies of this script to define additional tablespaces for the WEBLOGIC_GROUPSPACE Content Management Repository database

--  and to create additional Content Management Repository databases.  For     example; change <<WEBLOGIC>> to WEBLOGIC_GROUPSPACE.

--  Note:  Indexes will be placed in <<WEBLOGIC>>_DATA by default.  Rebuild indexes via rebuild_indexes.sql to move them to the index tablespace after

--  initial database object creation.

 Run This Command on Sql Plus.

  CREATE TABLESPACE weblogic_DATA

  DATAFILE 'C:\Oracle\weblogic_DATA01.DBF' SIZE 1000M;

  CREATE TABLESPACE weblogic_INDEX

  DATAFILE 'C:\Oracle\weblogic_INDEX01.DBF'

  SIZE 1000M;

Sample Oracle create database user script

-- *** Make a copy of this script and change <<WEBLOGIC>> to the desired user and tablespace name.

-- Create additional copies of this script to define additional database users for the WEBLOGIC_GROUPSPACE Content Management Repository database

--  and to create additional Content Management Repository databases.  For example; change <<WEBLOGIC>> to WEBLOGIC_GROUPSPACE.

  CREATE USER weblogic

  IDENTIFIED BY welcome1

  DEFAULT TABLESPACE weblogic_DATA

  TEMPORARY TABLESPACE TEMP;

GRANT CREATE TABLE, CREATE VIEW, CREATE TRIGGER, CREATE SEQUENCE, CREATE SESSION, UNLIMITED TABLESPACE TO weblogic;