Hi Seema,
define what you mean when you say 6 are fragmented.
John
[EMAIL PROTECTED] wrote:
Hi
If one tablespace has 10 tables and 6 are fragmented table in that
particular tablespace.If I use COPY command to move data from one
server to another then is COPy command bring data with
Seema,
If you COPY the datafiles at the OS level then you are getting an
exact image of the datafile. The same for the RMAN copy command. If you
use SQL insert ,, select type of copying data from one server to
another then the data will fill the extents and eliminate fragmentation.
It will not