Re: "chown"/copying of table with LONG data type possible?

Almut Herzog wrote:
>
> Hi,
>
> is it possible to "copy" a table containing a LONG datatype?
>
> "create table my_emp as (select * from emp);" would not work if emp
> contains LONG-columns.
>
> How else do I copy a table owned by SYSTEM to user SCOTT?
> As far as I know it is not possible to export as one user, and import as
> another; and I am not sure I like the idea of ASCII-imports.
> --
> Almut Herzog
> SECTRA Secure Transmission AB e-mail: al-her_at_sectra.se
> Teknikringen 2 voice: ++46 13 235221
> 583 30 Linkoping fax: ++46 13 212185
> SWEDEN
Almut,

Import actually allows you to change the ownership of objects. Use the FROMUSER and TOUSER parameters.

Dinesh Received on Tue May 14 1996 - 00:00:00 CEST