Re: How do I create Datafiles?
Date: 1996/04/15
Message-ID: <NEWTNews.829628014.25477.elric_dm_at_dialup.netvision.net.il>#1/1
In Article<1996Apr12.201319.1861_at_rumba.m.isar.de>, <elwood_at_rumba.m.isar.de> write:
> Newsgroups: comp.databases.oracle
> Path: news.NetVision.net.il!psinntp!psinntp!psinntp!howland.reston.ans.net!blackbush.xlink.net!isar.de!rumba.m.isar.de!elwood
> From: elwood_at_rumba.m.isar.de (Konstantinos Agouros)
> Subject: How do I create Datafiles?
> X-Newsreader: NN version 6.5.0 #3
> Organization: Private Site
> Message-ID: <1996Apr12.201319.1861_at_rumba.m.isar.de>
> Date: Fri, 12 Apr 1996 20:13:19 GMT
> Lines: 11
>
> 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.
>
> Konstantin
> --
> Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet:
elwood_at_rumba.m.isar.de
> Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
> ----------------------------------------------------------------------------
> "Treason, like beauty, lies in the eye of the beholder." Garak
use the sql command:
"alter database add datafile '<full path>' size <needed size>"
the file is created for you.
there is also a way to use a file defined befor in the OS by added
the key-work "reuse".
good luck
Yoram Received on Mon Apr 15 1996 - 00:00:00 CEST