Re: URGENT HELP NEEDED!

Never used Em for these things. I think it used to have an option to view the sql that it generated. (before it did anything) Jim

--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"Doug Baroter" <qwert12345_at_boxfrog.com> wrote in message
news:fc254714.0301080650.50a3362d_at_posting.google.com...


> I've no problem with command line to get things done, I was just

> reporting the lousy EM, and you know what, yesterday I tried to delete

> a PK for a table, the EM drop the whole table without warning, a piece

> of *.

>

> "Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message

 news:<3eNS9.676032$QZ.101269_at_sccrnsc02>...


> > Learn how to do these things via the command line interface.  Then you


 can


> > make sure it is doing what you want it to do.  I don't know, but maybe


 it is


> > pilot error.  If it isn't backed up then it isn't that important is it.


> > Jim

> > "Doug Baroter" <qwert12345_at_boxfrog.com> wrote in message

> > news:fc254714.0301070655.48810c25_at_posting.google.com...

> > > This is a testing db, I don't have a backup.  But HOW would Oracle9i

> > > drop an entire table while asked to delete an empty column in the

> > > first place???  Thanks.

> > >

> > > alex ivascu <alexdivascu_at_nospam-yahoo.com> wrote in message

 news:<3E1A7033.7_at_nospam-yahoo.com>...


> > > > from backup.


> > > >

> > > > Doug Baroter wrote:

> > > > > With Oracle9i on NT, I intended to drop a new column that I just

> > > > > created in an existining table using Enterprise Manager(EM) but

 the EM


> > > > > just drop the whole table.  How can savage the table?  Many many


> > > > > thanks.