I am inserting into a table in teradata by selecting from 3 tables , it inserts some 7 lakh records and it is very slow.
If i have to use collect statistics before inserting into the table , can i use collect statistics for the columns or how do i go abt it.
Thanks in advance.
I have a table in Teradata A, column abc integer.
I wan't to load the teradata data into a oracle table B, column abc number.
Datatype width is not specified in teradata, so what width can i give for the number column.
While unloading the data from Teradata into a file if i give a query as...
I have a table A in oracle Database.
I have another table B in Teradata.
The structures of the above table are same.
I want to load the data in oracle table to Teradata table. Is there any utility to do this. I would also like to know whether i can do this through a SQL Script in unix.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.