ORA-20104: create_collection_from_queryb2
Error:ORA-20104: create_collection_from_query
ParseErr:ORA-00942: table or view does not exist
Googled and noticed below solution works.
To re-create the table, it should be sufficient to do the following (in Application Builder):
1) As a workspace admin, go to Administration -> Manage Service -> Set Workspace Preferences
2) Check if “Enable File Repository” in “Team Development” is set to Yes.
Set it to No, if file upload isn’t needed or keep the Yes.
3) Click the Apply Changes button to re-create the apex$team_dev_files table in the workspace schema.
--checked no table before apply the solution
SQL> conn / as sysdba
Connected.
SQL> select * from dba_objects where object_name =upper('apex$team_dev_files');
no rows selected
Spent some and finally find the setting in 5.1.4 as shown below.
--checked again but I don't see the table is created.
SQL> l
1* select * from dba_objects where object_name =upper('apex$team_dev_files')
SQL> /
no rows selected
SQL> exit
Never mind, my problem solved.
