If a user X is created with Spool Space say 50 GB and later on this user is explicitly assigned with 10 GB of spool space individually den what
will happen ?????
Not sure of the question. If the user is assigned a profile with non-NULL spool space limit, then the profile limit applies. If the user has no profile or if spool space in the profile is NULL, then the user's individual limit applies.