Check out the sdcli command, which makes certain SQL Developer GUI features available from the command line...
cart: Database Cart Batch Tasks
dba: Basic Batch DBA Tasks
format: Format Task
migration: Database Migration Tasks
reports: Basic Batch Reporting Tasks
unittest: Unit Testing Batch Tasks
utility: Utility Import Task
cart <command> <command arguments>
cart <command> -help|h
export -cart <savedcart.xml> -config|cfg <exportconfig.xml> [-target|tgt <dirorfilename>] [-logfile <filenameorstderr>] [-deffile <exportdefinitionfile>]
cloud -cart <savedcart.xml> -config|cfg <deploycloudconfig.xml> [-target|tgt <filename>] [-logfile <filenameorstderr>] [<clouddefinitionfile>]
copy -cart <savedcart.xml> -config|cfg <copyconfig.xml> [-logfile|log <filenameorstderr>] [-deffile <copydefinitionfile>]
cart export -cart /home/carts/cart.xml -cfg /home/carts/exporttools.xml
Export the objects included in cart.xml using the options saved in exporttools.xml
cart cloud -cart /home/carts/cart.xml -cfg /home/carts/cloudtools.xml
Deploy the objects included in cart.xml using the options saved in cloudtools.xml.
cart copy -cart /home/carts/cart.xml -cfg /home/carts/copytools.xml
Copy the objects included in cart.xml using the options saved in copytools.xml
Thanks Gary Graham-Oracle
A quick question, If I'm using my cart to keep track of schema def changes, how would I allow the cart to look for new objects? Is there a way to do this through some script or would I have to manually rebuild the cart file each time?
you'd have to manually update the cart
you could try to fiddle with the xml and script it yourself that way
As Jeff indicates, nothing out of the box for this.
If you are intent on using command line / batch processing, however, perhaps you could use SQLcl to run a script (Java script) to find all objects created since the last time the cart xml file was updated, then update the cart xml to include the new objects. This xml has a very simple structure. Not sure if your Java script could then in turn make sdcli cart calls from within SQLcl. Just a thought.