Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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