I have one datafile that is highly fragmented. Its size is 10GB now and real size that is used is 2.5GB,so 7.5 is free.
I decided to export data, drop that datafile, recreate it and import data.
What should I mention? Is there any chance to loose some objects?? After dropping datafile?
I have one tablespace, with one datafile. Please provide me with any suggestions about exporting scripts.
There is an option:
TABLESPACES list of tablespaces to export
if I write script like that
exp username/aaa file=a.dmp tablespaces=my_tb_name log=a.log grants=y indexes=y constraints=y triggers=y
is it enough to import everything from that tablespace and anything that is related to the containing objects(I mean grants, constraints, triggers...)
And is it necessary to be on a database server not on a client to run the export ?
Thank you a lot, waiting you clever suggestions