Ask the Expert

ORA-1157 error with Oracle 8i database restore

I have backed up an Oracle 8i database (Windows-based) with Brightstor software. I restored it and I get an ORA-001157 error. I have noticed that the process is looking for *.ora datafile and I have *.dbf datafile. Do you have any suggestion about it?

    Requires Free Membership to View

The ORA-1157 error is saying that a file is missing. Look in your Alert Log and you will see which file Oracle cannot find. You'll have to restore that file as well.

This was first published in April 2007

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: