Terdata Export Error

Database
Fan

Terdata Export Error

Hello All,

I am new to the terdata database. I am planning to use fast export method to extract the data from teradata. when i was testing simple fast export script getting the error . Please check the below script and error message. Can you please help me anyone to fix that issue.

---SCript

.LOGTABLE EXPLOG;
.LOGMECH LDAP;
.LOGON servername/uid,PWD;
DATABASE data;
.BEGIN EXPORT SESSIONS 2;
.EXPORT OUTFILE :C:\Test\Test1.txt;
MODE RECORD FORMAT TEXT;
select * from table;
.END EXPORT;
.LOGOFF;

 

error message:

 

**** 15:00:17 UTY2411 Processing start date: FRI JUL 06, 2018
========================================================================
= =
= Logon/Connection =
= =
========================================================================
0001 .LOGTABLE EXPLOG;
0002 .LOGMECH LDAP;
0003 .LOGON 30.128.223.28/AD42778,;
**** 15:00:17 UTY8400 Teradata Database Release: 15.10.06.09
**** 15:00:17 UTY8400 Teradata Database Version: 15.10.06.09a
**** 15:00:17 UTY8400 Default character set: ASCII
**** 15:00:17 UTY8400 Current RDBMS has UDT support
**** 15:00:17 UTY8400 Current RDBMS has Large Decimal support
**** 15:00:17 UTY8400 Current RDBMS has FEXP w/o Spooling support
**** 15:00:17 UTY8400 Current RDBMS has TASM support
**** 15:00:17 UTY8400 Maximum supported buffer size: 1M
**** 15:00:17 UTY8400 Data Encryption supported by RDBMS server
**** 15:00:17 UTY1008 RDBMS failure: 3524, The user does not have CREATE TABLE
access to database SYSHIST.
**** 15:00:18 UTY2410 Total processor time used = '0.109201 Seconds'
. Start : 15:00:17 - FRI JUL 06, 2018
. End : 15:00:18 - FRI JUL 06, 2018
. Highest return code encountered = '12'.

 

 

Thanks

CK...

2 REPLIES
Teradata Employee

Re: Terdata Export Error

it is a permissions issue. Talk to your dba.
Fan

Re: Terdata Export Error

Thanks David