armin walland
06-03-2004, 03:03 PM
Hi dear group!
i have written a small jdbc based tool in java that may be used to dump
one, some or all tables from an oracle database in different ways
(INSERT statements, [postgres] COPY FROM STDIN statements or as
tab-separated text) or execute sql commands.
also the tool can execute sql statements which it reads from stdin or
from a file.
it may also be used interactively but there is no readline support or
cmdline editing support yet. i will try to add that if a lot of people
request it but for now i expect it to be used primarily in scripts but i
may be wrong :)
the main benefits are the following:
.)there is no need for oracle client software installed to use it
.)the tool can be used to synchronize oracle to other dbs
.)the tool can be used to execute any DDL or DML on the remote db
.)there are no dependencies except a current jre and the thin ojdbc
driver
.)jdbc appears to be pretty fast and very stable
.)it is cross platform
the tool is called oradump and it is available from sourceforge at
https://sourceforge.net/projects/oradump/
it is still in beta status so please do not use it in productive
environments without a lot of testing. as i write this it is available
as version 0.18 and i consider the current features as [kinda] stable.
the license is GPL.
i would be very happy to receive any comments, ideas, bugreports...
whatever and i hope this tool can be useful to some people.
best regards and enjoy, armin
--
my life, my universe, my everything
http://www.dtch.org
i have written a small jdbc based tool in java that may be used to dump
one, some or all tables from an oracle database in different ways
(INSERT statements, [postgres] COPY FROM STDIN statements or as
tab-separated text) or execute sql commands.
also the tool can execute sql statements which it reads from stdin or
from a file.
it may also be used interactively but there is no readline support or
cmdline editing support yet. i will try to add that if a lot of people
request it but for now i expect it to be used primarily in scripts but i
may be wrong :)
the main benefits are the following:
.)there is no need for oracle client software installed to use it
.)the tool can be used to synchronize oracle to other dbs
.)the tool can be used to execute any DDL or DML on the remote db
.)there are no dependencies except a current jre and the thin ojdbc
driver
.)jdbc appears to be pretty fast and very stable
.)it is cross platform
the tool is called oradump and it is available from sourceforge at
https://sourceforge.net/projects/oradump/
it is still in beta status so please do not use it in productive
environments without a lot of testing. as i write this it is available
as version 0.18 and i consider the current features as [kinda] stable.
the license is GPL.
i would be very happy to receive any comments, ideas, bugreports...
whatever and i hope this tool can be useful to some people.
best regards and enjoy, armin
--
my life, my universe, my everything
http://www.dtch.org