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
Search This Blog
Sunday, August 18, 2013
How to create tablespaces in 11gR2 RAC/ASM ?
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment