Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 03 Feb 2010 @ 10:08:46 GMT


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


Subj:   Moving subset of tables/views/applications/users
 
From:   Steve Hager

We are planning on moving a subset of our users/applications from one Teradata instance to another. I know what tables will be moved and need to identify what users will be effected. (Note - We have a 3rd party tool that logs/parses the users SQL. We have nested views and multi table/database joins within some views.)

I need to create a cross reference between tables and views so I can understand the user to table relationship. My current plan is to identify all views (from DBC.TABLES) and then issue a SHOW SEL * FROM view; and capture the resulting DDL, and extract the objects referenced in the CREATE TABLE, CREATE VIEW, or REPLACE VIEW statements.

I assume Teradata MDS provides such functionality, but not particularly interested in installing it.

Any additional suggestions?


Steve



     
  <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: 27 Dec 2016