Question on restoring database using Teradata Arcmain

Database

Question on restoring database using Teradata Arcmain

Dears,

It's my first encounter with teradata, the following question might be stupid :)

I was told to use Teradata Arcmain to restore database, but I have a query for the following script:

COPY DATA TABLE (tbase)

(FROM (tbase)

,NO FALLBACK)

,RELEASE LOCK

,FILE = tbase;

Could somebody tell me the difference between the three ‘tbase’? Thanks very much.

2 REPLIES

Re: Question on restoring database using Teradata Arcmain

Tim_Qiu:

COPY DATA TABLE (tbase) -->> Destination Table

FROM (tbase) -->>Name of the table archived (source).

FILE = tbase -->>Name of the file used when archived.

HTH.

Cheers.

Carlos.

Re: Question on restoring database using Teradata Arcmain

Thanks so much, Garlos.