Re: How do I create Datafiles?

From: <vermaat_at_gemini.tfdl.agro.nl>
Date: 1996/04/16
Message-ID: <1996Apr16.114322.449_at_ns2>#1/1

In article <1996Apr12.201319.1861_at_rumba.m.isar.de>, elwood_at_rumba.m.isar.de (Konstantinos Agouros) writes:
>Hi,
>
>my question might be stupid, but how do I create new Datafiles.
>I need that in order to create a new tablespace. Hints welcome.

It is indeed a stupid question, for it is clearly in the books.

But since you apparently don't have a book, here's the command:

ALTER TABLESPACE [name] ADD DATAFILE '[filespec]' SIZE [size in K or M] ;

---

| Peter J.R. Vermaat | Dutch Department of Agriculture | Wageningen |

---

| p.j.r.vermaat_at_tfdl.agro.nl | http://gemini.tfdl.agro.nl:1024/~vermaat/ |

---

|                           Flagellant in Dreamland                            |
********************************************************************************

Received on Tue Apr 16 1996 - 00:00:00 CEST