Help "Error Ora-01157"

[cyched]

Hello everyone,

could anyone help me?

I am here in the service trying to turn a subquery in Oracle that returns approximately 80,000 lines ... but when I do an insert in this subquery the following error message appears: "ORA-01157 '

What could be? Someone, have an idea?

[dr_gori]

I did not understand this:

I do an insert in this subquery

Are you doing insert in a table? that's it?
Gives Error in Select or Insert?

According to error, it appears that Datafile is not available at the operating system level. What the manual suggests is to give an Alter System Check Datafiles. See below:

Select all

ORA-01157:	cannot identify/lock data file string - see DBWR trace file 
 
Cause:	The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit access to this file but other files will be unaffected. However, the first instance to open the database will need to access all online data files. The accompanying error from the operating system describes why the file could not be identified. 
 
Action:	At the operating system level, make the file available to the database. Then either open the database or do an ALTER SYSTEM CHECK DATAFILES. 

[cyched]

I'm doing insert in a table, the error gives in the insert, if I do a select in the table does not give an error, I'm using the database link, I'm doing im insert in a subquery

[cyched]

Beauty ... now you can not test but as soon as I can, I'll test and if I do not resolve you ...

Even Valii Bruno! : Wink: