Adding Datafiles to tablespaces

[oracle@1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Wed Jan 11 07:45:51 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit

Production
With the Partitioning, Real Application Clusters, Automatic Storage

Management, OLAP,
Data Mining and Real Application Testing options

SQL> select distinct owner from dba_segments where

tablespace_name='USERS';

OWNER
------------------------------

EX_DEV1
SCOTT
AUDITOR


SQL> select file_name,bytes/1024/1024 from dba_data_files where

tablespace_name=

'USERS';

FILE_NAME
-------------------------------------------------------------------

-------------
BYTES/1024/1024
---------------
+DATA01/im/datafile/users.259.760022883
29880


SQL> alter tablespace users add datafile '+DATA01' size 2000M;

Tablespace altered.

SQL> select file_name,bytes/1024/1024 from dba_data_files where

tablespace_name

='USERS';

FILE_NAME
-------------------------------------------------------------------

-------------
BYTES/1024/1024
---------------
+DATA01/im/datafile/users.259.760022883
29880

+DATA01/im/datafile/users.282.772271427
2000


SQL> select file_name,bytes/1024/1024 from dba_data_files where

tablespace_name

='SYSTEM';

FILE_NAME
-------------------------------------------------------------------

-------------
BYTES/1024/1024
---------------
+DATA01/im/datafile/system.256.760022881
940


SQL> alter tablespace system add datafile '+DATA01' size 2000M;

Tablespace altered.

SQL> select file_name,bytes/1024/1024 from dba_data_files where

tablespace_name=

'SYSTEM';

FILE_NAME
-------------------------------------------------------------------

-------------
BYTES/1024/1024
---------------
+DATA01/im/datafile/system.256.760022881
940

+DATA01/im/datafile/system.283.772271543
2000


SQL> exit