Re: Oracle versus Microsoft Sqlserver 2000

go to qwest and download toad. sqlplus is for running scripts.

schemas vs databases is really a minor thing and more of a name difference.

Learn the transaction model differences, much different than db2.

You have much to learn about Oracle technology; seems like you are a GUI guy - judge technology by the GUI they give you. Jim

"Mike" <mike.mcneer_at_umusic.com> wrote in message news:81ffd231.0203141223.1f5eceed_at_posting.google.com...
> Been using DB2 for about 4 years and am now forced to use Oracle . So
> far Oracle is looking like a big piece of crap compared to DB2. Whats
> with this SQL *PLUS Worksheet for one thing? Still havent found a way
> to stop a query from executing... Its the worst looking and using tool
> for a database I have ever seen. Google advice is to get a third
> -party tool(???) for queries. Db2 = all tools I need to excute
> queries. I will admit the javatools can be kinda buggy in Db2 but
> Oracle doesnt even come close to the functionality. Also Whats with
> one database per instance?? That another major setback. From what I've
> seen people get by this by having multiple schemas under one instance
> not good in my opinion. For Oracle to be a database only company I
> would think they would have better tools and technology than Db2 or
> SQL Server but from what I see its not there. The one thing I have
> seen that I like is the little gui thing that shows you how the memory
> is being used by tablespaces and bufferpools. As far as SQL Server is
> concerned never has and never will be a real Relational Database. Yes
> good for small companies and tasks but would never use it in the
> Enterprise. Also I dont understand how some people tie themselves into
> Microsoft products..apparently there not doing their research...
Received on Fri Mar 15 2002 - 00:08:07 CST