Assume there are three data files that need to be imported. With aggregate storage databases, data loads are most efficient when all data files are loaded using one import operation. Therefore, load buffers are useful when loading more than one data file.
1
as the BUFFER-ID number.
alter database ASOSamp.Sample initialize load_buffer with buffer_id 1;
import database ASOSamp.Sample data from server data_file 'file_1' to load_buffer with buffer_id 1 on error abort; import database ASOSamp.Sample data from server data_file 'file_2' to load_buffer with buffer_id 1 on error abort; import database ASOSamp.Sample data from server data_file 'file_3' to load_buffer with buffer_id 1 on error abort;
import database ASOSamp.Sample data from load_buffer with buffer_id 1;The data-load buffer is implicitly destroyed.
alter database ASOSamp.Sample destroy load_buffer with buffer_id 1;
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |