Вот это отрывок из доки ....

Using the CREATE UNDO TABLESPACE Statement
The CREATE UNDO TABLESPACE statement is the same as the CREATE TABLESPACE statement, but the UNDO keyword is specified. Oracle determines most of the attributes of the undo tablespace, you can specify only the DATAFILE clause.

This example creates the undotbs_02 undo tablespace:

CREATE UNDO TABLESPACE undotbs_02
DATAFILE '/u01/oracle/rbdb1/undo0201.dbf' SIZE 2M REUSE AUTOEXTEND ON;

Altering an Undo Tablespace
Undo tablespaces are altered using the ALTER TABLESPACE statement. However, since most aspects of undo tablespaces are system managed, you need only be concerned with the following actions:

Adding a datafile
Renaming a datafile
Bringing a datafile online or taking it offline
Beginning or ending an open backup on a datafile
These are also the only attributes you are permitted to alter.

If an undo tablespace runs out of space, or you want to prevent it from doing so, you can add more files to it or resize existing datafiles.

The following example adds another datafile to undo tablespace undotbs_01:

ALTER TABLESPACE undotbs_01
ADD DATAFILE '/u01/oracle/rbdb1/undo0102.dbf' AUTOEXTEND ON NEXT 1M
MAXSIZE UNLIMITED;
.....

Делаю

CREATE UNDO TABLESPACE undotbs
DATAFILE '/home/oracle/OraHome1/oradata/undo.dbf' SIZE 2M REUSE AUTOEXTEND ON;

все окей

делаю

ALTER TABLESPACE undotbs
ADD DATAFILE '/home/oracle/OraHome1/oradata/undo.dbf' AUTOEXTEND ON NEXT 1M
MAXSIZE UNLIMITED;
пишет
ERROR at line 1:
ORA-01537: cannot add data file '/home/oracle/OraHome1/oradata/undo.dbf' - file
already part of database
???
В чем проблема госпада

Вот это отрывок из доки ....

Using the CREATE UNDO TABLESPACE Statement
The CREATE UNDO TABLESPACE statement is the same as the CREATE TABLESPACE statement, but the UNDO keyword is specified. Oracle determines most of the attributes of the undo tablespace, you can specify only the DATAFILE clause.

This example creates the undotbs_02 undo tablespace:

CREATE UNDO TABLESPACE undotbs_02
DATAFILE '/u01/oracle/rbdb1/undo0201.dbf' SIZE 2M REUSE AUTOEXTEND ON;

Altering an Undo Tablespace
Undo tablespaces are altered using the ALTER TABLESPACE statement. However, since most aspects of undo tablespaces are system managed, you need only be concerned with the following actions:

Adding a datafile
Renaming a datafile
Bringing a datafile online or taking it offline
Beginning or ending an open backup on a datafile
These are also the only attributes you are permitted to alter.

If an undo tablespace runs out of space, or you want to prevent it from doing so, you can add more files to it or resize existing datafiles.

The following example adds another datafile to undo tablespace undotbs_01:

ALTER TABLESPACE undotbs_01
ADD DATAFILE '/u01/oracle/rbdb1/undo0102.dbf' AUTOEXTEND ON NEXT 1M
MAXSIZE UNLIMITED;
.....

Делаю

CREATE UNDO TABLESPACE undotbs
DATAFILE '/home/oracle/OraHome1/oradata/undo.dbf' SIZE 2M REUSE AUTOEXTEND ON;

все окей

делаю

ALTER TABLESPACE undotbs
ADD DATAFILE '/home/oracle/OraHome1/oradata/undo.dbf' AUTOEXTEND ON NEXT 1M
MAXSIZE UNLIMITED;
пишет
ERROR at line 1:
ORA-01537: cannot add data file '/home/oracle/OraHome1/oradata/undo.dbf' - file
already part of database
???
В чем проблема госпада

ВОПРОС СНЯТ

я рефрешь делал просто автоматом получаеться
больше не буду