在手动创建表空间时候，报错
关于该报错
解决方法
该错误和参数db_files有关
db_files默认大小200，由于我们一次性添加了600个数据文件，超过了db_files的上限。因此我们这里需要调整db_files
alter system set db_files=1400 scope=spfile sid='*';
该参数需要重启数据库生效.
ORA-01240: too many data files to add in one command
关于该报错
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.
这是在执行手动创建表空间时候，一次性加入了600个数据文件。解决方法
该错误和参数db_files有关
db_files默认大小200，由于我们一次性添加了600个数据文件，超过了db_files的上限。因此我们这里需要调整db_files
alter system set db_files=1400 scope=spfile sid='*';
该参数需要重启数据库生效.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28697282/viewspace-1572410/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- CRS-1006 NO more members consider CRS-0215 could not start ora.rac1.vip
- 0506-342 The superblock on /dev/XXX is dirty,Run a full fsck to fix
- aix 无法mount 本地lv
- CRS-0215: Could not start resource 'ora.rac.rac2.inst'.
- Mount 参数配置 For Oracle file when use NFS on NAS devices
- oracle wait events(等待事件) 一览表
- 【BUG】crfclust.dbd变得非常大
- 【BUG】m000.trc ksugetosstat failed: op = ^P^A?`^G, location = SLSSTATMAXCP ()
- how to stop or start arch processes
- dbca建库，报错ORA-01092: ORACLE instance terminated
