13
« on: March 14, 2005, 08:34:59 am »
Hello everyone!
We are performing some tests in order to move our EAP file based project to an Oracle 10g repository. We want to have different Oracle users having access to a common schema, so we created a schema named ea_proto where we transfered the data our EAP file and a schema named ea_proto_user that has grants and synonyms pointing to ea_proto’s tables. If ea_proto_user logs in and tries to create a new EA package , the following error message appears: ORA-00942: table or view does not exist.
We traced the database connection and found out that the database dictionary tables are queried with the condition table_schema = 'EA_PROTO_USER' instead of table_schema = 'EA_PROTO'
SELECT *
FROM (SELECT NULL table_catalog, idx.table_owner table_schema,
idx.table_name table_name, NULL index_catalog,
idx.owner index_schema, idx.index_name index_name,
NULL primary_key,
DECODE (idx.uniqueness, 'UNIQUE', -1, 0) unique_,
NULL clustered, NULL TYPE, NULL fill_factor,
idx.initial_extent initial_size, NULL NULLS,
NULL sort_bookmarks, -1 auto_update, 2 null_collation,
col.column_position ordinal_position,
col.column_name column_name, NULL column_guid,
NULL column_propid, 1 collation, NULL cardinality,
NULL pages, NULL filter_condition, NULL integrated
FROM all_indexes idx, all_ind_columns col
WHERE idx.owner = col.index_owner
AND idx.index_name = col.index_name
AND idx.table_owner = col.table_owner
AND idx.table_name = col.table_name) dbschema_indexes
WHERE table_schema = 'EA_PROTO_USER' AND table_name = 'T_OBJECTPROBLEMS'
ORDER BY 8, 10, 5, 6, 17
Does anyone know how we can solve this problem?
Thank you very much.