Oracle database, the system tablespace to 98%, to increase the data files, error ORA - 01276: unable to add file
SQL> The alter in tablespace SYSTEM add datafile '+ data/XXXX/datafile/SYSTEM. 306.10004561647' size of 10240 m;
This increase the data file is correct?
Now error ORA - 01276,
There are two paths through the SQL query system: "+ DATA/XXXX/datafile/system. 256.978836893" and "+ DATA/XXXX/datafile/system. 306.10004561647" it has been used to increase the DATA file? But I why this error?
Turn to the great god how to solve,

CodePudding user response:

Because the SYSTEM table space space with ID 1 and 38 in ORACLE, so try to use this statement to modify success: the alter database datafile 38 resize 15 g; Although I don't know what reason be

CodePudding user response:

Your this table space is managed by OMF, add a data file, don't need to add the specific path and file name, add and specify the size can be directly:
The alter in tablespace system add datafile size XXX;
The second time you use the resize operation to expand the size of the document no. 38, has achieved the purpose of expanding the table space, and add the data file is not one thing, however,
Also: before your query to the table space utilization rate is 98%, but there are two data files, I suggest you look up table space now use space, usually the system table space is not too big, if the space is larger, such as more than 4 g, or growing fast, you'll have to check is what causes,

CodePudding user response:

Supplement, makes use of OMF management database does not need to add data file write data file path, because there is this parameter: db_create_file_dest specifies the target path, and the file name oracle will be automatically generated for you, the file name will identify its belong to which table space,

CodePudding user response:

My system tablespace has already used 45 g now, and I give another DT_VIO_DAT prompt ORA - 32771, when the increase of the tablespace cannot be added in the big file table space, use this table to 97%, trying to add a new data file; The alter tablespce dt_vio_dat add datafile '+ data/XXX/datafile dt_vio_dat02. DBF' size 5 g;
In tablespace altered
But look again at the space, the table space is still 97%, I use this way to give the USER table extends the space, but not in this

CodePudding user response:

Liu Xiaobai reference 4 floor database maintenance of the road of reply:

my system tablespace has already used 45 g now, and I give another DT_VIO_DAT prompt ORA - 32771, when the increase of the tablespace cannot be added in the big file table space, use this table to 97%, trying to add a new data file; The alter tablespce dt_vio_dat add datafile '+ data/XXX/datafile dt_vio_dat02. DBF' size 5 g;
In tablespace altered
But look again at the space, the table space is still 97%, I use this way to give the USER table extends the space, but this is not

45 g system tablespace, eliminate bugs, to illustrate the application of you have some shouldn't put data into the system tablespace, check dba_segments, look at the system put some what's under the table space,
Type bigfile tablespace can only put a data file, this type is specified in the create table space when, can't change, but you can also resize the data files, can be increased,