By
Published: 06 Dec 2006
I have a customer running Oracle 7.3. I know it's very old but the software runs on this version. Can you please help me with the following errors?
09:00 14th Nov 2006
ORA-01116: error in opening database file 10
ORA-01110: data file 10:
I have restored the file but still get this error. It happens on different files as well.
The ORA-1116 error indicates that for some reason, Oracle cannot open the file. Make sure that the file exists. Also make sure that the user running Oracle (typically 'oracle' on Unix/Linux servers) has write permissions to the file and the directory the file resides in.
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Continue Reading