Archives of the TeradataForum

Message Posted: Tue, 04 Sep 2012 @ 15:46:25 GMT

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

Hi Dipti,

To add space to the journal table, you can follow 2 methods mentioned below.

Method 1 - Go to Teradata administrator and tool - move space

Method 2 - 3 queries mentioned below -

     CREATE DATABASE TMP_SPACE FROM SPACE_RESERVE AS PERM=1E9;
     GIVE TMP_SPACE TO NEWDB;
     DROP DATABASE TMP_SPACE;

Thanks

Roopalini

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