Archives of the TeradataForum

Message Posted: Wed, 06 Apr 2011 @ 08:26:48 GMT

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

Hi James,

No problem.

Firstly, where did FRED create the tables ? I'm assuming that they are in FRED's database (i.e. the tables are called FRED.xxx). Gregg has given you one way of doing this. He's right in that you cannot use SQL to move a table from one database to another (in your case SYSDBA).

Apart from using the create followed by insert/select route (Gregg's method), you can:

- use CREATE TABLE AS ... WITH DATA. This needs a single command for each table but will move the table definition and data. Before you drop the original table you need to check that you've got all of the indexes in the new table.

- use ARC to archive all tables/required tables from FRED and COPY them into SYSDBA. Check the ARC manual for syntax.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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