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.
I would advise you to use "COPY" command to get data to new table, rather spend time in troubleshoot whats happening. Its pretty quick....
Jeff got a point... thats what happened possibly...pretty common mistake every one does..
HA! HA! HA!
OK, I guess the joke's on me because I was serious.
I understend , dont worry. And the import what you tell me?
The only way you might get the export/import to work is:
1. export non-partitioned table A
2. drop table A
3. create table A partitioned
4. import with ignore=y