Archives of the TeradataForum

Message Posted: Wed, 17 Dec 2003 @ 18:54:01 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi All,

I'm trying to restore a table which has been dropped. While performing restore from archive I'm encountering an error:

---------------------------------------------------------------
12/17/2003 13:40:47  RESTORE DATA TABLES (DWTABLES_DEV.stub_tmp),
12/17/2003 13:40:47  RELEASE LOCK,
12/17/2003 13:40:47  FILE = X;
12/17/2003 13:40:47  LOGGED ON   10 SESSIONS
12/17/2003 13:44:33  *** Error 3807:Table/view/trigger/procedure 'STUB_TMP' does not exist.
12/17/2003 13:44:33  DWTABLES_DEV.STUB_TMP - TABLE SKIPPED.
12/17/2003 13:44:56  STATEMENT COMPLETED
12/17/2003 13:44:56
12/17/2003 13:44:56  LOGOFF;
12/17/2003 13:44:58  LOGGED OFF  12 SESSIONS
12/17/2003 13:44:58  STATEMENT COMPLETED
--------------------------------------------------------------

Also this is the restore script that I'm using:

LOGON $LOGON;
restore data tables (dwtables_dev.stub_tmp),
release lock,
file=x;
LOGOFF;
-------------------------------------------------------

We're using Netbackup 3.4 for our backup/restore

Rgds,

Rohit

	<Prev	Next>		<<First	<Prev	Next>	Last>>