Inserting in a table after crossing the allocated tablespace space What will happen when I try to insert so many number of rows beyond the allocated tablespace size.
Say in Oracle DB, the initial tablespace size is set to 500MB and when it reached the limit and we try to create more records into it, should it fail or it will acquire more space from the hard disk?
Oracle will throw an error and rollback the query.


  ORA-01653: unable to extend table by in tablespace