This content has been marked as final. Show 5 replies
You've tried to count the number of rows in an external table having an invalid file location (file ixc.txt in directory IN_WIP).
Either filter that one out from the query itself or fix the location.
i didnt understand the location part.
i have a db and schema in dat.
now i am executing only this in SQL plus connecting to that db.
i have not mentioned the location. please let me know if i have to mention the location how will i do that.
The PL/SQL block you're trying to execute is meant to count the number of rows in each table of your schema.1 person found this helpful
Among those tables, there's one which actually is an EXTERNAL table.
An external table possesses a LOCATION attribute that tells Oracle where to find the file(s) the table is based on. In your case, Oracle expects a file named 'IXC.TXT' in directory 'IN_WIP', but apparently this file doesn't exist, hence the error you've got at runtime when Oracle tries to access the data.
can u help me change the query where location is not required.?
Eliminating external objects can be done by excluding row matches in user_external_tables e.g.
select object_name from user_objects where object_type = 'TABLE' and object_name not in (select table_name from user_external_tables);