SqlDbx
You are not logged in.
Pages: 1
Hi,
some tables can have constraints that are disabled. When you script those tables, the key-word DISABLE is missing at the end of the scripted constraints, highlighted below:
CONSTRAINT FK_MY_CONSTRAINT FOREIGN KEY (CUSTOMER_ID) REFERENCES DWH.D_CUSTOMERS (ID) DISABLE,
Is this the intended behaviour? I somehow expected the script to reflect the current state of table / constraints. The environment I use is:
* Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
* SQLDbx 4.10 Professional
Also, do you plan to include table partition info when scripting tables ?
Thank you guys,
Goran
Offline
Will look into this issue
Offline
Pages: 1