Re: How to dump all tables belong to a user into multiple flatfiles

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 03 Sep 2002 13:38:30 +0200
Message-ID: <2k79nu8vsnocem6csoihkpiret56shcbrs@4ax.com>

On 3 Sep 2002 00:23:12 -0700, allanwtham_at_yahoo.com (godmann) wrote:

>Hi there,
>
> I do not think I need to use Utl_file.
>
> I know how to dump tables one by one into delimited flatfile.
>But how to modify the script to make it dump ALL tables belong to a
>user say Scott into multiple flatfile named after the table itself?
>
> See example script at http://www.jlcomp.demon.co.uk/faq/flatfile.html
> Thanks.
>
>Allan

write a script to call the script above repeatedly, and remove what you don't need anymore.
IMO the purpose of this group is not to ask others to develop code for you for free.
You could also consider using a tool called TOAD, which is going to replace the *dinosaur* sqlplus, according to the principal TOAD developer. See the discussion on Qsqlplus in news:comp.databases.oracle.misc
But developing your own script calling the script from Jonathan's side would be definitely cheaper than buying TOAD

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Sep 03 2002 - 06:38:30 CDT