Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Question about resizing a tablespace

Re: Question about resizing a tablespace

From: simple <simpleNOsiSPAM_at_wanadoo.nl.invalid>
Date: 2000/05/03
Message-ID: <1fcc2be8.d25b0566@usw-ex0104-033.remarq.com>#1/1

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

Received on Wed May 03 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US