File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Oracle/OAS and the fly likes Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark ""oracle 9i Client" and "Oracle 9i personal edition" " Watch ""oracle 9i Client" and "Oracle 9i personal edition" " New topic

"oracle 9i Client" and "Oracle 9i personal edition"

ben oliver
Ranch Hand

Joined: Mar 28, 2006
Posts: 375
I want to have the following two things --

1. I work on Windows Xp, would like to have a tool to access remote Oracle database installed on a Unix server. I heard "Oracle Client" is good for this, so I installed one and now I can use its "SQL Plus" to access the remote database installed on unix.

2. But I still want to have a locally installed Oracle database (on my PC) to play around without messing up the remote database that is accessed by many people. I don't think installing a "Oracle client" is enough. Does "oracle Client" give me a local oracle database ? I guess not. Somebody mentioned "oracle personal edition" which will give me a local windows Oracle. Is that true ? If yes, then can I install the "oracle personal edition" after I finish installing the "oracle client" ? will it cause any conflict or problem ?
Jeremy Wilson
Ranch Hand

Joined: Feb 18, 2003
Posts: 166
I would use Oracle 10g Express Edition. It is a freely available database to support what you are looking for.

Jeremy Wilson
I agree. Here's the link:
subject: "oracle 9i Client" and "Oracle 9i personal edition"
It's not a secret anymore!