import into partition table -S.O.S
I am importing data from nonpartition table into table with partition (from oracle 7.3.4 to Oracle 8.1.7)
In a split second data have been inserted ,but from a certain point no inserting anymore.
The partition is by range (col year_month Varchar2(6)
I have done what marist89 said in one of the other posts
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
Did you check if the data fits into the range specified ?
Click Here to Expand Forum to Full Width