Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORACLE 8.0 server NT crash and burn, I need help here.

ORACLE 8.0 server NT crash and burn, I need help here.

From: MaNdRaKe <mandrakeelmago_at_hotmail.com>
Date: 1997/12/19
Message-ID: <01bd0cba$e52b1c20$4cf4adce@mao>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US