To register for an Internet.com membership to receive newsletters and white papers, use the Register button ABOVE.
To participate in the message forums BELOW, click here

HOME 11g Central 10g Central 9i Central 8i Central Oracle News Scripts FAQ OCP Zone Resources Database Journal
  #1  
Old 02-25-2003, 11:11 AM
DeltaFun DeltaFun is offline
Junior Member
 
Join Date: Feb 2003
Location: New York
Posts: 75
problems with ERwin

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.
__________________
Still learning
Reply With Quote
  #2  
Old 02-25-2003, 05:09 PM
gandolf989's Avatar
gandolf989 gandolf989 is offline
mod
 
Join Date: Nov 2000
Location: Pittsburgh, PA
Posts: 3,598
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.
Reply With Quote
  #3  
Old 02-27-2003, 11:32 AM
DeltaFun DeltaFun is offline
Junior Member
 
Join Date: Feb 2003
Location: New York
Posts: 75
Thanks for the info. Very appreciate.
__________________
Still learning
Reply With Quote
Reply Post New Thread

Bookmarks

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump


All times are GMT -4. The time now is 03:51 AM.


DBAsupport.com Recent Articles


 » Top 5 SQL Questions for a PL/SQL Job Interview

 » New Features for Oracle Database 11g Table Partitioning

 » Oracle Business Intelligence, Past and Present

 » Capturing Extra-Database I/O Performance Metrics

 » Database Object Tips for a PLSQL Job Interview

Search DBAsupport:
 


Click Here to Expand Forum to Full Width










Acceptable Use Policy

Internet.com
The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.