The number of tablespaces configured in Oracle increases and the number of tablespaces in oracle increases.

The number of tablespaces configured in Oracle increases and the number of tablespaces in oracle increases.
Oracle alter tablespace size

After using Oracle10g to create a database, some data is imported into the database. An error occurs when you continue to import data tables to the database the next day:

I checked a lot of information and found that it was originally an Oracle tablespace restriction, which led to the failure to continue importing data. If no settings are set during database creation,

The default tablespace size in Oracle is 400 mb. When the data volume in the database reaches this value, an error is returned when data is imported into the database. Solution:

Extended tablespace. You can expand the table capacity, for example, to 5 GB, or automatically increase the table capacity every time when the tablespace is insufficient, for example, auto-increment by 200 MB.

Detailed procedures are listed below:

1. log on to the database using the SQL plus command.

Enter sqlplus "Login User Name/password as login type" in the command line to log on. The built-in user name is commonly sys, And the password is set during oracle installation, remember that if you use a sys account to log on, the logon type must be sysdba.

2. view the distribution of each tablespace.

Select tablespace_name, sum (bytes)/1024/1024 from dba_data_files

Group by tablespace_name;

3. view the idle status of each tablespace.

Select tablespace_name, sum (bytes)/1024/1024 from dba_free_space group by tablespace_name;

4. Change the data table size (10 Gb)

Alter database datafile '/ora/oradata/radius/undo. dbf' resize 10240 m;

5. Set automatic growth when the tablespace is insufficient

5.1 check whether the tablespace increases automatically

SELECT FILE_NAME, TABLESPACE_NAME, autoextensible from dba_data_files;

5.2 set Automatic growth of tablespaces

Alter database datafile 'C: \ SmartDB01.ora 'autoextend on; // Enable Automatic Growth

Alter database datafile 'C: \ SmartDB01.ora 'autoextend on next 200 M; // automatically increase by 200 m each time

Alter database datafile 'C: \ SmartDB01.ora 'autoextend on next 200 m maxsize 1024 M; // each time it is automatically increased by 200 m, the maximum data table size cannot exceed 1G

[Turn]: http://www.cnblogs.com/RoyYu/archive/2012/12/09/2810492.html