Re: ORACLE EXPORT TO EXCEL, DBASE???

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Wed, 27 Nov 2002 00:50:16 GMT
Message-ID: <cFUE9.16$gp7.1280333@newssvr21.news.prodigy.com>

RALPHNOBLE wrote:
> A state agency has a database I need and they run Oracle. They are telling me
> it's way too difficult to export data from Oracle to Excel, Dbase or an ASCII
> text file. Can anyone who uses Oracle advise if such is really that hard, and
> let me know what's involved????
>
> Thanks,
>
> Ralph
>

Depends on what you mean by "has a database."

If you want all the tables owned by a particular schema owner - They would need to write a sql script that wrote the DDL for every table owned by that userid. If they were clever, they might be able to get away with a single script that extracted all tables in a particular schema.

If you want the data too, that would be yet another set of scripts.

If you want more than tables (eg, procedures, indexes, etc), then it gets tougher very quickly.

Bottom line: it could be anywhere on a continuum between extremely easy and impossible. Received on Tue Nov 26 2002 - 18:50:16 CST