Hi Gurus,

When we do a export and import of tables with indexes I think that only
the index definition is exported and not the index segment is exported.



What I mean is that if I have a table of 100 MB with 50 MB of index size
on that table. SO if I do a export with indexes then also only the 100
MB segment size of table will be exported and not the another 50 MB of
indexes segment. Only the index definition is exported and a new index
is created on the import site.



Please clarify me if I am right or wrong.





With Regards,



Amar P Singh

desk: +91 124 4167037

mobile: +91 (0) 9810788298
e-mail: [Email address protected]




Oracle LazyDBA home page