how do i increase database size from 11GB to above 20Gb

Question

Every time i get below error when ever i try to import new dump into the data base. How do i increase db size? Any ways to resolve this, without deleting data from database?

ORA-12953: The request exceeds the maximum allowed database size of 11 GB

Answer 1

I just ran into the same problem and found a good answer on this page: http://petesdbablog.wordpress.com/2013/04/07/oracle-11g-xe-and-the-11-gigabyte-limit/

It states that all data files (excluding the undo and temp file, which is generated by Oracle) together are allowed a maximum size of 11 GB.

You can check the current data file sizes with SQLPLUS by executing:

select file_name, bytes from dba_data_files;

One possible way to resolve the problem is to manually decrease the size of a data file that is rather big. You can do this with the following command in SQLPLUS (use one of the file names returned by the command above):

alter database datafile '/u01/app/oracle/oradata/XE/YOUR_OWN_FILENAME.dbf' RESIZE 5G;

If this doesn't work: try a larger value for the new file size.