Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: create controlfile (help needed)
Hi,
Why don't simply drop the tablespace containing those datafiles:
startup mount;
alter database datafile 'file_name1' offline;
alter database datafile 'file_name2' offline;
...
alter database open;
drop tablespace tbs_name;
Dias
"Andy Kwok" <andy.kwok_at_noos.fr> wrote in message news:<3e575787$0$1565$79c14f64_at_nan-newsreader-01.noos.net>...
> Hello
>
> I'm facing a kind of huge problem .
>
> I'm trying to make a copy of my database (on SunOs 2.6 with oracle 7.3.4) )
> but with mssing datafile .
>
> I've the essential datafile (for the tablespace system, the tablespace for
> the rollback and last but not least the temporary tablespace ) and of course
> the redo log files .
>
> But some of my datafile are missing .
>
> Do you know if it is possible to recreate control files ?
>
> I heard (read) through metalink that it 'seems' possible ...
>
> Any tips would be highly welcome ,
>
> Regards
> Andy
Received on Sat Feb 22 2003 - 16:42:18 CST