That was what I needed, thanks so much! I had read the article, but
hadn't realized what the screenshot was showing; I'm still one of those
who looks for words; gotta adapt.
On 12/9/2020 10:34 PM, Øyvind Isene wrote:
Have you seen this post by Jeff Smith: https://www.thatjeffsmith.com/archive/2018/11/scheduling-exports-of-your-data-using-the-cart/ <https://www.thatjeffsmith.com/archive/2018/11/scheduling-exports-of-your-data-using-the-cart/>?
It has a screenshot that shows how to generate the configfile.
tor. 10. des. 2020 kl. 02:42 skrev Tim Gorman <tim.evdbt@xxxxxxxxx <mailto:tim.evdbt@xxxxxxxxx>>:
Hi all,
I'm working with SQL Developer to export tables from a database
down to text files, specifically delimited files. Interestingly
enough, there does not appear to be an abundance of documentation
or blog posts on this functionality for some reason? Maybe I'm
missing out?
When I use the export tools from the graphical interface of SQL
Developer, everything seems to work fine. However, my customer
has thousands of tables to export, so I am thinking that the SQL
Developer command-line tool "sdcli" will be useful.
First, I'm using the *View *> *Cart *functionality to create a
shopping cart, and then save the cart definition to an XML file,
and then run SDCLI...
*./sdcli.exe cart export -cart ./system_clobtable_cart.xml*
Config argument is missing. -config <config> is required.
OK, that's understandable. After all, I haven't specified
connection information to the database anywhere, so presumably
that goes in this missing configuration file. The question is:
how do I generate it?
Googling keywords like "sdcli cart export -config" yields nothing
useful. Searching on the same keywords in support.oracle.com
<http://support.oracle.com> yield nothing either.
However, command-line help from the "sdcli.exe" command yields a
little bit more information...
./sdcli.exe cart export -help
CART EXPORT
Syntax:
export -cart <savedcart.xml> -config|cfg <exportconfig.xml>
[-target|tgt <dirorfilename>] [-logfile <filenameorstderr>]
export -deffile <exportdefinitionfile>
Description:
The cart export command is used to export the contents of a
previously saved cart. The options used for the export are
identified in a saved export configuration file. The export
file(s) can be saved to a different target file which must be
compatible with the save as type specified in the
configuration file.
Options
-cart <savedcart.xml> a saved cart file. Use one of the save
buttons for an open cart to create a saved cart file. The
file identifies the set of objects, if they are to be included
in the export and if ddl and/or data is to be exported.
-config|cfg <exportconfig.xml> a configuration file for a cart
export. Use the save button on the export tool to create a
saved configuration file. The file will include the options
to be used for the export.
-logfile|log <filenameorstderr> log to specified log file or
to stderr. If option is not specified no logging is done.
-deffile<exportdefinitionfile> file containing the options to
be used for the cart export.
-help|h show help text for cart export
Examples:
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 export -cart /home/carts/cart.xml -cfg
/home/carts/exporttools.xml -log stderr
Export the objects included in cart.xml using the options
saved in exporttools.xml. Write all log messages to stderr.
cart export -cart /home/carts/cart.xml -cfg
/home/carts/exporttools.xml -log /home/carts/export.log
Export the objects included in cart.xml using the options
saved in exporttools.xml. Write all log messages to file
export.log. Deletes existing log file.
cart export -cart /home/carts/cart.xml -cfg
/home/carts/exporttools.xml -tgt /home/carts/export2.sql
Export the objects included in cart.xml using the options
saved in exporttools.xml. Override the name of the export
file with tgt.
cart export -def /home/carts/export.def
Export using options in export.def.
Command Completed.
The help message above (highlighted in red typeface) seems to
indicate how to create the configuration XML file with "Use the
save button on the export tool to create a saved configuration
file". Sounds reasonable, so I go back to the graphical console
for SQL Developer, and I do find the Database Export wizard by
going to *Tools *> *Database Export...*, but that is a pure wizard
with no *Save *button anywhere. Also, I can right-click on the
table name in the left-hand navigation bar, and select *Export...*
but that brings up the same wizard with no *Save *button anywhere.
So, I cannot figure out how to create the necessary configuration
XML file required by SDCLI.
I'm tired of guessing. Can anyone help?
Thanks in advance!
-Tim
--
Øyvind Isene
+47 90864882