Problems with a datafile

From: Jesus M. Lopez <lopez_at_es.ibm.com>
Date: Thu, 28 Oct 1999 18:30:03 +0200
Message-ID: <38187A0B.976EFB7@es.ibm.com>

First of all, my knowledge about ORACLE is not very deep.

By mistake I added a datafile of 16Mb to a tablespace. My intention was to add a datafile of 2000Mb.

I tried to resize the file, but I couldn't resize it bigger than 65Mb.

Then, I looked for a way to delete the file in order to recreate it with the right size.

Well, now I have the file with status offline. I suppose that the file doesn't have any data because I have other two files of 2000Mb each and the volume of data is about 2400Mb.

Please, help!

My first intention is to get a file of 2000Mb instead the actual of 65Mb.
But, if I should live with the small file forever, my question is how can I bring it online, I'm running then database in NOARCHIVE mode.

My environment is:

• AIX 4.3
• ORACLE 7.3.4

Thanks in advance.
Jesus M. Lopez Received on Thu Oct 28 1999 - 11:30:03 CDT