try
copy from scott/tiger_at_hq create <table_name>using select * from<tablename>;
Ravindran.
- Original Message -----
From: Veera Prasad <vprasad_at_olf.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Wednesday, October 11, 2000 3:40 PM
Subject: Re: Create table thru subquery have problem
> I don't see any problem creating table the way you defined..
> Try this way
>
> create table <table_name> as select * from <schema_name>.<table_name>;
>
> Veera
>
> mala singh wrote:
>
> > Hi all
> >
> > I have problem at time of creating the table thru subquery like
> >
> > create table test_bak as select * from test;
> >
> > The test has one column either LONG or Long Raw type.Can ANy one help
me.I
> > have other option to create the table but I want to create the table the
way
> > I defined eariler.
> > thanks in advance.
> >
> > Mala
> >
> > Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com.
> >
> > Share information about yourself, create your own public profile at
> > http://profiles.msn.com.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: mala singh
> > INET: mala_singhm_at_hotmail.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Veera Prasad
> INET: vprasad_at_olf.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Oct 12 2000 - 17:47:50 CDT
