newbie: a couple of quick questions on design

Hi all,

I am new to Oracle 8i, and I wondered if someone would be so kind as to answer a few quick questions. I have had previous experience with MSSQL7. I'm trying to get to grips with security and tablespaces.

I'm creating a DB for a web application, it is a sort of library app in that it will require users to log in before they are able to have access to Word doc's/PDF's/JPG's etc. which I will be storing in the DB.

So far I have created a new tablespace (which is where all my tables, procedures, triggers etc will be located) and a user who has this tablespace as their default, this user has DBA priveledges(create/edit/delete tables, triggers, procedures etc). I am using this login as the equivilant to sa in MSSQL7, I will then create a second user who has restricted rights as user, i.e. what the Web app will use to login. Am I heading in the right direction with this or should I be doing this differently?

As I mentioned above I wish to store Adobe Acrobat documents(PDF), MS Word Documents, Images (gif, jpg, png), XML Documents in the DB, which datatype should I use for these, I'd like to store all of these in the same column, is this practical? is it practical to store all of these in the DB, or should I just store external links to these?

Any help would be gratefully received, I have a feeling that I will be asking quite a few questions over the next few weeks, until I get a bit more used to oracle, if anyone would be willing to take me under there wing so I can bounce a few questions/thoughts at them, it would be a great help.

Cheers in Advance

Steve Received on Sun May 13 2001 - 02:52:15 CDT