How to increase datafile/Tablespace max_size
venkatApr 19 2012 — edited Apr 19 2012Hi,
Below query got current size and max_size of the data_file. Now i want to increase the datafile size.
SQL> select FILE_NAME,TABLESPACE_NAME,BYTES/1024/1024,MAXBYTES/1024/1024 from dba_data_files
2 where TABLESPACE_NAME like 'Tablespace_one%' order by TABLESPACE_NAME;
FILE_NAME TABLESPACE_NAME BYTES/1024/1024 MAXBYTES/1024/1024
-------------------------------------------------------------------------------------------------------------------------------------
/xxx/yyyyy/ABCD/data/file_name.dbf TABELSPACE_ONE 4988 5000
I want to increase the max_size upto 6GB.
Please suggest that how to increase file max_size upto 6GB.
Thanks and Regards,
Venkat.