No, there is an option:
1.export table schema1.a (a1, a2);
2. drop table schema1.a;
3. create table schema1.b (b1, b2);
4. create view schema2.a as select b1 as a1, b2 as a2 from schema1.b;
5. import fromuser=schema1 touser=schema2;
--
Good luck!
Wit, Oracle DBA
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:954792284.21848.0.pluto.d4ee154e_at_news.demon.nl...
> No, there isn't. After all the export file just contains ordinary insert
> statements.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Kyriakos Lambros <kyriakos.lambros_at_lvvwd.com> wrote in message
> news:38E8F4B1.10D2DB5_at_lvvwd.com...
> > Is there a way to re-name a column when you import a table? When I try
> > to just enter a different column name from the import utility it fails
> > when it runs into the column name it doesn't recognize.
> >
> > Thanks in advance,
> >
> > Kyriakos Lambros
> >
>
>
Received on Mon Apr 03 2000 - 00:00:00 CDT
