Hi,

I have a query wrt INSTANCE_NUMBER on Oracle (8i and 9i).

Suppose I have multiple instances (instance numbers 1, 2 & 3).

Now I use an SQL -

ALTER TABLE user1.table1 modify partition sys_p6448
ALLOCATE EXTENT (SIZE 5K INSTANCE 4);

I am adding extents to this particular instance number say 4.
Where does oracle store this information ?


Regards,
anu_r