Database creation 
Author Message
 Database creation

Oracle Database structure is a little bit strange for me, especially the
database structure based on (if I have correctly understand !) multiples
files and one instance.
Why can't the database be located in only one file ?

If I get a file *.odb from somewhere else (it's the one which contain
tha data I think), how can I build an instance associated with this file
?

Do I have to build another database and import the data from this file ?
If yes, what is the procedure (I've read something about a control file
to load data, but nothing else...)

Thanks a lot for any explanations...



Wed, 18 Jun 1902 08:00:00 GMT
 Database creation

Hi Oliver,

First:
Oracle splits up the datafiles for several reasons:
(1) for security issues: you can place several files on different disks to
avoid data loss
(2) performance issues: imagine you place an index (physically) on a
differnt hard disk than the datafiles
etc.

Second:
I don't know *.odb Files

Third:
Control Files store information about the database-structur (where are the
different files located, etc.) They have nothing to do with your *.odb File
(whatever this is)

I think I can't tell you how to set up an oracle-database in a short way
(but if it is a small database just install a sample database and start form
using this one...) I suggest - to read the ORACLE Database Administrators
Guide

Oracle provieds tools to load data into an existing database:
(1) Import/Export Tool:
You can export form an existing ORACLE Database and then import this data
for example in another ORACLE Database (e.g. new version)
(2) SQL*LOADER
With this tool you can load data contained in an ascii-File with a variable
format (you have to define this format) into an oracle database.

good luck
-Walt-


Quote:
> Oracle Database structure is a little bit strange for me, especially the
> database structure based on (if I have correctly understand !) multiples
> files and one instance.
> Why can't the database be located in only one file ?

> If I get a file *.odb from somewhere else (it's the one which contain
> tha data I think), how can I build an instance associated with this file
> ?

> Do I have to build another database and import the data from this file ?
> If yes, what is the procedure (I've read something about a control file
> to load data, but nothing else...)

> Thanks a lot for any explanations...



Wed, 18 Jun 1902 08:00:00 GMT
 Database creation
This question is asked by a lot of people. I recently had a developer show
me how great SQL*Anywhere was because all the database was in one file (1
MB).  He could not understand why Oracle was a little more complicated?

The short answer is because it has to be.  Oracle runs small on line
transaction processing (OLTP in the MB size  ) to very large data warehouses
(GBs, maybe bigger).  Oracle must be extremely concerned with issues such as
security, reliability, recoverability, data access speeds.  1000s of users
hitting trillions of pieces of data 7 days week, 24 hours a day 365 days a
year is a difficult thing to create, especially if you want it to be in one
file (yet to see an OS that can create a terabyte sized file).  Oracle is
all thing to all DBAs, there are smaller version such as Oracle Lite and
Personal Oracle for small Access sized databases, and complicated
configuration such as parallel server that share a database across many
instances, maybe continents apart. (don't go there until you got the basics
covered).

Anyway, when you INSTANTLY get your bank book updated at a ATM, and 10,000
other people do the exact same thing at the exact same time, and they get
there book INSTANTLY updated as well, rest assured it was not a single file
database that pulled that off.

fwit, I'd first look at the Oracle concepts manual to get a feel for the db
before looking into the admin guide.  You can get them free at
http://technet.oracle.com/

Have fun and keep an open mind until you are required to do something BIG,
then you'll appreciate the complexity of Oracle (not to mention pays good
too)

Mike


Quote:
> Oracle Database structure is a little bit strange for me, especially the
> database structure based on (if I have correctly understand !) multiples
> files and one instance.
> Why can't the database be located in only one file ?

> If I get a file *.odb from somewhere else (it's the one which contain
> tha data I think), how can I build an instance associated with this file
> ?

> Do I have to build another database and import the data from this file ?
> If yes, what is the procedure (I've read something about a control file
> to load data, but nothing else...)

> Thanks a lot for any explanations...



Wed, 18 Jun 1902 08:00:00 GMT
 Database creation
Hi Walt & Mike,

Thank you a lot for these *enlightening* explanations !
I am beginning to understand...

One of the many reasons of my confusion was that I use Oracle 8i
Enterprise Edition, Oracle Enterprise Manager AND Oracle 8i Lite at the
same time !
I wanted to manage the POLIte database demo (of Oracle Lite) with
Enterprise Manager. But it seems that it's Oracle Lite structure are
*very* different from Oracle 'normal' structure :
I have to use an ODBC connection to connect to my database ( the *.odb
file) with Oracle Lite instead of a connection to a 'database service'.

I am going to read the lite manual right now !

Thank for the help you give to newbies !



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Database Creation Help

2. SSCE database creation using DTS Package on SQL 2K

3. client component database creation

4. HELP !!!!! - database creation in application

5. DataBase Creation

6. Database creation failed

7. Database Creation through scripting

8. Database creation suring install time

9. automating database creation

10. SQL-DMO C++ Database Creation

11. Error when running Database creation script

12. Dynamic database creation


 
Powered by phpBB® Forum Software