Archives of the TeradataForum

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

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

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.

Thanks,

Geeta Kudumula
AMEX IDN TERADATA DBA

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