How do I solve this problem?
ORA-12953: The request exceeds the maximum allowed database size of 11 GB
Dropping usernames as described in the earlier answer will work for a while.
After a certain number of bootstraps, it may become necessary to uninstall and reinstall OracleXE on your PC though.
The reason why is that the Oracle database stores metadata about other schemas. Based on this metadata, Oracle reserves space for tables, even after they are dropped. This stored space continues to grow in size as you bootstrap projects.
On my PC, this can be observed in the .DBF files found at:
You can also view this metadata by running this query and noting the values in the "owner" column:
"SELECT * FROM dba_segments WHERE tablespace_name = 'SYSTEM_DATA'"
Even though the Oracle users and their schemas are removed, information about the schemas remain.
Neither the system user nor the user listed as owner have permission to delete from the dba_segments table. So it doesn't seem that we can remove the metadata.
Deleting the .DBF files from the file system causes Oracle to crash.
As a result, uninstalling and reinstalling OracleXE may become necessary at some point.
Also see XE admin tips at https://portal.onenetwork.com/display/DBA/How+to+Administer+Local+Oracle+XE+Databases
I am able to resolved below issues by doing drop tablespace.
Issue – ORA-12953: The request exceeds the maximum allowed database size of 11 GB
Step – 1 : Go to your C:\views\ e.g. : C:\views\RTVN-24.0
Go to ant_dos.bat and do clean-dataset and delete-data
Step – 2 : Login database using sysdba and perform below queries
sqlplus sys as sysdba
select username from dba_users;
drop <unwanted users> cascade;
Step – 3 : If you still face same issue then login using sysdba and drop unwanted tablespaces from database
Right click on tablespace and drop tablespace
After this step you should be good, if still facing issue then its your bad luck L
Last option is to uninstall existing oracle set up and install latest oracle and do clean build and reload dataset.