exporting db to dump file, ORA-01157 error
Hello oh good men of DBASupport!!!
I am trying to make a dump file out of my database and have been encountering the error
. exporting tablespace definitions
EXP-00008: ORACLE error 1157 encountered
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/opt/oracle/oradata/orcl1/temp01.dbf'
EXP-00000: Export terminated unsuccessfully
The same error occurs when I try to load data using the "imp" command. Please help me out here. This is getting critical for my project.
Thanks in advance.
Click Here to Expand Forum to Full Width