Re: Tables no longer exported in sorted sequence

From: A.Liggins <A.Liggins_at_hotmail.com>
Date: Thu, 14 Jun 2001 22:30:21 +0100
Message-ID: <9gbaru$ips$1@uranium.btinternet.com>

If you are doing a full export, this may be because the dependancies of the tables have changed, i.e
parent key/child constraints, hence Oracle does the parents first then the children (possibly).

Alun

<dana.stockler_at_hydro.com> wrote in message news:9g6vts$1ep$1_at_vkhdsu24.hda.hydro.com...
> When exporting from one of my databases, the table names
> are no longer listed in sorted (alphabetical) sequence.
>
> I have ten instances in two servers and perform daily exports
> from all of them. The export program has always listed the table
> names in sorted order. Suddenly, for one of the instances, this
> has changed. The problem apparently began after the database
> was restarted.
>
> Any one out there have any ideas?
>
> I am running Oracle 8.0.6 on Windows NT4.
>
> Regards,
> Dana Stockler
>
Received on Thu Jun 14 2001 - 16:30:21 CDT