DB version: 11gRel 1 and 10G Rel2
I took the export(original) dump file of a schema from a 10gR2 instance. My attempts to IMPORT from this dump file kept failing because it was importing only to two Tablespaces(TLBDATA and TLBINDX which are relatively smaller tablespaces) and therefore these two tablespaces will run out of space.
i have a tablespace called JLDATA which has sufficient space for this import. So i used the following commands to limit the space consumption from TLBDATA and TLBINDX tablespace and allowing Unlimited space consumption from JLDATA.
CREATE USER WD_TESTSMA IDENTIFIED BY mypassword
DEFAULT TABLESPACE JLDATA
TEMPORARY TABLESPACE TEMP;
alter user WD_TESTSMA
quota unlimited on JLDATA
quota 1024m on TLBINDX
quota 3072m on TLBDATA
quota 0 on SYSAUX
quota 0 on SYSTEM;
But in both 11gRel1 and 10gR2 databases the above commands fail to limit the space consumed by WD_TESTSMA from TLBINDX and TLBDATA. During IMPORT, this user is consuming 8GB from TLBDATA(the limit i had set was 3 GB) and 6GB (the limit i had set was 1GB). Shockingly this user hasn't consumed a single byte from JLDATA.
Is this some kind of bug?