hi, i need defragment all extents of the one table, but i need to make, with all users loged. are there process for it ? can i make it ?
ps * In oracle 8i i use Move tables but in Oracle 7.3.4 :-((
Thanks !!1
Oracle 7.3.4
Printable View
hi, i need defragment all extents of the one table, but i need to make, with all users loged. are there process for it ? can i make it ?
ps * In oracle 8i i use Move tables but in Oracle 7.3.4 :-((
Thanks !!1
Oracle 7.3.4
import/export
or
create table .. as select * from....
+ rename table ...
There's no way to do it really on-line in 734 :-(
Or you have to buy an extra product. I think Quest software has one.
Gert
No way to do it that on-line to 8i