wrong size datafile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: wrong size datafile

  1. #1
    Join Date
    Sep 2000
    Posts
    31

    Question

    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.

    :(

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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]



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width