Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 111 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 161 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 475 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
-1653: ORA-01653: unable to extend table
muttleychess
Member Posts: 1,502 Bronze Badge
Hi
When I was trying Insert in my table (TAB1) , return me error below:
1653: ORA-01653: unable to extend table TAB1 by 50 in tablespace ATTRIBUTE
What is this error ?
My tablespace is:
TABLESPACE ATTRIBUTE
PCTUSED 60
PCTFREE 5
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 400K
NEXT 400K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 4
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE
NOPARALLEL;
Message was edited by:
muttleychess
When I was trying Insert in my table (TAB1) , return me error below:
1653: ORA-01653: unable to extend table TAB1 by 50 in tablespace ATTRIBUTE
What is this error ?
My tablespace is:
TABLESPACE ATTRIBUTE
PCTUSED 60
PCTFREE 5
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 400K
NEXT 400K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 4
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE
NOPARALLEL;
Message was edited by:
muttleychess
Comments
-
TAB1 is a table segment. When you are inserting it is trying to take extents.
Please increase the tablespace size. -
Resize solve your problem
alter database datafile '<full_file_name>' resize <size>M; -
I Edit original message: look the defintion of the tablespace
-
Please post the output of following query.
SELECT tablespace_name, sum(bytes) free FROM DBA_FREE_SPACE
group by tablespace_name;
You are running out of space in the physical files allocated to your tablespace.
May be the Autoextend is off or they have reached maxsize with Autoextend on. -
tks
1 ATTRIBUTE 198623232 -
Your insert is looking for 50 extents.
So by calculation your need is (400K*50) 20480000 bytes > 198623232 bytes available in the file.
you need to add more space to this tablespace. -
Sorry..wrong calculation. ignore my post.
-
Hi
Can to be ?
PCTINCREASE 0
I am using
INSERT /*+ APPEND */ INTO MY TABLE SELECT ...ETC
This insert +/- 5000000 rows, Can to be because there is not commit ?
Is best to use a cursor ? :-(
Message was edited by:
muttleychess -
PCTINCREASE is regarding calculation of next extent size to be allocated. Since it is set to 0, the next extent allocated to the table will always be of 400K.
-
Is best to use a cursor ? :-(I wouldn't use a cursor..
http://asktom.oracle.com/pls/ask/f?p=4950:8:9154101500537953706::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:73891904732164
insert and commit at the end! works fine.
This discussion has been closed.