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

Almut Herzog (al-her_at_sectra.se) 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.
:

The Sql*Plus 'COPY' command will copy long data fields.

If you're a DBA, you could also export as one user and import as another.

Joe

-- 
                                   
=-------------------------------------------------------------------------=
Joe Nardone <joe_at_access.digex.net>                  
  "The most beautiful thing we can experience is the mysterious.  It is 
  the source of all true art and all science.  He to whom this emotion
  is a stranger, who can no longer pause to wonder and stand rapt in awe,
  is as good as dead: his eyes are closed." - Einstein


-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: 2.6.2

mQBtAzCg5QoAAAEDANvEmc4OAT8wntnCv8UPjyD2kohKVGa1CU21PLpYljzl3AE7
pldpNNscKSoE//aVMKYBO+tRFTTsPNi0qZ6CDlEBXTgJAiszoHh1qCzZyYj7FTBL
YoUr+3sk9rU8Pma6AQAFEbQiSm9lIE5hcmRvbmUgPGpvZUBhY2Nlc3MuZGlnZXgu
bmV0Pg==
=1ocE
-----END PGP PUBLIC KEY BLOCK-----