-
Gentlemen,
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....
http://www.dbasupport.com/forums/sho...threadid=26229
Reddy,Sam
-
-
Jeff got a point... thats what happened possibly...pretty common mistake every one does..
Reddy,Sam
-
HA! HA! HA!
God Joke.
marist89
-
OK, I guess the joke's on me because I was serious.
Jeff Hunter
-
Ok.
marist89
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
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|