Re: Import + Sequences

From: Anurag Varma <avoracle_at_gmail.com>
Date: 14 Mar 2006 07:49:31 -0800
Message-ID: <1142351371.436983.99150@i40g2000cwc.googlegroups.com>

Ed_Zep wrote:
> Sorry, just to clarify. We're on Solaris 2.8.
>
> The steps being:
>
> Users are connected via the net (Oracle apps servers). I kick the users
> off and start the export (step 1).
>
> 1. Full SYS export of everything.
> 2. Full import, no rows, no indexes, no constraints, disabled triggers
> 3. Full import, rows, no indexes, constraints.
> 4. Full import, no rows, indexes, constraints (ok, did those twice)
>
> re-enable triggers, compare source and destination databases.
>
> The problem is the sequences.
>
> Any ideas?
>
> Thanks, Ed.

I'm surprised you don't have bigger problems than just sequences. A SYS export does not respect the consistent=Y parameter. So essentially you are doing a full export which is not consistent.

Never do export as SYS!

Anurag Received on Tue Mar 14 2006 - 09:49:31 CST