Incanto

Incanto is an open source project providing a set of Apache Ant tasks for accessing Oracle tools such as SQL*Plus and Data Pump Import/Export from Ant's XML build files.

Apache Ant is a powerful Java-based build and scripting tool (a small thing that builds big things). It is widely used to build and deploy software projects, furthermore it is well suited for installing database schemas and doing database administration work.

The objective of Incanto is to provide tools and methods to foster agile database techniques primarily for Oracle databases.

Ant Tasks for Oracle

Best Practices

Download

News, Articles

Uploading files into Oracle with Ant

March 5th, 2009

"Uploading files into Oracle with Ant" How to use the sqlldr Ant task to upload files as LOB's into Oracle.

Release 0.2.4

October 13th, 2007

Add task for the Oracle SQL*Loader utility.

Introduce failOnSpoolMatch parameter for sqlplus task to trap SP2 errors and other events within the SQL*Plus output stream. For further information, have a look at this diskussion thread.

Deprecation within Database Schemas

September 8th, 2007

"Deprecation within Database Schemas" About techniques to deprecate database items within an Oracle database.

Using Ant properties within SQL scripts with Incanto's sqlplus Task

July 16th, 2007

"Using Ant properties within SQL scripts with Incanto's <sqlplus> Task" How to pass properties from Ant to SQL scripts

Release 0.2.2

July 14th, 2007

Ant properties can now be used directly inside SQL scripts.

Jump-start with Oracle's Instant Client and Incanto

April 13th, 2006

"Jump-start with Oracle's Instant Client and Incanto" Article about the Oracle Instant Client and how to use it with Incanto's <sqlplus> task

Ant, Groovy and the Database

April 7th, 2006

Article on Mauszeig "Ant, Groovy and the Database" about how to query values from a database and use them as Ant properties