how-to copy tables form one database to another in Teradata RDBMS

-- for each TargetDb table give the user select right 

SELECT 'GRANT SELECT

ON ' !! TableName  !! ' TO userName

WITH GRANT OPTION ; 

' 

FROM dbc.tables

WHERE DataBaseName = 'TargetDb' ;

-- for each Cou chDb table create a new one in TargetDb

-- by copying the couch db 

SELECT '

DATABASE TargetDb ; 

CREATE TABLE ' !! TableName !! '

AS (

SELECT * FROM TargetDb.' !! TableName !! '

) WITH DATA;' 

FROM dbc.tables

WHERE DataBaseName = 'TargetDb' ;