Janet - 1. Piece of Cake. When you choose the Reverse Engineer tool, the 'Set Options' window has an Options panel on the right-hand side. You should see a 'Tables/Views owned by' choice. The default is 'All'. Change the radio button to 'Owners (comma separated)' and type in the schema name.
2. That's a little more difficult. My first instinct would be to check your path and make sure that the Oracle binaries are in it. Are you able to successfully connect to the database via SQL*Plus? Can you TNSPING it? Brian ---------------------------------------------- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | ---------------------------------------------- -----Original Message----- Linsy Sent: Wednesday, February 12, 2003 9:54 AM To: Multiple recipients of list ORACLE-L Hi all, I have couple of questions about ERWIN. -- I need to reverse engineer for just one schema. I specify the login name/pwd for that schema, but ERWIN generates charts for objects do NOT belong to that schema too! How do I get charts for a specific schema only? -- When connect to the db, Erwin asks about target server, ef: ODBC, Oracle, Sybase, etc. I can connect to the db through ODBC, but cann't connect using Oracle directly. Why ? Really appreciate any thoughts. Thank you in advance. Janet __________________________________________________ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
