Re: Oracle 8i Server Questions.

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 - 04:09:57 CST