Archives of the TeradataForum

Message Posted: Wed, 15 Mar 2006 @ 16:29:26 GMT

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

It is not very difficult.

The steps are:

1. Create the table with the new PI definition (see 3);

2. Move the data by using, say, INSERT INTO <new_table> ... SELECT FROM <old_table>;

3 (optional). If the original table had dependent objects such as SI or JI, you might be better off building them on the new table after you have moved the data. If you have triggers you might consider disabling them because their logic might not suit such a table migration.

4. Drop the old table.

5. Rename the new table to the original name.

Regards,

Victor

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