Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Dropping User and user created objects
From:   Gregg, William

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.


Bill Gregg, Teradata DBA, GE

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023