I am trying to reengineer schema from my production database. What I get are stored procedures,functions,etc, except tables. it gives the error : ORA-00942 -Table or view does not exist.What I want is table definition. Could anybody tell me what is possibly wrong with ERwin?
My db is 9i R2
ERwin is 4.1.
Thanks for help in advance.
02-25-2003, 06:09 PM
In this case there is nothing wrong with Erwin. If you try to reverse engineer a database with a non privileged account and get the system stuff you will get this error message. When you reverse engineer there is an option to only get objects owned by this schema.