Hi,
Anybody ever use sqlldr to load multiple databases at remote locations
at the same time, in parallel. I've tried logical standby and the sql
apply engine does not support critical tables. Physical standby will
not work since we need 24/7 access. Currently we have one site that
loads schema "a" while schema "b" is used This is application drive to
switch queries to the alternate scheama while one schema is being
loaded. I need to duplicate the process at a remote location with the
same database structure.

Normally I use Dataguard with a logical standby, but DG does not support
critical tables and datatypes. like user defined, function indexes,
stuff like that. Any idea's would be super appreciated. I know there
must be a simple solution.
Thanks to all!
Craig



Oracle LazyDBA home page