They've got enough trouble now.
On 12/14/2020 11:04 AM, Thomas Roach wrote:
Are you exporting this data to Austin TX? Sorry, couldn’t resist.
Sent from my iPhone
On Dec 10, 2020, at 8:46 PM, Tim Gorman <tim.evdbt@xxxxxxxxx> wrote:
I'm going to pretend you're correct.
On 12/10/2020 7:07 AM, Jeff Smith wrote:
I’m going to pretend you’re using this to NOT migrate someone off of Oracle.
*From:* Tim Gorman <tim.evdbt@xxxxxxxxx>
*Sent:* Thursday, December 10, 2020 10:01 AM
*To:* Øyvind Isene <oyvind.isene@xxxxxxxxx>
*Cc:* ORACLE-L <oracle-l@xxxxxxxxxxxxx>
*Subject:* Re: Questions about SQL*Developer CLI for exporting data
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://urldefense.com/v3/__https:/www.thatjeffsmith.com/archive/2018/11/scheduling-exports-of-your-data-using-the-cart/__;!!GqivPVa7Brio!KaKXZXJi8W4npwgOUkMp-_kR74jdRskW0Yucw7dEl3XBYPG94qzhs18AnkdHR1RYlwE$>?
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