By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,831 Members | 1,031 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,831 IT Pros & Developers. It's quick & easy.

Oracle database export

P: n/a
Hi,

I need to export an Oracle database to a DDL-formated file. On the Web, I
found a Python script that did exactly this for a MS Access database, but
not one for Oracle databases.

Does anyone know of such a tool or Python script.

regards tores
Oct 5 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Tor Erik Soenvisen wrote:
Hi,

I need to export an Oracle database to a DDL-formated file. On the Web, I
found a Python script that did exactly this for a MS Access database, but
not one for Oracle databases.

Does anyone know of such a tool or Python script.
Oracle is equipped with tools to do that. For example the conveniently named
export tool "exp"

No python in the equation, though.
Diez
Oct 5 '06 #2

P: n/a

Tor Erik Soenvisen wrote:
Hi,

I need to export an Oracle database to a DDL-formated file. On the Web, I
found a Python script that did exactly this for a MS Access database, but
not one for Oracle databases.
How does the Python script connect to the MS Access database?

If it's an ODBC connection, can't you make an ODBC connection to the
Oracle database and use the same script? I have an application that
loads PDA data to a named ODBC connection. I point that named
connection to different databases depending on whether I'm loading
to the network database (SQL Server) or a local database (MS Access).
No modification to the application required.
>
Does anyone know of such a tool or Python script.

regards tores
Oct 5 '06 #3

P: n/a


On Oct 5, 9:05 am, Tor Erik Soenvisen <torer...@hotmail.comwrote:
Hi,

I need to export an Oracle database to a DDL-formated file. On the Web, I
found a Python script that did exactly this for a MS Access database, but
not one for Oracle databases.

Does anyone know of such a tool or Python script.

regards tores
Would that help?
http://www.python.net/crew/atuining/...ols/README.txt

Waldemar

Oct 6 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.