Re: [sqr-users] SQL - Coping tables with Descrlong field.

["George Jansen" <GJANSEN@aflcio.org>]

If it is to be the same table name in another schema, you can use export and 
import to accomplish this.

If it is to be in the same schema, then you'll either have to code 
something--PL/SQL, Perl DBI, etc., or, if you have the space an 
export/import/rename/export/import cyle.

exp tables=table_with_long.....
scott/tiger

imp fromuser=scott touser=larry
larry/boat

sqlplus larry/boat
rename table_with_long to yatwl;

exp tables=yatwl........
larry/boat

imp fromuser=larry touser=scott.......
scott/tiger

>>> skfisher@ou.edu 11/08/02 02:44PM >>>
I need to make a duplicate of a table, on Oracle, with a descrlong field.  I
tried using the "Create table .. as", but that doesn't work because of the
descrlong.  Any ideas?

Thanks



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users