Results 1 to 5 of 5

Thread: Oracle dums

  1. #1
    Join Date
    Feb 2009
    Posts
    48

    Unanswered: Oracle dums

    plz help me in these question ia m so confused
    Attached Thumbnails Attached Thumbnails Capture.JPG   Capture1.JPG   Capture2.JPG   Capture4.JPG  

  2. #2
    Join Date
    Feb 2009
    Posts
    48
    plz lok at pic 2 it says when truncate table it will not release storage space while i search opposite on internet i am giving exam on oracle SQL 9i

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    > it says when truncate table it will not release storage space while i search opposite on internet
    What do your own test show happen?

    >i am giving exam on oracle SQL 9i
    Why?
    V9 Oracle is obsoleted & unsupported.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    The answer is ADF

    Truncate releases the high water mark, delete does not.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  5. #5
    Join Date
    Feb 2009
    Posts
    48
    what about other questions plz answer

Posting Permissions

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