Archive all tables with data

Tools & Utilities
Enthusiast

Archive all tables with data

Hi all!

May be a very simple question.. I want to dump the current state of the Teradata database. To do it, I use arcmain and the following script:

ARCHIVE DATA TABLES (dbname),

RELEASE LOCK,

FILE=ARCHIVE;

However, this script archives tables without data. How could I dump all objects with their content? 

Many thanks!

2 REPLIES
Enthusiast

Re: Archive all tables with data

Your script should achive the data.

Can you post the job log?

Rglass

Enthusiast

Re: Archive all tables with data

You are right, the script is correct. There are some other reasons of the problem that we have. I'll create a separate topic for that. Anyways, thanks for your fast reply!