Re: Oracle 8i Server Questions.

In article <3a7ea421$1_at_news.kos.net>,
  "dgdss" <dgdss_at_hotmail.com> wrote:
> With DB Assist you can specify and change the parameters as long as
 you do
> not install a 'typical' DB , make it a custom install and you can
 size,
> place datafiles etc.
> "Dennis" <dwehlman_at_my-deja.com> wrote in message
> news:95lu5i$dse$1_at_nnrp1.deja.com...
> > RK,
> >
> > In article <3a7e419c_at_news.iprimus.com.au>,
> > "R Kinaadman" <rokin_at_iprimus.com.au> wrote:
> > > Hi all,
> > >
> > > Just starting out with Oracle 8i.
> > >
> > > My apologies if these questions have been asked already.
> > >
> > > Where are the database files kept in Oracle 8i. For example, SQL
 Server 7
> > > keeps them in the mssql7\data\ folder under the name of the
 database
 and
> > > with the .mdf extension. Is there a similar type of setup with
> > Oracle????
> >
> > With Oracle you can save your files anywhere you want, e.
> > g. /oracle1/SID/system.dbf or /oracle2/SID/user.dbf I never used the
> > dbassist to create a standard database so I don't know where is the
> > standard location.
> > Run select * from v$datafile; to find more about your data files.
> >
> > > Creating new databases seems to be a long process using the gui
 Database
> > > Configuration Assistant. Is there a quicker way or does it usually
 take very
> > > long?
> >
> > You can write an init.ora file, a create database file and run it
 with
> > svrmgrl. The duration of creating a database depends on file sizes.
> >
> > >
> > > Lastly, Are there any good reference material that covers these
 type
 of
> > > questions I'm asking. I don't particularly like the Oracle -
 Complete
> > > Reference book as it deals mainly in Sql language and not
 Server/System
> > > setup and config of Oracle 8i.
> > >
> > > Thanks in advance.
> > >
> > > RK.
> > >
> > >
> >
> >
> >
> > Dennis
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/

>
>

You can also move the datafiles after you create the database. You can even do this while the database is up, provided it is not a system datafile.

--
nw3


Sent via Deja.com
http://www.deja.com/