Re: How to rename a column name?

From: AleX <korrozia_at_my-deja.com>
Date: Thu, 16 Sep 1999 02:15:55 GMT
Message-ID: <7rpjsj$f1b$1@nnrp1.deja.com>

In article <37de951e.458746_at_news.siol.net>, jmodic_at_src.si (Jurij Modic) wrote:
> On Mon, 13 Sep 1999 17:18:24 -0500, Tapan Trivedi
> <tapan.trivedi_at_abbnm.com> wrote:
>
> >You can export the table. Create a table of the required structure
that
> >you like and import the data into the new table.
> > Tapan
>
> This will result in "ORA-904: invalid column name". You can't import
> into existing table if the table structure (column names, data types)
> is not exactly the same as the one in the dmp file.
>
> Regards,
>
> Jurij Modic <jmodic_at_src.si>

Not true. You can export/import as long as the starget table has all the columns that the source table has.
--

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 15 1999 - 21:15:55 CDT