Re: (unknown)

Iris Watlington <[email protected]>
Newsgroups gmane.comp.db.oracle.toad.free
Message-ID <[email protected]>
Hi John,
 
Yes. I believe that the diagrams that I was given are ERWin files. I would like to learn how to open them and if I recall correctly - I need to create logical and physical relationships....can't remember the exact wording. However, I believe that the goal is to get data models so that I can eventually upload them into ARIS somehow. As you can see, being new to all of this. I'm a bit lost!
 
To answer your other question, "No. I was not the person who posted the earlier comments." Thank you very much for your help. I'll give your directions a try.

Sincerely,


Iris


Iris WatlingtonGSLC, MCSE, MCSA, MCP, Security+, Network+, A+Industry Certified ProfessionalDell Certified Systems ExpertMobile Notary/Notary Signing AgentE-mail: [email protected] 

________________________________
From: John Dorlon <[email protected]>
To: "[email protected]" <[email protected]> 
Sent: Thursday, November 15, 2012 11:49 AM
Subject: RE: [toad] (unknown)

  
I’m not sure what you mean by ‘import into Toad’, but if you want to view ER Diagram contained in the file, you can do this:
 
Open Toad for Oracle
From the main menu:  Database -> Report -> ER Diagram
Click the “open file” button and open the file.
 
I don’t know if it came from you or not, but there was a support case that came in a few days ago where someone wanted to use the ERX files as a means to create database objects.  Toad for Oracle can only do that if you can connect to the database where the objects exist.  
 
I don’t know if Toad Data Modeler can create a script directly from the .erx file or not.  
 
If you want to copy these objects from one database to the other, you can do it like this with Toad for Oracle:
 
1)      Open Toad for Oracle
2)      Connect to the database where all these objects exist
3)      From the main menu:  Database -> Report -> ER Diagram
4)      Click the “open file” button and open the file.
5)      Click the Export DDL button in the ER Diagram.
6)      Run the script produced by step 5) in the ‘other’ database, either from sql*plus or Toad for Oracle
 
 
 
From:[email protected] [mailto:[email protected]] On Behalf Of Iris Watlington
Sent: Thursday, November 15, 2012 10:20 AM
To: [email protected]
Subject: [toad] (unknown)
 
  
Hi,
 
I'm new to TOAD. I have not received any training, tutorial, manual, etc. I have access to TOAD Data Modeler, TOAD for Data Analysts and TOAD for Oracle. There is a task for which I very little time to respond and I have been provided with 2 diagrams which are .erx files. Can someone please tell me how to OR if it's possible to import the files into TOAD and which option of TOAD I should be using for this? Your assistance is greatly appreciated.
 
Sincerely,
 
Iris
 
 
Iris Watlington
GSLC, MCSE, MCSA, MCP, Security+, Network+, A+
Industry Certified Professional
Dell Certified Systems Expert
Mobile Notary/Notary Signing Agent
E-mail: [email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.