Re: fix table. HOW TO?

From: Vadim Grepan <kezal_at_mail.ru>
Date: Thu, 8 Jul 1999 11:10:19 +0400
Message-ID: <7m1iuk$vap$1@storm.comstar.ru>

Hello Filip!

Filip Hanik пишет в сообщении ...
>You cant delete columns or rename them in Oracle.
>I think it is fixed in Oracle 8i.
>
>If you use some sort of modeling tool, like Erwin, the usually will
generate
>a script to recreate the table and all its dependencies.

However, if table consists data, I have to move all rows by hands, isn't?

>> I've in my table (record) some fields, which I want to delete. I know
>how
>> update fields (e.g. increse or change type), but I don't know how delete
>> they permanent, with useless data?
>>

Rgds, Vadim Grepan

---

kezal_at_mail.ru
2:5020/653_at_fidonet.org Received on Thu Jul 08 1999 - 02:10:19 CDT