Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Copy data from one database instance to another on the same server
"Frank van Bortel" <frank.van.bortel_at_gmail.com> wrote in message
news:eidoeq$t45$1_at_news4.zwoll1.ov.home.nl...
>
> If they are really temporary tables, the methods
> described won't work. You can:
> - use an insert into remote table from temporary
> table during the session
> - use an insert into local table from temporary
> table, and use one of the methods described
> by others.
>
> The fact you use temporary tables and want to
> copy them, makes me fear your mistake oracle for
> an other product, and you are not using temporary
> tables at all.
> --
Sorry... I meant temporary as in
tables-that-I-have-created-for-a-temporary-purpose, not Temporary Tables!
I wondered whether it might be misconstrued and should have used another phrase. Received on Fri Nov 03 2006 - 04:31:48 CST