JasonCooper
IS-IT--Management
Hi
I need to 'defrag' some tables and wonder if the following method is the best way:
1. export table(s)
2. drop table 'tablename' cascade constraints
3. Import table(s)
It's mainly the drop command I'm unsure about.
Thanks
I need to 'defrag' some tables and wonder if the following method is the best way:
1. export table(s)
2. drop table 'tablename' cascade constraints
3. Import table(s)
It's mainly the drop command I'm unsure about.
Thanks