Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2008

    Unanswered: add datafile with reuse

    Hi all

    Can anybody tell me about a meaning of add datafile with keyword Resue;


  2. #2
    Join Date
    Jun 2004
    Provided Answers: 1
    From GOOGLE:

    REUSE - allows Oracle to reuse an existing file.

    If the file already exists, Oracle verifies that its size matches the value of the SIZE parameter (if you specify SIZE).

    If the file does not exist, Oracle ignores this clause and creates the file.

    You can omit this clause only if the file does not already exist. If you omit this clause, Oracle creates the file.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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