I have a table call of ' A' and this table not this partitioned
I created a table call ' B' with 6 partitions, and identical in the columns of the table 'A'
I made a command of
insert into B select * from A;
it came back me that 10000 rows had been created.
When went make a
select count (*) from b where col x=2;
for my surprise 0 rows came.
When I made a
select count (*) from b;
answered that there are 0 lines in the
table in the tablespaces that they were loaded,
it exists busy spaces.
What can have been happening????
If does an export of the table A and an
import in B i
it will be inserted in B according to the partition table.
07-10-2002, 01:21 PM
I would advise you to use "COPY" command to get data to new table, rather spend time in troubleshoot whats happening. Its pretty quick....