Ask you guys a question, I have a table, about forty million, the following query can be executed, but build a table will be submitted to the ora - 01652 error, how be to return a responsibility?

As with the create table table name as + select the correct statement is

CodePudding user response:

There is insufficient space on the users table

CodePudding user response:

 select SUM (BYTES/1024/1024) from dba_free_space where tablespace_name='USERS' 

Check the users table space remaining amount,
Extension data file size or add new data files

CodePudding user response:

100 don't have space, the home house, live at most 10 people, is now at eight, and to live five come in;

CodePudding user response:

There is insufficient space on the table

CodePudding user response:

Thanks for your answer