Re: High Water Mark ?

Because direct loads load data starting at the high water mark - however, for this question, which asks how to 'move' data, B and C are incorrect as SqlLoader is only used for loading (inserting) not unloading / moving. A does not exist on its own, D is wrong because import doesn't have a direct mode - thus leaving E as the correct answer.

You can use the dbms_space package or do a segment header block dump to get details about the high water mark

HTH Neil

yewpc_at_rnd.celcom.com.my wrote in message <81l2jp$m0g$1_at_nnrp1.deja.com>...
>hi,
> I have a quenstion on one of the question in OCP8 Database
>Administartion (accessement test)
>"You need to minimize resource contention by moving some of the data in
>the HR_DATA tablespace to the HR_DATA2 tablespace. Which method would
>you use to load this data below the high water mark ?
>A. direct-load insert
>B. SQL*Loader direct path
>C. SQL*Loader conventional path
>D. Export and Import utilities using direct mode
>E. Exportand Import utilities using conventional mode
>
>The answer is E. but why ?
>Can anyone tell me how each of the above method change the high water
>mark ?
>Actually what is high water mark ? what is it purpose ? what dictionary
>i can use to query about it ?
>Thank you
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Nov 26 1999 - 04:25:26 CST