Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting ORA-01653 while tablespace is set to unlimited.

671265Feb 8 2010 — edited Feb 9 2010
When I import data into table P.TEST, I got error "ORA-01653: unable to extend table P.TEST by 128 in tablespace P".

Here is the information of user P and tablespace P,
SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE='P' AND PRIVILEGE='UNLIMITED TABLESPACE';

GRANTEE	  PRIVILEGE	                       ADMIN_OPTION
------------ -------------------------------- -----------------------
P         	  UNLIMITED TABLESPACE	   NO

CREATE TABLESPACE P DATAFILE 
  '/data/oradata/wapbi/p01.dbf' SIZE 33554416K AUTOEXTEND ON NEXT 1024M MAXSIZE UNLIMITED,
  '/data/oradata/wapbi/p02.dbf' SIZE 33554416K AUTOEXTEND ON NEXT 1024M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
User P has "unlimited tablespace" priviledge and tablespace P is set to "unlimted" too.

Any comments will be appreaciate!


Best wishes,
Satine
This post has been answered by Hemant K Chitale on Feb 9 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 9 2010
Added on Feb 8 2010
15 comments
2,543 views