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.