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-23344: constraint (string.string) does not exist

1 Answers  


ORA-00394: online log reused while attempting to archive it

1 Answers  


DRG-10838: invalid SPAN argument supplied to NEAR

1 Answers  


ORA-09749: pws_look_up: port lookup failure

1 Answers  


PCB-00214: JUSTIFIED clause not allowed for host variable "string"

1 Answers  






ORA-16014: log string sequence# string not archived, no available destinations

1 Answers  


RMAN-06131: skip offline/readonly only allowed with current controlfile

1 Answers  


ORA-23387: replication parallel push dequeue error

1 Answers  


RMAN-05010: target database must be opened in READ WRITE mode for TSPITR

1 Answers  


ORA-32405: cannot alter tablespace for existing materialized view log

1 Answers  


O2F-00323: Internal error in OTT facility O2F

1 Answers  


ORA-15181: Symbol [string] not found in library string, error [string]

1 Answers  


Categories