Is there a option of creating control files when exporting Data

UDA
Enthusiast

Is there a option of creating control files when exporting Data

HI ,

We need to transfer data from teradata to oracle. The option we are going is transfering the data from teradata into flat files and providing it to the clients to load into oracle.

Is there a option of generating a control files in teradata for what ever data i exported using FASTEXP? By saying control files i mean No.of rows in teh flat file, The table layout and other details.

Regards
HK
2 REPLIES
Enthusiast

Re: Is there a option of creating control files when exporting Data

Using Fast Export,you cannot generate a control file in the same job. If your data volume is low, you may use a BTEQ job which you can use to generate your control file and data file in the same job. Otherwise, use a separate BTEQ job to create your control file.
Enthusiast

Re: Is there a option of creating control files when exporting Data

Thx Somesh... Can you give me sample script on doing this or if you tell me what command needs to be used to generate teh control file?

Regards
HK