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