Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORACLE 8.0 server NT crash and burn, I need help here.
I have installed and reinstalled my oracle server demo over 6 times.
I have set the data base sizes for the system, temp and roll back to 1G
each
I have set the user database size to 2G.
The basic problem is that I create my tables, load my data and create the
primary keys followed by the bitmap index columns. I then proceede to
do my queries. Well at least this is the plan.
In reality I have had very little success in doing this.
The ORACLE 8.0 environement has been corrupted 5 times and there is
no way that it will let me even go into the managers. The way that I am
doing
my creations and my loads is by means of the SQLPLUS and SQLLDR80 utilities
I have cut my jobs up into little steps like calling the sqlplus to do the
creation from a
batch, then calling the loader to load the data, the calling the sqlplus to
create my
keys and bitmap indexes and one final time to do the queries. The reason I
create
the keys and indexes afeter the data load is because when I did it before
hand the process took an incredible amount of time to create my little 750M
database.
So I desided to try it the oder way and got results until it tryed to do
the bitmap
indexing where it died and even NT died with it. Once I restarted the
system, it was
all gone. It said that my tables did not exist. So I reinitialized once
again and was not able to go back in to anything becase the ORACLE was not
available.
Hmmm interesting problem. I have 13 tables, with a maximum row count of
1.8M rows on one of the tables and an average table size of aboput 500K
rows. This database was loaded and tested fine on MSSQL server with less
problems.
What is wrong with this picture?
Can you help?
thanx in advance
MaNdRaKe
Received on Fri Dec 19 1997 - 00:00:00 CST