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

Home -> Community -> Usenet -> c.d.o.misc -> Re: ALTER TABLESPACE

Re: ALTER TABLESPACE

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1996/12/20
Message-ID: <32BB8A0A.4AB9@qrcsun.qrc.org>#1/1

Gus Spier wrote:
> My confidence level is low. Can someone please list the actions the
> well-read DBA would take to increase TEMP TABLESPACE? Or better yet,
> would the group cite the manual/chapter in the shelves of Oracle
> documentation that will give me the background and walk me through this
> process?

  1. connect internal; (startup it if it is not up now. ensure datafile_location is non-existence unless you use REUSE option).
  2. alter tablespace add datafile 'datafile_location' size nnM;
---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841
Received on Fri Dec 20 1996 - 00:00:00 CST

Original text of this message

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