Posted by: Pavel Ermakov | June 21, 2012

Archive procedures in Teradata using ARCMAIN

Hello all!

Do you know about “feature” regarding archiving procedures like this:

...
ARCHIVE DICTIONARY TABLES
(DB_NAME),
RELEASE LOCK,

FILE=ARCHIVE;
...

For example, if you have procedures in particular DB and want to restore them to the new DB at another site after this backup (DICTIONARY) you face off with some issues related to SHOW DEFINITION.

After you’ve been restored and built procedures when you try Show Definition you see “Loading DDL Text”.

Workaround for this issue – backup procedures like tables:

ARCHIVE DATA TABLES (not DICTIONARY)

Teradata Version is 13.10.

Regards,
Pavel.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: