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, 12:11 PM
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, 06:09 PM
gandolf989's Avatar
gandolf989 gandolf989 is offline
mod
 
Join Date: Nov 2000
Location: Pittsburgh, PA
Posts: 3,561
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, 12:32 PM
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 10:38 AM.


DBAsupport.com Recent Articles


 » Configuring Oracle as a Data Source for SQL Server

 » When tuning Oracle is not an option

 » Leveraging Logical Standby Databases in Data Guard

 » Building an Oracle Server Environment

 » Oracle 11g Security – Guidelines for Auditing

Search DBAsupport:
 


Click Here to Expand Forum to Full Width











Acceptable Use Policy


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.