Printable View
Dear Gurus,
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.
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.
If you really have an Erwin related question you should take a look at: http://webboard2.iland.com/~ERwin/login
I just happen to be familiar with Erwin, and I have gotten the same error message for the reasons I outlined above.
Thanks for the info. Very appreciate.