Lots of questions here.
>>The schema, for which I can access metadata, has 20 tables but I can see metadata of ONLY 13 of them.
Did you rest enable all 20 tables? REST enabling a SCHEMA doesn't auto REST any tables or views in that schema.
>>When I REST enabled this schema, I didn’t set any authorization. Then why is it asking me to authorize? How can I fix this issue?
On your connection to this schema in SQL Developer, right-click and, 'REST Enable.'
On the resulting dialog, is Secure checked/enabled? If so, un-check it, and click OK.
You wouldn't want to do this of course in your production system - you'll always want to secure your Auto-REST enabled resources.
Thanks for your reply, Jeff.
Yes, I have rest-enabled all objects but still schema metadata shows only 13 out of 22.
Did you mean p_auto_rest_auth parameter? It has always been FALSE.
ORDS.ENABLE_SCHEMA(p_enabled => TRUE,
p_schema => 'test',
p_url_mapping_type => 'BASE_PATH',
p_url_mapping_pattern => 'test',
p_auto_rest_auth => FALSE);
What can you tell me about the 7 missing tables? Any interesting data types on their columns? Do they all have primary keys?
Do their AUTO REST endpoints work? Can you do a GET on one of them and pull back data?