Holger Hoffstätte wrote:
>
> Good, so it's not really Modeler's fault but rather DbLoader. Good to
> know! I just tried against my Oracle9i test db, as system user I could
> reengineer my SYSTEM schema just fine; took only two seconds and didn't
> use much memory. SYS gave trouble because of duplicate keys.
>
> Andrus, I think we really need to address this by either renaming the keys
> in e.g. ascending order (not good for tables with strange names; many
> people unfortunately do that) or by making the keys internally use the
> fully qualified name. Maybe we could ignore the schema namespace when the
> DbAdaptor has no schema support so that we don't lose DataMap portability
> between databases. Don't know if this is possible.
Finally I was able to reproduce Javier's stack trace. The thing is that
on 9i SYS logins are turned off by default, so I've never used a user
with direct access to SYS schema. I just granted DBA to another,
unpriveleged, user and got the same exact error.
Will look at this some more later...
Andrus
This archive was generated by hypermail 2.0.0 : Mon Feb 17 2003 - 09:39:30 EST