Skip to content

A sql script to export a table generating .dat and .ctl files to be imported with sqlldr oracle utility.

License

Notifications You must be signed in to change notification settings

gpalleschi/gpgen_sqlldr

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 

Repository files navigation

GPGEN_SQLLDR


Description :

The gpgen_sqlldr is an sql script, created under Affero General Public License v3.0 to generate a .dat and .ctl files for oracle utility sqlldr. Basically permits to export a table with the possibility to filter data.

Script requiered two parameters :

   @gpgen_sqlldr.sql <TABLE NAME> <CONDITION>  

ex.

   @gpgen_sqlldr.sql users 1=1

Will be created these files :

  users.ctl
  users.dat

To use with :

    sqlldr userid={user}/{password} control=users.ctl log=users.log

Compatibility :

ORACLE 8 or upper


Prerequisites :

Script sql need to have write permission in directory where it is executed.


License :

This project is licensed under the Affero General Public License v3.0 - see the LICENSE file for details

About

A sql script to export a table generating .dat and .ctl files to be imported with sqlldr oracle utility.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Languages