Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Tablespace Fragmentation
I have a tablespace that I would like to defragment. I have read that I should :
1- Export the tablespace's content 2- Drop the tablespace including contents 3- Recreate it 4- Import the tablespace's content
What would happen if I drop the tablespace's objects one by one ? Would it be the same as step 2 and step 3 (it appeared that I got an ORA 1547)
Best Regards ,
Philippe (arpege_at_imaginet.fr) Received on Mon Oct 20 1997 - 00:00:00 CDT
![]() |
![]() |