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
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