Seems like a ton of work and how to populate this field.
Jim
"Richard Nield" <richard.nield_at_ntlworld.com> wrote in message
news:Daxy8.8985$Mi.1299727_at_news2-win.server.ntlworld.com...
> Hi...I was wondering what the general opnion of my problem below muight
be.
> I had just finished creating and population our new db for 2003/2004,
when
> the client contacts me with some changes he needs fro this year. When I
> look into his requiremts, I see the only way I can complete the task is by
> adding a new field to the ITEMS tablle. But that's ok, I think, I can use
> an ALTER statement to update the table in sqlplus and update the ERD in
> designer later.
> I tell my boss what I planned to to do and he says that I am not allowed
to
> do that I have to:
>
> 1. Exoport the data from the current DB.
> 2 Drop the schema
> 3. Update design and generate the DDL
> 4. Create new scehema and run the DDL
> 5. Import the data.
>
> My question is: is this the "way to do it " or is he just being
> dificult?
> Mny thanks for any advice!
> Richard N
>
>
Received on Sat Apr 27 2002 - 10:06:02 CDT
