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/
Received on Mon Feb 05 2001 - 07:02:11 CST
