DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: import into partition table -S.O.S

  1. #1
    Join Date
    Oct 2002

    import into partition table -S.O.S

    Hi ,
    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)

    Please advise.

    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

  2. #2
    Join Date
    Oct 2000
    Did you check if the data fits into the range specified ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width