ORA-1658是Oracle数据库中的一个常见错误,下面是对该错误的详细解答: 1. ORA-1658错误的含义 ORA-1658错误的具体信息为“unable to extend table ... by ... in tablespace ...”,意味着在尝试扩展表或索引时,由于表空间中的可用空间不足,导致无法完成扩展操作。 2. 可能导致ORA-1658错误的原因 表空间不...
2,扩充表空间的原有数据文件的大小 ALTER DATABASE DATAFILE 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS03.DBF' RESIZE 1024M; 3,修改表空间的数据文件或表空间成为使其自动增加 ALTER DATABASE DATAFILE 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS03.DBF' AUTOEXTEND ON NEXT 200M MAXSIZE UNLIMITED;...
关于ORA-1658错误和用户表空间配额 如图四川网省在导入总部导出的DMP文件中报1658错误,但是经过查询,表空间的使用率才10%,最后查明的用户空间配额给的太小造成的问题。 用户表空间配额与用户表空间是完全不一样的概念:如果对用户进行了表空间配额限制,哪怕用户就算拥有再大的表空间也只能使用被限制的那部分大小的表...
Oracle Database Cloud Schema Service - Version N/A and later: ORA-1654, ORA-1653, ORA-1658, ORA-1683 When Tablespace has plenty of free space
ora-1658: unable to creat initial extent for segment in tablespace 尝试使用imp命令导入转储时,出现错误" ora-1658:无法在表空间MYTBS中为段创建初始范围"。我在独立的Windows计算机中使用oracle XE 11.2。 数据库备份约为200MB。 以下是我的表空间设置。
But I keep getting "ORA-01658 unable to create initial extent in MY_IDX_TS", even though there is ample room. I thought it was because I had originally tried it with "PARALLEL 2" and there was some overhead needed, so I coalesced the TS (DICTIONARY, obviously) and tried it without ...
RE: ORA-1658 even though there is enough contig free Could it be because of the minimum extent size? Though I would think it unlikely that your minimum extent size would be greater than 147MB. > ---Original Message--- > From: Jesse, Rich [mailto:[EMAIL PROTECTED]] > > ...
> Subject: Re: ORA-1658 even though there is enough contig free > > > Rich, > 1)Run following script to check fat size which will indicate > how big your > initial extent may be as you are not finding contigous space in your ...