Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Fast unload of entire DB...(tools)
Most of the utilities I've seen create the control file for each table as
they unload it. I use a Pro*C program to do that, but you could write it
all in a SQL*Plus script, since all the information needed by the control
file (*.ctl) is stored in the data dictionary already.
Thor HW
BJ Miller wrote in message <700hvv$8d5$1_at_cletus.bright.net>...
>If you haven't seen my previous post, I have a customer who is migrating a
>database from one system to another (frequently).
>They are exporting to tape (SLOW!).
>
>I have investigated 'fast' unload tools for them, and have found that they
>all work with SQL Loader to reload. This would be great, however it
appears
>that in order to unload/load the entire database I need to create a
'control
>file' for each object. This app is Oracle Financials 10.7 with about
every
>option known. Creating an unload control file for each object would be as
>much of a hassle as the present problem. Obviously I am missing something.
>
>Is there a way using these tools (BMC or Platinum) to fast unload the
entire
>DB? Is there a tool that creates the necessary files?
>
>Big thanks in advance,
>BJ
>
>
Received on Tue Oct 13 1998 - 21:48:38 CDT