did u check the original myfile name is proper and it is on the proper
location ... if not then u will hav to mention
the source location also,,, else oracle takes as oracle default ...
also do u have space on the location to create brokenfile ?

Deepa Kale -DBA
Jyoti Structures - Nasik(IT)



"Wendry Yang "
<oracledba-ezmlmshield-x97183577.[Email Address Removed] To: "LazyDBA Discussion" <[Email address protected]
azyDBA.com> cc:
Subject: Re: RECOVERING/RESTORING/RECREATING DATAFILE
16-07-2004 08:03 AM






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
>
>




--------
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