Oracle 11G Express Edition - 101
Posted on 2011-09-16
OK.. forgive me if these are silly questions, but I'm confused. I'm a SQL Server guy and I have a client who wants me to do some reporting from his Oracle 11G database. Thinking like a SQL guy, I figured no big deal. So, I downloaded the Express Edition of Oracle and installed it on one of my machines. I clearly need a little kickstart here - or someone to tell me that I'm doing this all wrong. I figured I could have my client back up his database and I could restore it on the Express Edition and take a look around. Then I figured I could build my own database and do my tables and queries with data imported from his (I also need some data which is not in his Oracle DB), so I didn't mess up his database. Apparently this isn't the way it works.
First issue - it looks to me like EVERYTHING in Oracle Express is in ONE database, differentiated by "tablespaces". Is this true? Does this totally destroy my plan to restore the client's database to my machine? Secondly - I'm not crazy about the data management tools that come with Express. I see that there is something called Oracle Enterprise Manager (which I assume is like SQL Server Management Studio), but I don't see an easy way to get it or make it work with Express.
Can someone just give me an orienting kick in the pants to get me going in the right direction - or tell me not to try to do what I'm trying to do?