SQL Developer


Data Modeller: compare models


Hello,
when i go through the compare models dialog. The table columns are highlighted as been different. Inspection revels that the difference is in the data type:
On the source model it is set to the domain presentation and on the target - to it's a logical type representation.
I'm not sure how to change this?
Another question:
same dialog - the length of varchar is shown in chars on target and in bytes on the target.
Where do i need to change this ?
thank you
Andrew
Edited by: AndrewZ on Jan 11, 2010 12:19 PM 
Hello Andrew,
how did you create these models - with domains and without and that char - byte difference?
Look at "General options">DDL - there are two settings that could help:
- "Show char/byte unit...."
- "Use data type kind ..." - it's related to domain/ logical type difference;
also, you can create domains in model without domains - use Tools>"Types to domains wizard".
Philip 
Hello Philip,
"how did you create these models - with domains and without and that char - byte difference?"i created a logical model using domains. Each domain has been defined in the "domain administration" dialog and mapped to logical type with ( in case of char/varchar types ) "char" length.
For example :
loan_id is specified as "domain (short text)". Which is defined ( in "domains administration" ) as char(50).
After logical model was complete, i generated the relational , did "DDL generation" ran the script in the DB.
After that i made some changes to the logical ( added and changed some entities ).
To generate the diff i followed Sue's tutorial.
These were the steps I used to get to this situation.
So now i have ( in "Compare Models" dialog) the situation that all tables are different, and the difference is in a type presentation.
Here is the link to the screenshot i made.
"also, you can create domains in model without domains"hmmm, what would be an advantage of using this approach?
Thank you
Andrew
Edited by: AndrewZ on Jan 10, 2010 7:04 PM 
bump

Related Links

EA 2.1  desc of object type doesnt display correct result
BUG: EA 2.1 code editor: completion insight doesn't work in opened files
Edit table dialog with inherited privileges
Unable to see the schema tables ..
EA2 Export query results causes query to be executed again
Schema selection
v1.5.5 prompts for bind vars when SQL contains timestamp literal
EA2 - MacOSX - Settings not migrated from 1.5
EA2 - Dates not displaying times
01017 Invalid username/password; login denied; Error in v1.5, works in v1.2
Line Break After Semi-Colon?
query output similar to sql plus results
EA2 - EA1 - Connection interface is unavailable
Auto commit DDL: Difference between SQL developer and SQL*Plus?
Unable to do case-insensitive string comparison using NLS in SQL Developer
Read only user access

Categories

ORACLE DEV
Designer
Sample Code
Community Feedback (No...
Heterogeneous Connecti...
E-Business Suite Archi...
TimesTen In-Memory Dat...
ILM Assistant
.NET Stored Procedures
Integration - Oracle BAM
SQL Developer
Berkeley DB High Avail...
OPS/RAC (Korean)
Audit Vault
LCM: R12 Install/Upgrade
Siebel Archived Forums
Documaker
Planning and Budgeting
Master Data Management...
Sales
Financial Consolidatio...
Smart Space
LCM: Oracle iSetup
ServerStats
On Demand: SaaS and Ma...
Architecture
SOA Governance
WebLogic Server - Secu...
Communications Service...
Packaged Applications
Oracle中文合作伙伴技术论坛
Data Service Integrator
Business Intelligence ...
Self-Service
Workshop Product Famil...
aqualogic.bpm.general
Archived Discussion Fo...
SOA Suite 11gR1 Early ...
存档论坛
Oracle Policy Automation
Java EE (Java Enterpri...
Java Security
Conventional & Interru...
Installation
JVMTI [ARCHIVE]
Java EE SDK
Java System Message Queue
General Java Mobile Qu...
Socket Programming
Bug Examples
Java SE Embedded
JavaFX 2.0 and Later
Oracle Application Exp...
Oracle SOA Suite (Japa...
Software as a Service ...
Single Sign On
Israel Oracle User Gro...
Oracle Mobile
My Oracle Support Sear...
Engineered Systems
Infrastructure as a Se...
Chicago Area Eloqua Users
Utah Eloqua Users
E10 Lead Scoring
United Kingdom User Group
Search Engine Marketing
OpenWorld & JavaOne La...
Insurance
Oracle VM
See How
Enterprise Quality Man...
Oracle JET
JAI
Discussion - Accenture...
Interact 2014: A Moder...
Article Archive
DBA Plus Community-DBA...
Oracle Database Cloud ...
OTN at Oracle OpenWorld
Eclipse開発ツール
Service Supply Chain
From MOOC1
Resources
Cúpula Virtual de Tecn...
Brazil - Eloqua User G...
Modern Marketing Eloqu...
Oracle Application Ser...
Database Security - Ge...
Sensor-Based Services ...
产品
Siebel Technology
Hyperion System 9 Appl...
Long Messages Forum
weblogic.aqualogic.dat...
Primavera P6 EPPM User...
WebLogic开发
JavaServer Faces
Technical Questions
OTN Garage
Forms Gruppe

Resources

Database Users
RDBMS discuss
Database Dev&Adm
javascript
java
csharp
php
android
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App