wrong size datafile

[jn1971]

HI guys,
I created a datafile with a wrong size (5m instead of 50m). Please tell me how i delete it or make it bigger? ora7.1.4 on unix. Thanks very much in advance.

:(

[sreddy]

I don't think you have the option of resizing it in 7.1.4. Starting from 7.2, you can use the 'RESIZE' command. So you have to drop it and recreate it. See the following Metalink doc.


[url]http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=111316.1[/url]