Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 16 Jan 2013 @ 13:57:24 GMT

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

Subj:   Re: Rename a database
From:   Geeta Kudumula

No, there is no SQL statement available to rename a database (or user).

Some alternate ways to accomplish this are:

1. Use bteq / show table(s) /.export to host file /modify DDL from show table(s)/ .run file = modified DDL/SQL to create new table(s) / then insert into select * from old table, etc... - creation of new DB with appropriate permspace,spool, etc... assumed.

2. Use ARCMAIN, to ARCHIVE the DB and then COPY it to the new one.

In all cases, any attributes associated with the tables/DB's being moved would need to be "manually" redone or recreated via SQL scripting. This would include attributes such as access rights, and referential integrity as well as any join indexes.


Geeta Kudumula

  <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: 24 Jul 2020