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]