Skip to Content
avatar image
Former Member

Copy Data from virtual table to another virtual table.

Hi guys,

Here is a scenario in which I'm having data in one virtual table named 'VT1'. This VT1 table is getting updated by one CV.

My requirement is to update an another virtual table named 'VT2' from the data available in table VT1. Both the table is having same structure.

I tried to use a simple INSERT statement which is

INSERT INTO "VT2" (SELECT * FROM "VT1");

But this statement is giving error like..... SAP DBTech JDBC: [403]: internal error: Error executing query [Oracle][ODBC]Invalid datetime format. for query " INSERT INT......"

VT1 table definition is like Field1(varchar 56), Field2(varchar 100), Field3(timestamp), Field4(varchar 2000), Field5(varchar 2000), Field6(timestamp), Field7(varchar 2000), Field8(varchar 80), Field9(timestamp),Field10(varchar 80), Field11(timestamp)

Any suggestions here, expert @lars.breddemann @thomas.jung? Sincere thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 29, 2016 at 08:29 PM

    Hi Saurabh,

    for me it seems like the schema of VT1 is not exactly matching the one of VT2. (Column Names, Datatypes etc.)

    Can you please have a look at that? It might be that you need to do some transformation ontop of VT1 so that it produces valid output for VT2.

    Thanks,

    Timo Wagner

    Add comment
    10|10000 characters needed characters exceeded