Does anybody know how to solve the following problem:
I have a tablespace - 50000MB and 2 empty tables. I have created the cluster key and cluster index on these tables. Right after that I was trying to perform an Insert as Select stmt. on one of those tables to insert 1600MB of data. This Insert stmt, for some reason, takes the whole space of the tablespace and because of that insert was failed.
If you have any idea or experience with the similar type of issue, please respond.
Thank you, I would really appreciate your help.
Click Here to Expand Forum to Full Width