"Yes, when you're inserting data in a table you need to have enough storage space (in data files) on disk to save 40GB.
SGA and tablespace are two separate things. I'm not sure why Venkatesh mentioned the the SGA parameters…"
I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.