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 -> How to truncate the data file in a temporary tablespace?

How to truncate the data file in a temporary tablespace?

From: Dino Hsu <dino1_nospam_at_ms1.hinet.net>
Date: Wed, 04 Jul 2001 16:33:40 +0800
Message-ID: <v1l5kt41beqmoknksl96eugeltb3f0le8n@4ax.com> 






Dear all,



One of the data file in a temporary tablespace is extrordinarily big
(almost half the database size). I am going to do a physical off-line
backup, I need to truncate this data file to a small size. Can anyone
tell me how? Thanks in advance.



Dino
Received on Wed Jul 04 2001 - 03:33:40 CDT












Original text of this message













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