Re: There's gotta be a better way...

> Let's see, I gotta make this table. Cool. Made the tablespace, even
> setup a new schema with a cool new user that owns everything. Great.
> New table. Hot dog, I'm cookin now.
>
> Now I've got to add columns. Wait a minute, this ain't as swift as it
> was with any other data system I've used. I'll try "DBA Studio". And
> if I work at it, I can add one column a minute. This aint working.

You made the table then you tried to add the columns? Why not denote the columns at the same time you made the table? No wonder you aren't happy. You tried to take two steps to perform a one step operation. And this isn't Oracle's way of doing things. This is the database community's method defined in the SQL-92 standard. Just because you don't know how to drive the car doesn't make it a bad automobile. Once you learn how to use the clutch, you'll never go back to an automatic transmission......

Just my 3.14159265 cents worth,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================