Re: how to copy a table

On Sun, 30 Aug 1998 12:16:14 GMT, abhijit_jadeja_at_hotmail.com wrote:

>Dear Friends,
>
>I want to create a temporary table from the existing table
>using
>create table temp as select * from orig;
>but orig table consists a long column, so I am unable to do it.
>This is on Oracle.
>Can anybody suggest a one step alternative?
>Thanx in advance,

You can use SQL*Plus COPY command. It can copy tables with long collumns. Yust dont forget to set the Sql*Plus environment variable LONG to an appropriate value. For exact syntax for COPY commandlook at the Sql*Plus manual, but basicaly it is something like

COPY FROM scott/tiger_at_my_db TO scott/tiger_at_my_db CREATE new_tbl - USING SELECT * FROM old_tbl

>Abhi

HTH,

--
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)
================================================
The above opinions are mine and do not represent
any official standpoints of my employer