Toad World® Forums

Wrong insert at sync & convert


#1

CREATE TABLE “HM_TEST”.“STAEDTE_ENTFERNUNGEN_37E8CF176”(

“ID” Integer NOT NULL,

“LON1” Float(38) NOT NULL,

“SIN_LAT_PI1” Float(38) NOT NULL,

“COS_LAT_PI1” Float(38) NOT NULL,

“ENTFERNUNG” Number NOT NULL,

“LON2” Char(20 ) NOT NULL,

“SIN_LAT_PI2” Float(38) NOT NULL,

“COS_LAT_PI2” Float(38) NOT NULL

)

TABLESPACE “SONSTIGES”

/

INSERT INTO “HM_TEST”.“STAEDTE_ENTFERNUNGEN_37E8CF176” (“ID”, “ENTFERNUNG”) SELECT “ID”, “ENTFERNUNG” FROM “HM_TEST”.“STAEDTE_ENTFERNUNGEN”

/

Why is the insert statement so short ?

I think for resolution of this error I will attach the momentarily Model.

Best regards

Linus

Unfortunately I can not attach a file, because there is no box to enter it here on the internet …

Hello,

I tested around this weekend and wanted to use the first of generated scripts.
If I run the alter script, I get
ORA-01400 at the following statement.



Message was edited by: Linus


#2

Hi Linus,

please send us your models to modeling@quest.com. We will look into the matter. Thank you.

Regards,

Vaclav


#3

Hello Vaclav,

see my files sended at the mail address. Vladka received it and didn’t know what to do with it. I responded to her.

Have a nice christmas

Linus


#4

Hello Linus,

I’m sorry for the confusion.
Thanks for your models. The reason found. Please check out your email box for our explanation.
Thanks.

Have a nice day.

Vladka + TDM Team


#5

Hello Vladka,

yes you are right. I couldn’t remember after so much changes that I added some columns and renamed the others.

OK. Thanks. This case has been resolved.

Linus