Home -> Usenet -> comp.databases.oracle -> "chown"/copying of table with LONG data type possible?

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

From: Almut Herzog <al-her_at_sectra.se>
Date: 1996/05/13
Message-ID: <31973E61.36BF_at_sectra.se>#1/1 







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


Received on Mon May 13 1996 - 00:00:00 CEST












Original text of this message