I wonder it myself, since I have tried
ALTER DATABASE CREATE DATAFILE 'MYFILE' AS 'BROKENFILE';

And it end up with sql error stating wrong clause. I use windows2000 with
Oracle 9i. Anyone has any idea on where I went wrong?

Regards,

Wendry.


----- Original Message -----
From: "Edwin Uy " <oracledba-ezmlmshield-x38032025.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, July 15, 2004 7:34 AM
Subject: RECOVERING/RESTORING/RECREATING DATAFILE


> Hi all,
>
> If I lost a datafile, for example, deleted/removed by mistake and I do
> not have a backup of it. Can I restore the datafile if I do not have all
> the archived logs from when the datafile was first created? Or am
> totally messed up and need to get a litre of coffee with a 1000
> words-per-minute keystroke and 100% accuracy to input all those records
> ... :-)
>
> Cheers,
>
>
> EDWIN ONG UY
> \\|//
> (o o)
> ^"^"^"^"^"^oOOo"^(_)^"oOOo^"^"^"^"^"^"^"^"^"^"^
>
> "Choose a job you love, and you will never have to work a day in your
> life." --Confucius
> "How do I work? I grope." -- Albert Einstein
> "Experience is the best teacher, enrolling in the class is the biggest
> problem." -- Anonymous
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>



Oracle LazyDBA home page