Re: Datafiles problem

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_at_hotmail.com> wrote in message news:19990909060115.99295.qmail_at_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_at_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_at_news.rdc1.pa.home.com>
> >NNTP-Posting-Host: 24.8.218.197
> >X-Complaints-To: abuse_at_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_at_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_at_hotmail.com> wrote in message
> >news:7r6t7k$arh$1_at_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.
Received on Thu Sep 09 1999 - 06:42:13 CDT