Windows Phone 7 Developer Launch - Learn More

Oracle

There are 4 entries for the tag Oracle

Lost in Translation: Oracle 10g2 client hell

This is a post I've been meaning to write for a while. I had quite a bit of trouble getting the Oracle client working properly since I started with my current client. I've never used Oracle before and so it's been pretty frustrating since I've wanted the opportunity to work with it for a long time. But it turns out that the solutions have been pretty simple. Here's a list of some of the problems I've run into and their solutions: Use Admin install – When it comes to software/services that open up ports to the...

Lost In Translation – Episode 3: Users and Schemas

In my last post I mentioned I would be addressing tables next, but as I read through the documentation I realized something. Because Oracle doesn't have the same concept of databases as SQL Server I need to use schemas to segregate my data. In order to create a schema you must create a user. When you create a user in Oracle, a schema is implicitly created. Which means I need to create a user so I can place my tables and other database objects into a schema. I'll be using scripts in this episode instead of screenshots because...

Lost in Translation – Episode 2: Tablespaces

Recap In Episode 1 I addressed database instances but I'd like to correct a technicality. I compared SQL Server instances with Oracle Database instances. While this is pretty much correct, I'd like to add that technically this isn't correct. At least not according to Oracle's documentation. If you look on your installation disk for the docs directory I recommend reading the 2 Day DBA document. So far I'm finding it very valuable. Here's a quote from the Chapter 2 overview: After you create a database, either during installation or as a ...

Lost In Translation - Episode 1: Database Instances

I have been using SQL Server for about 8 years now. When compared to my peers (read: coworkers) I would classify myself as a SQL Server guru. When compared to many I meet on sites like SQLServerCentral.com where there seem to be those I would classify as SQL Server gods I feel small. When working for MaxPreps.com I was forced to sink or swim and had to learn in depth details about things like replication, mirroring, partitioning and the intricacy of the proceedure cache, execution plans and the query optimizer. So I have had the opportunity to really learn a...

 

 

Copyright © Mark J. Miller