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

["Biekens, Jan-Hein" <jh.biekens@kwantum.nl>]

You could use the copy command in SQLPlus.

The syntax is:

copy from user/password@connectstring to user/password@connectstring
[append/create/insert/replace] table_name using subquery]

Using the appropriate connectstrings you could copy between databases.

f.i.
copy from scott/tiger@db_name to scott/tiger@db_name create copy_emp using
select * from emp
would create a copy of emp, including long fields (if present).

Note that in SQLPlus you have to enter the command on one line. A new line
is not allowed.
The command will not work through SQR however (at least not in version
4.3.2).

Regards,

Jan-Hein Biekens




>>> 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