Re:modify a column from char(5) to varchar2(5) causes ora-02

From: <dgoulet_at_vicr.com>
Date: Thu, 25 Jan 2001 13:08:38 -0500
Message-Id: <10752.127524@fatcity.com>

Junxian,

    Is this column part of a foreign key?

Dick Goulet

____________________Reply Separator____________________

Subject: modify a column from char(5) to varchar2(5) causes ora-02267 Author: "Liu; Junxian" <Junxian_Liu_at_thomson.co.uk> Date: 1/25/2001 8:10 AM

Hi,

I am using ALTER TABLE MODIFY to change the type of a column from CHAR(5) to VARCHAR2(5), but gets ORA-02267 error?

Would it be that the column is part of an index the problem?

Any help would be appreciated!

Junxian Liu

---

This email and any files and/or attachments transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed.

If you have received this email in error, please notify the Systems Manager at Thomson Holidays Ltd., by telephoning +44 (0)20 7387 9321, by reverse charge or collect call if you wish.

You are not permitted to disclose the contents of this e-mail and of its attachments to any other person, nor make copies or transmit it to any other person without our written consent.

This email has been swept for computer viruses.

---

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Liu, Junxian
  INET: Junxian_Liu_at_thomson.co.uk

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 Jan 25 2001 - 12:08:38 CST