I have some blob data in my Database, i export this database and import it on the same server.
But after importing this dump in a new tablespace, the size of the original dbs file keeps on increasing.
Can anyone help me regarding this. I dont want the size of the original file to increase.
Appear inplace of going into new tablespace its imported into existing tablespace,
can you crosscheck it in dba_segments view (tablespace column).
Also have you used REMAP_TABLESPACE while doing import if this activity was performed by datapump.
we have not used datapump for import.
what we observed is, new DBS file is getting created and also the size of existing DBS file is getting increased.
this issue is observed with Oracle 10 client.
i am not able to get any useful info from dba_segments table..
is there any other way?