Hi Vineet,
It is a bug in the sources. There is an issue reported about this
(
https://jira.duraspace.org/browse/DS-2555) Some of the sql
queries on
dspace-api/src/main/java/org/dspace/content/Collection.java has a
"public." qualifier before table names (ie "FROM
public.eperson....") In Oracle the tables are not under the
"public" schema (as probably in other DBMS are), that's why it
fails.
Until the issue is resolved, you should correct the java class and
rebuild. The issue report has the details (it is easy)
HTH
Carlos