Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question about resizing a tablespace
If you want to resize your tablespace it doesn't influence the
performance. When you want to defracmentice your database you
must export and import your data.
This is don by the command imp/exp it asks you some questions
about the import on roles and stuff just answer default.
To resize your tablespace you can you'se the command:
alter tablespace(tablespace_name) resize ..M
![]() |
![]() |