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

oracle oracle11g oracle10g oracle-xe
Charan picture Charan · Feb 24, 2016 · Viewed 11.1k times · Source

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

Marcell picture Marcell · Apr 26, 2017

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.

Related questions

ORA-28000: the account is locked error getting frequently

I am getting the error : ORA-28000: the account is locked Is this a DB Issue? When I unlock user account using the command ALTER USER username ACCOUNT UNLOCK temporarily it will be OK. Then after some time the same account …

Read More
Oracle PL/SQL string compare issue

I have the following Oracle PL/SQL codes that may be rusty from you guys perspective: DECLARE str1 varchar2(4000); str2 varchar2(4000); BEGIN str1:=''; str2:='sdd'; IF(str1<>str2) THEN dbms_output.put_line('The two strings is …

Read More
When should I use 'for update nowait' in cursors?

In which case do we need to use for update nowait in cursors.

Read More