Oracle Error ORA-01240: too many data files to add in one command

Oracle Error Message

ORA-01240: too many data files to add in one command

Reason for the Error

The command specifies adding more data files than can be done in one command. It is necessary to fit all the file names into one log entry, but that would make the entry too large.

Solution

If this is a CREATE TABLESPACE command, create with fewer files then add the other files later. If this is an ADD DATAFILE command, break it up into multiple commands.