Hi Sureshy,

I'll do it again.

I have dropped all objects from GLD and GLX tablespace and rightnow it shows foll info in dba_free_space.

select file_id,bytes from dba_free_space where tablespace_name = 'GLD'

file_id bytes
---------------------------
39 524279808
106 524279808
128 104849408

select file_id,bytes from dba_free_space where tablespace_name = 'GLX'

file_id bytes
---------------------------
40 305127424
107 366993408
124 419422208

SELECT * FROM DBA_SEGMENTS WHERE tablespace_name='GLD'

No rows returned

SELECT * FROM DBA_SEGMENTS WHERE tablespace_name='GLX'

No rows returned


Now, I am giving command

imp gl/@test parfile=impgl.dat

I'll post the result after sometime.

Thanks.