Tarby777 wrote:
> Hi all,
>
> I'd appreciate your help with a problem that I've got at the moment.
> I'm running a script that applies the delta DDL that is required to get
> the database from one version of my app to the next. The script also
> does some DML after applying the schema changes. There are no other
> sessions running. I'm getting this error in the script's logfile:
>
> Sequence dropped.
> Sequence dropped.
> rename TEMP_MULTWIRE_SEQ to MULTTERM_SEQ
> *
> ERROR at line 1:
> ORA-03113: end-of-file on communication channel
>
> This is happening at a point in the script where I'm dropping two
> existing sequences, and renaming two other sequences (which are created
> earlier in the script) so that they have the same names as the
> sequences that just got dropped:
>
> drop sequence MULTTERM_SEQ;
> drop sequence WELDWIRESPEC_SEQ;
> rename TEMP_MULTWIRE_SEQ to MULTTERM_SEQ;
> rename TEMP_UWELD_SEQ to WELDWIRESPEC_SEQ;
>
> Now, what's confusing me is that the trace file generated at the time
> of this error doesn't mention the sequences but it does complain about
> a deadlock on a table that has just had several DDL operations applied
> to it. Here's the trace file:
>
> [start of trace file]
> (snip)
>
- Is your session in fact the only one accessing the schema/table?
(Jobs, Rollbacks, etc.)
- I guess you are running some tests here? Where does the test schema
come from? (via IMP ?)
br,
Martin
Received on Thu Oct 19 2006 - 09:11:21 CDT
