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



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

Answer / guest

Cause: 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.

Action: 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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07223: slspool: fork error, unable to spawn spool process.

1 Answers  


NID-00397: Changing database name from string to string

1 Answers  


LPX-00266: invalid language specification ~s

1 Answers  


NNC-00400: memory exhausted

1 Answers  


ORA-01303: subordinate process error: number. Check alert and trace logs

1 Answers  






ORA-31039: XML namespace length string exceeds maximum string

1 Answers  


TNS-04007: Internal error number.

1 Answers  


ORA-22307: operation must be on a user-defined type

1 Answers  


ORA-06408: NETCMN: incorrect message format

1 Answers  


NNL-00014: unknown data type "string"

1 Answers  


ORA-15091: operation incompatible with open handle in this session

1 Answers  


ORA-29871: invalid alter option for a domain index

1 Answers  


Categories