Recent content by kaikaufmann

Oops, I wasn't clear on my OS I guess. I'm running a Sun Sparc machine. So its a unix environment. Sorry for the confusion. Kai

Ok, one final question. I have decided to uninstall 8.1.7 entirely and want to start from scratch. I noticed that the install directory actually remains as well as the data directory that Oracle prompts for during the install. I have manually deleted these after the uninstall. The question...

Is the inti.ora file located in the dbs directory of the 8.1.7 install? I have looked in there, and I have found no pointers to the directory that Oracle is looking for. Kai

Ok, I see your point. Here's the complete error output: SQLException :: (ORA-07446: sdnfy: bad value '/export/home/oracle/test' for parameter user_dump_dest., sqlcode=7446, sqlstate=60000) Sorry for the confusion, Kai

Ok, I tried re-installing oracle after wiping all of my directories as well as the old 817 install directory. Apparently Oracle still seems to know about my old configuration. How is this possible. Is there a way just to do a clean install without bringing over any of the old configuration...

I deleted files that correlated to the datafile definition of some tablespaces (I think). Basically, when I try to run an uninstall script (drops all objects), I get the error mentioned above. In short, I was trying to remove a previous set of objects that were stored in the wrong directory...

I am currently in a situation where I accidentally deleted some database files out from under Oracle. I was wondering if there was a way to remove all the references to this database from within Oracle, or by modifying any init files and restarting Oracle. Can I do this with dbshut and...

So far all of the information is very useful for me to develop a sizing tool. But the question is, how do estimate sizes columns with a data type of NUMBER. Do you have to rely on what you know about the nature of the data? For example, if I have a table that I don't expect to grow more than...

Thanks for both of your answers. This brings up another question though. Say I populate a column with the number 1 in which case it will occupy 2 bytes in the database. If I later update that value to be 123456 which requires more storage space, what does Oracle do to allocate more space...

Could someone please tell me what the actual byte count is for the NUMBER data type. I am trying to come up with a database sizing tool and need to know the following byte counts for the following declarations: NUMBER(3) NUMBER(5) NUMBER(10) I know that the maximum storage size is 21 bytes...