/ All posts
- Organizing 1000+ tables into folders with Oracle MFD_META
Connecting to a certain Oracle DBMS brings 1000+ tables into project pane. 600+ are owned by the same user I use for connection. Couple of other users grant access for few hundred more tables each. The remaing odd tables are from ~20 different users.
Manifold has a great way to organize this mess into folders. However, having the current privileges, I can only organize the tables owned by the connecting user. Otherwise I get one of the following errors.
ORA-01031: insufficient privileges
ORA-00972: identifier is too long
ORA-00942: table or view does not exist
I guess Manifold tries to create MFD_META for other schemas(=users) and fails. But what is the 'identifier is too long' error?
Shouldn't SCOTT.MFD_META be able to contain records about HR.* etc. tables also?
Now I understand. Every schema/user has single organization for its tables and other users see the same organization.
I had different connections open and until I granted access to mfd_meta accross users, I did not see other users' folders and thought that each user can organize *all* tables its own way.