Search This Blog

Sunday, August 18, 2013

How to create tablespaces in 11gR2 RAC/ASM ?

SQL> create tablespace test datafile
  2  '+DATA'
  3  size 50m autoextend on next 100m
  4  extent management local
  5  segment space management auto;

Tablespace created.



SQL> select tablespace_name from dba_data_files;

TABLESPACE_NAME
------------------------------
USERS
UNDOTBS1
SYSAUX
SYSTEM
EXAMPLE
UNDOTBS2
TEST



SQL> alter tablespace test add datafile
  2  '+DATA'
  3  size 50M autoextend on next 100M;

Tablespace altered.


SQL> select file_name from dba_data_files where tablespace_name='TEST';

FILE_NAME
--------------------------------------------------------------------
+DATA/orcl/datafile/test.271.823780803
+DATA/orcl/datafile/test.272.823781017

0 comments:

Post a Comment