Re: Newbie

> I installed the database and can log in withut a problem, but is there a way
> to create different database files, like for instance Access will open and
> you can have several different database files to open and work with. Or is
> oracle just one big global application?
> How do I set up ODBC on Win2k to access my oracle DB as a back end and use
> Access as my fromt end? I am aware that this is not the best solution, but
> it would provide a good learnig tool on my own machine where I have all the
> necessary permissions.
> Any help in my getting started with Oracle is greatly appreciated.

I think you should read some core documentation about Oracle concepts. I can give you some hints now, but it won't help you as you don't know what you are doing when you just copy the given statements. Nevertheless, just to answer your question, in Oracle you can create as many database files as specified during the creation of the database. Database files always belong to a tablespace. In an Oracle database there is always a system tablespace. Database users shouldn't use this tablespace to store their objects. In a default database there is a users tablespace where database users store their data. During creation of database users you can define which tablespace should be the default one (when you create a table without specifying a tablespace the table will be created in the default tablespace). So if you want your Access application to make use of a specific tablespace just create a new one (with the CREATE TABLESPACE command) and create a user with the new tablespace as the default one.
To access your DB via ODBC create a new system or user DSN, define the name and the server of your Oracle DB and start working. Look at http://technet.oracle.com for more information.

Regards,

Knut Received on Mon Apr 08 2002 - 07:34:59 CDT