Databases Reference
In-Depth Information
5.
Create and populate the second table:
CREATE TABLE CL_LOCATIONS CLUSTER LOC_ENTRIES (COUNTRY_ID) AS
SELECT L.*, CAST(‹*› AS CHAR(1000)) AS FOO_DATA
FROM LOCATIONS L;
6.
Verify the database blocks where the data of the two tables is stored:
select
cl_countries.country_id,
dbms_rowid.rowid_block_number(cl_countries.rowid)
as cou_blk,
dbms_rowid.rowid_block_number(cl_locations.rowid) as loc_blk
from cl_countries, cl_locations
where cl_countries.country_id = cl_locations.country_id
order by 1;
7.
In the following screenshot, we can see the results of the last query:
