Archives of the TeradataForum

Message Posted: Tue, 05 Apr 2011 @ 18:40:43 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

James - Consider writing some SQL along these lines:

     Select 'show table FRED.' || trim(tablename) || ' ; '
     From dbc.tables
     Where trim(databasename) = 'FRED'
     Order by 1 ;

Use the Export to a file in SQL Asst (from the file pick llist)

Once complete, go into the file and change the database name on the DDL to NEWdb. From FRED.

Run the DDL and the tables are created.

Use a similar SQL generator to produce the required insert into newdb.tbl001 select * from fred.tbl001 for each table;

I don't believe that u can give a table to another DB or User.

Good Luck.

Rgrds,

Bill Gregg, Teradata DBA, GE

	<Prev	Next>		<<First	<Prev	Next>	Last>>