| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Datafiles problem
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.com%3E
>
Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't. Received on Thu Sep 09 1999 - 01:01:14 CDT
 |
 |