Re: Datafiles problem

I should have added one more comment.
There is only one way to drop a datafile...

Drop the tablespace that it belongs to.

Then you can go and delete the datafile manually (on UNIX use the rm command.)

Bob Fazio <bob_fazio_at_hotmail.com.no.spam> wrote in message news:PMGB3.3839$E46.10231_at_news.rdc1.pa.home.com...
> 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.
>
>
Received on Wed Sep 08 1999 - 23:39:30 CDT