Xref: alice comp.databases.oracle.server:65100
Path: alice!news-feed.fnsi.net!hammer.uoregon.edu!newshub.northeast.verio.net!howland.erols.net!newshub2.home.com!news.home.com!news.rdc1.pa.home.com.POSTED!not-for-mail
Reply-To: "Bob Fazio" <bob_fazio@hotmail.com.no.spam>
From: "Bob Fazio" <bob_fazio@hotmail.com.no.spam>
Newsgroups: comp.databases.oracle.server
References: <19990909060115.99295.qmail@hotmail.com>
Subject: Re: Datafiles problem
Lines: 125
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-Mimeole: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <p2NB3.3858$E46.10811@news.rdc1.pa.home.com>
Date: Thu, 09 Sep 1999 11:42:13 GMT
X-Complaints-To: abuse@home.net
X-Trace: news.rdc1.pa.home.com 936877333 24.8.218.197 (Thu, 09 Sep 1999 04:42:13 PDT)
NNTP-Posting-Date: Thu, 09 Sep 1999 04:42:13 PDT
Organization: @Home Network

If the datafile is not in dba_data_files, then yes go right ahead and delete
it.  Oracle really isn't using it.

You can also use the reuse option when you add and that should work also.


Prakash V <venkatprakash@hotmail.com> wrote in message
news:19990909060115.99295.qmail@hotmail.com...
> Bob:
>
> But as I said, my latest added datafile is showing thro either v$daafile
> view or in dba_data_files. But in HDD it is there. If I just delete that
(rm
> <file name> is that okay? Becase I am unable to make that dayafile offline
> and drop. Its giving the error of log/datafile not found.
>
> As you know when I created this datafile, because of no space problem the
> process got terminated. But it created a part datafile in HDD for about
500
> mb, as against 2000mb.
>
> Shall I delete that file from hdd and go ahead?
>
> V Prakash
>
>
> !not-for-mail
> >References: <7r6t7k$arh$1@nnrp1.deja.com>
> >Lines: 51
> >X-Priority: 3
> >X-MSMail-Priority: Normal
> >X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
> >X-Mimeole: Produced By Microsoft MimeOLE V5.00.2314.1300
> >Message-ID: <PMGB3.3839$E46.10231@news.rdc1.pa.home.com>
> >NNTP-Posting-Host: 24.8.218.197
> >X-Complaints-To: abuse@home.net
> >X-Trace: news.rdc1.pa.home.com 936851631 24.8.218.197 (Wed, 08 Sep 1999
> >21:33:51 PDT)
> >NNTP-Posting-Date: Wed, 08 Sep 1999 21:33:51 PDT
> >Organization: @Home Network
> >Errors-To: errors@list.deja.com
> >
> >  Message from the Deja.com forum:
> >  comp.databases.oracle.server
> >  Your subscription is set to individual email delivery
> > >
> >The answer to the first two questions is the same.
> >
> >alter database datafile 'filename' resize integer (K,M);
> >
> >To get the names of the datafiles and where they are located.
> >
> >select file_name,tablespace_name,bytes from dba_data_files;
> >
> >Hope this helps.
> >--
> >Bob Fazio
> >Remove no.spam from my email to reply
> >
> >Prakash <venkatprakash@hotmail.com> wrote in message
> >news:7r6t7k$arh$1@nnrp1.deja.com...
> > > Hi:
> > >
> > > I had tried to add a datafile of size 2000m. But, unfortunately, we
> > > didn't have that much space on the device. So the alter tablespace add
> > > datafile command fails and returned with 'No space left on device'
error
> > > message.
> > >
> > > Well. Now I know the device space and want to make a datafile of 1500m
> > > size. But when I try to do the same command with the same datafile
name,
> > > it says this file name already exists.
> > >
> >
> >Just resize as I stated above, there is no need to drop the datafile.
> >
> > > But I don't want that datafile anymore. How do I drop that datafile
and
> > > create the new one with the same name?
> > >
> >
> > > Another question: That particular tablespace (USERS) already contain
one
> > > datafile , users01.dbf. How do I increase the size of that datafile,
for
> > > eg, from 500m to 1000m?
> > >
> > > And, finally where exactly these datafiles are stored in HDD?
> > >
> >
> >Use the select statement on dba_data_files;
> >
> > > I am using Oracle 8.0.5 on Solaris box.
> > >
> > > THanks
> > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Share what you know. Learn what you don't.
> >
> >
> >
> >
> >
> >  _____________________________________________________________
> >  Deja.com: Share what you know. Learn what you don't.
> >  http://www.deja.com/
> >  * To modify or remove your subscription, go to
> >  http://www.deja.com/edit_sub.xp?group=comp.databases.oracle.server
> >  * Read this thread at
> >
>
>http://www.deja.com/thread/%3CPMGB3.3839%24E46.10231%40news.rdc1.pa.home.co
m%3E
> >
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
>
>  Sent via Deja.com http://www.deja.com/
>  Share what you know. Learn what you don't.