Hi

I mean DML operations from DBA´s view, like how it allocates extents. For example

(Using index cluster)

DEPT EMP in a cluster called dept_emp, according to Cluster definition the rows of emp and dept are kept in same blocks as long as the cluster key is same (deptno in this case), I am wondering, if I insert 1000 deptno values in dept.deptno and leave dept.dname and dept.loc empty and all emp columns empty Oracle will allocate extents for these "deptnos", if later, I then insert 1000 rows in emp.empno and emp.deptno (deptno same value as those inserted in dept table) leaving the other columns empty will all these new values be allocated in new blocks or same blocks as those I inserted previously in dept.deptno?