Actually, I stand corrected. Oracle has no real equivalent to SQL Server (or PostgreSQL or MySQL) database entities.
L
LordHunter317
@LordHunter317
0
Reputation
2
Posts
87
Profile views
0
Followers
0
Following
Best posts made by LordHunter317
This user hasn't posted anything yet.
Latest posts made by LordHunter317
-
RE: Why the I-Hate-Oracle Club?
-
RE: Why the I-Hate-Oracle Club?
@swami said:
It's a standard, even. And most Windows users don't care about the space in the name.
Please tell me you're joking. This is a Windows cultural VALUE? Most Windows people hate this damn thing because the space screws everything up.You know, GUIs and all that. Kind of a wonderful invention, you know.
You can also configure the Oracle base directory when installing your software. Though, like most software, it probably wouldn't like a path with a space in it.
Windows software that can't tolerate spaces in filesnames is in the minority these days.
That would be your problem, not Oracle's. Plenty have figured it out, it's also the most documented and written about database in the world.
To me, the fact that so many people have had to write about it tells me it's very difficult to figure out and use. Oracle is an extremely complex beast, evidenced by the fact DBAs frequently can't do development roles, and developers frequently can't do DBA roles. Which is just silly when you think about it. Save for initial setup and maintaince (which really should be automatic) all the DBA should ever have to do is change the backup tapes.
<FONT size=2>
Right, because it's so much fucking work to read a goddamn QUICK START guide or CONCEPTS manual that explains excatly how Oracle works, inside and out, in plain english. Your heart bleeds for me, really.
Except it doesn't. It explains the how, not the why.</FONT><FONT size=3>
</FONT><FONT size=2>
Actually, it is up to the database. But you would need to gather statistics on the tables (which you need to do in SQL Server too).
No, you don't. You may see less than opitium performance if you don't, but at least the indexes will be use, unlike in Oracle, where apparently they won't.</FONT><FONT size=2>
Right. Do you know how adorable you're being right now ? Please point me in the direction of software that does this.
PostgreSQL w/ pg_autovaccum seems completely maintaince void, save for the occasional need for index recreation in some corner cases. They're working to eliminate that too, as I understand it.</FONT><FONT size=2>So it's more than possible.</FONT>
<FONT size=2>Learn the f'ing database, all the documentation is FREE,
My Free oracle account seems to not be able to access anything.</FONT><FONT size=2>
the database download is FREE,
And is severly limited. It works for development, but that's it. It may not even work for delpoyment testing due to the connection limitations.</FONT><FONT size=2>
ALL STANDARDS? WHAT FUCKING CRACK ARE YOU ON and can I have some? "Program Files" is a silly abomination!
It's also MS' standard so I'll have to kindly suggest that you're the one on crack.</FONT><FONT size=2>
Right, only all of the world's military systems are written in Ada.
Very little military stuff is written in Ada, as it turns out. It never caught on the way the DoD wanted it to for a variety of reasons. When it was first introduced, it frequently didn't perform or didn't run on lots of H/W targets, by the time that was solved, it got displaced by other solutions. That's not to say it isn't used, but it's not even all that common in the US DoD. I know maybe two or three people total who've worked defense their whole lives and know ADA.</FONT><FONT size=2>
A "database" in SQL Server terminology is just a logical grouping of database objects, users, and data files.
It's more than just a logical grouping.</FONT><FONT size=2>
Closest thing Oracle has to this is the "schema" , which is private to a user.
I'm no Oracle expert, but I believe a tablespace is much closer.</FONT><FONT size=2>
It's a different thing that an Oracle database instance, which is the equivalent to creating a new master SQLServer database.
Commonly called a database catalog or cluster.</FONT>