-
1. Re: unable to obtain alter script from data modeler
be here now Aug 24, 2014 9:36 PM (in response to be here now)1 person found this helpfulI managed to get an expected alter script by importing existing data dictionary from database into a whole new design, changing it and then syncing my changed design back with data dictionary.
I tried to compare two designs - one reverse-engineered from ddl script, another one reverse-engineered from data dictionary - with each other, but still got blank screen in "DDL Preview". Probably a bug?
-
2. Re: unable to obtain alter script from data modeler
Philip Stoyanov-Oracle Aug 25, 2014 7:42 AM (in response to be here now)After this I press "DDL preview" and expect to see an "alter table FACT_FREIGHT_CARS" script there, but for some reason the window is empty and no script is generated:
Probably there is an error preventing that. Can you check the log file for errors logged there - use "View>External log".
At least you should get the following template if thee is nothing to be generated:
-- Generated by Oracle SQL Developer Data Modeler 4.0.2.840
-- at: 2014-08-25 10:40:58 EEST
-- site: Oracle Database 11g
-- type: Oracle Database 11g
-- Oracle SQL Developer Data Modeler Summary Report:
--
-- CREATE TABLE 0
-- CREATE INDEX 0
-- CREATE VIEW 0
-- ALTER TABLE 0
-- ALTER INDEX 0
-- DROP TABLE 0
-- DROP INDEX 0
-- CREATE TRIGGER 0
-- ALTER TRIGGER 0
-- CREATE SEQUENCE 0
-- ALTER SEQUENCE 0
-- DROP SEQUENCE 0
-- CREATE MATERIALIZED VIEW 0
-- DROP VIEW 0
--
-- ERRORS 0
-- WARNINGS 0
Philip
-
3. Re: unable to obtain alter script from data modeler
be here now Aug 26, 2014 1:19 AM (in response to Philip Stoyanov-Oracle)Probably there is an error preventing that. Can you check the log file for errors logged there - use "View>External log".
No, there are no errors in the log file, at least at the time I try to generate DDL (there are some irrelevant from a few days ago).
-
4. Re: unable to obtain alter script from data modeler
David Last-Oracle Aug 26, 2014 9:28 AM (in response to be here now)Hi,
Are there any other Tables, Views, ... with differences? Are there any other differences identified for Table FACT_FREIGHT_CARS (e.g. PK, UK or Foreign Key or Table Check Constraints)?
What is the datatype of column SOMETHING?
I assume standard DDL generation for your model is working fine?
If you could post the standard DDL for table FACT_FREIGHT_CARS (and any other Tables, Views, etc with differences) that would probably help to identify the cause of the problem..
Thanks,
David