I have some doubt on spool space allocation for a particular user on the below scenario:
Suppose user SYSDBA has 500 GB of perm space. It creates user MRKT with 300 GB of perm space and 300 GB of spool. Then user MRKT creates user ADVT with 100 GB of perm space and 100 GB of spool space. So finally user MRKT will be left with 200 GB of perm space and 300 GB of spool.
Now user MRKT creates some tables of 100 GB size in its user space.
Then how much spool space will MRKT user have after creating the tables?
Will it be 300 GB or 200 GB spool space after creating the tables?
The spool of a user does not depend on the user's perm space (otherwise most end users would have severe problems as they got PERM = 0).
So MRKT still can utilize up to 300GB spool (unless the system runs out of space).