|
|
|
Junior Member
 
Group: Forum Members
Last Login: 10/19/2007 10:39:17 AM
Posts: 11,
Visits: 2
|
|
Hi,
Is there a way to transfer a table from one database to another database in teradata ?
thanks,
Nagendhran
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 12/21/2007 11:48:24 AM
Posts: 39,
Visits: 4
|
|
Hi,
You can use copy objects option from the file menu(F8 command) from the Teradata Administrator(winddi) to accomplish this task.
--Regards,
Aravind
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 10/19/2007 10:39:17 AM
Posts: 11,
Visits: 2
|
|
Hi,
Thanks for your suggestion aravind.
rgds,
Nagendhran
|
|
|
|
|
Supreme Being
Group: PAC and SFT Members
Last Login: Today @ 6:11:07 PM
Posts: 331,
Visits: 533
|
|
|
Note that "Copy Objects" in Teradata Administrator only copies the definition (in effect does SHOW on one system and submits the resulting DDL on the other). It does not copy the data. There are many possible ways to move the data, including via ARCHIVE and COPY with the Teradata ARC utility.
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 10/19/2007 10:39:17 AM
Posts: 11,
Visits: 2
|
|
|
can you eloborate more on this fred ?
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 9/22/2008 2:11:57 AM
Posts: 118,
Visits: 62
|
|
If u have access to unix command prompt then....invoke arcmain.
--Command-line invocation of Teradata ARC from Solaris, MPRAS,HP-UX, and AIX:
arcmain outlog=arcall.out --The above command line calls the ARCMAIN executable.
--The default is archive to disk if no IOMODULE or IOPARM are specified. The input file named arcall.in contains ARCMAIN commands. The “<“ redirects the input file to ARCMAIN.
--The following example illustrates how a database is copied:
COPY DATA TABLE (Personnel)
(FROM (OldPersonnel), NO FALLBACK)
,FILE = ARCHIVE;
--The database named Personnel is restored from an archived database named OldPersonnel with all tables defined as nonfallback after the copy operation.
The above information is there in Teradata manual "Teradata Archive/Recovery Utility Reference"
Regards
Ramakrishna_Vedantam
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 9/22/2008 2:11:57 AM
Posts: 118,
Visits: 62
|
|
arcmain outlog=arcall.out --The above command line calls the ARCMAIN executable.
Regards
Ramakrishna_Vedantam
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 9/22/2008 2:11:57 AM
Posts: 118,
Visits: 62
|
|
arcmain outlog=arcall.out < arcall.in
Regards
Ramakrishna_Vedantam
|
|
|
|
| | |