Oracle Modify table Space size

When importing data to the Orale database ORA-01658: Unable to create a INITIAL area error for the segment in table Space XXX.

Oracle I initialize the size of 200M when creating a table space, when the amount of data in the database reaches this value, and then import the data into the database will be an error.

The workaround is to extend the table space.

You can choose to expand the capacity of the table, such as expansion to 2G, or when the table space is not enough to automatically increase the amount of capacity each time, such as 200M per increment.

View space allocations for each table

?

1	Select tablespace_name,bytes/1024/1024 from Dba_data_files order by bytes;

View the table space idle

?

1	Select Tablespace_name, sum (bytes)/1024/1024 from Dba_free_space Group by Tablespace_name;

Change the size of the table space (2G)

?

1	ALTER DATABASE datafile ' D:ORACLEPRODUCT10.2.0ORADATAORCLXXX.DBF ' resize 2048m;

Automatically grow when table space is low

1, see whether the table space to open automatic growth

?

1	SELECT file_name,tablespace_name,autoextensible from Dba_data_files;

2, set the table space automatic growth

?

1 2 3 4

ALTER DATABASE datafile ' XXXXXX.DBF ' autoextend on;//open automatic growth ALTER database datafile ' xxxxxx.dbf ' on NEXT 200M; Automatically grow 200m//automatically every time 200m, the maximum table space is not more than 1G ALTER DATABASE datafile ' xxxxxx.dbf ' autoextend on NEXT 200M MAXSIZE 1024M;