The following example shows how to Resize OR
Extend a datafile to the NBLT24DATA tablespace in the +DATA ASM group.
1. Identify the datafiles for the tablespace you
want to increase.
SQL>
select file_name,bytes/1024/1024/1024 GB from dba_data_files where
tablespace_name = 'NBLT24DATA' order by file_name;
2. Resizing OR extending the datafile on ASM.
SQL> alter database datafile '+DATA/dcpdb/datafile/nblt24data.278.914343685' resize 32g;
Tablespace altered.
No comments:
Post a Comment