Re: ORA-03113 Error

Al Willis wrote:

> Hi,
>
> Please pardon the length of this post, but I thought that it might be
> important to show the table schema data.
>

> /* START OF TABLE DEFINITION FOR LOOPDAT */
> CREATE TABLE IM.LOOPDAT (
> LOOPNO VARCHAR2(20) NOT NULL,
> SHEETNO VARCHAR2(15),
> DRAWINGTYPE VARCHAR2(5),
> DRAWING VARCHAR2(40),
> LOOPMODEL VARCHAR2(20),
> BLOCK01ON VARCHAR2(1),
> BLOCK02ON VARCHAR2(1),
> BLOCK03ON VARCHAR2(1),
> BLOCK04ON VARCHAR2(1),
> BLOCK05ON VARCHAR2(1),
> BLOCK06ON VARCHAR2(1),
> BLOCK07ON VARCHAR2(1),
> BLOCK08ON VARCHAR2(1),
> BLOCK09ON VARCHAR2(1),
> BLOCK10ON VARCHAR2(1),
> BLOCK11ON VARCHAR2(1),
> BLOCK12ON VARCHAR2(1),
> BLOCK13ON VARCHAR2(1),
> BLOCK14ON VARCHAR2(1),
> BLOCK15ON VARCHAR2(1),
> BLOCK16ON VARCHAR2(1),
> BLOCK17ON VARCHAR2(1),
I'll pardon the length of the post ... but not the table definition. Based on the above you have no business touching a keyboard.

I would suggest you push back from your desk, very slowly pick up the telephone, and call someone in your area that teaches a concept called relatonal database theory and normalization.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)