Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Dropping User and user created objects
From:   DWellman

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.



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

  <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: 15 Jun 2023