Sent: Tuesday, August 13, 2002 9:18
AM
Subject: Another Transferring data from
one table to another fast Q
How
about if your table has (I didn't do it) a LONG column. CTAS doesn't work and
I don't see the nologging option for the ccopy command - in 8.1.6
anyway
Title: RE: Transferring data from one table to another
How
about if your table has (I didn't do it) a LONG column. CTAS doesn't work and I
don't see the nologging option for the ccopy command - in 8.1.6
anyway.
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL
:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Tuesday, August 13, 2002 9:18 AM
To: Multiple recipients of list ORACLE-L
Subject: Another Transferring data from one table to another fast Q
How about if your table has (I didn't do it) a LONG column. CTAS doesn't
work
Title: RE: Another Transferring data from one table to another fast Q
Yes, but direct SQL with CTAS is faster. Of course, could put nologging on table after creation but then need separate ddl script. Still like CTAS.
-Original Message-
From: Baker, Barbara [mailto:[EMAIL PROTECTED