Search code examples
database-schemateradatadump

How to load or import backup file into new teradata database?

I'm working in Teradata Database Express 14.04

I took the particular database build( backup the database) in Teradata Database.

The Archived file is stored in /roor/Documents/TD_BUILD. The file extension of TD_BUILD is (.File).

Now, how to import that file into new Database in Teradata?

Solution

  • To restore to a different system and/or database or to restore a dropped table you need a COPY instead of a RESTORE:

    copy data tables(xyz),release lock,file=test;

    Caution, restoring on database level drops all objects within first, i.e. ARCMAIN submits a DELETE DATABASE.

    If you restore to a different database:

    copy data tables(newdb) (from (xyz)),release lock,file=test;