Dump und reload database

[make]

Hi,
how can can i dump and reload my database in as quick and safer way.
I think it is nessecary to dump the database because the fragmentation is over 6 %.
I have tried to do it with a copy of the database. But i killed a table, so i think i made a mistake.
I opened the Data Administration an dumped the *df an the *d file of a table, then i deleted the table with the data dictionary an commited the changes.
Then i try to load back the *df. file , that works, but when i try to load the *d file an error message comes an the table comes emty.

Can anyone tell me how to daump an reload a table and a whole Database in a right way.

Greets
Make

 

[toby.Harman]

Sounds like you did the right things.

What was the error message that came back when you loaded the .d file?

When you say "fragmentation is over 6%" what do you mean? How are you measuring this fragmentation? If this is a disk defragmenter doing the measuring then you must stop the database to defragment the disk.